Hello, I just followed the instructions on integrating coppermine with phpBB2.
And now when I try and access the coppermine gallery I get the following error:
"Fatal error :
There was an error while processing a database query"
It does not even take me to a login page or any page at that. Anyone help me with this?
phpBB does still work though.
Please let me know if you have any ideas, thanks...
if coppermine used to work before the integration, undo your changes to include/init.inc.php (making cppermine standalone again temporarily). Go to coppermine config, enable debug_mode (ath the very bottom of the page), save your settings, re-enable phpbb integration and check the additional debug_mode output when you encounter the db error. If it is alin to you, paste it into your next posting here.
GauGau
ok I got this out of the debug mode:
"Fatal error :
There was an error while processing a database query.
While executing query "SELECT user_id, username as user_name, user_level FROM `phpBB`.phpbb_sessions INNER JOIN `phpBB`.phpbb_users ON session_user_id = user_id WHERE session_id='6925100d372e57cf92ff8a55526da989' AND session_user_id ='2'" on 0
mySQL error: Table 'phpBB.phpbb_sessions' doesn't exist"
I gather thats something about getting the user id from the SQL database?
I followed these instructions when I attempted the intregration if that helps,
http://coppermine.sourceforge.net/manual.php#integrating
Both coppermine and phpbb are using the same SQL database as suggested in it.
Lemmie know if you know what I should do thanks.
there's something fishy with your bridge file - post lines 24-28 from your bridge file (replace your password with ***), should look like this// database configuration
define('PHPBB_DB_NAME', 'your_database_name'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server
define('PHPBB_DB_USERNAME', 'your_db_username'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', '****'); // The password to use to connect to the database
Could it be that you set your database name to phpbb, although your database is named differently?
GauGau
here are the lines you requested...
// database configuration
define('PHPBB_DB_NAME', 'phpBB'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server
define('PHPBB_DB_USERNAME', 'username'); // The username to use to connect to the da
define('PHPBB_DB_PASSWORD', '***'); // The password to use to connect to the
ok, so your username is actually "username"? I don't think so...
You start by actually filling the values into the bridge file that apply to your server. Recommended reading: http://coppermine.sourceforge.net/manual.php#integrating
GauGau
no no, I just changed that. Figured since you asked to change the pass I mise well hide the username.
I had filled out the values accordingly from "http://coppermine.sourceforge.net/manual.php#integrating"
ok, what value do you have for define('PHPBB_DB_NAME', 'phpBB'); // The name of the database used by the board
?
GauGau
all my values were as I posted except for the user and pass...
I am guessing I was supposed to change that value? I left as it was, as I thought thats the name you want it to use or something.. I tried putting my SQL database name in there as well but it didnt seem to change anything.
No, you should change the 'phpBB', to the actual name of your database.
hmm, thats odd... I changed the value back to my database name and it seems to be working :)
Maybe I had made a typo when I tried my database name before?
Thanks all for your help, coppermine and phpbb both seem to be working fine :)
Keep up the great work!