mysql error? (logs)
#1

Код:
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?
Reply
#2

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
Reply
#3

Try

Quote:

's Base.'

to

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));

Reply
#4

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..
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)