Errors after 6.11 upgrade

[bajabob]

Hi,

I recently upgraded to 6.11 and noticed the following two error messages on the main admin statistics page at the very top:


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/......./gallery/adm-misc.php on line 1231

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/......./gallery/adm-misc.php on line 1255


Anyone know what it is and how to fix it?

Thanks in advance,
Robert

[Chuck S]

Have you ran any required upgrades from your previous version forward. Only reason there would be mysql issues if you missed running an upgrade.

You can also try repairing tables incase you have an issue with any tables.

[bajabob]

Hi,

Yes I did run each step in the upgrade script from 5.62 on, so the two steps there. Should I try rerunning them overtop the upgraded db?

I also tried the repair, but I've been unable to load the statistics page in the admincp since then. Is there any trick to get it to load or another place to check for those errors?

Thanks,
Robert

[Chuck S]

try doing a repair on the tables admlog and iponline tables. These queries are valid and I show no errors in the code.

Content visible to verified customers only.

If those tables exist in your database with all the required fields and are not crashed you should have no issues.