Page 1 of 1

Can't login anymore. MySQL Query Failed

Posted: 10 Oct 2023, 21:40
by manuel
Suddenly I got this error. I think the hosting provider upgraded the SQL server
I get the login screen but after entering the username and password I got the error:

Query Error -- Report to System Administrator ASAP

MySQL 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 'system
WHERE
system_id = 0' at line 4

SELECT
*
FROM
system
WHERE
system_id = 0


Is there a sollution for this kind of error?

I use:
CATS Versie 0.9.1 (Beas)
Serverversie: 8.0.34 - MySQL Community Server - GPL
Protocolversie: 10

Re: Can't login anymore. MySQL Query Failed

Posted: 11 Oct 2023, 13:59
by RussH
Hi Manuel,
so the good news is your data is safe. But if your provider has upgraded the MySQL version from under you then yes that will be an issue. Cats v0.9.1 will not be able to use current MySQL, or current php for that matter.

so If you need to stick with version 0.9.1 you'll have to get that MySQL downgraded, otherwise grab version 0.9.7.2 and install it with PHP 7.3, MariaDB 10 and import the MySQL database and take it from there.

You will be able to backup the opencats database at a commandline using MySQL dump.

Re: Can't login anymore. MySQL Query Failed

Posted: 17 Oct 2023, 08:14
by manuel
OpenCats is verry easy to back-up with a simple work around. I made a local webserver with an old version of xampp server. Copied all the current files to it using FTP. Made a copy of the database en imported it local.

Because the error pointed out to the file /lib/SystemInfo.php I compared it with the latest version.
There are some differences so I decided to replace the file with this newer version and ..... don't ask me why but it's all working fine again. :-)

Re: Can't login anymore. MySQL Query Failed

Posted: 30 Dec 2023, 10:23
by Thomas Frank
manuel wrote: 17 Oct 2023, 08:14 OpenCats is verry easy to back-up with a simple work around. I made a local webserver with an old version of xampp server. Copied all the current files to it using FTP. Made a copy of the database en imported it local. wordle unlimited

Because the error pointed out to the file /lib/SystemInfo.php I compared it with the latest version.
There are some differences so I decided to replace the file with this newer version and ..... don't ask me why but it's all working fine again. :-)
You are so creative. I appreciate that.

Re: Can't login anymore. MySQL Query Failed

Posted: 27 Feb 2024, 03:09
by nimoprteva
manuel wrote: 17 Oct 2023, 08:14 OpenCats is verry easy to back-up with a simple work around. I made a local webserver with an old version of xampp server. Copied all the current files to it using FTP. Made a copy of the database en imported it local.

Because the error pointed out to the file /lib/SystemInfo.php I compared it with the latest versionbackrooms game

There are some differences so I decided to replace the file with this newer version and ..... don't ask me why but it's all working fine again. :-)
fantastic! :)

Re: Can't login anymore. MySQL Query Failed

Posted: 18 Mar 2024, 10:44
by hickmankay20
manuel wrote: 17 Oct 2023, 08:14 OpenCats is verry easy to back-up with a simple work around. I made a local webserver with an old version of xampp server. Copied all the current files to it using FTP. Made a copy of the database en imported it local.
dordle
Because the error pointed out to the file /lib/SystemInfo.php I compared it with the latest version.
There are some differences so I decided to replace the file with this newer version and ..... don't ask me why but it's all working fine again. :-)
It seems I followed what you instructed and it worked. Appreciate your contributions