Converting from IPB 2.3.1 to SMF - need to test first

[PaddyD]

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 Expand

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! I'm sure I'll be back at some point, but at least this conversion craziness is mostly behind me.

[vbgamer45]

Glad you have it working!

[PaddyD]

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.

[Aleksi "Lex" Kilpinen]

Please do let us know how it goes in the end And if you run in to any questions, let us know.

[PaddyD]

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.

[Aleksi "Lex" Kilpinen]

Sounds good