SMF Support > Converting to SMF
Desperate to convert from XMB 1.9.11 to SMF
Mauldraine:
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
Mauldraine:
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.
K@:
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.
Mauldraine:
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!!!
IchBin™:
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.
Navigation
[0] Message Index
[#] Next page
Go to full version