I’m using Concrete5.2.1 on a server running PHP 5.6 and MySQL (hosted on OVH). When I try to log in to the admin interface, I encounter the following error:
mysql 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 ‘Groups on UserGroups.gID = Groups.gID WHERE UserGroups.uID = ‘1’’ at line 1]
in EXECUTE(“SELECT Groups.gID, Groups.gName FROM UserGroups INNER JOIN Groups ON UserGroups.gID = Groups.gID WHERE UserGroups.uID = ‘1’”)
I’ve tried restoring the database, but the issue persists. The structure of the tables seems correct (Groups and UserGroups exist). I’m wondering if this could be related to:
An incompatibility between Concrete5.2.1 and a more recent MySQL version,
Or an issue during the database restoration process (importing from Windows to Linux).
Has anyone experienced this issue or have any suggestions on how to resolve it?
The error 1064 occurs due to Mysql version mismatch,because different versions have different
reserved words, which if used by a previous version causes the error to occur.
The simplest and most effective solution for it is.
-when using phpMyadmin,select the “compatibility mode” & select the target db version from the drop down box.
-when using MySql administrator,while backing up choose “compatibility mode” in advanced tab ,
and while restoring through mysql administrator ,click “auto-detect file charater set” if backup was not made using mySql administrator.
the default file characer set used by mysql admministrator is utf8.
You should update your site to run on concrete 5.6.4
5.6.4 is compatible with the Groups reserved word and will run on php 7.4 (much faster)
Get in touch if you want this done for you as a paid job.
Yeah, you probably tried to update directly from 5.2.1 to 5.6.4, you cannot jump from one major version to another, you need to update sequentially through the versions especially with archive versions.
I would not expect 5.6.0 to make a difference.
You need to continue stepping through the versions until you get to 5.6.3.5 and then the final step to 5.6.4.0