SA-MP Forums Archive
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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL Error (/showthread.php?tid=190036)


MySQL Error - sjvt - 13.11.2010

pawn Код:
MySQL retourneerde: Documentatie
#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 '(0, 2 Room Apartment, 1090.1619, -1785.1078, 13.6468, 2496.049804, -1695.238159,' at line 2
What's the problem?

Re: MySQL Error - sjvt - 14.11.2010



The message you have entered is too short. Please lengthen your message to at least 8 characters.

Re: MySQL Error - The_Gangstas - 14.11.2010

post the code.

Re: MySQL Error - sjvt - 14.11.2010

pawn Код:
SQL-query:

--
-- Gegevens worden uitgevoerd voor tabel `server_houses`
--
INSERT INTO `server_houses` ( `ID` , `Description` , `EnterX` , `EnterY` , `EnterZ` , `ExitX` , `ExitY` , `ExitZ` , `Int` , `Vir` , `Level` , `Owned` , `Owned` , `Cost` , `Locked` , `Vehicle` , `Vcolor1` , `Vcolor2` , `Paintjob` , `VehX` , `VehY` , `VehZ` , `VehA` , `Plate` , `Garbage` , `NotUsed` )
VALUES ( 0, 2Room Apartment, 1090.1619, - 1785.1078, 13.6468, 2496.049804, - 1695.238159, 1014.742187, 3, 1, 5, 0, The State, 100000, 1, 516, 1, 1, 255, 1896.000000, - 2145.000000, 13.000000, 179.000000, Housecar, 0, 0 ) ;

MySQL retourneerde: Documentatie
#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 'Room Apartment, 1090.1619, -1785.1078, 13.6468, 2496.049804, -1695.238159, 1014.' at line 2


Re: MySQL Error - sjvt - 14.11.2010



The message you have entered is too short. Please lengthen your message to at least 8 characters.

Re: MySQL Error - smeti - 14.11.2010

use the string ' '

Код:
VALUES(0, '2Room Apartment', 10..


Re: MySQL Error - sjvt - 14.11.2010

FIXED THX.