PhpBB3 and Dolphin 6.0.0005 Integration (ad free)

sreejumon · 03-11-2008

Hello,

I am trying to integrate Dolphin 6.0 (ad free version) with PhpBB3. I had searched in forum, but couldn't see any solution for the same. Hence starting a new thread again.

Phbbb3 installation went fine. I am using same DB for both Dolphin and PhpBB3.
I have phpbb.aemod to Dolphin module section. While uploading the module, I got the following error via email to admin account.

Code:

phpbb FuncUpdate error: mysql_query(UPDATE phpbb_users
                                               SET `user_active` = 1,
                                 `username` = 'admin',
                                 `user_password` = MD5('0e538033cf70sdsd5d5ccf68d7b5sdsd'),
                                 `user_level` = 1,
                                 `user_rank` = 1,
                                 `user_email` = 'admin@mysite.com',
                                 `user_regdate` = UNIX_TIMESTAMP('')
                                               WHERE `user_id` = 2)

Unknown column 'user_active' in 'field list'

Next error

Code:

modules_update(): invalid user identifier ($ID = '', $IsAdmin = '0')

While registering a new user at Dolphin, I am getting the following error.

Code:

phpbb FuncAdd error: mysql_query(INSERT INTO phpbb_users
                               SET `user_active` = 1,
                                 `username` = 'newuser',
                                 `user_password` = MD5('400db9d6dc4a91b9f3780e988cafc526'),
                                 `user_level` = 0,
                                 `user_rank` = 0,
                                 `user_email` = 'newuser@gmail.com',
                                 `user_regdate` = UNIX_TIMESTAMP('2008-03-10 12:07:11'),
                                 `user_style` = 1,
                                 `user_lang` = 'english',
                                 `user_dateformat` = 'D M d, Y g:i a',
                                 `user_attachsig` = 1,
                                 `user_allowbbcode` = 1,
                                 `user_allowsmile` = 1,
                                 `user_allowavatar` = 1,
                                 `user_allow_viewonline` = 1,
                               `user_id` = 53)
- Hide quoted text -

Unknown column 'user_active' in 'field list'

Let me know if anyone know how to fix this issue.

Thanks in advance
Sree

sreejumon · 03-16-2008

Since I couldn't find any solution for PhpBB3 integration, I am back to phbBB2.

After integration everything looks okay. No errors. I can register to Dolphin site and same users are getting replicated in phpBB2 forum. But I am not able to login to Forum. When I checked the users password in both tables, I can see some mismatch. Dolphin Profile table and php_users table, password field values are different for same user. If I copy the password value from profile table and update the php_users table manually, login works in both sites. I guess, something to do with MD5.

Let me know how to solve this issue.

**madman** · 03-16-2008

And when a user change his password in dolphin he cant login to phpbb. I look for it the hole day. I give up.

**Smoge** · 03-26-2008

The table structure is different between phpBB2 and phpBB3 - so the phpbb.aemodule will need work for it to function. Did you search ModMySite about this - I thought some others had some threads already going about phpBB(2)(3) in dolphin?

As for the password change problem - it is prob due to the password encryption currently being used - unless they match (or you use the same functions), the update will fail.

Smoge