query failed error

Events happening in the community are now at Drupal community events on www.drupal.org.

Posted by drupalxykon on October 1, 2007 at 12:09pm

Hi,

I installed http://ftp.drupal.org/files/projects/phpbb-5.x-1.1.tar.gz with phpBB2.0.22 and Drupal 5.2

I try to load my website after enabling the module (and setting the paths), I get this error:

Query failed: SELECT topics.topic_id, topics.topic_title, topics.topic_last_post_id FROM topics LEFT JOIN forums ON topics.forum_id = forums.forum_id WHERE forums.auth_view = 0 ORDER BY topic_last_post_id DESC LIMIT 10;

These tables exist in my phpBB database, but obviously not in my drupal database

Am I supposed to tweak any files? I followed instructions on http://kepp.net/drupal/node/1

Categories: phpBB

Comments

Connection caching

Posted by arkepp on October 1, 2007 at 12:59pm

arkepp's picture

You're probably experiencing a PHP bug related to connection caching, where PHP tries to reuse the connection to the Drupal database for phpBB queries.

One solution is to put all tables into the same database and use prefixes to distinguish phpBB and Drupal. The other alternative is to set database host to 127.0.0.1 in Drupal and 'localhost' in phpBB, that'll create two different connections, one using sockets, the other using TCP.