Mysql error - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql error (/showthread.php?tid=318069)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql error (/showthread.php?tid=318069)
Mysql error - GeonMake - 13.02.2012
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)
Re: Mysql error - [MG]Dimi - 13.02.2012
Show me code from script.
Re: Mysql error - Johnson_boy - 13.02.2012
Add single quotes to this Casa confort II (probably %s in string, make it '%s')
Re: Mysql error - GeonMake - 13.02.2012
Resolved! Thanks for all.