Page 1 of 1

Login fails: You have an error in your SQL syntax

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

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

Posted: Sat Feb 22, 2020 10:10 am
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.

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

Posted: Sat Feb 22, 2020 9:53 pm
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_).