error during integration phpbb 2.0.11 with coppermine 1.3.2

[baboon]

hi,
( i ask the same question in the french part but nobody can answer to me , so i try here  )

i have an error during integration phpbb 2.0.11 with coppermine 1.3.2

on the 'index of the gallery i have this message (in debug mode ) :

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 `artskorps.org`.phpbb_users WHERE user_id='2' AND user_password='9f2d51d70359652a77855970504e6d3c' AND user_active='1'" on 0

mySQL error: Incorrect table name 'phpbb_users'


i don't understand because the table  'phpbb_users' is existing :

Code Select Expand

Base de données artskorps.org  - Table phpbb_users  sur le serveur sql.artskorps.org

# phpMyAdmin MySQL-Dump
# version Online
# http://www.phpmyadmin.net/ (download page)
#
# Serveur: sql.artskorps.org
# Généré le : Mardi 22 Février 2005 à 13:29
# Version du serveur: 3.23.47
# Version de PHP: 4.1.2
# Base de données: `artskorps.org`
# --------------------------------------------------------

#
# Structure de la table `phpbb_users`

ectect...

so i give you the configuration of my files :

phpbb.inc.php

Code Select Expand

// database configuration
define('PHPBB_DB_NAME', 'artskorps.org'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'sql.artskorps.org'); // The name of the database server
define('PHPBB_DB_USERNAME', '****'); // 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/'.
[b]define('PHPBB_WEB_PATH', '/forum/');[/b]
// 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);
// ------------------------------------------------------------------------- //
// You can keep the default values below if your instalation is standard
// ------------------------------------------------------------------------- //
// The prefix for the phpBB cookies
define('PHPBB_COOKIE_PREFIX', 'phpbb2mysql'); // The prefix used for board cookies

// Prefix and names for the database tables
define('PHPBB_TABLE_PREFIX', 'phpbb_'); // The prefix used for the DB tables
define('PHPBB_USER_TABLE', 'users'); // The members table
define('PHPBB_SESSION_TABLE', 'sessions'); // The session table
define('PHPBB_GROUP_TABLE', 'groups'); // The groups table
define('PHPBB_UGROUP_TABLE', 'user_group'); // The group/user table


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='/gallery';
header("Location: http://".$cpg_host.$cpg_path);
exit;
?>

init.inc.php

Code Select Expand

define('COPPERMINE_VERSION', '1.3.2');
// 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');

the adress of my forum :

http://www.artskorps.org/forum/index.php

the adress of my gallery :

http://www.artskorps.org/gallery/index.php

i am on "online.net" a french server, who have some knows restrictions on php, i make modification like it's indicate in the french coppermine forum  ($PHP_SELF trouble)


thanks for you help !! 

[kegobeer]

Do you have your Coppermine and phpBB tables in the same database?

[jefvhal]

Check on your board the file config.php and on your gallery "bridge/phpbb.inc.php"

The next values have to be exactly the same:
On config.php "$dbhost = 'XXX'" and on phpbb.inc.php "define('PHPBB_BD_HOST', 'XXX')"
On config.php "$dbname = 'XXX'" and on phpbb.inc.php "define('PHPBB_DB_NAME', 'XXX')"
On config.php "$dbuser = XXX'" and on phpbb.inc.php "define('PHPBB_DB_USERNAME', 'XXX')"
On config.php "$dbpasswd = 'XXX'" and on phpbb.inc.php "define('PHPBB_DB_PASSWORD', 'XXX')"

[baboon]

Do you have your Coppermine and phpBB tables in the same database?

yes it's in the same database (i can have just one..)

Check on your board the file config.php and on your gallery "bridge/phpbb.inc.php"

The next values have to be exactly the same:
On config.php "$dbhost = 'sql.artskorps.org'" and on phpbb.inc.php "define('PHPBB_BD_HOST', 'sql.artskorps.org')"
On config.php "$dbname = 'artskorps.org'" and on phpbb.inc.php "define('PHPBB_DB_NAME', 'artskorps.org')"
On config.php "$dbuser = XXX'" and on phpbb.inc.php "define('PHPBB_DB_USERNAME', 'XXX')"
On config.php "$dbpasswd = 'XXX'" and on phpbb.inc.php "define('PHPBB_DB_PASSWORD', 'XXX')"

i 've got exactly the same.

[Nibbler]

Try setting the db name in the bridge file as blank/empty.

[baboon]

thanks !
it works !! 

[nanothree]

im getting the same sort of problem, ive tried what is in this post, my error is different though:

There was an error while processing your database query:
While executing query "SELECT COUNT(*) FROM **ERROR**" on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '**ERROR**' at line 1

can you help?

[Nibbler]

That means you have added code that is referencing the coppermine user table in a bridged install. Since this is meaningless, the variable holding the name of the user table is set to **ERROR** to avoid confusion.

[nanothree]

How do i fix this?

here is my modified code:
phpbb.inc.php

Code Select Expand


// database configuration
define('PHPBB_DB_NAME', 'liam_dreads'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server
define('PHPBB_DB_USERNAME', 'liam_liam'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', 'xxxxx'); // 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);
// ------------------------------------------------------------------------- //
// You can keep the default values below if your instalation is standard
// ------------------------------------------------------------------------- //
// The prefix for the phpBB cookies
define('PHPBB_COOKIE_PREFIX', 'phpbb2mysql'); // The prefix used for board cookies

// Prefix and names for the database tables
define('PHPBB_TABLE_PREFIX', 'phpbb_'); // The prefix used for the DB tables
define('PHPBB_USER_TABLE', 'users'); // The members table
define('PHPBB_SESSION_TABLE', 'sessions'); // The session table
define('PHPBB_GROUP_TABLE', 'groups'); // The groups table
define('PHPBB_UGROUP_TABLE', 'user_group'); // The group/user table

and my init.inc.php

Code Select Expand


// 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');


[Nibbler]

That's not the issue - you are using some mod or have made some other code changes that do not support bridging.

[Tranz]

@nanothree, you should be careful about posting admin-level passwords in public. I have x'd out your db password. You should still change it.

[nanothree]

hmmmmm, maybe its the online stats mod or the general commenst, thanks,