Quick update on the phpBB 3.x module

Events happening in the community are now at Drupal community events on www.drupal.org.
arkepp's picture

As I mentioned previously, on November 5th we moved all our websites ( http://mac1.no, http://linux1.no, http://kreativ1.no + a few others ) to Drupal 5.3 / phpBB 3.x. The module has actually not caused a single problem since then, but there were other things that kept me busy*. This weekend we upgraded to RC8 by applying the diff directly, and that worked flawlessly too. I have updated the module, but not had a chance to test it properly. Unfortunately, the version we use on our production sites depends on a lot of code you don't want, so the code released here comes from a different branch and QA has to be done separately.

Hopefully this release, in addition to updating the prepatched files to RC8, will fix five things:
1) RC7 and below had a bug where the flag signifying a phpBB 2.x hash would not be reset when a password was changed. The module emulated this part too, so the same bug had to be fixed. The hash is now replaced on the first login, and the flag reset.
2) The bug reported by Sheli_11, only relevant if you use the second block (http://groups.drupal.org/node/6429#comment-21268)
3) At some point during the RC process phpBB dropped having default values for certain columns, at least for the mysql 4.0 schema (I think it happened later to the MySQL 4.1 one). I really don't understand why phpBB's schemas have to define things like "user_website blob NOT NULL," and then have the code set them to '' on every insert, but either way, it's part of the code now and in dire need of testing.
4) Similarly, Drupals user table will not accept picture = NULL, so functions_drupal.php sets it to '' instead.
5) The access right "administer phpBB" is no longer being used and has therefore been removed.

So if you have some time to spare, please grab the latest version from http://kepp.net/phpbb3 and let me know what you find.

  • We have made some changes that let multiple domains access the same database, but with forums sorted differently and respecting each user's site preference when sending out notification emails. We also let users pick categories and subforums a la carte. Some of these systems didn't get exercised properly before launch, so things were pretty intense for the first couple of days.

Comments

mysql error

demon326's picture

hi arkepp i'm getting a mysql error when i'm making a new account:

Unknown column 'user_from blob' in 'field list' query: INSERT INTO phpbb_users (user_id,group_id,username,username_clean,user_password,user_regdate,user_email,user_options,user_lang,user_timezone
,user_sig,user_lastpage,user_permissions,user_from blob,user_aim,user_yim,user_msnm,user_jabber,user_website,user_occ,user_interests) VALUES(1122,164,'benny','benny','d2684abdfbfbf0cb89d7c448cc8d8183',1196851273,'ag.demon@gmail.com','853','nl',0,'','','','','','','','','','','') in /opt/www/dewildeg/web/www.newmarcel.be/tvseries/drupal/includes/database.mysql.inc on line 172.

its does not get inserted into phpbb

and i also get this error when i submit my reg:

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,user_sig,user_lastpage,user_permissions,user_from blob,user_aim,user_yim,user_msnm,user_jabber,user_website,user_occ,user_interests) VALUES(1123,164,'benny','benny','563dc1b8db3692c57ca6eb45db0e2290',1196851697,'ag.demon@gmail.com','853','nl',0,'','','','','','','','','','','')

and i'm using back the old version of the module untill this one is working without errors :D

Yeah, that was a cut'n'paste

arkepp's picture

Yeah, that was a cut'n'paste typo. Download again and replace phpbb.module with the new one.

MySQL error solved

buffalo-king's picture

yeah, I have found that error yesterday. The "user_from blob" doesnot exist in "phpbb_users".

Then I changed "user_from blob" to "user_from". It is ok! :)

Hi arkepp,thx for the fast

demon326's picture

Hi arkepp,thx for the fast fix :), but i think i found a other bug in phpbb caused by the module...

this is the problem:
when a new users registers and lets say i make him a global mod,then the next user that registers is getting the same color as the previous user in phpbb so that user will also get a green name but does not have the mod rigts....

i'm reporting this now cause i habe it also on other boards with the module....

Greetz

I'd like to help test this

archard-gdo's picture

I'd like to help test this out. But can you provide some instructions on exactly how to upgrade? I'm running a live site and I really don't wanna screw anything up.

Also, is it safe to upgrade to drupal 5.5 with this?

You should make a copy of

arkepp's picture

You should make a copy of your live site, upgrade the copy and then test that. If it works you can replace the code of the live site, there have been no database changes afaik.

I upgraded the mentioned website to Drupal 5.5 by overwriting all the files (but I have everything in subversion, so it's easy to go back as long as the database doesn't get hurt).

With regards to RC8 I downloaded the .zip with the changes, which contains a diff for RC7->RC8. I renamed my directory to the RC7 name (see top of patch) and then ran
patch -p0 < patch-file


I am pretty sure I know what would have to happen to cause the behavior demon326 is describing, I'm not convinced this module is causing it since the group assignment and coloring stuff happens entirely in phpBB. Check the phpBB 3.x bugtracker, I'll test it once I get a chance to upgrade kepp.net to RC8.

Well they just released the

archard-gdo's picture

Well they just released the gold version so I'll just wait until you update the module for that.

No changes

arkepp's picture

Hi,

there are actually no changes between RC8 and gold that affect the module.

But I should do a clean install on http://kepp.net , just in case.

In that case I will update

archard-gdo's picture

In that case I will update and let you know if I find anything wrong.

Found an error

archard-gdo's picture

When you click on a username link in drupal (http://www.yoursite.com/user/username) the redirect is a bad link. It looks like this:

"http://www.yoursite.com/phpbb3/forum/memberlist.php?mode=viewprofile&u=1001"

That phpbb3 is not supposed to be there.

It's probably the absolute

arkepp's picture

It's probably the absolute URL in the configuration file?

Which configuration file? I

archard-gdo's picture

Which configuration file?

I upgraded to drupal 5.5 by the way.

modules/phpbb/configuration.i

arkepp's picture

modules/phpbb/configuration.inc

Yep, you were right, thanks

archard-gdo's picture

Yep, you were right, thanks :)

how to delete an account

buffalo-king's picture

when I delete a user account in drupal, the account still in phpbb3.
what shall I do to delete one account in drupal and phpbb at once.

buffalo-king from china

Second sentence in the

arkepp's picture

Second sentence in the installation instructions, all user operations have to be done through phpBB. Otherwise you'll have to keep things in-sync manually.

I must admit I preferred how

solipsist's picture

I must admit I preferred how the phpBB 2 version worked where Drupal was master, and phpBB slave.

Are there any technical reasons to why there cannot be an implementation of hook_user to handle user editing and updating?


Jakob Persson
Webbredaktören - www.webbredaktoren.se

phpBB 3.x user profiles are

arkepp's picture

phpBB 3.x user profiles are about 5 times more complex than phpBB 2.x ones, and standard Drupal user profiles are trivial. So in the interest of time, and since the UCPs organize this information nicely, I chose the easy route.

A patch would be very welcome, if anyone has the time or money to properly implement all that stuff in Drupal.

oops

arkepp's picture

oops, replied to wrong branch, sorry

phpbb

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: