Mysql error
#1

pawn Код:
[23:32:04] CMySQLHandler::Query(INSERT INTO `house` (`ID`, `Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Owner`, `Description`, `Value`, `Int`, `Lock`, `Owned`, `World`, `Type`) VALUES ('0', '1531.083007', '-1670.414672', '13.382812', '221.733001', '1140.514648', '1082.609375', 'The State', 'Living,Dormitor,Bucatarie', '100000', '4', '0', '0', '476733', Casa confort II)) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'confort II)' at line 1)
How to resolv this error? What problem?
Reply
#2

Show me code from script.
Reply
#3

Add single quotes to this Casa confort II (probably %s in string, make it '%s')
Reply
#4

Resolved! Thanks for all.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)