View Full Version : Post upgrade error
October 1st, 2007, 06:25 PM
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.
October 1st, 2007, 08:09 PM
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
October 2nd, 2007, 08:36 AM
Holy cow! Ran that one line of SQL, and BOOM -- problem solved! You guys really know your schtuff. :D Thanks; let's see if I can do the rest without screwing it up.
October 2nd, 2007, 11:19 AM
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.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.