Posted by arkepp on September 20, 2007 at 4:05am
Based on Yorlik's and demon326's bug reports (see previous update thread) I have fixed four issues (clean usernames, group id on user row in phpBB, user count statistics, forgotten comment "hah"). The beta has been updated and can be downloaded from here. It is enough to replace phpbb.module if you were using the previous version from September 10th. Note that it was not possible to register new users on the demo-website over the weekend, I started working on the first issue but had to quit halfway.
Comments
Excellent. It looks like
Excellent. It looks like this project is coming along nicely. I think the gold release of phpBB 3 will come soon, are you planning to release another module or can we continue using this one and just upgrade the phpBB 3 software?
Starting to look usable
Yeah, it's starting to look usable. I don't plan on making any major changes and any updates are only about replacing files anyway. Note that the gold release will probably change the modified ACP and UCP files.
Outstanding issues are mainly concerned with how this ties into the ACP of phpBB, or whether the use profiles can / should be moved back to Drupal.
Honestly I'd prefer
Honestly I'd prefer profiles, and PM's and avatars and all that stuff to be separate from Drupal. I just want the user accounts and logins to be synced and I'll be happy. Anything other than that just makes things too complicated and somewhat unnecessary in my opinion.
Oh, and will there be blocks
Oh, and will there be blocks added to the final version of this module?
"X most recent topics" is
"X most recent topics" is included, I wasn't planning on adding any more. What did you have in mind?
Oh, sorry, I didn't notice
Oh, sorry, I didn't notice it. That block is good enough for me.
Anyway, I tested out forced password changes. Changing your password on the Drupal side will not change it on the phpBB side as well. However, the logins are still synced and everything appears to work ok. Since logins are forced on the Drupal side it probably shouldn't be an issue... but I'm just giving you a heads up in case it causes problems in the future.
Selected forums block ?
I'd love to have a block where I could chose the forum where the news are pulled from.
Having a choice to only use headline or to include a teaser or the full text of the first post in a thread would allow a nice newspage in Drupal,
fed from a forum called "news", where the users can post comments in the forum.
I know this is kinda redundant ti existing Drupal functionality, but it makes sense in the context of a community where the forum plays the dominant role for exchange.
I myself have solved the problem such, that I use Drupal for news writing and created a forum as a link in phpbb3, so if clicking on the news forum one gets redirected to the Drupal news page.
I don't think I will write
I don't think I will write that unless anyone wants to fund it, but you can easily adapt the existing block though at the bottom to achieve the filtering effect you mention.
If you want to omit forums with id 1,2,3,4:
$ignore_query = " AND $tt.forum_id NOT IN(1,2,3,4) ";If you want to only include forums with id 1,2,3,4:
$ignore_query = " AND $tt.forum_id IN(1,2,3,4) ";You can insert one of these lines before
//Anonymous or authenticated? Should add check for search enginesPretty cool what you can do with a single line, eh? :)
When you click on "My
When you click on "My Account" in Drupal, is that supposed to take you to your profile in phpBB? I had to reinstall today and it did this, but I don't remember that happening before.
That was discussed very
That was discussed very early on when I started coding on the phpBB 3.x module. People with the special permission to "edit Drupal profiles" will still be able to edit the Drupal profiles, but if they do the information goes out of sync, so it's generally a bad idea.
As mentioned earlier, but sort of rejected by yourself, better integration of profiles would be welcome, but it's a bit of work.
for all people that have the
for all people that have the bug in phpbb3 that the user canot be found but the user is real..,arkep fixed it in the newest verion off the module but it wont effect older users so i contacted yorlik that provided the fix..
step1: go to phpmyadmin
step2: select youre database
step3: go to the user table of phpbb3(click on the image on the left side of the table
step 4: find the sub table "clean_username"
step 5: find the users with Upercase letters (note them on a paper or something also note the user ID)
step 6: run this query: UPDATE
database name_database.phpbb_usersSETusername_clean= 'nickname of the user in lowercase' WHEREphpbb_users.user_id=user ID here LIMIT 1 ;just copy/past the query for all the effected users and there ID's
note: if you do this correctly it will work if dont know what youre doing leav it alone :P
All of them at once
You can also do all of them, IF you assume that "clean username" really just means lowercase:
UPDATE phpbb_users SET username_clean = LOWER(username) WHERE group_id = 0;
And the other bug can be fixed as well, though you need to check that 3 is the right value (see phpbb_groups, group_id for group name REGISTERED)
UPDATE phpbb_users SET group_id = 3 WHERE group_id = 0;
But you really should not bed storing valuable data in phpBB 3.x / this module, and that's why there was no complete upgrade path.
Issues with table/field names
So, sorry if this is annoying, but I am a relatively new user to Drupal and I am attempting to integrate phpBB into my site. I keep getting this error:
Query failed: Unknown column 'group_moderator' in 'field list' INSERT INTO phpbb_groups (
group_type,group_name,group_desc,group_moderator,group_single_user) VALUES( 1,'dan','Personal User',0,1)My first recourse was to change 'group_description' to 'group_desc'. Now it appears that I am getting hung up on 'group_moderator' and then 'group_single_user' as these are not fields in the 'phpbb_groups' table that I have with my fresh installation of phpBB3.
Any help or thoughts would be great.
Thanks,
-John
Wrong module?
My guess is that you downloaded the module for phpBB 2.x instead of following the link to the beta listed above.
banning not working in phpbb3
Hi arkepp,
i'm trying to ban somebody in my board the band is enterd suces fully but the user can still brows the forums ?:S, is this a phpbb bug or is this just a bug off the module?..
Where?
Where are you banning them, in phpBB or in Drupal?
phpbb
Hi arkepp,
i'm banning the perons in phpbb when i got to the database table with the ban information i see that there inserted inside it like it has to be and in drupal there account has bin blocked..,but when i ban them in phpbb nothing hapens they can still read the forums and thats not supposed to hapen :)
Greetz
Sorry, your post seems
Sorry, your post seems selfcontradicting to me.
Are you saying that you are doing it through the phpBB admin control panel, and that the ban appears to be entered correctly in the database, but that it still has no effect?
It's conceivable that I have introduced a bug in the code that bans users, but I would check the bug tracker on phpbb.com first (which is down right now).
idd sorry for the confusing
idd sorry for the confusing text :D, idd i'm saying that i ban the user in the admin control panel and the ben appears to be entered correctly in the database, but that it still has no effect in phpbb...
i first thougth i made a mistake but i checked the banning tables and they where like they had to be..
and i dont think its a bug cause i just looked on the bug tracker and i dont see anything with banning problems :)
update on banning bug
Hi arekpp,i just tested the ban function again and this time it worked but i tested in on a other users.. so i thinkt it was a little bug in phpbb itself.
owyeah i also have a sugestion: when you ban a user in phpbb its gets also bannend in drupal but when you UNban the user in phpbb the user is still blocked in phpbb.. so maybe you can fix it:)
At this point that's
At this point that's according to "spec" , http://groups.drupal.org/node/6081 , I'll think about it.
RC6
Hi arkepp,will this release be compactible with phpbb 3 RC6?
Nope. And RC6 is broken:
Nope. And RC6 is broken: http://www.phpbb.com/community/viewtopic.php?f=14&t=584826
RC7 was just released... are
RC7 was just released... are you going to update the beta for this?
Later this week
I've got a client that wants it, so I'll probably start tomorrow and get it out here towards the end of the week. RC7 has a lot of changes that affect the module, including a new password hashing mechanism.
bug in module?
Hi arkepp,my members are reporting an SQL error when they change there password in phpbb and the press submit..
this is the error:
General Error
SQL ERROR [ mysql4 ]
Column set to default value; NULL supplied to NOT NULL column 'picture' at row 1 [1263]
edit: i tested this on a clean bord and now i'm sure the error is cause of the phpbb module cause thats the only thing that uses the image table all of my other mods donot alter those settings :)
i dont have the avatars shared cause a other module is using the files folder in drupal....
update:
okay i tested it again with a normal account off my
this is what i did:
1. changed the password of me in ACP to a simple thing
2.reask my password via drupal so that drupal updates my account
3.copy/past the link in the browser that allows me to change my password
4.when i change the password without having a avatar in phpbb its giving the above error but the password has bin changed in phpbb note sure if drupal also gets updated.
5. when having a avatar uploaded its giving no errors so thats good.
BUG REPORT
now there is 1 little thing i want report that need priority:
when the user wants to change his/her password phpbb is asking for the old password but drupal does not mail a old password but just a link to login..,result the admin needs to change the user password before they can change it again.
in steps:
1. the user ask phpbb a new password-->gets redirected to drupal to fill in the form[OK]
2.the user filled in the form and gets a mail with the link-->user clicks on it and is logged in in the forum[OK]
3. the user goes to the UCP and wants to change his/her password-->they fill both the new passwords fields in[OK]
4.phpbb asks for the old password but how can the user know his/her old password if they are using the password forgotten fucntion?[NOT OK].
the user got stuck cause they cant compleet step 4 cause they dont know the new password so only the admin can help them with doing a hard reset but thats not a sollution if youre board has many members..,so i hope you inderstand this information and will fix this cause it only happens with the password forgotten fucntion
I had the same problem ...
I had the same problem and fixed it by changing the database table such,
that NULL values are allowed in the respective field.
I didn't see any negative side effects so far ....
command
never mind i found the functio :D.
but Yorlik,the lost password function needs attention cause its hard to change the password if you dont know your old/new one....
1) The NULL problem we have
1) The NULL problem we have discussed a couple of times before (demon326), I asked you to go and compare the database schemas. Allowing NULL is okay, but I believe setting a default to '' or 0 (depending on whether it's integer og varchar) is what phpBB assumes.
2) The password reset should sned you to a custom form that lets you type in a new password twice, not to the UCP. I need to check up on this after I get time to look at RC7.
mm idd strange Arkepp,i
mm idd strange Arkepp,i updated the module,phpbb,drupal and al the problems seem to be gone :)