Error in SAMP MySQL - 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: Error in SAMP MySQL (/showthread.php?tid=196317)
+- 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: Error in SAMP MySQL (/showthread.php?tid=196317)
Error in SAMP MySQL - Archangel+ - 05.12.2010
Help! On create account in game - error:
"Error in mysql_query: 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 'Key) VALUES ('MyNickName', 'MyPass')' at line 1"
Re: Error in SAMP MySQL - dice7 - 05.12.2010
show your query
Re: Error in SAMP MySQL - Archangel+ - 05.12.2010
format(query, sizeof(query), "INSERT INTO players (Name, Key) VALUES ('%s', '%s')", sqlplyname, sqlpassword);
samp_mysql_query(query);
Re: Error in SAMP MySQL - dice7 - 05.12.2010
Print out the formated query before executing it.
Re: Error in SAMP MySQL - Archangel+ - 05.12.2010
Код:
[17:39:30] [join] Archangel has joined the server (0:169.254.195.247)
[17:39:30] SELECT id FROM players WHERE LOWER(Name) = LOWER('') LIMIT 1
[17:39:37] Error in mysql_query: 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 'Key) VALUES ('Archangel', 'tgut')' at line 1
[17:39:37] SELECT id FROM players WHERE LOWER(Name) = LOWER('Archangel') LIMIT 1
[17:39:37] INSERT INTO players (Name, Key) VALUES ('Archangel', 'tgut')