Error while processing a database query, when bridged to phpBB Error while processing a database query, when bridged to phpBB
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

Error while processing a database query, when bridged to phpBB

Started by artisticlight, October 01, 2006, 06:17:55 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

artisticlight

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