• Welcome to Simple Machines Community Forum. Please login or sign up.
October 24, 2021, 07:02:23 PM

News:

SMF 2.1 RC4 has been released! Try it out and help us test! :) Read more.


[SMF Converter] IPB 4.4

Started by vbgamer45, August 31, 2019, 11:09:23 AM

Previous topic - Next topic

Loshmi

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

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'

vbgamer45

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

Loshmi

That did the trick - Conversion complete! I see all themes and posts but I can't log in  ???
QuotePassword 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.
QuoteThis 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

September 23, 2019, 03:24:13 PM #23 Last Edit: September 23, 2019, 03:36:43 PM by 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

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


Add before

$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

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

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

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

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!
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

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:
QuoteDear 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.
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

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?

QuoteThis 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 = "";
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

Loshmi

Error
QuoteStatic 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

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

Advertisement: