News:

Wondering if this will always be free?  See why free is better.

Main Menu

converter for XMB 1.9.11 failed !

Started by Dblog, August 16, 2011, 03:05:13 AM

Previous topic - Next topic

Dblog

i used available converter in downloads section and got this error
Duplicate entry '1207' for key 'PRIMARY' in topics and converter stopped at this point
when i check smf mysql table, it had 1000 (last entry was numbered 1212) entries in topics

after this posts etc are not yet converted.

i used same converter to test a small sized XMB 1.9.11 board with less than 100 topics and it was done in seconds.
what could be reason in bigger board

big board has 1200+ topics and 9000+ posts

Dblog

running the converter again and i noticed that its stopping exactly after converting 1000 topics and shows 'duplicate key error'

any clue on this??

kat

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

Dblog

yes
i've done that but converter stops at same position

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

Dblog

i tried to search this forum for suggestions and found similar problem for IPB to SMF conversion
http://www.simplemachines.org/community/index.php?topic=292127.0
i did similar modification for xmb_to_smf.sql and ran the converter again
this time it stopped at
..../convert_xmb.php?step=1&substep=13&start=400
and says

Converting posts (part2)
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting banned users... Successful.
Converting settings... Successful.
Converting moderators... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Recalculating forum statistics... Table 'smf.topics' doesn't exist

also topic titles have been changed all over the forum

kat

I think I'd be tempted to ask your host about the database, then.

Dblog

i asked. they said database is okay
i even repaired and optimized it and gave a dump copy to a friend who did this conversion on his local machine and got same error

kat

Well, the database is obviously not OK, if you have Duplicate entry '1207' for key 'PRIMARY'.

Did you regale them with that piece of information?

Dblog

i manually removed topic 1207 and then ran converter but it was stuck at Duplicate entry '1210' for key 'PRIMARY'.
then if i remove 1210, then its stuck at Duplicate entry '1212' for key 'PRIMARY'.

basically, it converts only first 1000 topic into smf and stops at 1001st topic

then i did what was suggested in that IPB converter topic and got topics converted but now it says

"Recalculating forum statistics... Table 'smf.topics' doesn't exist"

also topic titles have been changed all over the forum with replied titles for those topics.
also it didnt calculate stats so it shows only 1 member and 1 posts in stats but i can see all 9000+ posts converted

kat

Do you know, for certain, that key '1207' is for topic 1207? (I've never dug that deeply into the db to be honest).

The thing I'm not getting, here, is that your host's saying that the db is fine, when it's patently not.

Dblog

if its not for 1207 topic, then why would it skip 1207 when i removed it manually and stuck at 1210 and so on...
problem i've noticed is that if board has 1000+ topics, then 1001st topic gets this problem

i've converted a smaller board with 400+ topics and it had no issues

i'd googled about this and though may be the primary key is small INT, so it may not take more than 1000 but SMF uses mid INT

but it didnt make diff.

now i retried converting and it did topics okay
but when it came to posts..

"Converting posts (this may take some time)...Wrong value type sent to the database. Integer expected. (id_member)"

Dblog

Hi
i've found this file in some other post on this board when someone was replying about this duplicate entry problem for xmb.
instead of convert.php they suggested a modified convert_xmb.php which i downloaded and tried
it converted everything perfectly but topic titles(first post) was edited/changed with replied titles.
this happened for most topics

rest all looked fine

can someone tell me whats wrong with that conversion file?


Dblog

can someone tell me how to run this script now.
Its doing nothing on php 7+ or 8+

I also tried the converter here
https://download.simplemachines.org/index.php?converters;id=5

which says it'll convert XMB to SMF 2.0.19
I have a working XMB 1.9.12 and a fresh install of SMF 2.0.19

Doug Heffernan

Quote from: Dblog on July 11, 2022, 12:20:12 PMcan someone tell me how to run this script now.
Its doing nothing on php 7+ or 8+

I also tried the converter here
https://download.simplemachines.org/index.php?converters;id=5

which says it'll convert XMB to SMF 2.0.19
I have a working XMB 1.9.12 and a fresh install of SMF 2.0.19

Are both forums on the same server? If so, are both forums installed on the same database? If not, do both databases share the same user with full permissions/access to both databases?

Dblog

yes. both are on same server and use same database and same user with full permissions
convert.php in official converter link or convert_xmb.php (which i attached long bck) are returning blank page

Doug Heffernan

Quote from: Dblog on July 11, 2022, 01:13:50 PMyes. both are on same server and use same database and same user with full permissions
convert.php in official converter link or convert_xmb.php (which i attached long bck) are returning blank page

What is your php version?

Dblog

PHP Version 8.1.4.
I can try 7.4 too on a different subdomain if it works that way

Dblog

Any update on how to make this converter work ?

Oldiesmann

Do you get a blank screen when trying to run it? If so, check the server error log. PHP has changed a lot since this converter was first written.
Michael Eshom
Christian Metal Fans

Advertisement: