PhotoPost Community - View Single Post - Upgraded from 5.21 to 5.5

bluemi · November 13th, 2006, 04:38 PM

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?

November 13th, 2006, 04:38 PM	#1 (permalink)
bluemi Member Verified Customer Join Date: May 2005 Posts: 33	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); 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?