News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

New User, First Post

Started by flussaudio, August 12, 2019, 10:00:47 PM

Previous topic - Next topic

flussaudio

Howdy, folks.  Installed phpBB a couple days ago, and found it to be too anemic and less than intuitive.  I read through the conversion guide, but needed to ask a quick question before I pull the trigger.

I understand SMF has to be installed before the conversion process begins.  I don't want to take my present forum offline until I know everything has converted properly, so my plan is to install SMF in a temporary directory, test to be sure everything works, delete the current phpBB install, then relocate SMF to the '.../foum' directory where phpBB presently resides, replacing it.

However, I"m guessing that doing so will wreak havoc on relative and absolute paths.  Is there an easy way to fix this?

Thanks in advance!

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

flussaudio

Quote from: vbgamer45 on August 12, 2019, 10:07:08 PM
There is a repair settings tool
What is repair_settings.php?
Thanks for this.

So, close but no cigar.

Installed SMF 2.1RC2 (figured I'd save myself a step by jumping to the next release now)
Installed the 'convert.php' file
Ran the conversion tool
Everything reported back fine - no errors
Logged in to SMF, and no content was brought in to SMF.  Nothing.  No users, no categories, no posts.

I'm guessing I went wrong by jumping to 2.1 right away?


vbgamer45

Yeah I would go to SMF 2.0.x first. Convert then upgrade to SMF 2.1
Get convertor from https://github.com/SimpleMachines/converters
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

flussaudio

Quote from: vbgamer45 on August 13, 2019, 08:16:37 PM
Yeah I would go to SMF 2.0.x first. Convert then upgrade to SMF 2.1
Get convertor from https://github.com/SimpleMachines/converters
Ok, so I started from scratch.  Dumped tables, purged files in directory, extracted 2.0.15, installed board, extracted convert.php, ran script, getting  "Unknown system variable 'SQL_MAX_JOIN_SIZE" error.

Then, tried script from GitHub, got this:

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:

    SELECT
    u.user_id AS id_member, SUBSTRING(u.username, 1, 80) AS member_name,
    SUBSTRING(u.username, 1, 255) AS real_name,
    SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS last_login,
    u.user_regdate AS date_registered,
    SUBSTRING(u.user_from, 1, 255) AS location,
    u.user_posts AS posts, IF(u.user_rank = 1, 1, IFNULL(mg.id_group, 0)) AS id_group,
    u.user_new_privmsg AS instant_messages,
    SUBSTRING(u.user_email, 1, 255) AS email_address,
    u.user_unread_privmsg AS unread_messages,
    SUBSTRING(u.user_msnm, 1, 255) AS msn,
    SUBSTRING(u.user_aim, 1, 16) AS aim,
    SUBSTRING(u.user_icq, 1, 255) AS icq,
    SUBSTRING(u.user_yim, 1, 32) AS yim,
    SUBSTRING(u.user_website, 1, 255) AS website_title,
    SUBSTRING(u.user_website, 1, 255) AS website_url,
    u.user_allow_viewonline AS show_online, u.user_timezone AS time_offset,
    IF(u.user_allow_viewemail = 1, 0, 1) AS hide_email, u.user_avatar AS avatar,
    REPLACE(u.user_sig, '\n', '<br />') AS signature,
    u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
    u.user_notify_pm AS pm_email_notify,
    CASE u.user_inactive_reason WHEN 0 THEN 1 ELSE 0 END AS is_activated,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
    '' AS personal_text, '' AS time_format, '' AS usertitle, u.user_ip AS member_ip,
    '' AS secret_question, '' AS secret_answer, '' AS validation_code,
    '' AS additional_groups, '' AS smiley_set, '' AS password_salt,
    u.user_ip AS member_ip2
    FROM `********`.phpbb_users AS u
    LEFT JOIN `********`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `********`.smf_membergroups AS mg ON (mg.group_name = CONCAT('phpBB ', r.rank_title))
    WHERE u.group_id NOT IN (1, 6)
    GROUP BY u.user_id
    LIMIT 0, 500;

Caused the error:

    Unknown column 'u.user_from' in 'field list'

vbgamer45

Take out this line from .sql file from the members query

  SUBSTRING(u.user_from, 1, 255) AS location,
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

flussaudio

Quote from: vbgamer45 on August 13, 2019, 09:57:19 PM
Take out this line from .sql file from the members query

  SUBSTRING(u.user_from, 1, 255) AS location,

Now I'm getting:
Unknown column 'u.user_msnm' in 'field list'

vbgamer45

Take out these lines as well

    SUBSTRING(u.user_msnm, 1, 255) AS msn,
    SUBSTRING(u.user_aim, 1, 16) AS aim,
    SUBSTRING(u.user_icq, 1, 255) AS icq,
    SUBSTRING(u.user_yim, 1, 32) AS yim,
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

flussaudio

#8
And now, this:
Unknown column 'u.user_website' in 'field list'

Is there perhaps another way to do this that might work?  The source forum (phpBB) is very small, with only four users and perhaps six threads of about 3 posts each, with some attachments.  Instead of tryhing to convert phpBB to SMF, is it possible to bring content, categories, users and permissions only?

vbgamer45

Keep removing fields until works so remove

    SUBSTRING(u.user_website, 1, 255) AS website_title,
    SUBSTRING(u.user_website, 1, 255) AS website_url,
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

flussaudio

At the rate we're going, there won't be anything left...
Unknown column 'f.forum_posts' in 'field list'

Please understand I'm hesitant to remove (or add) anyting without the guidance of someone who actually knows what he's doing.   ;D

vbgamer45

The members table is more unique as most profile fields have been removed from that table from a lot of forum systems.

f.forum_posts sounds like you made it past converting members?
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

flussaudio

Quote from: vbgamer45 on August 14, 2019, 11:54:29 AM
The members table is more unique as most profile fields have been removed from that table from a lot of forum systems.

f.forum_posts sounds like you made it past converting members?
So it seems.  I have members, and one 'category came in, but no forums or posts.

vbgamer45

What's complete error message like what step?
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

flussaudio

Quote from: vbgamer45 on August 14, 2019, 12:41:33 PM
What's complete error message like what step?

Converting...
Converting members...
Successful.
Converting additional member groups... Successful.
Preparing for categories conversion... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:

    SELECT
    f.forum_id AS id_board, CASE WHEN f.parent_id = c.temp_id THEN 0 ELSE f.parent_id END AS id_parent, f.left_id AS board_order, f.forum_posts AS num_posts,
    f.forum_last_post_id AS id_last_msg, SUBSTRING(f.forum_name, 1, 255) AS name, c.id_cat AS id_cat, '-1,0' AS member_groups,
    SUBSTRING(f.forum_desc, 1, 65534) AS description, f.forum_topics AS num_topics, f.forum_last_post_id AS id_last_msg
    FROM `********`.phpbb_forums AS f
    LEFT JOIN `********`.smf_categories AS c ON (c.temp_id = f.parent_id)
    WHERE forum_type = 1
    GROUP BY id_board
    LIMIT 0, 500;

Caused the error:

    Unknown column 'f.forum_posts' in 'field list'

vbgamer45

Change

f.forum_id AS id_board, CASE WHEN f.parent_id = c.temp_id THEN 0 ELSE f.parent_id END AS id_parent, f.left_id AS board_order, f.forum_posts AS num_posts,
    f.forum_last_post_id AS id_last_msg, SUBSTRING(f.forum_name, 1, 255) AS name, c.id_cat AS id_cat, '-1,0' AS member_groups,
    SUBSTRING(f.forum_desc, 1, 65534) AS description, f.forum_topics AS num_topics, f.forum_last_post_id AS id_last_msg

To

f.forum_id AS id_board, CASE WHEN f.parent_id = c.temp_id THEN 0 ELSE f.parent_id END AS id_parent, f.left_id AS board_order, f.forum_posts_approved AS num_posts,
    f.forum_last_post_id AS id_last_msg, SUBSTRING(f.forum_name, 1, 255) AS name, c.id_cat AS id_cat, '-1,0' AS member_groups,
    SUBSTRING(f.forum_desc, 1, 65534) AS description, fforum_topics_approved AS num_topics, f.forum_last_post_id AS id_last_msg
 

Once you get all working please post the final.sql file here.
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

flussaudio

Quote from: vbgamer45 on August 14, 2019, 01:37:23 PMOnce you get all working please post the final.sql file here.
Most certainly.  ;-)


flussaudio

QuoteUnknown column 'fforum_topics_approved' in 'field list'

Why do I get the feeling this just isn't quite baked, yet?  So, is it safe to keep re-running the same script until we get it right, or should I start again each time with a new, fresh install of SMF?


vbgamer45

The convertors for phpBB have not been updated for phpb 3.2.x we are basically writing the code now as we go.
Change to this instead

f.forum_id AS id_board, CASE WHEN f.parent_id = c.temp_id THEN 0 ELSE f.parent_id END AS id_parent, f.left_id AS board_order, f.forum_posts_approved AS num_posts,
    f.forum_last_post_id AS id_last_msg, SUBSTRING(f.forum_name, 1, 255) AS name, c.id_cat AS id_cat, '-1,0' AS member_groups,
    SUBSTRING(f.forum_desc, 1, 65534) AS description, f.forum_topics_approved AS num_topics, f.forum_last_post_id AS id_last_msg
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

flussaudio

#19
Quote from: vbgamer45 on August 14, 2019, 02:02:35 PM
The convertors for phpBB have not been updated for phpb 3.2.x we are basically writing the code now as we go.

Unknown column 't.topic_replies' in 'field list'

If (when?) we finally get this working, I'm going to reinstall SMF and run it 'clean' again to be sure.  Not even positive I've got all the amendments right, at this point.

Advertisement: