Simple Machines Community Forum

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


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 (https://download.simplemachines.org/index.php?thanks;filename=smf_2-0-phpbb32x_converter.zip).

Thanks  :)

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

Thanks vbgamer45.
I increase the length with
ALTER TABLE smf_members MODIFY passwd VARCHAR(255)

The conversion ends with some errors with the attachments:
(https://postimg.cc/629pJGqH)

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...

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

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

Add after

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


I tried, I always get wrong password...

Quote from: vbgamer45 on April 16, 2020, 10:16:35 AM
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.

Made a mistake should be

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


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

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

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

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

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


OK perfect now I can log in  :)

These are the things I noticed:
1. All users (except administrator) are not activated
(https://postimg.cc/QKVHzrj8)
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
(https://postimg.cc/RqRYQ6sQ)

<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
<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  ;)

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.

Quote from: vbgamer45 on April 17, 2020, 09:57:49 AM
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

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

Hi vbgamer45, there are any news?
Thanks

No update at this time