I 'm a drupal fans. I try to add phpbb3 forum to my drupal5.3 by phpbb module.
Follow the website tips: http://kepp.net/phpbb3/
try it step by step for several times.

when I create a new account from drupal, the error information showed as follow:

Query failed: 0 INSERT INTO phpbb_users (`user_id`,`group_id`,`username`,`username_clean`,`user_password`,`user_regdate`,`user_email`,`user_options`,`user_lang`,`user_timezone`) VALUES(1001,2,'testuser01','testuser01','1c69c86322d53d8d4aada33e4063c8e3',1196591735,'fengjiongming@sina.com','853','en',0)

user warning: Field 'user_permissions' doesn't have a default value query: INSERT INTO phpbb_users (`user_id`,`group_id`,`username`,`username_clean`,`user_password`,`user_regdate`,`user_email`,`user_options`,`user_lang`,`user_timezone`) VALUES(1002,2,'testuser02','testuser02','8d5e9f31e23e962c82e9c54234cf61ec',1196592517,'fengjiongming@cttbj.com','853','en',0) in D:\myproject\wwwroot\includes\database.mysql.inc on line 172.

I am in trouble. What shall I do?

waiting for your answers ... ...

Comments

buffalo-king’s picture

buffalo-king commented

no one answer me?

arkepp’s picture

arkepp commented
Priority: Critical » Minor

How can this be critical when phpBB 3.x hasn't even been released yet?

It's related to phpBB changing the database schemas throughout the RC cycle, a few columns, including user_permissions, lost their default values. You can try upgrading your installation to RC8 and download a new copy of the module from http://kepp.net/phpbb3

There are more people that can help you over at http://groups.drupal.org/phpbb

buffalo-king’s picture

buffalo-king commented

yeah, thanks for your answer! It is really a long time at this weekend
I have solved the problem now. :-)

buffalo-king from china

arkepp’s picture

arkepp commented
Status: Active » Closed (fixed)