I'm trying to install the phpBB2 integration along with Drupal. Both are brand new installations with the newest versions. I've followed the directions exactly, but when I try to login using the Drupal login prompt at steps 32/33 of the installation, I get a page of mySQL errors. The exact errors are:

Warning: Table 'whatnnet_drupalphpbb.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'whatnnet_drupalphpbb.profile_fields' doesn't exist\nquery: SELECT f.name, f.type, v.value FROM profile_fields f INNER JOIN profile_values v ON f.fid = v.fid WHERE uid = 2 in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120.', 2, '', 'http://www.whatmission.net/drupal/node?destination=', 'http://www.whatmission.net/drupal/', '209.243.21.43', 1153176169) in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120

Warning: Table 'whatnnet_drupalphpbb.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Table 'whatnnet_drupalphpbb.watchdog' doesn't exist\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'user', 'Session opened for <em>phpbb_admin</em>.', 0, '', 'http://www.whatmission.net/drupal/node?destination=', 'http://www.whatmission.net/drupal/', '209.243.21.43', 1153176169) in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120.', 2, '', 'http://www.whatmission.net/drupal/node?destination=', 'http://www.whatmission.net/drupal/', '209.243.21.43', 1153176169) in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120

Warning: Table 'whatnnet_drupalphpbb.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Table 'whatnnet_drupalphpbb.users' doesn't exist\nquery: UPDATE users SET login = 1153176169 WHERE uid = 2 in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120.', 2, '', 'http://www.whatmission.net/drupal/node?destination=', 'http://www.whatmission.net/drupal/', '209.243.21.43', 1153176169) in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120

Warning: Table 'whatnnet_drupalphpbb.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Table 'whatnnet_drupalphpbb.role' doesn't exist\nquery: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (2) in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120.', 2, '', 'http://www.whatmission.net/drupal/node?destination=', 'http://www.whatmission.net/drupal/', '209.243.21.43', 1153176170) in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120

Warning: Table 'whatnnet_drupalphpbb.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Cannot modify header information - headers already sent by (output started at /home2/whatnnet/public_html/drupal/includes/database.mysql.inc:120) in /home2/whatnnet/public_html/drupal/modules/phpbb.module on line 436.', 2, '', 'http://www.whatmission.net/drupal/node?destination=', 'http://www.whatmission.net/drupal/', '209.243.21.43', 1153176170) in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120

Warning: Table 'whatnnet_drupalphpbb.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Cannot modify header information - headers already sent by (output started at /home2/whatnnet/public_html/drupal/includes/database.mysql.inc:120) in /home2/whatnnet/public_html/drupal/modules/phpbb.module on line 437.', 2, '', 'http://www.whatmission.net/drupal/node?destination=', 'http://www.whatmission.net/drupal/', '209.243.21.43', 1153176170) in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120

Warning: Table 'whatnnet_drupalphpbb.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'session_regenerate_id() [<a href=\'function.session-regenerate-id\'>function.session-regenerate-id</a>]: Cannot send session cookie - headers already sent by (output started at /home2/whatnnet/public_html/drupal/includes/database.mysql.inc:120) in /home2/whatnnet/public_html/drupal/modules/user.module on line 943.', 2, '', 'http://www.whatmission.net/drupal/node?destination=', 'http://www.whatmission.net/drupal/', '209.243.21.43', 1153176170) in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120

Warning: Table 'whatnnet_drupalphpbb.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Table &#039;whatnnet_drupalphpbb.sessions&#039; doesn&#039;t exist\nquery: UPDATE sessions SET sid = &#039;cf3d319ffd0071a47380cf591e349f0d&#039; WHERE sid = &#039;992822981ab2f1f1eb1f1ed988e41c90&#039; in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120.', 2, '', 'http://www.whatmission.net/drupal/node?destination=', 'http://www.whatmission.net/drupal/', '209.243.21.43', 1153176170) in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120

Warning: Table 'whatnnet_drupalphpbb.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Cannot modify header information - headers already sent by (output started at /home2/whatnnet/public_html/drupal/includes/database.mysql.inc:120) in /home2/whatnnet/public_html/drupal/includes/common.inc on line 266.', 2, '', 'http://www.whatmission.net/drupal/node?destination=', 'http://www.whatmission.net/drupal/', '209.243.21.43', 1153176170) in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120

Warning: Table 'whatnnet_drupalphpbb.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Table &#039;whatnnet_drupalphpbb.sessions&#039; doesn&#039;t exist\nquery: SELECT sid FROM sessions WHERE sid = &#039;cf3d319ffd0071a47380cf591e349f0d&#039; in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120.', 2, '', 'http://www.whatmission.net/drupal/node?destination=', 'http://www.whatmission.net/drupal/', '209.243.21.43', 1153176170) in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120

Warning: Table 'whatnnet_drupalphpbb.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Table &#039;whatnnet_drupalphpbb.sessions&#039; doesn&#039;t exist\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&#039;cf3d319ffd0071a47380cf591e349f0d&#039;, 2, 0, &#039;209.243.21.43&#039;, &#039;messages|a:1:{s:5:\\&quot;error\\&quot;;a:9:{i:0;s:284:\\&quot;user warning: Table &amp;#039;whatnnet_drupalphpbb.profile_fields&amp;#039; doesn&amp;#039;t exist\\nquery: SELECT f.name, f.type, v.value FROM profile_fields f INNER JOIN profile_values v ON f.fid = v.fid WHERE uid = 2 in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120.\\&quot;;i:1;s:528:\\&quot;user warning: Table &amp;#039;whatnnet_drupalphpbb.watchdog&amp;#039; doesn&amp;#039;t exist\\nquery: INSERT INTO wat in /home2/whatnnet/public_html/drupal/includes/database.mysql.inc on line 120

I also got similar errors when I logged off in step 32.

I've actually tried adding a watchdog table to the phpbbdrupal database, and the errors go away, but I am then unable to login at all.

Did I miss something in the installation?

Thanks.

Comments

arkepp’s picture

arkepp commented

'whatnnet_drupalphpbb.watchdog'

Either Drupal is configured to use the wrong database or you have not completely installed Drupal into the database whatnnet_drupalphpbb, I don't believe this has anything to do with the module.

dahli.llama’s picture

dahli.llama commented

Ok, maybe you can help me out then.

I have a full Drupal install in the whatnnet_drupal472 database. I then have a new install of phpBB2 in the phpBB2 subdirectory under Drupal and it uses the database whatnnet_drupalphpbb. Both of them work fine seperately. I am able to login on both and post/add content/etc. Once I run the module install and try to log out for the first time, then I start getting the errors.

Is there something in the module that changes which database drupal is pointing to? Is it easier to install both drupal and phpbb in the same database?

I will be giving this another try today. Thanks for the help so far.

dahli.llama’s picture

dahli.llama commented
Status: Active » Fixed

Ok, I was able to get things working when I put both the drupal and the phpBB install into the same database.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)
emackn’s picture

emackn commented

I'm having this same issue. The one problem is that I do not have the option of installing drupal and phpbb on the same database. Is there any other steps to take when using different databases? I know I'm missing something. My exploits so far are here, http://drupal.org/node/102020 .

vm’s picture

vm commented

unfortunatly not at this time. the only way to use this is with phpbb and drupal in the same database so they can share certain table within that database. I don't think this is the fault of the module itself or drupal itself. Very well may be the way phpbb is coded that doesnt make it share friendly.

arkepp’s picture

arkepp commented

All my sites mac1.no, linux1.no, ipod1.no, video1.no run with separate databases for Drupal and phpBB.

Ages ago I had problems with database connection persistence, and it COULD be what you are struggling with right now. I.e. you make a connection for database1 , $dbc1, and another one for database 2, $dbc2. But then when you call $dbc1 in a script, after you have created $dbc2, it still connects you to $dbc2.

The easiest way to check this is to code up a new script to test it. I think a (costly) work-around is to use 127.0.0.1 instead of localhost for one of the connections, but that won't work everywhere either.

No such problems with recent versions though, I currently use mysqli.

emackn’s picture

emackn commented

Whats getting me is that I have it all running on another host and it works fine with the separate databases.

So annoying ;) It's probably something silly like a empty space at the end of some file or untrimmed string screwing everything up. lol

Is there any setting for how many db connections get cached in mysql or php? Just a thought.

arkepp’s picture

arkepp commented

You can disable persistent connections in php.ini, possibly through .htaccess as well.

By default every connection is persistent, based on the ip-address that the hostname resolves to. Note that localhost is special and uses a UNIX socket (on Unix anyway), so 127.0.0.1 is not the same as localhost, hence you can use the two to avoid persistence issues.

emackn’s picture

emackn commented

Thanks, setting the other connection string to use 127.0.0.1 instead of localhost did the trick for me. The settings in the php.ini file are set for persistent connections.
Specifically, I edited the phpbb config.php file that you're not supposed to edit.

mierdin’s picture

mierdin commented
Title: mySQL errors when attempting to login after phpbb integration module installation. » mySQL errors when attempting to login after phpbb integration module installation

Isn't there some config file that allows you to change where the module is looking for these tables?

Obviously right now the problem is that it's looking in the drupal db, but these tables for me exist my phpBB db.
That's why I'm getting the same errors that are described here.

Any way I can change a value to force the module to look in the phpBB db? Seems like a pretty simple config file change.