Topic: phpBB 3.2.9 to SMF 2.0.17

[Massl]

Hi, i would like to switch from phpBB 3.2.9 to SMF 2.0.17 but i get the following error:

Code: [Select]

Converting ranks... Successful.
Converting groups... Successful.
Converting members...Data too long for column 'passwd' at row 1

I'm trying locally with WAMP, both software are installed and fully functional.
Converter downloaded from here.

Thanks 

[vbgamer45]

Try to increase the length of your SMF's smf_members table the passwd column to varchar 255 and see if that helps

[Massl]

Thanks vbgamer45.
I increase the length with

Code: [Select]

ALTER TABLE smf_members MODIFY passwd VARCHAR(255)
The conversion ends with some errors with the attachments:


But the biggest problem is that no one can log in, after "Password security has recently been upgraded. Please enter your password again." the password is not recognized.

There is also problems with user signatures and img tags, more details soon...

[vbgamer45]

For passwords try this requires change to Sources/LogINOut.php
Find

Code: [Select]

// Maybe we were too hasty... let's try some other authentication methods.
$other_passwords = array();
Add after

Code: [Select]

$other_passwords[] = password_verify($_POST['passwrd'],$user_settings['password_salt']);


[Massl]

I tried, I always get wrong password...

Try to increase the length of your SMF's smf_members table the passwd column to varchar 255 and see if that helps

Just to say that I did a clean install of 2.0.17... I hadn't specified it before.

[vbgamer45]

Made a mistake should be

Code: [Select]

$other_passwords[] = password_verify($_POST['passwrd'],$user_settings['password_salt']);


[Massl]

Again no login, always "Password security has recently been upgraded. Please enter your password again." and after "Wrong password".

[vbgamer45]

What do the first 6 characters of the password look like? I want to see what version of phpBB hashing you are on.

[Massl]

They are different...
The first users of the forum have
$CP\2y$10
Some
$H\2y$9
and most   
$2y$10$

[vbgamer45]

Passwords that start with $2  should work with the password_verify above.

Other ones might be an older hash for older phpbb versions trying doing some research not really clear on what the hash method is for which one https://www.phpbb.com/community/viewtopic.php?t=2509386

You can try adding this as well

Code: [Select]

$other_passwords[] = crypt($_POST['passwrd'], $user_settings['passwd']);


[Massl]

OK perfect now I can log in 

These are the things I noticed:
1. All users (except administrator) are not activated

2. In all messages there is « Last Edit: January 01, 1970, 12:00:00 AM by Guest »
3. Quote aren't recognized and the text is strikethrough

Code: [Select]

<r><QUOTE author="test" post_id="19966" time="1540385087" user_id="5667"><s>[quote=test post_id=19966 time=1540385087 user_id=5667]</s>
text quoted
<e>[/quote]</e></QUOTE>4. All messages have problems with tags:
 - There is <t> at beginning and </t> at the end of all messages;
 - Many messages are truncated because they are full of tags like this

Code: [Select]

<r><IMG src="http://s18.postimg.org/4gkk5ccu1/test.jpg"><s>[img]</s><URL url="http://s18.postimg.org/4gkk5ccu1/test.jpg">http://s18.postimg.org/4gkk5ccu1/test.jpg</URL><e>[/img]</e></IMG><br/>
<br/>
<B><s>[b]</s><COLOR color="#FF0000"><s>[color=#FF0000]</s>Color<e>[/color]</e></COLOR><e>[/b]</e></B> (<URL url="http]</s>Color<e>[/url]</e></URL>)<br/>

Thanks again 

[vbgamer45]

In the database for your forum run this query where smf_members is the table for your members database.

 UPDATE smf_members SET is_activated = 1



I will have to look at the rest.

[Massl]

I will have to look at the rest.

Hi vbgamer45, did you understand what is changed in versions 3.2.x?
The converter seems to work well with 3.1.x versions, if needed I can update to 3.3.0 and so you can only work on the latest version.

Thanks

[vbgamer45]

I haven't had a chance yet. I  have used phpBB3.2 I can check my convertor notes for a different project i manage.

[Massl]

Hi vbgamer45, there are any news?
Thanks

[vbgamer45]

No update at this time