Plain and simple.
If i'm logged into my forum, phpBB, I cannot get into the photo gallery. Gives me this error:
"Fatal error :
There was an error while processing a database query"
However, if I am logged out of the forum, I can enter the gallery fine and view all pictures, vote, do everything possible. No error message.
The integration is set up correctly, but we recently moved servers and since the move, I have not been able to log in - is there a hidden file possibly that never got transferred, or is there some configuration that I must update?
Thanks
www.bmwsport.net
-Jeff
here is the Debug mode result - can anybody help with the break down of this?
"
While executing query "SELECT (ug.group_id + 5) as group_id FROM `phpbb`.phpbb_user_group as ug LEFT JOIN `phpbb`.phpbb_groups as g ON ug.group_id = g.group_id WHERE user_id = 2 AND user_pending = 0 AND group_single_user = 0" on 0
mySQL error: select command denied to user: 'bmwsportdb@localhost' for table 'phpbb_user_group'
"
i'm going to try to merge the 2 databases - but I appreciate any research..
Got the problem.
I have 2 usernames and passwords for the MySQL database, each username has access to one specific database. "bmwsport" and "phpbb" - since the gallery is under the "bmwsport" database, the integration from the "phpbb" database wont pull any info from the other database. Trying to fix this right now, but that's the problem.
fixed.
can leave this if anybody else ever encounters this problem.
Glad you got it sorted.
Note, it is recommended that the gallery and BB are on the same database.