Fatal Error after Bridge to phpBB 2.20

[monicads]

I have the following issue when trying to bridge coppermine and phpBB 2.20:
ERROR:
page not found
link in address bar: [http://www.metro3p.com/3p_forum/ucp.php?mode=login&redirect=http%3A%2F%2Fwww.metro3p.com%2Fcoppermine%2F]

I don't see this file in the board root dir.  I see a generic one in the 3p_forum/includes dir but that one can not be copied to the board root.

Coppermine install: http://www.metro3p.com/coppermine
Forum install: http://www.metro3p.com/3p_forum
Coppermine version: cpg1.4.7 (straight from sourceforge today)
Forum version: phpBB v2.20
Test user account:  testacct  /  test1

BridgeManager settings:
Forum URL:  http://www.metro3p.com/3p_forum
Relative path to your BBS's config file:  ../3p_forum/ 
Use post-based groups?:  1 
   I've also tried this setting @ 0.

I've done everything but stroke this setup before I gave up the ghost and now requesting support.
Thanks.

[Nibbler]

I expect you are using 2.0.20, not 2.20. Take care to selected the correct option in the bridge manager.

[monicads]

I just download the 2.20 thinking I had the 2.0.18 but the update file said 2.20 is already installed and no updates are necessary.

[monicads]

Your right! my new configuration and error is:
Coppermine install: http://www.metro3p.com/coppermine
Forum install: http://www.metro3p.com/3p_forum
Coppermine version: cpg1.4.7 (straight from sourceforge today)
Cookie setting: ppp
Forum version: phpBB v 2.0.21
Test user account:  testacct  /  test1

ERROR: There was an error while processing a database query  during enable of bridge.

BridgeManager settings:
Forum URL:  http://www.metro3p.com/3p_forum
Relative path to your BBS's config file:  ../3p_forum/
Board Cookie setting: mppp3
Use post-based groups?:  1 

[Nibbler]

Test account does not work.

[monicads]

your right again, the username is 'testaccount' not  testacct

[Nibbler]

OK, disable the bridge, enable debug mode in config, enable the bridge and see what the real mysql error message you get is.

[monicads]

First thank you for responding so quickly.

Next this is what I got.
While executing query "SELECT * FROM `3p_membership`.3pf_groups WHERE group_single_user = 0" 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 '.3pf_groups WHERE group_single_user = 0' at line 1

I check the debug for further version info in case you needed to know this also.
==========================
VERSION INFO :
------------------
PHP version: 4.3.11 - OK
------------------
mySQL version: 4.0.27-max-log
------------------
Coppermine version: 1.4.7(stable)
==========================

[Nibbler]

Try changing

Code Select Expand

$this->groupstable =  '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['groups'];

to

Code Select Expand

$this->groupstable =  $this->db['name'] . '.' . $this->db['prefix'] . $this->table['groups'];

in the bridge file.

[monicads]

Thanks, Done, however that just resulted in yet another error;
PAGE:
Fatal error :


DEBUG:
While executing query "SELECT u.user_id AS user_id, u.user_password AS password, u.user_level FROM `3p_membership`.3pf_users AS u, `3p_membership`.3pf_sessions AS s WHERE u.user_id=s.session_user_id AND s.session_id = '3359027f60b37ae11985812827c1c917' AND u.user_id > 0" 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 '.3pf_users AS u, `3p_membership`.3pf_sessions AS s WHERE u.user

[Nibbler]

Apply the same fix there then.

Code Select Expand


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


all changes to

Code Select Expand


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


[monicads]

U the Man!  My first born is promised, but you came so close.

In case I need to say it for others.  It worked.

Thank you.