News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

php nuke to smf 1.1.11 convertor error

Started by gevv, March 19, 2010, 03:56:09 AM

Previous topic - Next topic

gevv

Hello   

php nuke to smf 1.1.11  convertor error please help me

-----------------------------------------------------------------

Converting topic notifications... Unsuccessful!
This query:

    INSERT INTO `forumdb`.smf_log_notify
    (ID_MEMBER, ID_TOPIC)
    VALUES ('3191', '2962'),
    ('2916', '3006'),
    ('6059', '9607'),
    ('420', '3007'),
    ('1501', '3008'),
    ('4797', '3009'),
    ('55', '3011'),
    ('3942', '3012'),
    ('5515', '4385'),
    ('2916', '3013'),
    ('827', '3014'),
    ('2304', '5849'),
    ('302', '3012'),
    ('4530', '2970'),
    ('1084', '2754'),
    ('2009', '3006'),
    ('4324', '3017'),
    ('129', '3016'),
    ('4732', '273'),
    ('1769', '11614'),
    ('7696', '19103'),
    ('4357', '6547'),
    ('1196', '3021'),
    ('3938', '3022'),
    ('3938', '3023'),
    ('3914', '3024'),
    ('1628', '3022'),
    ('3191', '3030'),
    ('3191', '3024'),
    ('3191', '3021'),
    ('4609', '3036'),
    ('4821', '3024'),
    ('1628', '6547'),
    ('3699', '3038'),
    ('3191', '3038'),
    ('4822', '1302'),
    ('4822', '1302'),
    ('827', '3040'),
    ('4627', '3041'),
    ('903', '3036'),
    ('1685', '1877'),
    ('302', '3043'),
    ('39', '3045'),
    ('425', '2079'),
    ('4', '9635'),
    ('3171', '3046'),
    ('3171', '3194'),
    ('4827', '3047'),
    ('3171', '3043'),
    ('1084', '3043'),
    ('425', '3048'),
    ('3171', '2427'),
    ('420', '3042'),
    ('3171', '3036'),
    ('2324', '3056'),
    ('420', '117'),
    ('1309', '1645'),
    ('420', '3006'),
    ('12520', '12406'),
    ('10038', '12382'),
    ('1683', '3066'),
    ('903', '3066'),
    ('903', '2364'),
    ('4609', '3072'),
    ('14', '3073'),
    ('3330', '3075'),
    ('4051', '3076'),
    ('3330', '3077'),
    ('3171', '3074'),
    ('3171', '3072'),
    ('1685', '2914'),
    ('129', '3080'),
    ('4132', '3072'),
    ('4132', '3081'),
    ('4885', '3083'),
    ('4832', '3085'),
    ('3720', '2977'),
    ('1104', '3086'),
    ('1104', '3079'),
    ('827', '3090'),
    ('1104', '3071'),
    ('1104', '3089'),
    ('1196', '3006'),
    ('1402', '3021'),
    ('3171', '3079'),
    ('420', '3091'),
    ('903', '3095'),
    ('4132', '3096'),
    ('3191', '3091'),
    ('129', '3091'),
    ('903', '3098'),
    ('4827', '3099'),
    ('3191', '3093'),
    ('4829', '3031'),
    ('129', '3101'),
    ('2071', '5105'),
    ('39', '3112'),
    ('4780', '1882'),
    ('4609', '2669'),
    ('369', '2494'),
    ('369', '2965'),
    ('4627', '3115'),
    ('4609', '629'),
    ('401', '2965'),
    ('129', '3108'),
    ('1633', '3117'),
    ('380', '2965'),
    ('3171', '629'),
    ('129', '629'),
    ('2009', '3118'),
    ('1318', '2669'),
    ('3191', '3118'),
    ('749', '5054'),
    ('4829', '3119'),
    ('3191', '3137'),
    ('3330', '656'),
    ('1494', '3121'),
    ('3720', '2583'),
    ('3171', '3123'),
    ('1196', '3125'),
    ('6977', '8112'),
    ('2501', '1241'),
    ('2324', '3075'),
    ('903', '3123'),
    ('4609', '2740'),
    ('2324', '3121'),
    ('2324', '3127'),
    ('4938', '2578'),
    ('4975', '3155'),
    ('903', '656'),
    ('903', '3129'),
    ('903', '3077'),
    ('4609', '70'),
    ('2324', '3147'),
    ('1685', '656'),
    ('1652', '3058'),
    ('1633', '3134'),
    ('1196', '3058'),
    ('1318', '3055'),
    ('129', '3136'),
    ('3594', '3133'),
    ('2009', '3131'),
    ('1628', '3137'),
    ('3191', '3138'),
    ('4829', '1292'),
    ('3887', '3139'),
    ('3171', '440'),
    ('129', '440'),
    ('3171', '3142'),
    ('1685', '3144'),
    ('3171', '17374'),
    ('4955', '3145'),
    ('4865', '3141'),
    ('4865', '3013'),
    ('55', '3145'),
    ('4609', '3146'),
    ('1318', '3123'),
    ('129', '3112'),
    ('3191', '3141'),
    ('129', '3141'),
    ('1196', '178'),
    ('1918', '3150'),
    ('4627', '3151'),
    ('4965', '3085'),
    ('2324', '3128'),
    ('3674', '3153'),
    ('425', '3025'),
    ('335', '3153'),
    ('2228', '3156'),
    ('2426', '4580'),
    ('2545', '3156'),
    ('2545', '3155'),
    ('2545', '3154'),
    ('2545', '3153'),
    ('2545', '3152'),
    ('2545', '3151'),
    ('2545', '3150'),
    ('2545', '3149'),
    ('2545', '3148'),
    ('2545', '3147'),
    ('903', '3156'),
    ('2545', '117'),
    ('2545', '3128'),
    ('129', '5119'),
    ('903', '3128'),
    ('1196', '3158'),
    ('1318', '3158'),
    ('7986', '6545'),
    ('5054', '210'),
    ('2953', '22181'),
    ('2461', '3155'),
    ('1153', '3158'),
    ('129', '3166'),
    ('4982', '2905'),
    ('11984', '17449'),
    ('1196', '3167'),
    ('2009', '178'),
    ('3191', '3171'),
    ('129', '3128'),
    ('129', '3170'),
    ('3191', '3170'),
    ('129', '3171'),
    ('63', '3173'),
    ('903', '3167'),
    ('129', '3174'),
    ('1196', '3175'),
    ('63', '3176'),
    ('63', '3177'),
    ('3171', '3443'),
    ('1196', '3174'),
    ('749', '1901'),
    ('749', '3130'),
    ('4132', '3264'),
    ('1196', '3180'),
    ('3171', '3405'),
    ('2902', '3182'),
    ('129', '3184'),
    ('1104', '3185'),
    ('1318', '3183'),
    ('3149', '3265'),
    ('4051', '3188'),
    ('55', '3190'),
    ('4609', '3953'),
    ('55', '3188'),
    ('55', '3181'),
    ('903', '3191'),
    ('3191', '8145'),
    ('5775', '4866'),
    ('1104', '3854'),
    ('3171', '3192'),
    ('4051', '3187'),
    ('4051', '3186'),
    ('1196', '3210'),
    ('129', '3188'),
    ('4780', '3140'),
    ('4337', '3006'),
    ('1318', '3186'),
    ('4188', '3198'),
    ('3380', '1877'),
    ('235', '3201'),
    ('2009', '3204'),
    ('129', '3197'),
    ('4955', '3203'),
    ('3171', '3146'),
    ('8606', '17432'),
    ('1104', '3863'),
    ('1196', '2977'),
    ('129', '3247'),
    ('3149', '629'),
    ('129', '3185'),
    ('2156', '3207'),
    ('2222', '5800'),
    ('129', '3216'),
    ('5022', '3220'),
    ('4609', '3221'),
    ('5677', '5046'),
    ('1196', '3222'),
    ('4768', '3223'),
    ('129', '2842'),
    ('129', '3224'),
    ('129', '3194'),
    ('39', '3226'),
    ('2916', '4910'),
    ('4051', '3231'),
    ('4132', '3224'),
    ('11984', '17513'),
    ('4051', '3232'),
    ('4337', '3229'),
    ('8606', '17521'),
    ('749', '2711'),
    ('4570', '1873'),
    ('9046', '17522'),
    ('129', '3212'),
    ('6457', '17436'),
    ('1494', '3237'),
    ('4051', '3238'),
    ('2916', '3080'),
    ('1196', '3239'),
    ('6895', '9702'),
    ('1196', '3191'),
    ('3171', '3239'),
    ('1196', '3234'),
    ('1196', '3231'),
    ('3171', '3237'),
    ('1196', '3241'),
    ('3171', '3103'),
    ('4337', '3242'),
    ('903', '3243'),
    ('5047', '3244'),
    ('2009', '3243'),
    ('2009', '3244'),
    ('1318', '3244'),
    ('4337', '3246'),
    ('2868', '2905'),
    ('1318', '3247'),
    ('1318', '3245'),
    ('2916', '3249'),
    ('1084', '3212'),
    ('55', '3250'),
    ('1318', '3250'),
    ('4609', '3266'),
    ('1918', '6414'),
    ('4609', '3251'),
    ('4609', '3194'),
    ('6047', '17443'),
    ('4609', '3167'),
    ('3191', '3250'),
    ('129', '3250'),
    ('903', '2921'),
    ('6895', '6968'),
    ('4185', '3256'),
    ('5609', '14'),
    ('1780', '3283'),
    ('4132', '12485'),
    ('4609', '3259'),
    ('5059', '3260'),
    ('14', '3261'),
    ('1350', '3259'),
    ('5515', '9528'),
    ('296', '3263'),
    ('4609', '3264'),
    ('235', '3253'),
    ('1084', '9620'),
    ('4609', '3269'),
    ('4829', '3270'),
    ('401', '3229'),
    ('15799', '17439'),
    ('5257', '1111'),
    ('3818', '3274'),
    ('4609', '3268'),
    ('3942', '3275'),
    ('39', '3276'),
    ('3171', '3270'),
    ('3171', '3275'),
    ('129', '3612'),
    ('8676', '7031'),
    ('903', '4492'),
    ('4132', '4457'),
    ('301', '1626'),
    ('2953', '9696'),
    ('3171', '3361'),
    ('4132', '2734'),
    ('4051', '3253'),
    ('4051', '3291'),
    ('1494', '3289'),
    ('1318', '3292'),
    ('1820', '1987'),
    ('3171', '3253'),
    ('5240', '3606'),
    ('55', '3288'),
    ('344', '12203'),
    ('1153', '2549'),
    ('4609', '2572'),
    ('4609', '3284'),
    ('4609', '3292'),
    ('1494', '3292'),
    ('4609', '2584'),
    ('4609', '4192'),
    ('2009', '2921'),
    ('2426', '3301'),
    ('129', '3292'),
    ('4609', '3287'),
    ('4609', '3301'),
    ('1494', '3302'),
    ('4337', '3303'),
    ('4337', '2655'),
    ('3171', '3307'),
    ('2440', '2655'),
    ('2009', '3300'),
    ('129', '3303'),
    ('129', '3300'),
    ('4609', '4199'),
    ('3931', '3307'),
    ('5101', '3310'),
    ('2568', '3305'),
    ('1318', '3305'),
    ('301', '3310'),
    ('1065', '10374'),
    ('1153', '3100'),
    ('4609', '3305'),
    ('4337', '3316'),
    ('3594', '3308'),
    ('1084', '3297'),
    ('1084', '3303'),
    ('1084', '3295'),
    ('4337', '3323'),
    ('4609', '3318'),
    ('4609', '2412'),
    ('4609', '3307'),
    ('4188', '3305'),
    ('2009', '3317'),
    ('129', '3320'),
    ('2009', '2648'),
    ('2009', '3327'),
    ('2009', '3036'),
    ('129', '2572'),
    ('301', '2412'),
    ('5059', '3330'),
    ('1153', '2688'),
    ('903', '2688'),
    ('5059', '2572'),
    ('5059', '3331'),
    ('63', '3332'),
    ('4357', '4492'),
    ('4886', '3333'),
    ('5649', '6535'),
    ('55', '3333'),
    ('5094', '3333'),
    ('2009', '3332'),
    ('2009', '2163'),
    ('2009', '2655'),
    ('4', '3332'),
    ('4609', '3380'),
    ('3171', '3341'),
    ('769', '3342'),
    ('2916', '5038'),
    ('5094', '3342'),
    ('5094', '3341'),
    ('1494', '2655'),
    ('4132', '3341'),
    ('4337', '3328'),
    ('3171', '3355'),
    ('420', '3356'),
    ('3171', '3359'),
    ('3171', '3188'),
    ('3171', '3178'),
    ('826', '3361'),
    ('903', '3297'),
    ('903', '3359'),
    ('972', '3361'),
    ('3171', '3362'),
    ('129', '3633'),
    ('2112', '3634'),
    ('3171', '3281'),
    ('3171', '3365'),
    ('3171', '3366'),
    ('4609', '3361'),
    ('4609', '3281'),
    ('3171', '3367'),
    ('3171', '3368'),
    ('129', '3361'),
    ('3171', '3369'),
    ('3171', '3370'),
    ('3171', '3371'),
    ('129', '3366'),
    ('2009', '3674'),
    ('7900', '6225'),
    ('4609', '3372'),
    ('4609', '3340'),
    ('4132', '4571'),
    ('129', '5255'),
    ('2071', '2798'),
    ('4609', '3362'),
    ('4609', '3141'),
    ('5466', '4081'),
    ('2009', '3379'),
    ('129', '4968'),
    ('420', '3330'),
    ('301', '3375'),
    ('301', '3224'),
    ('4337', '3376'),
    ('2009', '3382'),
    ('826', '3384'),
    ('3191', '3379'),
    ('129', '3340'),
    ('3171', '3340'),
    ('63', '897'),
    ('3171', '3375'),
    ('1494', '3392'),
    ('425', '3300'),
    ('2009', '3630'),
    ('301', '4079'),
    ('2112', '3395'),
    ('903', '3392'),
    ('3171', '3195'),
    ('2156', '3397'),
    ('4609', '3400'),
    ('5059', '3400'),
    ('4188', '3307'),
    ('9482', '7194'),
    ('4132', '15320'),
    ('2112', '3397'),
    ('5738', '4881'),
    ('4609', '3407'),
    ('4337', '3167'),
    ('4337', '2202'),
    ('5037', '3401'),
    ('3942', '4577'),
    ('4531', '3411'),
    ('5126', '3409'),
    ('8840', '15582'),
    ('129', '3401'),
    ('4609', '3412'),
    ('4609', '3413'),
    ('2324', '5212'),
    ('2009', '3413'),
    ('4609', '2655'),
    ('401', '3411'),
    ('1318', '2202'),
    ('1494', '3407');

Caused the error:

    Duplicate entry '3191-2962-0' for key 'PRIMARY'

try again
ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Norv

Can you please try emptying the smf_log_notify table, in phpMyAdmin (empty, not drop :) ), then try again the conversion?
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

Advertisement: