Advertisement:

Author Topic: phpBB 3.2.9 to SMF 2.0.17  (Read 4613 times)

Offline Massl

  • Jr. Member
  • **
  • Posts: 340
phpBB 3.2.9 to SMF 2.0.17
« 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:

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

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,595
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #1 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
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

Offline Massl

  • Jr. Member
  • **
  • Posts: 340
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #2 on: April 16, 2020, 01:49:41 PM »
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...


Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,595
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #3 on: April 16, 2020, 02:36:59 PM »
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']);

« Last Edit: April 16, 2020, 03:20:14 PM by 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

Offline Massl

  • Jr. Member
  • **
  • Posts: 340
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #4 on: April 16, 2020, 03:17:09 PM »
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.

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,595
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #5 on: April 16, 2020, 03:18:40 PM »
Made a mistake should be
Code: [Select]
$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

Offline Massl

  • Jr. Member
  • **
  • Posts: 340
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #6 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".

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,595
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #7 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.
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

Offline Massl

  • Jr. Member
  • **
  • Posts: 340
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #8 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$

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,595
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #9 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
Code: [Select]
$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

Offline Massl

  • Jr. Member
  • **
  • Posts: 340
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #10 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

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

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,595
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #11 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.
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

Offline Massl

  • Jr. Member
  • **
  • Posts: 340
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #12 on: May 03, 2020, 10:28:37 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


Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,595
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #13 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.
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

Offline Massl

  • Jr. Member
  • **
  • Posts: 340
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #14 on: August 14, 2020, 08:32:24 AM »
Hi vbgamer45, there are any news?
Thanks

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,595
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: phpBB 3.2.9 to SMF 2.0.17
« Reply #15 on: August 14, 2020, 09:02:00 AM »
No update at this time
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