XMB convert error

[flewfruit]

Hi, when I try to convert XMB 1.9.11 with this converter: http://download.simplemachines.org/index.php?thanks;filename=smf_2-0_xmb_converter.zip
to SMF v2.0 I get this error:

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Duplicate entry '1092' for key 'PRIMARY'

At this time it stucks....

Please help me, I really need to fix this.

[kat]

Have you tried going to your site's CPanel and repairing the database?

[flewfruit]

Yes, same error
please help me.

[kat]

If you repaired the database, yet it's still showing as having a duplicate key, it might be an idea to ask your host if they can correct that.

[flewfruit]

How can my host correct that? I'm the owner of the server and the db.

[kat]

Ah. My ESP must've failed me, coz I didn't know that.

Remove the duplicate using phpmyadmin? Read my sig, first.

[flewfruit]

Thanks for the support, you're great..I'm now in phpmyadmin, but where do I have to remove this?

[kat]

Ah. I'm afraid you've got me, there.

Let me see if I can figure that out on mine.

Back in a mo!

[kat]

OK. So, this is where it gets interesting...

I did a search for the key "PRIMARY" in my database.

It's simply not there.

Does a key with that name show-up, if you try a search?

(Bear with me, here, this is all new, to me).

[flewfruit]

Nahhh ..Didn't find anything  .

cheers and thanks, ain't interessting for me 

I'm really sad, I can't get this to work..Otherwise I have to buy invision power and try it with their converter, but I want SMF.

If someone can convert my xmbforum to smf with SUCCESS I'll pay him 20$ via alertpay. But with attachments.

[flewfruit]

Great news from me, I faced the problem finally after 3 days 

solution: http://www.simplemachines.org/community/index.php?topic=292127.msg1924988#msg1924988

everything was transfered, i'm so freaking happy to be now a part of smf :=)

[Dblog]

hi flewfruit
i tried that IPB conveter trick sometime back
it managed to skip that duplicate entry problem but topics, posts and total members were not calculated properly
though all 9000+ posts seem to appear but i see wrong stats

"1 Posts in 1 Topics by 1 Members. Latest Member: Admin"

but converted forum shows almost all posts (i guess)

also there was an error that topic titles(title from first post in a topic) are not correct.
after conversion, topic titles are random..like converter took some title from replies to that topic and made it the main title of those topic.

i haven't checked PMs, banned users etc yet.

[Dblog]

can someone suggest me how to do this
i posted my issue above

[kat]

You've kinda hijacked somebody else's topic, here, CBlog.

If you start another one, you might be better off...

[Dblog]

i already started another topic but none replied me
http://www.simplemachines.org/community/index.php?topic=446744.0