I have a website built with MODX Revo 2.3.1 on Linux hosting. After being told by the client that they had suddenly lost the ability to do things in the manager area, I logged in and saw that a new user account had been created (the only person with permission to create user accounts was myself, and there was only one client with limited content permissions 42 out of the full 172) using an email address ending .ru and beginning "f***youmodx" (*** = uck). My content access permissions had been altered, but after reverting them to what they were, it is still impossible to save any changes to updated resources with my full permissions.
I have updated the CMS to 2.3.2 and deleted the rogue user account, and checked the permissions. Made another attempt to update a resource, then everything in the manager area below the blue band at the top disappears (resource tree, etc, disappears), and clicking logout or end sessions does not work. Can't log out or force a logout of all users. Manager area now functionless.
In another browser I manage to get to the error log. It notes an error from about three hours earlier:
[2014-12-09 09:04:01] (ERROR @ /connectors/index.php) Could not get table class for class: modAccess
[2014-12-09 09:04:01] (ERROR @ /connectors/index.php) Could not get table name for class: modAccess
[2014-12-09 09:04:01] (ERROR @ /connectors/index.php) Error 42000 executing statement:
Array
(
[0] => 42000
[1] => 1064
[2] => 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 'AS `modAccess` WHERE `modAccess`.`principal` = 3' at line 1
)
With the other browser I manage to end all sessions. then log in again successfully and see the resources but can't update some of them and am denied access to media files in template variables on the resources, even though the permissions for my Admin account should give me full access as the Super User.
Any advice?