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.
I expect you are using 2.0.20, not 2.20. Take care to selected the correct option in the bridge manager.
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.
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
Test account does not work.
your right again, the username is 'testaccount' not testacct :(
OK, disable the bridge, enable debug mode in config, enable the bridge and see what the real mysql error message you get is.
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)
==========================
Try changing
$this->groupstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['groups'];
to
$this->groupstable = $this->db['name'] . '.' . $this->db['prefix'] . $this->table['groups'];
in the bridge file.
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
Apply the same fix there then.
// 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
// 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'];
U the Man! My first born is promised, but you came so close. :D
In case I need to say it for others. It worked.
Thank you.