Fatal error...

[vanessa]

Hello,

I installed coppermine yesterday and now I wanted it to bridge (or how do you say this ?!) with my Phpbb.  I did everything as explained in the manual and after uploading the files I get the following error :

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

url : www.vakantieweetjes.be/cpg133 : coppermine
www.vakantieweetjes.be/forum : phpbb
www.vakantieweetjes.be : home

I use phpBB 2.0.14 and I use 2 databases as I did not know how to use only one...
I created a new user (with all priviliges) for the phpbb db as I did not remembered my password, the same user I use in the coppermine db.

These are the changes I made :

in phpbb.inc.php:

Code Select Expand

// database configuration
define('PHPBB_DB_NAME', 'phpBB2'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server
define('PHPBB_DB_USERNAME', 'vanessa'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', '******'); // The password to use to connect to the database

// The web path to your phpBB directory
// If your URL to your board is for example 'http://yoursite_name.com/phpBB2/',
// you'll have to set the below var to '/phpBB2/'.
define('PHPBB_WEB_PATH', '/forum/');
// Logout Flag
// the value of this boolean constant depends on your phpBB version:
// If your version of phpBB is 2.0.4 or lower - change the value to FALSE;
// if your version of phpBB is 2.0.5 or newer - leave it as TRUE
define('PHPBB_LOGOUT_GET', TRUE);

in init.inc.php :

Code Select Expand


define('COPPERMINE_VERSION', '1.3.3');
// User database integration
// Uncomment the applicable line if you want to use it
define('UDB_INTEGRATION', 'phpbb');
// define('UDB_INTEGRATION', 'invisionboard');
// define('UDB_INTEGRATION', 'vbulletin23');
// define('UDB_INTEGRATION', 'vbulletin30');
// define('UDB_INTEGRATION', 'yabbse');
// define('UDB_INTEGRATION', 'smf');
// define('UDB_INTEGRATION', 'woltlab21');
// define('UDB_INTEGRATION', 'punbb');

created cpg_redir.php :

Code Select Expand

<?php
if (!$_SERVER['HTTP_HOST']) {
  $cpg_host=$HTTP_SERVER_VARS['HTTP_HOST'];
} else {
  $cpg_host=$_SERVER['HTTP_HOST'];
}
$cpg_path='/cpg133';
header("Location: http://".$cpg_host.$cpg_path);
exit;
?>

Thanks in advance for the help !

[Nibbler]

They have to be in the same database, it's not optional.

[vanessa]

oh, dear, and how do I do that ?... I'm not an expert with PHPmyadmin...

[Nibbler]

You can move coppermine into the phpbb database using phpMyadmin and then edit coppermine's include/config.inc.php so that it contains the information of the phpbb database. To move coppermine you need to use 'export' in phpmyadmin while in the coppermine database, that will give you a file of all coppermine's database tables. You then switch to the phpbb database in phpmyadmin and click on the SQL tab, upload the file, and that will import the coppermine tables into the ipb database. Then you have to edit coppermine's include/init.inc.php with your FTP client and fill in the new database information. You can get the right information from phpbb's config file, but don't change the table prefix. Once you have done this, they will be in the same database and should bridge with no problems.

[vanessa]

ok, I did the export, switched to the phpbb db, clicked SQL, and then, what do  I then ?... Where is the file that I need to upload stored ?...

[vanessa]

well, I think  I got it now, but I got a problem with changing the config.inc.php, when I upload the changed file I get an error, saying "Can't open that file: Permission denied" ... What now ?

[vanessa]

ok, the config.in.php problem is solved...

But when I try to open my coppermine, I still get the same error as in the beginning...

[Nibbler]

OK, comment

Code Select Expand

define('UDB_INTEGRATION', 'phpbb');

back out again to disable the bridge, enable debug mode in config, then uncomment the line to re-enable the bridge. Then post the error message you get instead of 'There was an error while processing a database query'.

[vanessa]

hey,

sorry for the late reply...
I just did what you asked and now I get the followong error :

Code Select Expand

Fatal error :

There was an error while processing a database query.
While executing query "SELECT user_id, username as user_name, user_level FROM `phpBB2`.phpbb_users WHERE user_id='2' AND user_password='09623cbc1928aae17a97cfaf0269cf5f' AND user_active='1'" on 0

mySQL error: select command denied to user: 'vanessa@localhost' for table 'phpbb_users'

[Nibbler]

Then you have to edit coppermine's include/init.inc.php with your FTP client and fill in the new database information. You can get the right information from phpbb's config file, but don't change the table prefix.

Have you done that ?

[vanessa]

I did what you asked but again :

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

[Nibbler]

If you can't work it out, you can PM me an FTP login to your coppermine dir.

[vanessa]

I think  I got it now !!!
I had forgotten to make the new changes in the phpbb.inc.php...

Thanks alot for your time and help!!!! You're the best !

EDIT : I just discovered a new problem, I logged in as test person, created an album, but he can't seem to recognize the username, he gives 3x? as user with the photos... How can I solve that one ??

[Nibbler]

Only phpbb users can be recognised by coppermine, any users that were in coppermine before cannot be used.