Post upgrade error

[Linnefaulk]

After upgrading, I am seeing errors like the following:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/linnecar/public_html/photopost/forums/phpbb2.php on line 29

My gallery is at http://www.linnecards.com/photopost/index.php. I apologize for my lack of knowledge; ANY help would be greatly appreciated.

[Chuck S]

Hello are you sure this was installed correctly? Check your config-inc.php file for one to ensure under members database you have the correct phpbb2 database info and next you need to check your phpbb config.php file and see what your table prefix is no doubt phpbb_. Somehow your table prefix is messed up I think so you can go to your web control panel and run in your database admin tool a query like this to see where this helps when viewing your photopost database

UPDATE pp_settings SET setting='phpbb_' WHERE id=83

[Linnefaulk]

Holy cow! Ran that one line of SQL, and BOOM -- problem solved! You guys really know your schtuff. Thanks; let's see if I can do the rest without screwing it up.

[Chuck S]

Not a problem yeah this is not something that happens on an upgrade someone would have had to intentionally edit the admin settings and cleared this entry under forum settings.