Advertisement:

Author Topic: New User, First Post  (Read 1035 times)

Offline flussaudio

  • Semi-Newbie
  • *
  • Posts: 22
New User, First Post
« on: August 12, 2019, 10:00:47 PM »
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!

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,399
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #1 on: August 12, 2019, 10:07:08 PM »
There is a repair settings tool
What is repair_settings.php?
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 flussaudio

  • Semi-Newbie
  • *
  • Posts: 22
Re: New User, First Post
« Reply #2 on: August 13, 2019, 07:10:55 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?


Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,399
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #3 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
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 flussaudio

  • Semi-Newbie
  • *
  • Posts: 22
Re: New User, First Post
« Reply #4 on: August 13, 2019, 08:44:51 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 [nofollow]
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'

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,399
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #5 on: August 13, 2019, 09:57:19 PM »
Take out this line from .sql file from the members query
Code: [Select]
  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

Offline flussaudio

  • Semi-Newbie
  • *
  • Posts: 22
Re: New User, First Post
« Reply #6 on: August 14, 2019, 09:57:36 AM »
Take out this line from .sql file from the members query
Code: [Select]
  SUBSTRING(u.user_from, 1, 255) AS location,
Now I'm getting:
Unknown column 'u.user_msnm' in 'field list'

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,399
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #7 on: August 14, 2019, 10:07:06 AM »
Take out these lines as well
Code: [Select]
    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

Offline flussaudio

  • Semi-Newbie
  • *
  • Posts: 22
Re: New User, First Post
« Reply #8 on: August 14, 2019, 10:19:34 AM »
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?
« Last Edit: August 14, 2019, 10:33:00 AM by flussaudio »

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,399
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #9 on: August 14, 2019, 10:33:01 AM »
Keep removing fields until works so remove
Code: [Select]
    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

Offline flussaudio

  • Semi-Newbie
  • *
  • Posts: 22
Re: New User, First Post
« Reply #10 on: August 14, 2019, 10:56:52 AM »
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

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,399
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #11 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?
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 flussaudio

  • Semi-Newbie
  • *
  • Posts: 22
Re: New User, First Post
« Reply #12 on: August 14, 2019, 12:24:04 PM »
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.

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,399
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #13 on: August 14, 2019, 12:41:33 PM »
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

Offline flussaudio

  • Semi-Newbie
  • *
  • Posts: 22
Re: New User, First Post
« Reply #14 on: August 14, 2019, 01:32:50 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'

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,399
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #15 on: August 14, 2019, 01:37:23 PM »
Change
Code: [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
To
Code: [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_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

Offline flussaudio

  • Semi-Newbie
  • *
  • Posts: 22
Re: New User, First Post
« Reply #16 on: August 14, 2019, 01:41:59 PM »
Once you get all working please post the final.sql file here.
Most certainly.  ;-)


Offline flussaudio

  • Semi-Newbie
  • *
  • Posts: 22
Re: New User, First Post
« Reply #17 on: August 14, 2019, 01:54:54 PM »
Quote
Unknown 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?


Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,399
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #18 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.
Change to this instead
Code: [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_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

Offline flussaudio

  • Semi-Newbie
  • *
  • Posts: 22
Re: New User, First Post
« Reply #19 on: August 14, 2019, 02:05:38 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.
« Last Edit: August 14, 2019, 02:18:48 PM by flussaudio »