Login fails: You have an error in your SQL syntax

Found a bug? Tell us!!
Post Reply
Niclas
Regular
Posts: 61
Joined: Fri Aug 29, 2008 3:54 pm
Location: Frankfurt / Germany

Login fails: You have an error in your SQL syntax

Post by Niclas »

Sorry, for replying so late.
But I upgraded to 2.3.2 in the meantime and cannot log on to the backend anymore. I get the error message: "Query failed: 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 '0' at line 33"

Unfortunately this message doesn't tell me in which file the syntax needs to be corrected.

My MySQL server version: 5.5.62-0+deb8u1-log - (Debian)
onli
Regular
Posts: 2825
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

Re: Login fails: You have an error in your SQL syntax

Post by onli »

Split from viewtopic.php?f=3&t=24611

I'd look into the apache log to see whether a bit more context is given here.
Niclas
Regular
Posts: 61
Joined: Fri Aug 29, 2008 3:54 pm
Location: Frankfurt / Germany

Re: Login fails: You have an error in your SQL syntax

Post by Niclas »

I don't have access to the Apache log and settings. I could ask the provider but an answer might take time.
So far I found a pretty old thread where it comes to "_" vs. "-" and I have a "_" (underscore): (e.g. mydatabase_).
Post Reply