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 » Fri Feb 21, 2020 11:23 pm

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)

User avatar
onli
Regular
Posts: 2361
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

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

Post by onli » Sat Feb 22, 2020 10:10 am

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 » Sat Feb 22, 2020 9:53 pm

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