I've installed cpg okay, and it worked perfectly - I then edited the various files needed to integrate it with phpbb. I've checked and double checked everything, but all I get now is an error:
Fatal error :
There was an error while processing a database query
Anyone got any ideas what may be wrong and how I fix it?
Regards
Eddy
enable debug_mode in coppermine config to see what query actually fails. Report here; copy'n paste the error message (not the debug output) into your reply (using the quote or code buttons above).
Joachim
I get the following error after enabling debug:
Notice: Use of undefined constant PHPBB_COOKIE_PREFIX - assumed 'PHPBB_COOKIE_PREFIX' in /home/paddledu/public_html/cpg132/bridge/phpbb.inc.php on line 86
Fatal error :
There was an error while processing a database query.
While executing query "SELECT user_id, username as user_name, user_level FROM `paddledu_forum`.phpbb_users WHERE user_id='0' AND user_password='*' AND user_active='1'" on 0
mySQL error: select command denied to user: 'paddledu_eddy875@localhost' for table 'phpbb_users'
I hope that helps a little as it means nothing to me! :-)
Regards
Eddy
Ooops! I'd forgotten to add the user to the sql database :-(
Anyway, now that I've done that I now get another error if I try to run the admin.php file:
You don't have permission to access this page.
File: /home/paddledu/public_html/cpg132/admin.php - Line: 25
Notice: Use of undefined constant PHPBB_COOKIE_PREFIX - assumed 'PHPBB_COOKIE_PREFIX' in /home/paddledu/public_html/cpg132/bridge/phpbb.inc.php on line 86
If I run cpg normally I get the following error:
Notice: Use of undefined constant PHPBB_COOKIE_PREFIX - assumed 'PHPBB_COOKIE_PREFIX' in /home/paddledu/public_html/cpg132/bridge/phpbb.inc.php on line 86
Any suggestions anyone?
Regards
Eddy
Sounds like you didn't edit your bridge file correctly. Post it here so we can look at it. Don't forget to remove your password, if applicable.
You were absolutely correct kegobeer. After reading your post I looked at the file in more detail, and sure eough I'd made a mistake!
Everything seems to be working now, so many thanks for all the help!
Regards
Eddy