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
Comments
Connection caching
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.
I changed my directory from
I changed my directory from 'phpbb' to 'phpBB2'. Having briefly looked at the code , it seems like phpBB2 is hard coded?
Lots of default values are
Lots of default values are set to phpBB2, simply because that is what phpBB unpacks to, but I don't think anything was hardcoded anymore.
What lines?