Advertisement:

Author Topic: Converting from IPB 2.3.1 to SMF - need to test first  (Read 1690 times)

Offline PaddyD

  • Semi-Newbie
  • *
  • Posts: 29
Re: Converting from IPB 2.3.1 to SMF - need to test first
« Reply #40 on: May 15, 2018, 09:51:21 PM »
HALLELUJAH!!! I actually managed to figure it out, with some very careful Googling to find something similar.

Found this: https://stackoverflow.com/questions/21943861/copy-field-from-one-table-to-another-where-fields-match

And from that, I was able to create this:

Code: [Select]
UPDATE smf_messages
JOIN ibf_posts on smf_messages.id_msg = ibf_posts.pid
set smf_messages.body = ibf_posts.post

And ran that in phpMyAdmin and voila! I have posts! Over 200,000 of them! PHEW. Now, on to the fun stuff - making the board look & function the way we want! :D I'm sure I'll be back at some point, but at least this conversion craziness is mostly behind me.

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,133
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from IPB 2.3.1 to SMF - need to test first
« Reply #41 on: May 15, 2018, 10:16:14 PM »
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

Offline PaddyD

  • Semi-Newbie
  • *
  • Posts: 29
Re: Converting from IPB 2.3.1 to SMF - need to test first
« Reply #42 on: May 15, 2018, 11:54:08 PM »
Thank you for all your help! Looking forward to moving on from our ancient IPB - and really like what I'm seeing so far with SMF. :)

Online Aleksi "Lex" Kilpinen

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 16,871
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: Converting from IPB 2.3.1 to SMF - need to test first
« Reply #43 on: May 18, 2018, 01:53:03 PM »
Please do let us know how it goes in the end :) And if you run in to any questions, let us know.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline PaddyD

  • Semi-Newbie
  • *
  • Posts: 29
Re: Converting from IPB 2.3.1 to SMF - need to test first
« Reply #44 on: May 18, 2018, 01:55:00 PM »
We're busy testing, Aleksi - and so far, I'm really liking it. :) I'll post a link when (assuming the rest of the admins are all on board) we go live for all our members/general public.

Online Aleksi "Lex" Kilpinen

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 16,871
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: Converting from IPB 2.3.1 to SMF - need to test first
« Reply #45 on: May 18, 2018, 01:56:40 PM »
Sounds good :)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas