fatal error - problems intergrating with IPB

[SMiFFAD]

Hello there...

Bear with me as im a bit new at most of this, so its a trip into the unknown somewhat.

I have done a search, read the documentation and retraced my steps a couple of times, and i still cant get it to work 

Situation:

I have an invision board (v2.0.4 - www.ultimatejapcars.co.uk/forums) and a copper mine gallery (www.ultimatejapcars.co.uk/gallery)  Standalone, they work perfectly.... but i want to intergrate the galelry into the forum, using the forums members database.  i have followed the instructions, after i upload the bridge and include php files, all i get is:

"Fatal error :
There was an error while processing a database query"

To me this says its able to access the database (so access info is correct), but having problems with a query.....?

Is anyone able to shed some light on this, as i dont know who else to ask 

Thanks in advance for any help 

[SMiFFAD]

Apologies... ive just realised ive posted this in the wrong place 

[Nibbler]

Are you using the ipb2 bridge file from the forum or the ipb1.3 bridge file from the coppermine package ?

[SMiFFAD]

Are you using the ipb2 bridge file from the forum or the ipb1.3 bridge file from the coppermine package ?

The one that came with the coppermine package... is this where the problem lies? 

[Stramm]

recheck db host, db name, db user, db password in the bridgefile. If that info is wrong you'll get the 'Fatal error'

[SMiFFAD]

recheck db host, db name, db user, db password in the bridgefile. If that info is wrong you'll get the 'Fatal error'

Thats deffo right, if i put in incorrect info, i get a different error, saying its unable to access the database etc....  :-\\

[Stramm]

tell me your invision board database name (best is copy/ paste)
and then do the same with the info in the bridge file (that one -> define('IB_DB_NAME', 'ivboard');)

if these don't match you'll get ... Fatal error

[SMiFFAD]

Right... solved half the problem - using the updated bridge file from on here  it now seems to be at least making the effort to work 

New problem... having installed the updated bits, i click log in, it takes me to a log in screen for my board... tap in my details, logs me into my board, not the gallery...

Im sure ive missed something simple.. anyone make me look stupid and tell me? 

[Nibbler]

http://forum.coppermine-gallery.net/index.php?topic=17684.0

We need at least a test user account to troubleshoot login issues.

[Stramm]

If I'm not totally mistaken the invision bridge didn't support redirecting to 100%.. there was an hack though (somewhere on the invision site). Try to search the board and you'll find what I mean

[SMiFFAD]

right, test account...

user: copper test
pass: test

Links:
http://www.ultimatejapcars.co.uk/forum
http://www.ultimatejapcars.co.uk/gallery

Ive found the refer problem was due to the firewall on my pc, disabled it, it redirects back to the galley, BUT im still not logged in and unable to see the admin CP on the gallery... doh 

Cheers for your help guys, so close to getting it going 

[SMiFFAD]

Just to further confsue the problem, it seems the only people who can now log onto the gallery are those who were set up BEFORE i intergrated....

Using a test account i have on the board that wasnt set up on the gallery doesnt re-direct back to the gallery, it actually logs the account into the board..

*confusion*

Possibly something to do with syncronising the members lists? which i read about, but if i am unable to log in as admin, i cant do this 

[Nibbler]

Please post the rest of the information requested in the link.

[SMiFFAD]

Please post the rest of the information requested in the link.

Ah apologies, trying to do a million things at once - thanks for being patient!

Below is the bridge file, sensitive info removed, the int.inc.php file has had the "//"'s removed before the invisionise entry, and the new login.php file has been uploaded into my sources folder...and i obviously have admin rights on the board/database etc.

Code Select Expand

// database configuration
define('IB_DB_NAME', '*******'); // The name of the database used by the board
define('IB_BD_HOST', '**********'); // The name of the database server
define('IB_DB_USERNAME', '*******'); // The username to use to connect to the database
define('IB_DB_PASSWORD', '******'); // The password to use to connect to the database

// The web path to your Invision Board directory
// In this example http://yoursite_name.com/ivboard/
define('IB_WEB_PATH', '/forum/');

[Stramm]

can't work... as mentioned in the docs it's best to have the forum and the gallery on the same domain.
After I log into your forum I'm redirected to http://domain839233.sites.fasthosts.com/forum//index.php
means the cookie with the login info is for that domain and cpg's looking for a cookie for the domain www.ultimatejapcars.co.uk. And here's no login info stored

[SMiFFAD]

can't work... as mentioned in the docs it's best to have the forum and the gallery on the same domain.
After I log into your forum I'm redirected to http://domain839233.sites.fasthosts.com/forum//index.php
means the cookie with the login info is for that domain and cpg's looking for a cookie for the domain www.ultimatejapcars.co.uk. And here's no login info stored

See what you mean... but... my book mark for the forum is "http://domain839233.sites.fasthosts.com/forum//index.php" and i access the gallery in the same way.. so am i right in thinking my cookies should be able to work.. but people coming in via the domain will have problems?

[Stramm]

there's more wrong... you still haven't posted all the requested info! I need to see the bridgefile down to // Nothing to edit below this line

and do me a favour... check define('IB_COOKIE_PREFIX', '');
here goes your invision cookie prefix.. and as it looks you've forgotten to update that line
should be ujccgall ... I guess

[SMiFFAD]

there's more wrong... you still haven't posted all the requested info! I need to see the bridgefile down to // Nothing to edit below this line

and do me a favour... check define('IB_COOKIE_PREFIX', '');
here goes your invision cookie prefix.. and as it looks you've forgotten to update that line
should be ujccgall ... I guess

Ahhhhhhhhh  sussed it.... i haddnt edited the board cookie prefix, so that was wrong...

Many thanks for your help guys, wouldnt have been able to do it without it 

If i knew who you were id take you all out for a beer 

[Stramm]

perfect... checked and for me all's working excellent. Even the redirection. Looks nice

Good luck and thanks for the beer