mysql error? (logs) - Printable Version

mysql error? (logs) - 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? (logs) (/showthread.php?tid=476907)

mysql error? (logs) - recor - 21.11.2013

Код:

Error (0): Failed to exeute 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 's Base.', UTC_TIMESTAMP())' at line 1.

help?

Re: mysql error? (logs) - Jankingston - 21.11.2013

maybe you have entered the wrong credentials in the connection setting : if u r using wamp

Hostname : localhost
Username : root
pass : leave it :P
database : create a DB and write the name of DB her

Re: mysql error? (logs) - kbalor - 21.11.2013

Try

Quote:

's Base.'

Quote:

'%s Base.',

Edit: I wonder what is the 's' you put for, but usually mysql it would be like this

Sample:

Quote:

format(query,sizeof(query),"SELECT `BannedBy`, `BanReason`, `BanDate` FROM `"MyTableName"` WHERE `PlayerName` = '%s'", GetName(playerid));

Re: mysql error? (logs) - Konstantinos - 21.11.2013

Quote:

Originally Posted by kbalor

Edit: I wonder what is the 's' you put for, but usually mysql it would be like this

It cuts the query and it shows the part NEAR the error in the syntax.

Quote:

Originally Posted by recor

Код:

Error (0): Failed to exeute 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 's Base.', UTC_TIMESTAMP())' at line 1.

help?

Post the query, we cannot read your mind..