Upgraded from 5.21 to 5.5 - database trouble

[bluemi]

I'm running PP Pro integrated with phpBB 2.0.21. Recently I did the upgrade from 5.21 to 5.5 and everything seemed to go well. Then today I suddenly started getting huge amounts of error notification emails and when I opened my gallery I had the following mysql error shown:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/.../galleries/pp-inc.php on line 303

Elsewhere in the forum I read that this has to do with a wrong Photopost prefix in the database but since I didn't change the prefix during the upgrade (i used the upgrade script) how can this suddenly be wrong?

After doing some searches on Google I have now set line 303 in pp-inc.php from

$cacheq = mysql_fetch_array($totalv);

to

$cacheq = @mysql_fetch_array($totalv);

and everything works fine again now but since I don't really have a clue about these things I guess this is only a temporary solution that will create more trouble elsewhere. Any ideas?

[Chuck S]

Did you run your upgrade scripts from 5.21 to 5.5 as there should be no issue with the cache table since it should exist if you ran the upgrades.

[bluemi]

Hi Chuck, yes I did and actually all worked fine for 9 days. The problem suddenly started today.

[bluemi]

Hm, more error messages now:
Can't open file: 'ppost_cache.MYD'. (errno: 145)

[bluemi]

Hm, might have fixed it. There was something wrong with a table in ppost_cache. Restored it, and also changed back the line in pp-inc.php. All normal now.