Hey, I started using Coppermine and it's just too good, thanks.
But my problem is, I can't create a bridge. Even once, when I tried doing it, it crashed my IPSC totally, no pages were worked, all I got was a mySQL error about some "cegg" thing.
So I don't want this to happen again so how do I correctly do this? Thanks.
EDIT: Forgot to read the top thread so here's this:
I have the following issue when trying to bridge:
Not really an error message..
Coppermine install: http://anti-n00b.byethost13.com/ipsc/
Forum install: Nowhere, I couldn't install the forum
Coppermine version: You have currently installed: 1.4.7
Forum version: None
Test user account: Test_CM / temp
BridgeManager settings:
Forum URL: This is the part I don't get...
Relative path to your BBS's config file: This is the part I don't get...
Use post-based groups?: 0
Look in "BridgeManager settings"
How can you not know the url of your forum ?
Apparently it is http://anti-n00b.byethost13.com/ which makes the relative path ../
Well, I didn't know I should have put my forum URL on there, or something, I just didn't understand it..
Sorry, I'll try that now.
EDIT: Erm, what do I put in the first text-box? :/
EDIT AGAIN: I tried just putting the URL to my forum there, with "../" in the other box, and when I came to the last page of bridging, "There was an error while processing a database query" - that showed up..
Enable debug mode and post the mysql error message you receive when you replicate the db error.
File: /var/www/virtual/anti-n00b.byethost13.com/htdocs/ipsc/include/functions.inc.php - Line: 249
Post the mysql error message.
Oh, sorry, got the wrong Error. Here:
While executing query "SELECT * FROM `1197_anti-n00b`.1197_antin00b_membergroups" on Resource id #6
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 '.1197_antin00b_membergroups' at line 1
Got this information too, if you somehow need it:
==========================
VERSION INFO :
------------------
PHP version: 5.1.4 - OK
------------------
mySQL version: 4.1.11-Debian_4sarge3-log
------------------
Coppermine version: 1.4.7(stable)
You have exactly the same issue as http://forum.coppermine-gallery.net/index.php?topic=32405.msg150649#msg150649, solution is posted there there.
Thanks for replying again.
Quote from: Nibbler on June 07, 2006, 11:46:06 PM
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.
Um, I don't know what file you're talking about? It must be bridgemgr.php since that's the only bridge file I have.. But the first code you entered, it can't be found, therefore it can't be replaced with the other code. :S I even tried an CTRL + F search to try finding part of the words in the codes, but no luck. I even did a search in my folder where I have the Coppermine, the "Search for words in the files" thing? I searched "$this" but nothing showed up. Or maybe I'm doing something wrong? Thanks again for helping me.
bridge/smf10.inc.php
Oh, bleh. But I changed that, this comes up:
While executing query "SELECT * FROM 1197_anti-n00b.1197_antin00b_membergroups" on Resource id #6
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 '-n00b.1197_antin00b_membergroups' at line 1
Pretty much the same as the one before. And it isn't the same as the other guys error he got after. Should I just change those "Derived Full Table Names"? If yes, I tried looking for it but what you said he should change, isn't in my file, unless it's in another one... Thanks again! And sorry for being stupid.
Try it without the dbname. Note that the dash is not valid for database name, that is why we need the workaround.
Change
$this->usertable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['users'];
$this->groupstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['groups'];
to
$this->usertable = $this->db['prefix'] . $this->table['users'];
$this->groupstable = $this->db['prefix'] . $this->table['groups'];
Thank you, it worked. *thumbs up*
Thanks for helping. :)