coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: Texan78 on April 04, 2005, 03:10:16 AM

Title: Fatal DB Error
Post by: Texan78 on April 04, 2005, 03:10:16 AM
After trying to visit my Gallery i notice when i clicked on the link for it i get this message:

Fatal error :
There was an error while processing a database query


Any idea why im getting this and how to fix it. I was thinking it might be something with the DB config file maybe?
Title: Re: Fatal DB Error
Post by: kegobeer on April 04, 2005, 03:14:41 AM
You have to enable debug mode and report the actual error message.  If you can't get into your gallery, you'll have to use phpmyadmin to change debug_mode to 1 in your cpg132_config table.
Title: Re: Fatal DB Error
Post by: Texan78 on April 04, 2005, 04:12:31 AM
Ok thank you, i did what you said and got this message for the reason behind it:

While executing query "SELECT user_id, username as user_name, user_level FROM `texascam_phpbb2`.phpbb_sessions INNER JOIN `texascam_phpbb2`.phpbb_users ON session_user_id = user_id WHERE session_id='73b3399fe3759bdb3037d7844c603671' AND session_user_id ='2' AND user_active='1'" on 0

mySQL error: Table 'texascam_phpbb2.phpbb_sessions' doesn't exist


I know how and why im getting it now as i was moving my DB around on my fourm to the new phpbb plus and upgrading to .13. Any ideas of how to fix this problem now?
Title: Re: Fatal DB Error
Post by: Texan78 on April 04, 2005, 08:31:51 AM
Here we go again.
Title: Re: Fatal DB Error
Post by: Nibbler on April 04, 2005, 11:18:34 AM
Correct the information in the bridge file.
Title: Re: Fatal DB Error
Post by: Texan78 on April 04, 2005, 06:50:11 PM
Thank you it works great again. I figured it had something to do with that file. I just forgot which one it was since it has been a while since i installed it. I had created a new DB for my phpbb since i upgraded it to plus and the bridge file was still pointing to the old DB. All is great now though, thanks.