Advertisement:
« previous next »
Pages: [1] 2  All   Go Down

Author Topic: Desperate to convert from XMB 1.9.11 to SMF  (Read 5362 times)

Offline Mauldraine

  • Semi-Newbie
  • *
  • Posts: 13
Desperate to convert from XMB 1.9.11 to SMF
« on: April 03, 2012, 04:54:29 AM »
Greetings to the SMF support community.  My apologies for the urgency of this request up front.  My existing server has a temperamental RAID card so I'm moving to a new server.  During this migration I decided to throw away XMB and use SMF.  I have a fresh installation of SMF 2.0.2 and initial setup has been completed.

I just downloaded the XMB convert script and accompanying sql file.  When I start the conversion process I quickly encounter the following ...

Converting topics...Duplicate entry '15614' for key 'PRIMARY'

I removed that line with a quick sql command, "delete from xmb_threads where tid='15614'", ran it again and quickly received the same error but for entry 15611.  After deleting a few more of these I realized that something bigger was at work here.  So here I am, in a bind, with only 9 days left before the old server is de-provisioned.  Can anyone help me get the xmb forums converted?  Any help is greatly appreciated.

Martin
Logged

Offline Mauldraine

  • Semi-Newbie
  • *
  • Posts: 13
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #1 on: April 03, 2012, 01:06:25 PM »
Ladies and Gentlemen,

I'm sincerely hoping that someone might be able to help me here.  I'm also willing to pay for someone's time to do the conversion for me.  I can send you a tar.gz file with the SQL export file, and the forum folder.  So all that would be necessary is to import it in to your MySQL instance and beat the data in to "SMF Submission".  I'd be happy to offer anyone $50 via PayPal, personal money order, or any other form of payment just to be able to keep the 2+ years of user contributions.

Please help.
Logged

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 38,636
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #2 on: April 03, 2012, 04:48:33 PM »
Welcome to the forum, Martin!

I saw your post, when you first did it. But, to be honest, I don't know much about converting. :(

But, I mentioned this, to a previous message and I have no idea if it worked, because I never got a reply. :(

What I said, there, was:

What about this?

http://www.simplemachines.org/community/index.php?topic=140744.msg1553232#msg1553232

Although this was a phpbb problem, could this work?

http://www.simplemachines.org/community/index.php?topic=139451.msg894669#msg894669

Having just searched, here, for "Duplicate entry '1781'", there seem to be quite a few things to try.

It seems to be a common XMB problem.

Let's see if any of that helps.
Logged

Offline Mauldraine

  • Semi-Newbie
  • *
  • Posts: 13
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #3 on: April 04, 2012, 05:16:17 AM »
Thank you for the reply.  Sadly the sql document in that other thread caused an error message in just converting the member data.  In that same thread it was suggested that I simply delete the offending entry ...

Converting topics...Duplicate entry '15614' for key 'PRIMARY'

So I deleted it (delete from xmb_threads where tid='15614') and ran it again.  In each instance of re-running the converter, I received the exact same error but with a different entry number.  Each time I would delete it ... 15615 ... 15616 ... by the time I got to 15689 I gave up and looked at how many threads I actually had.  I have 16070 threads.  At that point I could only hypothesize that I would have to delete 15614 all the way through 16070 on the off chance that it might convert, and in doing so would loose a lot of good threads.

But I did find some promise in the second thread and thought that I was on to something when it was suggested to convert the XMB data to phpBB first, and then from there to SMF.  Unfortunately, the XMB to phpBB converter is for version 2.0 and not 3.0, and hasn't been supported or maintained in years.

If there are any additional suggestions, I am all ears Ladies and Gentlemen.  My offer still stands.  I will GLADLY pay someone for their time to convert the forum data.  I have just a few days left before I have to put the XMB software on the new server.  I'm desperate, can you tell?

Thank you to all who have read this thread!!!
Logged

Offline IchBin™

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,918
  • Gender: Male
  • I don't speak German.
    • IchBin.us
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #4 on: April 04, 2012, 09:48:14 AM »
Mauldraine,

I'm no expert on the conversion processes either, but if you'd like I can take a stab at seeing if I can get them to work? I'll need a copy of your DB to try this. It's probably too big to email or something, so if you'd like to put it up somewhere that I can download it from your site, then you can just send me a link in PM and I'll see what happens on my end with things.
Logged
Brad "IchBin™" Grow        TinyPortal        Themes
Coding Guidelines       

Offline Mauldraine

  • Semi-Newbie
  • *
  • Posts: 13
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #5 on: April 05, 2012, 03:01:10 AM »
Thank you SO MUCH IchBin.  I will dump the entire forums schema in to a file, put it some place for you to download, and will PM you the moment that it's available.  This is going to be a sleepless night for me.
Logged

Offline Mauldraine

  • Semi-Newbie
  • *
  • Posts: 13
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #6 on: April 05, 2012, 03:41:34 AM »
You have a PM.   :D
Logged

Offline IchBin™

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,918
  • Gender: Male
  • I don't speak German.
    • IchBin.us
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #7 on: April 05, 2012, 10:48:34 AM »
You can go ahead and delete that file now, as I have a copy of it. I'll see what I can do with it today and will get back to you as needed.
Logged
Brad "IchBin™" Grow        TinyPortal        Themes
Coding Guidelines       

Offline pamanatek

  • Charter Member
  • Newbie
  • *
  • Posts: 1
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #8 on: April 05, 2012, 11:31:33 AM »
I have been having the same problem for weeks now with no solutions that I can find.
Logged

Offline Mauldraine

  • Semi-Newbie
  • *
  • Posts: 13
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #9 on: April 06, 2012, 01:01:20 AM »
Thank you SO MUCH.  I really don't want to have to use forum software that hasn't been actively developed for almost 2 years.  Plus SMF is one of the only forum solutions that is mobile ready.  I'm so ready to change.  I eagerly look forward to hearing from you.  Do you have a PayPal account so that I can pay you for the conversion?
Logged

Offline IchBin™

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,918
  • Gender: Male
  • I don't speak German.
    • IchBin.us
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #10 on: April 06, 2012, 11:14:16 AM »
Getting close! It looks like I was able to get the converter to complete. The only issue's I can see right now, is that we need to convert the way they use quotes in their posts to the way SMF does. A few more fixes and that should hopefully have it working. I'm hoping to post the updated files today.
Logged
Brad "IchBin™" Grow        TinyPortal        Themes
Coding Guidelines       

Offline IchBin™

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,918
  • Gender: Male
  • I don't speak German.
    • IchBin.us
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #11 on: April 06, 2012, 09:02:49 PM »
Give these files a try and see if they work for you.

If they don't work, please post the text on the page where it says what step you are on. Also post the URL your browser shows too. Hopefully these will work.

« Last Edit: April 06, 2012, 10:44:43 PM by N. N. »
Logged
Brad "IchBin™" Grow        TinyPortal        Themes
Coding Guidelines       

Offline Mauldraine

  • Semi-Newbie
  • *
  • Posts: 13
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #12 on: April 07, 2012, 02:37:23 AM »
Sadly ...

URL path: forums/convert.php?step=1&substep=9&start=5400
Error:  Converting posts (this may take some time)...The database value you're trying to insert does not exist: poster_email

Man I had such high hopes.  So what should I do now?  Your advice is super appreciated.
« Last Edit: April 07, 2012, 02:57:24 AM by Mauldraine »
Logged

Offline N. N.

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,317
  • Blue Wolf
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #13 on: April 07, 2012, 07:04:10 AM »
Mauldraine,
I'm sorry for missing that, I actually experienced it too working with your database last night and got it fixed, but for some reason IchBin didn't experience it, it worked fine for him, and without replicating an error we can't fix it. :D So the fix wasn't in the currently posted converter. (given the size of your database and how long it takes to complete a conversion, IchBin has worked a lot of time on it, and sometimes with partial conversion processes to check only one bit or another, that bit may have passed during one of those.)

Please, give a try to the attached package. Meanwhile we'll test further the results and be ready to support the conversion of your forums.
« Last Edit: April 07, 2012, 07:30:54 PM by N. N. »
Logged
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker
Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Mauldraine

  • Semi-Newbie
  • *
  • Posts: 13
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #14 on: April 07, 2012, 03:02:11 PM »
It's alive ...

ALIVE

Muwahahahaha.  I cannot even begin to express my sincere appreciation for all of your efforts.  My God!  I was really worried that I wasn't going to be able to keep the xmb forum data.  I'm sure through your testing you found out that we have over 100,000 posts, and I would have just cried if I lost it all.  Thank you again and again.
Logged

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 38,636
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #15 on: April 07, 2012, 03:18:51 PM »
Wonderful stuff, guys! :)
Logged

Offline IchBin™

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,918
  • Gender: Male
  • I don't speak German.
    • IchBin.us
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #16 on: April 07, 2012, 03:27:47 PM »
Quote from: Mauldraine on April 07, 2012, 03:02:11 PM
It's alive ...

ALIVE

Muwahahahaha.  I cannot even begin to express my sincere appreciation for all of your efforts.  My God!  I was really worried that I wasn't going to be able to keep the xmb forum data.  I'm sure through your testing you found out that we have over 100,000 posts, and I would have just cried if I lost it all.  Thank you again and again.

I discovered how many posts you had several times. lol The conversion of posts took quite a bit when I finally made it all the way through. Wouldn't have worked without Norv's brilliance. So glad you got it working!
Logged
Brad "IchBin™" Grow        TinyPortal        Themes
Coding Guidelines       

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 38,636
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #17 on: April 07, 2012, 03:35:33 PM »
Is it worth modifying the conversion script that we have to include this?
Logged

Offline Mauldraine

  • Semi-Newbie
  • *
  • Posts: 13
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #18 on: April 07, 2012, 03:39:49 PM »
I do have one (I'm sure) small issue ... At the top of the forums there is a section without a name.  There are a few forums in that section.  When we go in to the admin section, and then in to the Modify Boards area, that section is called "Salvage Area".  But the forums that I see on the public view, are not listed in the admin view.  Any suggestions?  I have not moved the domain name over yet to the new server, so if you would like to look at it, it's located here ...

http://76.74.251.214/forums/index.php [nofollow]

If you need admin rights just let me know and I'll PM you with my login.
Logged

Offline IchBin™

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,918
  • Gender: Male
  • I don't speak German.
    • IchBin.us
Re: Desperate to convert from XMB 1.9.11 to SMF
« Reply #19 on: April 07, 2012, 04:01:44 PM »
hmmm... there may be something left to figure out in the converter. I'd have to go back and look at my end results. Not setup where I'm at to check that stuff. If you'd like, feel free to PM me a temp admin account and I'll take a look at that.

Oh and definitely K@. We'll add all the fixes to our current download for this.
Logged
Brad "IchBin™" Grow        TinyPortal        Themes
Coding Guidelines       
Pages: [1] 2  All   Go Up
« previous next »