forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 bridging => Topic started by: Darkscale on January 27, 2007, 10:35:08 pm
-
I have the following issue when trying to bridge coppermine and phpbb 2.0.22:
While executing query "SELECT u.user_id, u.user_password, u.user_level FROM `sql.free.fr`.ruffforum_sessions_keys AS s
INNER JOIN `sql.free.fr`.ruffforum_users AS u ON s.user_id = u.user_id WHERE u.user_id = '2' AND u.user_active = 1 AND s.key_id = MD5('80c82e9df9e6773bf97fb9106987dd52')" on Resource id #9832552
mySQL error: Incorrect database name 'sql.free.fr'
Coppermine install: http://dpslegion.free.fr/galerie/
Forum install: http://dpslegion.free.fr/ruffforum/
Coppermine version: cpg1.4.10(stable)
Forum version: PhpBB 2.0.22
Test user account: ID: don't needed
BridgeManager settings:
Forum URL: http://dpslegion.free.fr/ruffforum
Relative path to your BBS's config file: ../ruffforum/
Use post-based groups?: 0
Cookie name/preifx: phpbb2mysql
Hope you will be able to help me :)
-
Database names should not contain dots. This is illegal. There are workarounds posted (mainly on the french board) that you will need to apply/adapt to the phpbb bridge file.
http://forum.coppermine-gallery.net/index.php?topic=24988
http://forum.coppermine-gallery.net/index.php?topic=24876
-
I tried that i saw on the topics linked, always the same error.
I'm sure that's a problem with the configuration of Coppermine, that's my config.inc:
// MySQL configuration
$CONFIG['dbserver'] = 'sql.free.fr'; // Your database server
$CONFIG['dbuser'] = 'dpslegion'; // Your mysql username
$CONFIG['dbpass'] = '*****'; // Your mysql password
$CONFIG['dbname'] = 'dpslegion'; // Your mysql database name
I tried to change 'sql.free.fr" by sql_free_fr, sql_free.fr, ... nothing change and the error say the same thing.
I don't understand why the error speak about sql.free.fr whereas I changed by _ .
Help ???
-
You need to change the bridge file, not config.inc.php.
-
OK then, plan B is to hack the code.
bridge/coppermine.inc.php
$this->sessionstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['sessions'];
change to
$this->sessionstable = $this->db['prefix'] . $this->table['sessions'];
I made this, but the error is always here after bridging.
Always this:
While executing query "SELECT u.user_id, u.user_password, u.user_level FROM `sql.free.fr`.ruffforum_sessions_keys AS s
INNER JOIN `sql.free.fr`.ruffforum_users AS u ON s.user_id = u.user_id WHERE u.user_id = '2' AND u.user_active = 1 AND s.key_id = MD5('c9603e98801b1c19d0359c32c303ba38')" on Resource id #9789736
mySQL error: Incorrect database name 'sql.free.fr'
???
-
You need to change it for each table, see http://forum.coppermine-gallery.net/index.php?topic=24988.msg114975#msg114975
-
I changed each table as it:
// Derived full table names
// $this->usertable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['users'];
$this->usertable = $this->db['prefix'] . $this->table['users'];
// $this->groupstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['groups'];
$this->groupstable = $this->db['prefix'] . $this->table['groups'];
// $this->sessionstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['sessions'];
$this->sessionstable = $this->db['prefix'] . $this->table['sessions'];
Always the same thing: I finish to bridge and error.
-
You need to change them all, so from
// Derived full table names
$this->usertable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['users'];
$this->groupstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['groups'];
$this->sessionstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['sessions'];
$this->usergroupstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['usergroups'];
$this->sessionskeystable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['sessionskeys'];
to
// Derived full table names
$this->usertable = $this->db['prefix'] . $this->table['users'];
$this->groupstable = $this->db['prefix'] . $this->table['groups'];
$this->sessionstable = $this->db['prefix'] . $this->table['sessions'];
$this->usergroupstable = $this->db['prefix'] . $this->table['usergroups'];
$this->sessionskeystable = $this->db['prefix'] . $this->table['sessionskeys'];
-
Done.
Now I get this error when I go on the Gallery:
While executing query "SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, ug.user_group AS group_id FROM cpg_users AS u, cpg_ AS ug WHERE u.user_id=ug.user_id AND u.user_id='1'" on Resource id #5
mySQL error: Table 'dpslegion.cpg_' doesn't exist
-
I don't know what you did to cause that. Make sure you did exactly as instructed.