SQL syntax error
#1

Hey, upon logging on my server I don't get the registration/login dialog, so I went to check the MySQL log for any sort of error that occured. Apparently, there is something wrong with one of my queries.

[ERROR] CMySQLQuery::Execute[OnAccountCheck(i)] - (error #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 ''accounts' WHERE 'Name'=Rudey LIMIT 1' at line 1

Is there anything wrong with: "SELECT 'Password', 'ID' FROM 'accounts' WHERE 'Name'=%e" ?

Thanks in advance!
Reply


Messages In This Thread
SQL syntax error - by Rudey - 27.07.2015, 13:25
Re: SQL syntax error - by BigGroter - 27.07.2015, 13:27
Re: SQL syntax error - by Vince - 27.07.2015, 13:31
Re: SQL syntax error - by Rudey - 27.07.2015, 13:37
AW: SQL syntax error - by Macronix - 27.07.2015, 13:43
Re: SQL syntax error - by Vince - 27.07.2015, 13:46
Re: SQL syntax error - by Rudey - 27.07.2015, 17:42

Forum Jump:


Users browsing this thread: 1 Guest(s)