Advertisement:

Author Topic: [SMF Converter] IPB 4.4  (Read 9593 times)

Offline Loshmi

  • Semi-Newbie
  • *
  • Posts: 33
Re: [SMF Converter] IPB 4.4
« Reply #20 on: September 23, 2019, 02:52:07 PM »
Ok, I saw what you did so I've made few changes after converter stopped. This is something else now:

Code: [Select]
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:

    SELECT
    p.pid AS id_msg, p.topic_id AS id_topic, p.post_date AS poster_time,
    CASE WHEN p.author_name = '' THEN 0 ELSE p.author_id END AS id_member, SUBSTRING(t.title, 1, 255) AS subject,
    SUBSTRING(p.author_name, 1, 255) AS poster_name,
    SUBSTRING(p.ip_address, 1, 255) AS poster_ip, p.use_emo AS smileys_enabled,
    IFNULL(p.edit_time, 0) AS modified_time, SUBSTRING(p.edit_name, 1, 255) AS modified_name,
    t.forum_id AS id_board, REPLACE(p.post, '<br />', '') AS body,
    SUBSTRING(IFNULL(m.email, 'guest@example.com'), 1, 255) AS poster_email, 'xx' AS icon
    FROM `milosbts_novatest2`.forums_posts AS p
    LEFT JOIN `milosbts_novatest2`.forums_topics AS t ON (t.tid = p.topic_id)
    LEFT JOIN `milosbts_novatest2`.core_members AS m ON (m.member_id = p.author_id)
    WHERE t.forum_id IS NOT NULL
    LIMIT 0, 500;

Caused the error:

    Unknown column 'p.use_emo' in 'field list'

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,538
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [SMF Converter] IPB 4.4
« Reply #21 on: September 23, 2019, 02:54:32 PM »
Change p.use_emo AS smileys_enabled to
1  AS smileys_enabled
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 Loshmi

  • Semi-Newbie
  • *
  • Posts: 33
Re: [SMF Converter] IPB 4.4
« Reply #22 on: September 23, 2019, 03:11:13 PM »
That did the trick - Conversion complete! I see all themes and posts but I can't log in  ???
Quote
Password security has recently been upgraded. Please enter your password again.
When I click on "Forgot your password?" I receive an email with my OpenID instead of password reset. And Invision community is signed bellow.
Quote
This mail was sent because the 'forgot OpenID' function has been applied to your account. Below is the OpenID that your account is associated with:
*****
*****
Regards,
The Invision Community Team.
Do you have any suggestion?

Offline Loshmi

  • Semi-Newbie
  • *
  • Posts: 33
Re: [SMF Converter] IPB 4.4
« Reply #23 on: September 23, 2019, 03:24:13 PM »
Forgot to tell you that instead of user name and password I received on my email: IP address and Username.
« Last Edit: September 23, 2019, 03:36:43 PM by Loshmi »

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,538
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [SMF Converter] IPB 4.4
« Reply #24 on: September 23, 2019, 03:42:59 PM »
Passwords might be an issue.You can try modifying
sources/LoginInOut.php
Find
Code: [Select]
// None of the below cases will be used most of the time (because the salt is normally set.)

Add before
Code: [Select]
$other_passwords[] = crypt($_POST['passwrd'], '$2a$13$' . $user_settings['password_salt']);
$other_passwords[] = password_verify($_POST['passwrd'],$user_settings['passwd']);


Also can you post your final .sql file you modified.


That might help but you still might need to reset all passwords.
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 Loshmi

  • Semi-Newbie
  • *
  • Posts: 33
Re: [SMF Converter] IPB 4.4
« Reply #25 on: September 23, 2019, 03:59:42 PM »
Ok, I'm in! But there is a problem because I can't get into admin control panel. When I click on "Admin" or on any other option bellow, I just receive a blank page.

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,538
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [SMF Converter] IPB 4.4
« Reply #26 on: September 23, 2019, 04:03:28 PM »
That's odd. Check your apache error log? Something seems broke. Make sure you are on PHP 7.1 or less.
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 Loshmi

  • Semi-Newbie
  • *
  • Posts: 33
Re: [SMF Converter] IPB 4.4
« Reply #27 on: September 23, 2019, 04:18:54 PM »
So it's written that Web server is on PHP version: 7.2.7. I don't know how and where to check that Apache error logs.

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,538
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [SMF Converter] IPB 4.4
« Reply #28 on: September 23, 2019, 04:20:13 PM »
Cpanel might have an area.
Otherwise webserver logs are in /var/log/httpd on linux   you can also enable php error logging to a file


can you also send me your final.sql file for this converter when you have a chance
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 Loshmi

  • Semi-Newbie
  • *
  • Posts: 33
Re: [SMF Converter] IPB 4.4
« Reply #29 on: September 23, 2019, 04:34:45 PM »
This was our final version of the file that made it all the way to the end.

Offline Loshmi

  • Semi-Newbie
  • *
  • Posts: 33
Re: [SMF Converter] IPB 4.4
« Reply #30 on: September 25, 2019, 11:50:04 AM »
Hello again vbgamer45, do you have any other trick for my problem? Stil the same thing, when I want to enter Admin settings it all goes white.
Did you had some free time to check that edited conversion file of ours?

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,538
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [SMF Converter] IPB 4.4
« Reply #31 on: September 25, 2019, 11:53:51 AM »
That might be a general SMF issue i would try in support boards

I did check out the sql file
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 Loshmi

  • Semi-Newbie
  • *
  • Posts: 33
Re: [SMF Converter] IPB 4.4
« Reply #32 on: September 25, 2019, 12:41:12 PM »
I made it! I just had to reinstall SMF and import that mysql base that we created and filled with converted posts and members. It all works for now - posts are there, members are there, I can enter Admin area. It all looks fine for now, we'll see.
Thank you once again for all your help!

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,538
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [SMF Converter] IPB 4.4
« Reply #33 on: September 25, 2019, 01:00:37 PM »
Awesome glad you have it working!
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 Loshmi

  • Semi-Newbie
  • *
  • Posts: 33
Re: [SMF Converter] IPB 4.4
« Reply #34 on: October 08, 2019, 03:21:50 PM »
Hello again, so there are a couple of issues after the conversion.
First - I couldn't stay longer than 60 minutes inside the Admin panel. So I had to create a new admin during SMF install, that account doesn't have any problem (just have to re-type the password every 60 minutes).
Second - I "opened" forum today, all members had issues with their passwords. When they asked for password reset they just received this email:
Quote
Dear username,
This mail was sent because the 'forgot OpenID' function has been applied to your account. Below is the OpenID that your account is associated with:


IP: *******
Username: ****
There is no password reset link or anything like that. Is this connected to the conversion or is it something else? What do you think?

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,538
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [SMF Converter] IPB 4.4
« Reply #35 on: October 08, 2019, 03:38:35 PM »
Set the openid_uri to "" in the smf_members table hopefully that should help.
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 Loshmi

  • Semi-Newbie
  • *
  • Posts: 33
Re: [SMF Converter] IPB 4.4
« Reply #36 on: October 08, 2019, 04:34:53 PM »
Can you please explain with few more details? I should go to phpmyadmin, then go inside members table and just type "" into that field?

Quote
This mail was sent because the 'forgot OpenID' function has been applied to your account. Below is the OpenID that your account is associated with:
 ""

IP: ****
Username: *****

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,538
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [SMF Converter] IPB 4.4
« Reply #37 on: October 08, 2019, 04:58:37 PM »
yes run
update  smf_members change set openid_uri = "";
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 Loshmi

  • Semi-Newbie
  • *
  • Posts: 33
Re: [SMF Converter] IPB 4.4
« Reply #38 on: October 09, 2019, 09:00:17 AM »
Error
Quote
Static analysis:

1 errors were found during analysis.

    Unrecognized keyword. (near "change" at position 15)

SQL query:

update members change set openid_uri = ""

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'change set openid_uri = ""' at line 1

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,538
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [SMF Converter] IPB 4.4
« Reply #39 on: October 09, 2019, 10:05:45 AM »
My mistake tired
Code: [Select]
update  smf_members set openid_uri = "";
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