Posted by arkepp on October 19, 2007 at 3:11am
The beta has been updated again to keep up with phpBB and RC7. phpBB no longer uses regular MD5 hashes, which caused some pain and has resulted in a new file being included, hash.inc. If you have a bug to report, please make sure you are really running phpBB RC7 and have applied the database update. Drupal 5.3 should not cause any problems.
To update download the beta from http://kepp.net/phpbb3 and replace ALL the files, see the installation instructions for details
Comments
sounds great..
i read the instrution and get interested...
my world warcraft guild plan to switch to a new forum (we plan to use phpbb3)
at the moment, our plan is to use stargate portal (a forum mod)
perhaps this module is a alternative.
is there any roadmap?
Not really, I am waiting for
Not really, I am waiting for phpBB 3 to be released, then it will stay as "beta" for a little while, maybe two weeks.
I will deploy it on fairly large sites within the next couple of weeks. If you're interested you should test it out now and make sure you understand how it works before you try to use it for real.
Just upgraded, and
Just upgraded, and everything went very smoothly. Thanks for maintaining this module so well, arkepp.
Actually, I just tried
Actually, I just tried changing my password in phpBB and it was not changed in Drupal. It did work on the last beta though.
Thanks for the report, I
Thanks for the report, I used the wrong variable at one point. Download the file again, and replace ucp_profile.php and functions_drupal.php, and you should be good to go.
I've double checked what happens if an admin changes a user's password, and that appears to be working fine.
I replaced both files and
I replaced both files and tried again, but it still didn't work.
I did some more testing, and what I did was I changed the password to something using phpBB, then looked into the database to see what the passwords in both the phpBB database and the Drupal database were changed to. In phpBB, it was changed to $H$ and then some random letters and numbers. I'm guessing this is the new hash you were talking about.
Then I looked in the Drupal database and the password was changed to a normal md5 encryption, c4ca4238a0b923820dcc509a6f75849b. I then repeated the process with a different password and went into the phpBB database and found it had changed the value to something else (still with the $H$ preceding it), but when I looked in the Drupal database, the value was still c4ca4238a0b923820dcc509a6f75849b! I went to md5decrypter.com and it turns out that this is the encryption for "1". I confirmed this by successfully logging in to drupal using "1" as the password. So take that information for what it's worth.
I'm using drupal 5.3 by the way.
That's what would have
That's what would have happened with the old code, are you sure you copied ucp_profile.php to the correct directory? Line 199 should say update_drupal(false, false, $data['new_password']); The last parameter is what I changed.
You can test with your own account on http://kepp.net/phpbb3 , that site is running Drupal 5.3 as well.
Gah, you're right, I just
Gah, you're right, I just copied the files wrong. Hehe, sorry! :)
Again, thanks for maintaining this module so well, I really appreciate it.
problem(fixed)
Hi arkepp,
my users found a problem today when they want to change there avatar there getting a mysql error:
General Error
SQL ERROR [ mysql4 ]
Table 'deb4463_drupal.drupal_users' doesn't exist [1146]
SQL
UPDATE drupal_users SET picture = 'forum/shared/upload455c2a10dc037e190c70f43f7e7a93f2_154.jpg', name = 'demon', mail = 'the.hunter@pandora.be' WHERE uid = 154
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()
FILE: includes/functions_drupal.php
LINE: 104
CALL: dbal_mysql->sql_query()
FILE: includes/ucp/ucp_profile.php
LINE: 580
CALL: update_drupal()
FILE: includes/functions_module.php
LINE: 471
CALL: ucp_profile->main()
FILE: ucp.php
LINE: 310
CALL: p_master->load_active()
how does this error come up:
1. go to the UCP
2. select profile and take avatar
3. choos:"Upload from your machine:"
4.press submit and the error comes up.
this also hapens when you try to delete the avatar.
where not using any table prefix.
where using RC7 and the latest module.
update:
arkepp,the phpbb error told me to look inside the file "functions_drupal.php"
i found a little bug...
on line 11 you will see this:
<?php$drupal_user_table = 'drupal_users';//if we use a table prefix it has to be prefix_users
?>
on line 12 we find this:
<?php$drupal_session_table = 'drupal_sessions';//if we use a table prefix we use prefix_sessions
?>
so what is the problem?:
the problem is that your code is expecting a table prefix off "drupal_" so i deleted the "drupal_" tag and the problem is solved..
i added the comment in the file so i know it for the next release of the error comes up again.
From the installation
From the installation instructions:
1.2 Install Drupal
Download Drupal 5.2, unpack it.
Install Drupal
Advanced options, table prefix "drupal_"
3.2
Copy the file functions_drupal.php as above. Check the variables.
So you didn't check the variables, you didn't follow the instructions to let the prefix be "drupal_", and the error message spells it out pretty clearly, including the exact line where the problem occurs. And this is a bug?