[Solved]: Error accessing main gallery page after PHPBB integration..

[jamz310]

Running latest Compermine and PHPBB. Both running fine stand alone. After doing the PHPBB intergration I get the following error in the debug mode in the main gallery page.

There was an error while processing a database query.

While executing query "SELECT COUNT(*) FROM **ERROR**" 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 '**ERROR**' at line 1

File: /home/jammer31/public_html/photo/include/functions.inc.php - Line: 105

I can log into PHPBB from the gallery page and I get directed to the BBS ok. But I stay in the BBS.  If I click my gallery link, I get there but with the same error.
Just going to the gallery site straight off gets the error. On the main gallery page I can click other buttons like top rated most viewed and they all work fine and I can see the photos. Only if debug is turned on. Without debug - I get just a blank block with"There was an error while processing a database query."  

Any thoughts?


Jamz..

[jamz310]

I should metiion that I am using seperate databases. According to an older post, the code was added to allow the use of seperate databases.

$result = db_query($sql, $UDB_DB_LINK_ID);

The weird thing is...just going to the main gallery site produces the error. No loggin in ..just bringing up the site. Of course commenting out the define('UDB_INTEGRATION', 'phpbb'); and everything works fine.

Wonder  if its some kind of user account problem.
Jamz

[jamz310]

OK....here is more debug info comparing when intergration is enabled vs disabled.:


Disabled:

[27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg131_pictures WHERE pid='5'
    [28] => SELECT COUNT(*) FROM cpg131_users
    [29] => SELECT COUNT(*) FROM cpg131_online
    [30] => SELECT COUNT(*) FROM cpg131_online WHERE user_id <> 0
    [31] => SELECT user_id, user_name FROM cpg131_users ORDER BY user_id DESC LIMIT 1
    [32] => SELECT user_id FROM cpg131_online WHERE user_id <> 0



Enabled:

[27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg131_pictures WHERE pid='5'
    [28] => SELECT COUNT(*) FROM **ERROR**


Jamz..

[Joachim Müller]

where did you read that the tables could be on different databases? The docs say it must be on the same db.
When posting bridging issues, you usually provide a link and test account (non-admin).

GauGau

[jamz310]

Found the info in the folllowing thread:

http://coppermine-gallery.com/forum/index.php?topic=1876.0

My site addr : www.photofaq.net

Jamz..

[Nibbler]

It is because you are using the 'who is online' mod. It requires you to make alterations to use it in a bridged setup. Disable it in config.

[jamz310]

Yeah thanks,,

That was the problem that generated the error. Fixed that..I still have a slight problem. I go to gallery. Click logon, Redirects to BBS. Stays in BBS. OK...no biggie..I put link
to gallery. Click to gallery....not logged in. Cant login to gallery because of redirect. Where is the code that does the (re) redirect back to the gallery? Its falling down there
somewhere with the code that does some type of auto-login to the gallery I guess. Oh...looks like its in phpbb.inc.php.

Thanks,
jamz

[jamz310]

Ok...thanks for the help. Found I had a descrepency with the bbs cookie name and pphbb.inc.php cookie prefix name.

Thanx again!

Jamz..