We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Answered Error HY000 executing statement

    • 30585
    • 833 Posts
    treigh Reply #1, 11 years ago
    Anybody knows the meaning of the following error? The site was running just fine a few hours ago - no new packages installed. Now, the manager is taking ages to load and the front-end is in slow mode to. 

    [2013-04-15 00:24:21] (ERROR @ /connectors/system/databasetables.php) Error HY000 executing statement:
INSERT INTO `modx_session` (`id`, `access`, `data`) VALUES ('4k54glv0nnrj3b76k8vd0sppj7', 1365985461, 'modx.user.contextTokens|a:2:{s:3:\"mgr\";i:1;s:3:\"web\";i:1;}modx.mgr.user.token|s:52:\"modx516ace9a86f054.98150864_1516ad0074e5bf6.48211895\";modx.mgr.session.cookie.lifetime|i:0;modx.web.user.token|s:52:\"modx516ace9a86f054.98150864_1516ae51ef0b9f1.98377641\";modx.web.session.cookie.lifetime|i:0;newResourceTokens|a:4:{i:0;s:23:\"516b39bd414966.27606014\";i:1;s:23:\"516b3a5530f186.56632092\";i:2;s:23:\"516b45470e9893.15322834\";i:3;s:23:\"516b45abed6795.13336460\";}')
Array
(
    [0] => HY000
    [1] => 2014
    [2] => Cannot execute queries while other unbuffered queries are active.  Consider using PDOStatement::fetchAll().  Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
)

    This question has been answered by treigh. See the first response.

      A MODx Fanatic
    • AMDbuilder Reply #2, 11 years ago
      That error generally points to a MySQL issue, you might try checking all of your tables.
        Patrick | Server Wrangler
        About Me: Website | Tweets |  MODX Hosting
        • 30585
        • 833 Posts
        treigh Reply #3, 11 years ago
        I thought so.. Doing just that. Thanks for the follow-up.
          A MODx Fanatic
        • discuss.answer
          • 30585
          • 833 Posts
          treigh Reply #4, 11 years ago
          For anyone interested, I checked all tables, cleared overheads and everything seems to be fine on the database front. The hosting company is under ddos attack that targets their Wordpress install. I guess everyone on their shared platform is also affected. This issue can be considered closed for the moment.
            A MODx Fanatic
          • AMDbuilder Reply #5, 11 years ago
            I'm glad to hear you identified the problem, the wordpress attack has definitely been affecting hosts lately.

            Thanks for reporting back!
              Patrick | Server Wrangler
              About Me: Website | Tweets |  MODX Hosting
            • sottwell Reply #6, 11 years ago
              Yes, I was hoping you guys were doing OK with that. Nasty business. It's a crying shame that a few jerks have to spoil things for the rest of us.
                Studying MODX in the desert - http://sottwell.com
                Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                Join the Slack Community - http://modx.org