Topic: [SMF Converter] XMB - 1.9.8

[JayBachatero]

zamorc - he means to run the conversion locally.  Also what I mean about the step is that in the url what is the step there? Also use the file that I attached in the first post.

themortalgod - can you check the step that it got to in the url?

[weec]

Duplicate entry '162-71-0' for key 1

zamorc, solution of this trouble - 'delete theme  ID 71(on xmb forum) & reupgrade your xmbforum to XMB Nexus 1.9.6 RC2, after try now conversion

[zamorc]

Well why to reupgrade? If I leave just a few posts in xmb forum everything is OK. When I try to convert the whole forum than I get this error.

Also what I mean about the step is that in the url what is the step there? Also use the file that I attached in the first post.
Sorry but still don't know about which step you are talking.
In one folder I have xmb. In another I have fresh install of smf. I have taken the file from this topic and copied it into smf folder and convert.php from download section of this site. Than I have gone to: http://mysite/smf/convert.php and I have received this error.

[weec]

ok ok

JayBachatero, i am downloaded(recomended) new files convert.php & xmb_to_smf.sql
and tryed again

see error in attached file

[babyjuker]

What is the error at the end of the page?  Duplicate key?

Yes, now i re-converted with the upgraded file as well as the .sql file but i'm still having issues with it.  It'll convert the members but not the posts nor the topics.  I keep getting this error "Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Incomplete." then it'll refresh after i press the continue bar.  Then i will only get converting topics...incomplete, after refreshing for a good 7 times, nothing will happen. 

[JayBachatero]

weec try the reuploaded file in the first post.

babyjuker does the substep change in the url?  How big is your board?

[themortalgod]

it got to step 1

[weec]

JayBachatero, all normal, this error in TXT file (error codepage)
i am setuping normal codepage, trying convert  - converting normal (without errors 'dublicate key')
but time of coversion process is UP (very long)

[JayBachatero]

Converting posts can be a long process so just hang in there.

[babyjuker]

weec try the reuploaded file in the first post.

babyjuker does the substep change in the url?  How big is your board?

not that i know of.  i have more posts and threads then members.  Im not sure of the exact size.

[JayBachatero]

Look at the url and see if &substep=## increases.

[babyjuker]

well i didn't see a start number but when it came to the page of letting me know that the converting of threads was incomplete it left off at substep=7&start=1000 the first time it was at 700

[babyjuker]

i've finally gotten past the threads but now i get the error of converting posts

listed in the file attached

[JayBachatero]

Do you have the latest convert.php.  It should do INSERT IGNORE INTO to prevent dup keys error.

[babyjuker]

yes i do that is what i've been using, the one that is attached in this thread

[JayBachatero]

Use the convert.php from here I mean.
http://www.simplemachines.org/community/index.php?topic=140741.0

[zamorc]

I am really tired. I have used this converter but again the same mistake.

Code: [Select]

Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Unsuccessful!
This query:

    INSERT INTO `zanimiv_smf`.zanimiv_log_notify
    (ID_MEMBER, ID_TOPIC)
    VALUES ('1', '30'),
    ('1', '34'),
    ('1', '38'),
    ('1', '57'),
    ('1', '74'),
    ('1', '86'),
    ('1', '105'),
    ('1', '108'),
    ('1', '109'),
    ('1', '110'),
    ('1', '130'),
    ('1', '142'),
    ('1', '160'),
    ('1', '162'),
    ('1', '166'),
    ('1', '182'),
    ('1', '193'),
    ('1', '196'),
    ('1', '204'),
    ('1', '206'),
    ('1', '227'),
    ('38', '12'),
    ('17', '7'),
    ('17', '1'),
    ('17', '1350'),
    ('376', '2878'),
    ('20', '94'),
    ('385', '1566'),
    ('47', '96'),
    ('47', '2046'),
    ('47', '71'),
    ('47', '4126'),
    ('47', '257'),
    ('47', '1269'),
    ('48', '560'),
    ('54', '120'),
    ('77', '2860'),
    ('77', '2705'),
    ('77', '2852'),
    ('77', '2569'),
    ('77', '2850'),
    ('90', '382'),
    ('90', '268'),
    ('91', '105'),
    ('91', '825'),
    ('94', '8'),
    ('277', '1049'),
    ('99', '2271'),
    ('99', '135'),
    ('99', '180'),
    ('100', '105'),
    ('116', '1170'),
    ('116', '1779'),
    ('116', '2868'),
    ('473', '1337'),
    ('122', '105'),
    ('131', '60'),
    ('131', '120'),
    ('135', '105'),
    ('135', '965'),
    ('158', '1666'),
    ('162', '71'),
    ('162', '643'),
    ('162', '71'),
    ('162', '307'),
    ('162', '71'),
    ('173', '3069'),
    ('206', '46'),
    ('210', '2096'),
    ('210', '1795'),
    ('210', '1921'),
    ('215', '1079'),
    ('215', '1759'),
    ('215', '1079'),
    ('219', '251'),
    ('229', '357'),
    ('229', '564'),
    ('229', '3479'),
    ('229', '933'),
    ('229', '1944'),
    ('229', '1421'),
    ('229', '1289'),
    ('229', '1458'),
    ('229', '1813'),
    ('229', '3097'),
    ('229', '2835'),
    ('229', '2877'),
    ('229', '1973'),
    ('229', '424'),
    ('229', '2204'),
    ('229', '3717'),
    ('229', '3612'),
    ('229', '3808'),
    ('229', '3819'),
    ('229', '3262'),
    ('264', '1973'),
    ('264', '306'),
    ('264', '2046'),
    ('264', '385'),
    ('264', '930'),
    ('264', '102'),
    ('264', '1011'),
    ('264', '50'),
    ('264', '794'),
    ('264', '927'),
    ('264', '1645'),
    ('263', '1774'),
    ('285', '766'),
    ('285', '71'),
    ('318', '685'),
    ('319', '3248'),
    ('415', '1017'),
    ('415', '43'),
    ('415', '2370'),
    ('415', '1041'),
    ('415', '2080'),
    ('415', '1716'),
    ('342', '1676'),
    ('541', '1679'),
    ('394', '1326'),
    ('397', '1158'),
    ('397', '4209'),
    ('404', '2424'),
    ('404', '3262'),
    ('406', '71'),
    ('422', '2402'),
    ('422', '2195'),
    ('422', '424'),
    ('422', '424'),
    ('422', '2402'),
    ('422', '1892'),
    ('422', '1269'),
    ('422', '2419'),
    ('422', '448'),
    ('422', '2372'),
    ('422', '2456'),
    ('430', '448'),
    ('452', '1356'),
    ('466', '1277'),
    ('466', '1289'),
    ('466', '1361'),
    ('466', '1440'),
    ('466', '1449'),
    ('466', '1458'),
    ('466', '307'),
    ('464', '2550'),
    ('464', '2204'),
    ('464', '3262'),
    ('484', '1437'),
    ('484', '1373'),
    ('484', '1480'),
    ('670', '1637'),
    ('671', '2363'),
    ('866', '3692'),
    ('737', '3105'),
    ('499', '1931'),
    ('499', '1011'),
    ('499', '253'),
    ('499', '1011'),
    ('499', '1572'),
    ('499', '1225'),
    ('499', '1734'),
    ('499', '1716'),
    ('499', '1381'),
    ('499', '1378'),
    ('499', '1311'),
    ('499', '335'),
    ('499', '71'),
    ('499', '876'),
    ('499', '4172'),
    ('499', '844'),
    ('499', '1269'),
    ('499', '1379'),
    ('499', '1419'),
    ('499', '155'),
    ('499', '1779'),
    ('499', '307'),
    ('499', '1447'),
    ('499', '1430'),
    ('499', '2901'),
    ('499', '1779'),
    ('499', '2023'),
    ('499', '3262'),
    ('499', '1816'),
    ('499', '1817'),
    ('499', '1057'),
    ('499', '1241'),
    ('499', '1430'),
    ('499', '1181'),
    ('499', '910'),
    ('499', '71'),
    ('499', '1546'),
    ('499', '2702'),
    ('499', '1847'),
    ('499', '1848'),
    ('499', '1196'),
    ('499', '1610'),
    ('499', '2730'),
    ('499', '1136'),
    ('499', '2198'),
    ('499', '2826'),
    ('499', '4201'),
    ('499', '2971'),
    ('499', '1921'),
    ('499', '3096'),
    ('499', '3049'),
    ('499', '1637'),
    ('499', '3780'),
    ('499', '3036'),
    ('499', '3157'),
    ('499', '1041'),
    ('499', '3042'),
    ('499', '2736'),
    ('499', '3361'),
    ('499', '1954'),
    ('499', '1942'),
    ('499', '2046'),
    ('499', '2071'),
    ('499', '3222'),
    ('499', '3224'),
    ('499', '3199'),
    ('499', '1214'),
    ('499', '811'),
    ('499', '2932'),
    ('499', '593'),
    ('499', '2765'),
    ('499', '2482'),
    ('499', '1802'),
    ('499', '1843'),
    ('499', '3190'),
    ('499', '3130'),
    ('499', '3082'),
    ('499', '3092'),
    ('499', '50'),
    ('499', '280'),
    ('499', '1629'),
    ('499', '1970'),
    ('499', '2685'),
    ('499', '191'),
    ('499', '1921'),
    ('499', '3247'),
    ('499', '3420'),
    ('499', '2238'),
    ('499', '3253'),
    ('499', '1091'),
    ('499', '2780'),
    ('499', '1011'),
    ('499', '687'),
    ('499', '2768'),
    ('499', '3428'),
    ('499', '2677'),
    ('499', '3603'),
    ('499', '1892'),
    ('499', '353'),
    ('499', '3291'),
    ('499', '354'),
    ('499', '619'),
    ('499', '1897'),
    ('499', '3401'),
    ('499', '3336'),
    ('499', '3014'),
    ('499', '3416'),
    ('499', '43'),
    ('499', '3260'),
    ('499', '3350'),
    ('499', '3576'),
    ('499', '3553'),
    ('499', '3664'),
    ('499', '3653'),
    ('499', '2046'),
    ('499', '3654'),
    ('499', '3591'),
    ('499', '2204'),
    ('499', '3715'),
    ('499', '3721'),
    ('499', '1559'),
    ('499', '1624'),
    ('499', '1851'),
    ('499', '1413'),
    ('499', '3290'),
    ('499', '3656'),
    ('499', '3324'),
    ('499', '3723'),
    ('499', '3338'),
    ('499', '3736'),
    ('499', '3744'),
    ('499', '1248'),
    ('499', '1278'),
    ('499', '794'),
    ('499', '535'),
    ('499', '3743'),
    ('499', '2673'),
    ('499', '1985'),
    ('499', '3749'),
    ('499', '3506'),
    ('499', '2885'),
    ('499', '667'),
    ('499', '3669'),
    ('499', '3764'),
    ('499', '3760'),
    ('499', '1362'),
    ('499', '3683'),
    ('499', '1213'),
    ('499', '2802'),
    ('499', '3758'),
    ('499', '3655'),
    ('499', '231'),
    ('499', '347'),
    ('499', '361'),
    ('499', '3252'),
    ('499', '3612'),
    ('499', '3703'),
    ('499', '3259'),
    ('499', '3634'),
    ('499', '2030'),
    ('499', '35'),
    ('499', '2636'),
    ('499', '3304'),
    ('499', '3684'),
    ('499', '900'),
    ('499', '3289'),
    ('499', '261'),
    ('499', '3725'),
    ('499', '1549'),
    ('499', '424'),
    ('499', '615'),
    ('499', '2536'),
    ('499', '2082'),
    ('499', '3633'),
    ('499', '3320'),
    ('499', '3271'),
    ('499', '254'),
    ('499', '3108'),
    ('499', '1947'),
    ('499', '1902'),
    ('499', '1236'),
    ('499', '3484'),
    ('499', '3710'),
    ('499', '3197'),
    ('499', '3766'),
    ('499', '3502'),
    ('499', '3451'),
    ('499', '1956'),
    ('499', '2379'),
    ('499', '3145'),
    ('499', '3342'),
    ('499', '2956'),
    ('499', '3783'),
    ('499', '1742'),
    ('499', '3326'),
    ('499', '2622'),
    ('499', '4344'),
    ('499', '1015'),
    ('499', '2064'),
    ('499', '1713'),
    ('499', '3031'),
    ('499', '3552'),
    ('499', '1892'),
    ('499', '1973'),
    ('499', '146'),
    ('499', '3503'),
    ('499', '3495'),
    ('499', '3446'),
    ('499', '2034'),
    ('499', '3296'),
    ('499', '3699'),
    ('499', '2619'),
    ('499', '3496'),
    ('499', '1838'),
    ('499', '1555'),
    ('499', '1894'),
    ('499', '1004'),
    ('499', '3790'),
    ('499', '3226'),
    ('499', '3851'),
    ('499', '3732'),
    ('499', '3731'),
    ('499', '3302'),
    ('499', '3102'),
    ('499', '3023'),
    ('499', '2422'),
    ('499', '2247'),
    ('499', '1779'),
    ('499', '71'),
    ('499', '3557'),
    ('499', '3794'),
    ('499', '3793'),
    ('499', '3788'),
    ('499', '3801'),
    ('499', '3800'),
    ('499', '222'),
    ('499', '1113'),
    ('499', '3799'),
    ('499', '3795'),
    ('499', '1512'),
    ('499', '3775'),
    ('499', '805'),
    ('499', '1503'),
    ('499', '1233'),
    ('499', '3798'),
    ('499', '3806'),
    ('499', '3808'),
    ('499', '3809'),
    ('499', '3089'),
    ('499', '4190'),
    ('499', '4341'),
    ('499', '3813'),
    ('499', '1134'),
    ('499', '3820'),
    ('499', '3927'),
    ('499', '3882'),
    ('499', '3946'),
    ('499', '3283'),
    ('499', '3878'),
    ('499', '3796'),
    ('499', '1689'),
    ('499', '3845'),
    ('499', '3894'),
    ('499', '1944'),
    ('499', '3084'),
    ('499', '3914'),
    ('499', '1839'),
    ('499', '961'),
    ('499', '448'),
    ('499', '3825'),
    ('499', '1259'),
    ('499', '2651'),
    ('499', '3839'),
    ('499', '3827'),
    ('499', '3868'),
    ('499', '3853'),
    ('499', '3840'),
    ('499', '3804'),
    ('499', '3915'),
    ('499', '3917'),
    ('499', '3925'),
    ('499', '3921'),
    ('499', '1757'),
    ('499', '3919'),
    ('499', '1188'),
    ('499', '584'),
    ('499', '3968'),
    ('499', '3963'),
    ('499', '3986'),
    ('499', '767'),
    ('499', '3874'),
    ('499', '3930'),
    ('499', '2004'),
    ('499', '3982'),
    ('499', '3985'),
    ('499', '2185'),
    ('499', '3987'),
    ('499', '1741'),
    ('499', '2118'),
    ('499', '2550'),
    ('499', '4000'),
    ('499', '543'),
    ('499', '4001'),
    ('499', '4005'),
    ('499', '3904'),
    ('499', '3937'),
    ('499', '3857'),
    ('499', '4007'),
    ('499', '3753'),
    ('499', '2698'),
    ('499', '3817'),
    ('499', '3828'),
    ('499', '1428'),
    ('499', '4025'),
    ('499', '3916'),
    ('499', '4018'),
    ('499', '4052'),
    ('499', '4053'),
    ('499', '4058'),
    ('499', '3984'),
    ('499', '3125'),
    ('499', '3711'),
    ('499', '3700'),
    ('499', '3122'),
    ('499', '2918'),
    ('499', '4055'),
    ('499', '3912'),
    ('499', '3967'),
    ('499', '4004'),
    ('499', '4047'),
    ('499', '3929'),
    ('499', '3945'),
    ('499', '4326'),
    ('499', '368'),
    ('499', '3842'),
    ('499', '3970'),
    ('499', '4099'),
    ('499', '3862'),
    ('499', '945'),
    ('499', '3737'),
    ('499', '4322'),
    ('499', '684'),
    ('499', '3936'),
    ('499', '4336'),
    ('499', '3955');

Caused the error:

    Duplicate entry '162-71-0' for key 1
-----------------------------------------------------------

And now I persume know about which steps has someone talking here - is this step 1 substep 20 ?
convert.php?step=1&substep=20&start=0

Is it possible to convert xmb at all?

Edit: Please use code tags!

[JayBachatero]

Are you using the latest convert.php?  That table its supposed to do INSERT IGNORE.

[zamorc]

Yes. Iam using this:
http://www.simplemachines.org/community/index.php?topic=140741.0

[JayBachatero]

Ok then that should work.  Can you PM me FTP info and I can give it a shot for you.