Hi
I have to integrate an existing PhpBB 2.X into Drupal, so I tried out the PHPBB integration module. After first trying to integrate an fresh php bb installation into a fresh drupal installation I failed after deleting the cookies and log in again (a did everything according to the manual at http://kepp.net/drupal/. I got the following text in my browser:
Warning: Table 'phpbb.fixwatchdog' doesn't exist query: INSERT INTO fixwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Table 'phpbb.fixwatchdog' doesn't exist\nquery: INSERT INTO fixwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'user', 'Session opened for <em>funkyfrieder</em>.', 0, '', 'http://localhost/dnp/?destination=admin', 'http://localhost/dnp/admin', '127.0.0.1', 1186662694) in C:\development\Apache2\htdocs\dnp\includes\database.mysql.inc on line 172.', 2, '', 'http://localhost/dnp/?destination=admin', 'http://localhost/dnp/admin', ' in C:\development\Apache2\htdocs\dnp\includes\database.mysql.inc on line 172
Warning: Table 'phpbb.fixwatchdog' doesn't exist query: INSERT INTO fixwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Table 'phpbb.fixusers' doesn't exist\nquery: UPDATE fixusers SET login = 1186662694 WHERE uid = 1 in C:\development\Apache2\htdocs\dnp\includes\database.mysql.inc on line 172.', 2, '', 'http://localhost/dnp/?destination=admin', 'http://localhost/dnp/admin', '127.0.0.1', 1186662694) in C:\development\Apache2\htdocs\dnp\includes\database.mysql.inc on line 172
Warning: Table 'phpbb.fixwatchdog' doesn't exist query: INSERT INTO fixwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Table 'phpbb.fixprofile_values' doesn't exist\nquery: SELECT fixprofile_values.value AS value FROM fixprofile_values, fixprofile_fields\n WHERE fixprofile_fields.fid = fixprofile_values.fid AND fixprofile_fields.name = 'phpbb_user_interests'\n AND fixprofile_values.uid = '1' in C:\development\Apache2\htdocs\dnp\includes\database.mysql.inc on line 172.', 2, '', 'http://localhost/dnp/?destination=admin', 'http://localhost/dnp/admin', '127.0.0.1', 1186662694) in C:\development\Apache2\htdocs\dnp\includes\database.mysql.inc on line 172
....ans so one
since I have to make adjustments on the module anyways I started to find information/documen tation on how the module works, how it works together with Drupal, How drupal works (internally) but it looks like there is very litle information regarding this module. Is there no information or am I just not able to find it.
Is there anybody with a little advice, where to start and how to get a deep insight the whole topic?
Comments
PHP bug
I am pretty sure you're seeing a common bug where MySQL ignores the database connection parameter and uses a cached connection instead. The result is, like you can see above, that Drupal asks the phpBB database for the watchdog table, which only exists in Drupals database.
Three possible solutions:
1) Put both phpBB and Drupal in the same database, use different prefixes of course
2) Use 'localhost' as the hostname in one program, and '127.0.0.1' in the other
3) Use MySQLi in Drupal and MySQL in phpBB
The main thing you have to read up on are module hooks in Drupal. The module is short and there are comments, all the action really happens in phpbb_user(), so that's where you get an overview of what it tries to do. There is a separate, optional block 'Recent topics' at the bottom.
Thanks!!
Thanks a million for the quick and good answer!!
It works perfectly when I put both in the same DB.
I just had a little problem when I installed the Privatemsg module and I'm not sure if the error that occured was caused by the module itself (development status for Drupal 5) or if the modul doesn't work together properly with the PHPBB module.
My error was :
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') description varchar(255) NOT NULL, type varchar(255) NOT N' at line 1 query: CREATE TABLE drupalprivatemsg_mails ) description varchar(255) NOT NULL, type varchar(255) NOT NULL, subject varchar(255) NOT NULL, body varchar(255) NOT NULL, notification_subject varchar(255) NOT NULL, notification_text_body varchar(255) NOT NULL, notification_html_body varchar(255) NOT NULL, notification_group_text_body varchar(255) NOT NULL, notification_group_html_body varchar(255) NOT NULL, mailkey varchar(255) NOT NULL, PRIMARY KEY (mailkey) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in C:\development\Apache2\htdocs\drup\includes\database.mysql.inc on line 172.
but to me it looks more like a general problem of the Messenger Module
...
Update
It was a problem caused by the module in the Development status. With the stable privatemsg-5.x-1.8.tar.gz it works fine as far as I can tell at the moment.
Alright, thanks again for your help.