We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 2901
    • 277 Posts
    Hi all
    yesterday morning we had a server problem. Today I was to change a chunk, after saving and clicking logout the manager css disappeared I've tried to login again with several browsers, the problem remains in all of them and the manager is unusable like this.

    I've checked the core cache and found a strange error repeating itself since the crash:

    [2012-01-16 15:38:57] (ERROR @ /index.php) Error preparing statement for query: SELECT modAccessContext.id, modAccessContext.target, modAccessContext.principal, modAccessContext.authority, modAccessContext.policy, Policy.data FROM `modx_access_context` AS `modAccessContext` LEFT JOIN `modx_access_policies` `Policy` ON `modAccessContext`.`policy` = `Policy`.`id` WHERE ( `modAccessContext`.`principal_class` = ? AND `modAccessContext`.`target` = ? ) ORDER BY modAccessContext.target,modAccessContext.principal,modAccessContext.authority,modAccessContext.policy ASC -
    [2012-01-16 15:38:57] (ERROR in xPDO::connect @ /var/www/vhosts/renosommerhalder.ch/httpdocs/core/xpdo/xpdo.class.php : 344) SQLSTATE[08004] [1040] Too many connections

    that error is persitstant and I was not able so far to find the problem.

    modx revo version 2.1.3 trad.
    PHP 5.2.17
    MySQL 5.0.77

    Anybody any idea what this could be?

    OK I am a bid closer, but don't see the problem.

    I get an 404 for
    modx-min.css and login-min.css
    and a error message that
    lang.js.php was interpreted as script but was sent as html

    [ed. note: bbeer last edited this post 14 years, 8 months ago.]
      • 3749
      • 24,544 Posts
      Check the compress_css system setting. Changing it to 0 may help.


      ---------------------------------------------------------------------------------------------------------------
      PLEASE, PLEASE specify the version of MODX you are using . . . PLEASE!
      MODx info for everyone: http://bobsguides.com/MODx.html
        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
        • 2901
        • 277 Posts
        Thanks BobRay

        this is a strange problem. I compared the database (after realizing that some path where wrong) and there was a entry (manager_theme) missing, which I can't explain why. So I added that entry manually, then deleted core>cache>system_settings and it now works again. However I do not understand how this could happen.
        I have not altered the database at all
        I actually saved a chunk
        then logout and the problem started

        Guess I will update this installation as soon as 2.2 final it out.

        I really don't understand that.
          • 3749
          • 24,544 Posts
          That can happen if you install an extra that creates a System Setting, then later uninstall the extra.

          ---------------------------------------------------------------------------------------------------------------
          PLEASE, PLEASE specify the version of MODX you are using . . . PLEASE!
          MODx info for everyone: http://bobsguides.com/MODx.html
            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
            • 2901
            • 277 Posts
            BobRay

            this is the same installation I had problems with before with a Package in this post
            https://forums.modx.com/thread/?thread=71710#dis-post-405254

            Maybe this problem is related!
              • 3749
              • 24,544 Posts
              I think it's likely.



              ---------------------------------------------------------------------------------------------------------------
              PLEASE, PLEASE specify the version of MODX you are using . . . PLEASE!
              MODx info for everyone: http://bobsguides.com/MODx.html
                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