[SMF Converter] IPB 4.4

[Loshmi]

Ok, I saw what you did so I've made few changes after converter stopped. This is something else now:

Code Select Expand

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, '[email protected]'), 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'

[vbgamer45]

Change p.use_emo AS smileys_enabled to
1  AS smileys_enabled

[Loshmi]

That did the trick - Conversion complete! I see all themes and posts but I can't log in 

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.

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?

[Loshmi]

Forgot to tell you that instead of user name and password I received on my email: IP address and Username.

[vbgamer45]

Passwords might be an issue.You can try modifying
sources/LoginInOut.php
Find

Code Select Expand


// None of the below cases will be used most of the time (because the salt is normally set.)


Add before

Code Select Expand


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

[Loshmi]

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.

[vbgamer45]

That's odd. Check your apache error log? Something seems broke. Make sure you are on PHP 7.1 or less.

[Loshmi]

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.

[vbgamer45]

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

[Loshmi]

This was our final version of the file that made it all the way to the end.

[Loshmi]

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?

[vbgamer45]

That might be a general SMF issue i would try in support boards

I did check out the sql file

[Loshmi]

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!

[vbgamer45]

Awesome glad you have it working!

[Loshmi]

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:

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?

[vbgamer45]

Set the openid_uri to "" in the smf_members table hopefully that should help.

[Loshmi]

Can you please explain with few more details? I should go to phpmyadmin, then go inside members table and just type "" into that field?

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

[vbgamer45]

yes run
update  smf_members change set openid_uri = "";

[Loshmi]

Error

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

[vbgamer45]

My mistake tired

Code Select Expand


update  smf_members set openid_uri = "";