Advertisement:

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

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,508
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #20 on: August 14, 2019, 02:21:31 PM »
Post the whole error message that is different than the forums table it looks like.
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: 25
Re: New User, First Post
« Reply #21 on: August 14, 2019, 02:24:09 PM »
Roger that.

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

    SELECT
    t.topic_id AS id_topic, t.forum_id AS id_board, t.topic_first_post_id AS id_first_msg,
    CASE t.topic_type WHEN 1 THEN 1 WHEN 2 THEN 1 ELSE 0 END AS is_sticky,
    t.topic_last_post_id AS id_last_msg, t.topic_poster AS id_member_started,
    t.topic_last_poster_id AS id_member_updated, po.topic_id AS id_poll,
    t.topic_replies AS num_replies, t.topic_views AS num_views,
    CASE t.topic_status WHEN 1 THEN 1 ELSE 0 END AS locked
    FROM `********`.phpbb_topics AS t
    LEFT JOIN `********`.phpbb_poll_options AS po ON (po.topic_id = t.topic_id)
    LIMIT 0, 500;

Caused the error:

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

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,508
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #22 on: August 14, 2019, 02:36:41 PM »
Change
Code: [Select]
t.topic_id AS id_topic, t.forum_id AS id_board, t.topic_first_post_id AS id_first_msg,
    CASE t.topic_type WHEN 1 THEN 1 WHEN 2 THEN 1 ELSE 0 END AS is_sticky,
    t.topic_last_post_id AS id_last_msg, t.topic_poster AS id_member_started,
    t.topic_last_poster_id AS id_member_updated, po.topic_id AS id_poll,
    t.topic_replies AS num_replies, t.topic_views AS num_views,
    CASE t.topic_status WHEN 1 THEN 1 ELSE 0 END AS locked
To
Code: [Select]
t.topic_id AS id_topic, t.forum_id AS id_board, t.topic_first_post_id AS id_first_msg,
    CASE t.topic_type WHEN 1 THEN 1 WHEN 2 THEN 1 ELSE 0 END AS is_sticky,
    t.topic_last_post_id AS id_last_msg, t.topic_poster AS id_member_started,
    t.topic_last_poster_id AS id_member_updated, po.topic_id AS id_poll,
    t.topic_posts_approved  AS num_replies, t.topic_views AS num_views,
    CASE t.topic_status WHEN 1 THEN 1 ELSE 0 END AS locked
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: 25
Re: New User, First Post
« Reply #23 on: August 14, 2019, 03:56:58 PM »
Converting topics...
Unsuccessful!
This query:

    SELECT
    t.topic_id AS id_topic, t.forum_id AS id_board, t.topic_first_post_id AS id_first_msg,
    CASE t.topic_type WHEN 1 THEN 1 WHEN 2 THEN 1 ELSE 0 END AS is_sticky,
    t.topic_last_post_id AS id_last_msg, t.topic_poster AS id_member_started,
    t.topic_last_poster_id AS id_member_updated, po.topic_id AS id_poll,
    t.topic_posts_approved AS num_replies, t.topic_views AS num_views,
    CASE t.topic_status WHEN 1 THEN 1 ELSE 0 END AS locked
    LEFT JOIN `********`.phpbb_poll_options AS po ON (po.topic_id = t.topic_id)
    LIMIT 0, 500;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN `********`.phpbb_poll_options AS po ON (po.topic_id = t.top' at line 8


At this point, I am going to reinstall a fresh copy of SMF and make the edits all over again from scratch.  Stand by... I need to clear a few things off my desk before I can turn my attention to this.  Give me an hour or so...


Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,508
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #24 on: August 14, 2019, 04:10:37 PM »
It looks like this part disappeared from your statement
FROM `********`.phpbb_topics AS t
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: 25
Re: New User, First Post
« Reply #25 on: August 14, 2019, 04:11:54 PM »
Yes, I masked the db and domain information for security reasons, as I have with all my prior posts.

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,508
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #26 on: August 14, 2019, 04:13:46 PM »
I meant the query you deleted too much it was just left with
CASE t.topic_status WHEN 1 THEN 1 ELSE 0 END AS locked
    LEFT JOIN `********`.phpbb_poll_options AS po ON (po.topic_id = t.topic_id)

Which was missing the FROM `********`.phpbb_topics AS t which was in the original query
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: 25
Re: New User, First Post
« Reply #27 on: August 14, 2019, 04:37:35 PM »
Converting ranks... Successful.
Converting groups... Successful.
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_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
    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:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN `********`.smf_categories AS c ON (c.temp_id = f.parent_id)
    WHER' at line 5

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,508
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #28 on: August 14, 2019, 04:40:14 PM »
You are still missing FROM `********`.phpbb_topics AS t   before the left join. Not sure why WHERE forum_type = 1 was added..
If you need help attach your .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: 25
Re: New User, First Post
« Reply #29 on: August 14, 2019, 05:55:48 PM »
Here 'ya go...

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,508
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #30 on: August 14, 2019, 06:30:45 PM »
Updated file attached
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: 25
Re: New User, First Post
« Reply #31 on: August 14, 2019, 07:03:03 PM »
Updated file attached
BOOM.  Needs a bit of work on some items, but users and posts are there.  A few oddities like strikethrough on prior quotes and URLs  where they've been replaced by SMF's graphical style, and this little oddity with the forum name at top left where it says: FL�SS Audio where it should say 'FLÜSS Audio'.  I'm guessing it's a code page / character set thing, but that's also above my pay grade.  Is there a way to fix that?

THANKS!

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,508
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #32 on: August 14, 2019, 07:14:48 PM »
UTF8 site needs to be enabled on utf8/installed with utf8 as the character set and 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 flussaudio

  • Semi-Newbie
  • *
  • Posts: 25
Re: New User, First Post
« Reply #33 on: August 14, 2019, 07:23:09 PM »
And he strikethroughs?

Also, how would we make a section (or 'category') hidden?  In phpBB, I could apply permissions to the category, and subforums would inherit those settings.  Can't seem to find that here.

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,508
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New User, First Post
« Reply #34 on: August 14, 2019, 08:06:58 PM »
Strikethoughs you will have to look in the database for the message and see what is wrong.
You might just have to do a find and replace on all the strike though tags though sql.

For category permissions/boards I would post in the general support forums they would know more about that than I.
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: 25
Re: New User, First Post
« Reply #35 on: August 15, 2019, 09:11:29 AM »
Just wanted to report back as a reference for others who may also be looking to convert from phpBB to SMF.

The amended script provided by vbgamer45 worked perfectly.  There were some anomalies along the way, however.  In the case of my board, some language (character set) issues threw me off, and strikethroughs appear in some posts.  Here was my solution:

Wiped clean, installed 2.0.15 fresh twice to confirm, once each way:
  - Selecting UTF8 causes the "?" symbol to appear
  - NOT selecting UTF8 displays correct umlaut (Ü) in header
Using the latter (not UTF8) and converting with UTF8 preserves the correct formatting.
User categories are not the same, but were marked with a 'phpBB' prefix to separate them from the SMF user categories.
Looks like passwords were not properly converted, but the 'recover' function to reset works properly.

Since the original phpBB install was new, there are only a dozen posts in total.  I'll just edit each manually to remove the strikethroughs.

Thanks!