Upgraded from 5.21 to 5.5 - database trouble
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);
$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?