News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Desperate to convert from XMB 1.9.11 to SMF

Started by Mauldraine, April 03, 2012, 04:54:29 AM

Previous topic - Next topic

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.

kat

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.
IchBin™        TinyPortal

Mauldraine

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.

Mauldraine


IchBin™

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.
IchBin™        TinyPortal

pamanatek

I have been having the same problem for weeks now with no solutions that I can find.

Mauldraine

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?

IchBin™

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.
IchBin™        TinyPortal

IchBin™

#11
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.

IchBin™        TinyPortal

Mauldraine

#12
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.

Norv

#13
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.
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

Mauldraine

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.


IchBin™

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!
IchBin™        TinyPortal

kat

Is it worth modifying the conversion script that we have to include this?

Mauldraine

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.

IchBin™

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.
IchBin™        TinyPortal

Advertisement: