SA-MP Forums Archive
MYSQL Help - 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 Help (/showthread.php?tid=657512)


MYSQL Help - Ahmadd - 09.08.2018

PHP код:
[Fri Aug 10 17:49:56 2018] Error (0): Could not execute 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 'playerDonuts=0, WHERE playerName='Ahmadd'' at line 1. 


Re: MYSQL Help - Florin48 - 09.08.2018

post the line where is this 'playerDonuts=0, WHERE playerName='

Re: MYSQL Help - Kraeror - 09.08.2018

You have an incorrectly placed upper comma. Exactly after `%s` or `%i` where is the Player name you have got 2 closing commas!

Re: MYSQL Help - Calisthenics - 10.08.2018

Quote:
Originally Posted by Kraeror
Посмотреть сообщение
You have an incorrectly placed upper comma. Exactly after `%s` or `%i` where is the Player name you have got 2 closing commas!
Those are apostrophes and the last one is from mysql logs. It takes a part of query and it places it inside apostrophes.
The problem is the comma , before WHERE clause.