forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 bridging => Topic started by: monicads on June 07, 2006, 10:18:58 pm
-
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.