We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 4089
    • 5 Posts
    Hello there,

    My first post after a lot of reading here, I can log into the manager but I can’t access the content tree as modx put this error instead:

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/voxafric/public_html/modx/manager/includes/user_settings.inc.php on line 17
    
    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home2/voxafric/public_html/modx/manager/includes/user_settings.inc.php on line 19
    
    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/voxafric/public_html/modx/manager/frames/nodes.php on line 107
    
    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/voxafric/public_html/modx/manager/frames/nodes.php on line 111
               This folder is empty
    
    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/voxafric/public_html/modx/manager/frames/nodes.php on line 56


    Furthermore inside the right frame this message appears:

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/voxafric/public_html/modx/manager/actions/welcome.static.php on line 89

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/voxafric/public_html/modx/manager/actions/welcome.static.php on line 158

    I’ve posted more than a thousand posts so far ... any suggestions ?

    Thx
      • 10449
      • 956 Posts
      I quickly searched the forum and found two related threads about the same types of mysql errors... One of those recently upgraded to mysql 5.1, and it looked like the hosting company messed something up. I’m not sure if this is a new mysql bug or just random server madness/misconfiguration...

      http://modxcms.com/forums/index.php?topic=35397.0
      http://modxcms.com/forums/index.php?topic=35411.0

      You should look up the DB tables: Do you see document-rows there at all? Maybe compare with a local fresh copy (incl. sample pages).
      After doing a complete DB-backup, do a check to see if some tables are corrupt. Try to run the repair command.