• Welcome to Simple Machines Community Forum. Please login or sign up.
September 22, 2021, 02:30:30 AM

News:

Check out the SMF Function DB!


phpBB 3.2.9 to SMF 2.0.17

Started by Massl, April 16, 2020, 03:36:22 AM

Previous topic - Next topic

Massl

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.

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
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Massl

Thanks vbgamer45.
I increase the length with
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

April 16, 2020, 02:36:59 PM #3 Last Edit: April 16, 2020, 03:20:14 PM by vbgamer45
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']);


Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Massl

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.

vbgamer45

Made a mistake should be

$other_passwords[] = password_verify($_POST['passwrd'],$user_settings['password_salt']);
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

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.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

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

$other_passwords[] = crypt($_POST['passwrd'], $user_settings['passwd']);
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

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


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

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.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Massl

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


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.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Massl

Hi vbgamer45, there are any news?
Thanks

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Advertisement: