Code: Select all
update phpbb_users set user_email_hash = concat(crc32(lower(user_email)), length(user_email));
This means that the converter calculates hashes incorrectly. I'll see if I can fix it for the next release.The Miker wrote:You have to re-synchronize the stats on every single forum and sub-forum in the ACP for the data to appear.
There is another thing I wanted to add... After the conversion we had shut down our previous forum so we couldn't notify people of their new passwords, and people had problems resetting their passwords on the new forums. They'd get the error "The e-mail/username information submitted could not be found." I fixed this problem by running the following SQL query on the forum's database:
Just substitute "phpbb_" for whatever your prefix is.Code: Select all
update phpbb_users set user_email_hash = concat(crc32(lower(user_email)), length(user_email));
It seems that when the data is converted it leaves negative values for the user_email_hash which makes phpbb unable to verify that the submitted information is correct.