Error with PunBB bridge

[hypnotoad]

I'm having a strange issue with the PunBB integration.  When I edit the bridge file with the appropriate information, I get the following when I browse to my gallery:


Notice: Undefined index: group_id in /home/.rabiawasherkiln/stahler/pokerpeeps.net/gallery/bridge/punbb.inc.php on line 88

Notice: Undefined index: group_id in /home/.rabiawasherkiln/stahler/pokerpeeps.net/gallery/bridge/punbb.inc.php on line 92

Notice: Undefined index: user_id in /home/.rabiawasherkiln/stahler/pokerpeeps.net/gallery/bridge/punbb.inc.php on line 95
Fatal error :
There was an error while processing a database query

Looking at those lines in the punbb.inc.php file, there doesn't seem to be anything crazy out of whack.  Is there a change I need to make?

Coppermine 1.3.2
PunBB 1.2.2
(I'm using the dev version of the bridge by nibbler.  Another user was getting this, but seems to have it resolved on their site.  The resolution has not been posted nor have I received e-mail replies from either of the parties involved regarding this).

Thanks for any assistance you can provide.

Edit:  I used the debug file.  This is what I get:
Bridge file has been loaded
loaded punbb config file
Authenticate called
Cookie 'punbb_cookie' was found
Fatal error :
There was an error while processing a database query

[Joachim Müller]

I'm using the dev version of the bridge by nibbler.

You can't use the devel version of the bridge file (which was designed to work only with cpg1.4) with a cpg1.3.x install, this simply won't work, as the bridging concept has changed. Devel versions aren't supported anyway.

Notice: Undefined index: group_id in /home/.rabiawasherkiln/stahler/pokerpeeps.net/gallery/bridge/punbb.inc.php on line 88

Notice: Undefined index: group_id in /home/.rabiawasherkiln/stahler/pokerpeeps.net/gallery/bridge/punbb.inc.php on line 92

Notice: Undefined index: user_id in /home/.rabiawasherkiln/stahler/pokerpeeps.net/gallery/bridge/punbb.inc.php on line 95
Fatal error :
There was an error while processing a database query

Notices are irrelevant, we need the "hard" error. Enable debug mode and post what query actually fails.

Posting a link (probably http://pokerpeeps.net/gallery/  ) and a non-admin test user account (with bridging enabled) might help as well...

Joachim

[hypnotoad]

From my original post:

Edit:  I used the debug file.  This is what I get:
Bridge file has been loaded
loaded punbb config file
Authenticate called
Cookie 'punbb_cookie' was found
Fatal error :
There was an error while processing a database query

This is the most descriptive the error gets, I'm afraid.  For debug mode, it really doesn't tell me much.

[Nibbler]

That isn't what debug mode is, read the docs.

If you can't figure it out by yourself then wait for the supported stable release of 1.4.

[hypnotoad]

Doh!  Didn't realize there was a debug mode in the admin tools as well. 

Ok...I reverted back to the 1.3.2 bridge.  I've got the system in debug and here's what happens when I try to login:

While executing query "SELECT id AS user_id, username AS user_name, status FROM `databasae`.punbbusers WHERE username='2' AND password='somethinsomethin'" on 0

mySQL error: Unknown column 'status' in 'field list'


Hopefully this is what you're looking for.  Thanks in advance. 

[Joachim Müller]

Doh!  Didn't realize there was a debug mode in the admin tools as well. 

There is no debug_mode in "admin tools" afaik. Do you have another version of coppermine that I'm not aware off?

Joachim

[Nibbler]

You can't use the bridge that came with cpg 1.3.2 with punbb 1.2 as it was designed for punbb 1.1.5 and won't work. If you can get the experimental 1.3.2 <=> 1.2 bridges to work then good. If you can't then you'll have to wait for 1.4, which supports bridging to punbb 1.2.x