Problems once integrated with Invision Board

[Filigree]

After integration, and update a few problems have occured in my Coppermine Gallery.

1) You can not login in from the gallery, only from Invision Board.  Clicking the Gallery's Login link takes you to an inexistent page.
2) You cannot view the Admin's User list.  Once again, takes you to an inexistant page.
3)Cannot logout from Gallery, takes you to inexistant page
4)Admin Tools brings up "Critical Error: There was an error while processing a database query "

I have checked my config and init.inc files, and my bridge files, they all seem to be configured properly. 

I had upgraded from the dev4 version to the stable.

Any ideas?


-Taylor Carlson

[Casper]

Did you update all your files, including the bridge files?

[hyperion]

Yes, an update was done to the server paths in all files to bring them in line with W3C's HTTP standards.  Some users with non-standard server settings may have trouble with this, but it can be fixed with ease. 

To verify that this is the case please post a link, or explain what URL it is trying to go to vs. what it should be.

[Filigree]

Yes, I updated all files, and double checked all Invision Board database settings.

Gallery:
http://despairfaction.ca/gallery/index.php

Logout:
http://despairfaction.ca/gallery/logout.php?referer=%2Fgallery%2Findex.php

Usermgr:
http://despairfaction.ca/gallery/usermgr.php

User manager and Admin tool both go to the correct URL I believe.  In the past, Usermanager would direct me to Invision Boards Admin Panel, now however, I get a Cannot find server error.
Everything else works relatively great..

Oh.  And the Login link "should" be directed to  http://despairfaction.ca/colloquium/ , atleast that was where it would direct users before.

[Filigree]

Could this have something to do with the fact that my original installation was of 1.1, and I have been upgrading ever since?  Maybe something was missed or configured improperly along the way?

So, I just did a seperate clean install in another directory, to see if had something to do with the upgrade, or the bridging with Invision Board itself.  The clean install has the exact same problem.  So, it must have something to do with the bridge or Invision Board itself.

[psychowolfman]

I am seeing similar behavior.

I had a 1.2 album that I had upgraded and it had many problems, so I installed from scratch...and I still have the same problems.

Invision is version 1.3

When I turn php debuggin on I get errors like so:

Undefined index: cat_thumb in /home/sask/public_html/gallery/themes/saskmetal/theme.php on line 1048 (Main gallery page, index.php)

While executing query "SELECT aid, category, IF(name IS NOT NULL, CONCAT('(', name, ') ',title), CONCAT(' - ', title)) AS title FROM cpg130_albums AS a LEFT JOIN ibf_members AS u ON category = (10000 + id) ORDER BY category, title" on

mySQL error: Table 'sask_gallery.ibf_members' doesn't exist

AND

File: /home/sask/public_html/gallery/include/functions.inc.php - Line: 110

When I click ADMIN TOOLS.

Also, if I disable debugging, I simply get an error on the admin tools page, and nothing else...but if debugging is enabled it shows the above error, then renders the page (Inside of the frame, the whole page again) and then where the album select box should be at the bottom I have:

Select album

Notice: Undefined variable: UDB_DB_NAME_PREFIX in /home/sask/public_html/gallery/bridge/invisionboard.inc.php on line 374

Notice: Undefined variable: UDB_DB_LINK_ID in /home/sask/public_html/gallery/bridge/invisionboard.inc.php on line 377


EDIT: Also, it appears as the bulk add photos thing doesn't work.  It says "This function allows you to add a batch of file that your have uploaded to your server by FTP.  Select the directory where you have uploaded your files"  But there's no place to select a directory...(It can't be in userpics, just in albums dir then it works...previous versions it could be in the userpics dir.)

[hyperion]

@Psychowolfman,

What is the name of your Invision members table in the database?

@Filigree,

Please give me something like:

It should go here: http://www.mywebsite.com/forums/admin.php

But it tries to go here: http://www.mywebsite.com/charles/admin.php

@all:

I picked up a copy of IPB 1.3, and should be able to test it soon. Please remember to activate debug mode.

[athlonkmf]

My members notified me that they can't login either with other browsers than explorer because of some cookiesprobs.

Even when logged in with the forum and then going to the gallery would leave them logged out   :-\\

Of course. the login/logout-link is also not working as told before.

[psychowolfman]

@Psychowolfman,

What is the name of your Invision members table in the database?

My invision members is ibf_members in my invision database...

coppermine has it's OWN database seperate from Invision though, and that SQL error is true in that ibf_members doesn't exist is THAT database.

[deocare]

IM having the same problem.

cant logout from coppermine
can user ADMIN tool and other

SOmeone help me fix this?

[deocare]

anyone ? i cant fix it yet.

[Qest]

Same problem... except in my case it was a fresh install of both scripts.

[Casper]

Can you all please state if you have coppermine on the same database as the forum, or on different databases.

[psychowolfman]

Can you all please state if you have coppermine on the same database as the forum, or on different databases.

Mine are in seperate db's

[Filigree]

Both Coppermine and Invision Board are sharing the same Database in my case.

After enabling debug mode, I have concluded that my difficulties are due to the same problem that pychowolfman is experiancing.

After rumaging through some files, a common reccuring error seems to be with $UDB_DB_LINK_ID and $UDB_DB_NAME_PREFIX.  Both in the Bridge file and inc/function file.  

'Title' in the Admin Tools script seems to be an unknown value.

Users goes here: http://despairfaction.ca/gallery/usermgr.php  (displays cannot find sever page)
It should go here:http://despairfaction.ca/colloquium/index.php?act=Members

Admin Tools goes to the correct localation, however a Database Query Error is shown.  Debug info infers that 'title' is an unknown value.

I'm sorry I cannot be of more help, but as my gallery recieves high amounts of traffic, I'm afraid it may disrupt my users experiance, and become a security risk if I enable debug mode and leave it viewable to everyone.

[hyperion]

Thank you, Filigree, for the helpful information.  I'm integrating CPG and IPB 1.3 on my server tonight, and I will check this out in more detail.

[psychowolfman]

Last night I decided to try and move my coppermine database into the same db as invision.  Upon doing that, the sql error stating ibf_members doesn't exist is replaced with a different error.  I can't remember what it was now, but it basically said something in the ibf_members table wasn't there.

Regardless, the error creates the same results to the end user.

I've also noticed that when you try and send an ecard with invision integration switched on there's no where to put in your email address and when you hit submit it tells you invalid email.  However, this does work if you run standalone and log in through coppermine's system.

[Casper]

If you moved the database, did you remember to update your bridge file?

[psychowolfman]

If you moved the database, did you remember to update your bridge file?

You bet I did.  At first it was giving me the same ibf_members not found error, then I remembered, "Oh yeah...gotta change the access settings"  After changing that I got a different error, but it still involved the ibf_members table.  I'm not at home now, so I can't re-test it, but I could tonight and post the exact error here.

[hyperion]

Okay, I've integrated IPB 1.3 and Coppermine.  

I found that the Admin tools error is an actual bug, and I have attached a new revision of the IPB bridge that should fix the issue. I introduced this bug when introducing album list support for the Admin tools page.  You will need to change the extension from  .txt to .php.

I had no difficulties with login/logout links, profiles, or user editing.  This makes me suspect that those having problems have not properly specified the path in the bridge, or they do not have the $_SERVER['HTTP_HOST'] variable available.

The relevant bridge value here is:

Code Select Expand


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


If you verify that the path is correct but still have problems with linking, you are advised to change

Code Select Expand


// Redirect
function udb_redirect($target)
{
   header('Location: http://' . $_SERVER['HTTP_HOST'] . IB_WEB_PATH . $target);
   exit;
}


to

Code Select Expand


// Redirect
function udb_redirect($target)
{
   header('Location: ' . IB_WEB_PATH . $target);
   exit;
}


This will change the link back to a relative path.  Users are warned, however, that this does not conform to WC3 standards and may result in broken links on standards compliant servers and clients. If you suspect the problem lies with the $_SERVER['HTTP_HOST'] variable (as seen in the redirect function), you may try hard coding the value.

Code Select Expand


// Redirect
function udb_redirect($target)
{
   header('Location: http://www.mysite.com'. IB_WEB_PATH . $target);
   exit;
}


or even

Code Select Expand


// Redirect
function udb_redirect($target)
{
   header('Location: http://www.mysite.com/forums/'. $target);
   exit;
}


[attachment deleted by admin]