forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 modpack by Stramm => Topic started by: artisticlight on October 01, 2006, 06:17:55 pm

Title: Error while processing a database query, when bridged to phpBB
Post by: artisticlight on October 01, 2006, 06:17:55 pm

Hello, and thanks for this great mod.

I installed the modpack today and I get an error when I try to view an image (i.e., I click on a thumbnail). The error is:

There was an error while processing a database query.

While executing query "SELECT c.msg_id, c.msg_author, c.msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, c.author_id, c.author_md5_id, c.msg_raw_ip, c.msg_hdr_ip, c.pid, u.user_avatar AS avatar_url FROM cpg_comments AS c LEFT JOIN `andrew_phpBB`.phpbb_users AS u ON c.author_id=u.user_id WHERE pid='145' ORDER BY c.msg_id ASC" on Resource id #20

mySQL error: Table 'andrew_phpBB.cpg_comments' doesn't exist

File: /hsphere/local/home/andrew/artrevealed.net/cpg/include/functions.inc.php - Line: 248


I do not get this error if I disable bridging. I am bridged to phpBB v2.0.21.

I checked through phpMyAdmin and the andrew_phpBB.cpg_comments table does not exist, but andrew_cpg.cpg_comments does. I'm not sure why cpg is looking for comments in the phpBB database.

Any help would be appreciated. Thank you.

Andrew

Title: Re: Error while processing a database query, when bridged to phpBB
Post by: Stramm on October 01, 2006, 06:32:11 pm

http://forum.coppermine-gallery.net/index.php?topic=35177.0
http://forum.coppermine-gallery.net/index.php?topic=35642.0
http://forum.coppermine-gallery.net/index.php?topic=35883.0