Simple Machines Community Forum

SMF Support => Converting to SMF => phpBB => Topic started by: Massl on April 16, 2020, 03:36:22 AM

Title: phpBB 3.2.9 to SMF 2.0.17
Post by: Massl on April 16, 2020, 03:36:22 AM
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  :)
Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: 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
Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: Massl on April 16, 2020, 01:49:41 PM
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://i.postimg.cc/629pJGqH/Immagine.png) (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...

Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: vbgamer45 on April 16, 2020, 02:36:59 PM
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']);


Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: Massl on April 16, 2020, 03:17:09 PM
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.
Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: vbgamer45 on April 16, 2020, 03:18:40 PM
Made a mistake should be

$other_passwords[] = password_verify($_POST['passwrd'],$user_settings['password_salt']);
Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: Massl on April 16, 2020, 03:25:42 PM
Again no login, always "Password security has recently been upgraded. Please enter your password again." and after "Wrong password".
Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: vbgamer45 on April 16, 2020, 03:32:12 PM
What do the first 6 characters of the password look like? I want to see what version of phpBB hashing you are on.
Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: Massl on April 16, 2020, 03:38:09 PM
They are different...
The first users of the forum have
$CP\2y$10
Some
$H\2y$9
and most   
$2y$10$
Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: vbgamer45 on April 16, 2020, 03:48:57 PM
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']);
Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: Massl on April 17, 2020, 02:57:42 AM
OK perfect now I can log in  :)

These are the things I noticed:
1. All users (except administrator) are not activated
(https://i.postimg.cc/QKVHzrj8/2.jpg) (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://i.postimg.cc/RqRYQ6sQ/3.jpg) (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  ;)
Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: vbgamer45 on April 17, 2020, 09:57:49 AM
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.
Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: Massl on May 03, 2020, 10:28:37 AM
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

Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: vbgamer45 on May 03, 2020, 12:07:17 PM
I haven't had a chance yet. I  have used phpBB3.2 I can check my convertor notes for a different project i manage.
Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: Massl on August 14, 2020, 08:32:24 AM
Hi vbgamer45, there are any news?
Thanks
Title: Re: phpBB 3.2.9 to SMF 2.0.17
Post by: vbgamer45 on August 14, 2020, 09:02:00 AM
No update at this time