We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 36604
    • 268 Posts
    The host has experimented some big trouble today.
    The frontend has crashed first with a xpdo/php error, then it came back, and finally 30 minutes later we lost contact with everything (ssh, ftp...) with errors that let think there were physical malfunctions on the hardware (but with no more precisions).

    When the server came back I was NOT able to see anything in the resources tree.
    Only both context (web + en) were displayed but noway to open them.

    If I use any other user account (by chance I have another admin one) everything is ok.

    If it was a normal acl issue it could had occurred if someone tried to play with this, but it's not the case. However the admin account is still in administrator group (like the other admin accounts) and moreover SUDO user is checked too.

    Looks like the DB is corrupted ??

    I created another user and put it into the administrator group. this one has no pb.

    What should I check ?

    Thank you
      • 3749
      • 24,544 Posts
      The first thing to try is repairing all tables in the DB with PhpMyAdmin. Then, I would delete all files in the core/cache directory and clear your browser cache and cookies before logging back in.
        Did I help you? Buy me a beer
        Get my Book: MODX:The Official Guide
        MODX info for everyone: http://bobsguides.com/modx.html
        My MODX Extras
        Bob's Guides is now hosted at A2 MODX Hosting
        • 36604
        • 268 Posts
        Quote from: BobRay at Feb 04, 2013, 01:47 AM
        The first thing to try is repairing all tables in the DB with PhpMyAdmin.
        Hmm..

        What does this suppose ??
        I'm not able to manually see what is wrong.
        Looking at the modx_users I just see all records perfectly similar. I don't see anything strange for the 'admin'.

        Thank you
          • 36604
          • 268 Posts
          I deleted the original admin and recreate another. it's ok UT i have this now in the error log
          [2013-02-04 17:04:53] (ERROR @ /connectors/security/user.php) Could not get table class for class: modAccess
          [2013-02-04 17:04:53] (ERROR @ /connectors/security/user.php) Could not get table name for class: modAccess
          [2013-02-04 17:04:53] (ERROR @ /connectors/security/user.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` = 1' at line 1
          )
          


            • 3749
            • 24,544 Posts
            Does the new admin have the same ID (usually 1)? There are many other entries in other tables that refer to the admin by ID.

            Repairing the DB tables in PhpMyAdmin never hurts. They can be corrupted and still look OK when you view them. Just "check all" at the view of all tables and select "Repair" in the drop-down at the bottom of the grid.
              Did I help you? Buy me a beer
              Get my Book: MODX:The Official Guide
              MODX info for everyone: http://bobsguides.com/modx.html
              My MODX Extras
              Bob's Guides is now hosted at A2 MODX Hosting