Simple Machines Community Forum

SMF Support => Converting to SMF => MyBB => Topic started by: jetli68 on January 11, 2010, 08:59:36 AM

Title: Duplicate entry '1071' for key 1 how to fix
Post by: jetli68 on January 11, 2010, 08:59:36 AM
i there i  am getting this error now  when trying to convert  mybb to smf 1.11

and at bottom it says try again  and when i click  it  it says 517 for key 1

i have tryied  recount_categories.php that did not work anyone got any ideas how to fix this please

tia

jet
Title: Re: Duplicate entry '1071' for key 1 how to fix
Post by: Norv on January 11, 2010, 08:51:24 PM
Can you please copy and paste the entire error message, or make a screenshot with it?
Title: Re: Duplicate entry '1071' for key 1 how to fix
Post by: jetli68 on January 13, 2010, 05:08:06 AM
this is the error i get

[code]Converting...
Converting topics... Unsuccessful!
This query:
INSERT INTO `filesune_mybb`.smf_topics
(ID_TOPIC, ID_BOARD, isSticky, ID_POLL, numViews, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, numReplies, locked, ID_FIRST_MSG, ID_LAST_MSG)
VALUES ('517', '8', '0', '0', '7', '1', '411', '1', '', '527', '3338'),
('518', '8', '0', '0', '6', '1', '411', '1', '', '528', '3337'),
('519', '29', '0', '0', '4', '1', '411', '2', '', '529', '3508'),
('520', '29', '0', '0', '11', '1', '451', '2', '', '530', '3526'),
('521', '8', '0', '0', '12', '1', '411', '2', '', '531', '3303'),
('522', '8', '0', '0', '9', '1', '730', '3', '', '532', '4874'),
('523', '29', '0', '0', '14', '1', '8', '3', '', '533', '5889'),
('524', '29', '0', '0', '27', '1', '377', '6', '', '534', '5046'),
('525', '29', '0', '0', '12', '1', '730', '3', '', '535', '4871'),
('526', '8', '0', '0', '7', '1', '411', '2', '', '536', '3573'),
('527', '29', '0', '0', '12', '1', '411', '4', '', '537', '3296'),
('528', '29', '0', '0', '27', '1', '411', '5', '', '538', '3298'),
('529', '29', '0', '0', '12', '1', '8', '3', '', '539', '5893'),
('530', '29', '0', '0', '14', '1', '411', '4', '', '540', '3668'),
('531', '29', '0', '0', '4', '1', '411', '1', '', '541', '3325'),
('532', '29', '0', '0', '4', '1', '411', '1', '', '542', '3326'),
('533', '29', '0', '0', '4', '1', '411', '1', '', '543', '3327'),
('534', '8', '0', '0', '8', '1', '411', '1', '', '544', '3328'),
('535', '29', '0', '0', '26', '1', '444', '4', '', '545', '5180'),
('536', '29', '0', '0', '11', '1', '411', '2', '', '546', '3504'),
('537', '29', '0', '0', '7', '1', '451', '2', '', '547', '3518'),
('538', '29', '0', '0', '8', '1', '8', '3', '', '548', '5894'),
('539', '29', '0', '0', '11', '1', '8', '3', '', '549', '5888'),
('540', '29', '0', '0', '9', '1', '8', '3', '', '550', '5899'),
('541', '38', '0', '0', '7', '3', '3', '0', '', '551', '551'),
('542', '29', '0', '0', '10', '1', '8', '4', '', '552', '5898'),
('543', '41', '0', '0', '1', '3', '3', '0', '', '553', '553'),
('544', '31', '0', '0', '3', '3', '3', '0', '', '554', '554'),
('545', '31', '0', '0', '2', '3', '3', '0', '', '555', '555'),
('546', '31', '0', '0', '1', '3', '3', '0', '', '556', '556'),
('547', '31', '0', '0', '2', '3', '3', '0', '', '557', '557'),
('548', '8', '0', '0', '6', '1', '411', '2', '', '558', '3491'),
('549', '29', '0', '0', '17', '1', '8', '3', '', '559', '5887'),
('550', '8', '0', '0', '5', '1', '411', '2', '', '560', '3487'),
('551', '8', '0', '0', '9', '1', '411', '1', '', '561', '3318'),
('552', '29', '0', '0', '4', '1', '411', '1', '', '562', '3317'),
('553', '8', '0', '0', '6', '1', '411', '2', '', '563', '3484'),
('554', '41', '0', '0', '8', '3', '77', '1', '', '564', '1535'),
('555', '8', '0', '0', '6', '1', '411', '2', '', '565', '3481'),
('556', '33', '0', '0', '6', '3', '1103', '2', '', '566', '6922'),
('557', '33', '0', '0', '1', '3', '3', '0', '', '567', '567'),
('558', '33', '0', '0', '4', '3', '847', '1', '', '568', '6971'),
('559', '33', '0', '0', '1', '3', '3', '0', '', '569', '569'),
('560', '33', '0', '0', '0', '3', '3', '0', '', '570', '570'),
('561', '33', '0', '0', '5', '3', '847', '1', '', '571', '6972'),
('562', '33', '0', '0', '1', '3', '3', '0', '', '572', '572'),
('563', '33', '0', '0', '0', '3', '3', '0', '', '573', '573'),
('564', '33', '0', '0', '1', '3', '3', '0', '', '574', '574'),
('565', '33', '0', '0', '0', '3', '3', '0', '', '575', '575'),
('566', '33', '0', '0', '2', '3', '241', '1', '', '576', '2751'),
('567', '33', '0', '0', '1', '3', '3', '0', '', '577', '577'),
('568', '33', '0', '0', '0', '3', '3', '0', '', '578', '578'),
('569', '33', '0', '0', '0', '3', '3', '0', '', '579', '579'),
('570', '33', '0', '0', '0', '3', '3', '0', '', '580', '580'),
('571', '33', '0', '0', '10', '3', '241', '1', '', '581', '2394'),
('572', '33', '0', '0', '0', '3', '3', '0', '', '582', '582'),
('573', '33', '0', '0', '0', '3', '3', '0', '', '583', '583'),
('574', '33', '0', '0', '0', '3', '3', '0', '', '584', '584'),
('575', '33', '0', '0', '1', '3', '3', '0', '', '585', '585'),
('576', '37', '0', '0', '0', '3', '3', '0', '', '586', '586'),
('577', '37', '0', '0', '3', '3', '3', '0', '', '587', '587'),
('578', '37', '0', '0', '0', '3', '3', '0', '', '588', '588'),
('579', '37', '0', '0', '0', '3', '3', '0', '', '589', '589'),
('580', '37', '0', '0', '0', '3', '3', '0', '', '590', '590'),
('581', '37', '0', '0', '0', '3', '3', '0', '', '591', '591'),
('582', '37', '0', '0', '1', '3', '3', '0', '', '592', '592'),
('583', '37', '0', '0', '0', '3', '3', '0', '', '593', '593'),
('584', '37', '0', '0', '0', '3', '3', '0', '', '594', '594'),
('585', '37', '0', '0', '0', '3', '3', '0', '', '595', '595'),
('586', '37', '0', '0', '1', '3', '3', '0', '', '596', '596'),
('587', '36', '0', '0', '0', '3', '3', '0', '', '597', '597'),
('588', '36', '0', '0', '1', '3', '3', '0', '', '598', '598'),
('589', '36', '0', '0', '0', '3', '3', '0', '', '599', '599'),
('590', '36', '0', '0', '0', '3', '3', '0', '', '600', '600'),
('591', '36', '0', '0', '2', '3', '3', '0', '', '601', '601'),
('592', '36', '0', '0', '0', '3', '3', '0', '', '602', '602'),
('593', '36', '0', '0', '0', '3', '3', '0', '', '603', '603'),
('594', '36', '0', '0', '0', '3', '3', '0', '', '604', '604'),
('595', '36', '0', '0', '0', '3', '3', '0', '', '605', '605'),
('596', '36', '0', '0', '0', '3', '3', '0', '', '606', '606'),
('597', '41', '0', '0', '2', '3', '3', '0', '', '607', '607'),
('598', '31', '0', '0', '1', '3', '3', '0', '', '608', '608'),
('600', '41', '0', '0', '0', '3', '3', '0', '', '610', '610'),
('601', '41', '0', '0', '1', '3', '3', '0', '', '611', '611'),
('602', '32', '0', '0', '8', '1', '847', '1', '', '612', '6461'),
('603', '41', '0', '0', '1', '3', '3', '0', '', '613', '613'),
('604', '41', '0', '0', '1', '1', '1', '0', '', '614', '614'),
('605', '42', '0', '0', '1', '1', '1', '0', '', '615', '615'),
('606', '41', '0', '0', '1', '1', '1', '0', '', '616', '616'),
('607', '41', '0', '0', '1', '1', '1', '0', '', '617', '617'),
('608', '43', '0', '0', '1', '1', '1', '0', '', '618', '618'),
('609', '42', '0', '0', '1', '1', '1', '0', '', '619', '619'),
('610', '41', '0', '0', '1', '1', '1', '0', '', '620', '620'),
('611', '36', '0', '0', '0', '3', '3', '0', '', '621', '621'),
('612', '36', '0', '0', '0', '3', '3', '0', '', '622', '622'),
('613', '36', '0', '0', '0', '3', '3', '0', '', '623', '623'),
('614', '36', '0', '0', '1', '3', '3', '0', '', '624', '624'),
('615', '44', '0', '0', '2', '1', '1', '0', '', '625', '625'),
('616', '41', '0', '0', '1', '1', '1', '0', '', '626', '626'),
('617', '33', '0', '0', '2', '1', '1', '0', '', '627', '627'),
('618', '37', '0', '0', '1', '3', '3', '0', '', '628', '628'),
('619', '19', '0', '0', '1', '1', '1', '0', '', '629', '629'),
('620', '19', '0', '0', '1', '1', '1', '0', '', '630', '630'),
('621', '27', '0', '0', '3', '1', '1', '0', '', '631', '631'),
('622', '19', '0', '0', '16', '1', '1406', '4', '', '632', '8011'),
('623', '19', '0', '0', '9', '1', '847', '2', '', '633', '5892'),
('624', '19', '0', '0', '15', '1', '4', '2', '', '634', '1211'),
('625', '19', '0', '0', '2', '1', '1', '0', '', '635', '635'),
('626', '19', '0', '0', '1', '1', '1', '0', '', '636', '636'),
('627', '19', '0', '0', '1', '1', '1', '0', '', '637', '637'),
('628', '31', '0', '0', '1', '6', '6', '0', '', '638', '638'),
('629', '31', '0', '0', '1', '6', '6', '0', '', '639', '639'),
('630', '19', '0', '0', '0', '1', '1', '0', '', '640', '640'),
('631', '31', '0', '0', '1', '6', '6', '0', '', '641', '641'),
('632', '44', '0', '0', '2', '6', '1', '1', '', '642', '644'),
('633', '22', '0', '0', '2', '1', '1', '0', '', '643', '643'),
('634', '17', '0', '0', '1', '1', '1', '0', '', '645', '645'),
('635', '19', '0', '0', '1', '1', '1', '0', '', '646', '646'),
('636', '19', '0', '0', '0', '1', '1', '0', '', '647', '647'),
('637', '19', '0', '0', '1', '1', '1', '0', '', '648', '648'),
('638', '17', '0', '0', '0', '1', '1', '0', '', '649', '649'),
('639', '17', '0', '0', '0', '1', '1', '0', '', '650', '650'),
('640', '17', '0', '0', '1', '1', '1', '0', '', '651', '651'),
('641', '19', '0', '0', '0', '1', '1', '0', '', '652', '652'),
('642', '19', '0', '0', '0', '1', '1', '0', '', '653', '653'),
('643', '24', '0', '0', '1', '1', '1', '0', '', '654', '654'),
('644', '19', '0', '0', '0', '1', '1', '0', '', '655', '655'),
('645', '19', '0', '0', '1', '1', '1', '0', '', '656', '656'),
('646', '19', '0', '0', '1', '1', '1', '0', '', '657', '657'),
('647', '19', '0', '0', '1', '1', '1', '0', '', '658', '658'),
('648', '19', '0', '0', '1', '1', '1', '0', '', '659', '659'),
('649', '29', '0', '0', '3', '1', '411', '1', '', '660', '3314'),
('650', '29', '0', '0', '15', '1', '8', '3', '', '661', '5924'),
('651', '29', '0', '0', '24', '1', '8', '7', '', '662', '5883'),
('652', '8', '0', '0', '11', '1', '411', '2', '', '663', '3304'),
('653', '29', '0', '0', '12', '1', '117', '3', '', '664', '4444'),
('654', '8', '0', '0', '5', '1', '411', '1', '', '665', '3310'),
('655', '29', '0', '0', '11', '1', '8', '3', '', '666', '5890'),
('656', '8', '0', '0', '8', '1', '411', '2', '', '667', '3294'),
('657', '8', '0', '0', '25', '1', '1', '4', '', '668', '2083'),
('658', '8', '0', '0', '6', '1', '411', '1', '', '669', '3309'),
('659', '8', '0', '0', '14', '1', '53', '4', '', '670', '3479'),
('660', '8', '0', '0', '8', '1', '411', '2', '', '671', '3352'),
('661', '8', '0', '0', '5', '1', '411', '2', '', '672', '3351'),
('663', '31', '0', '0', '2', '6', '6', '0', '', '674', '674'),
('664', '34', '0', '0', '1', '6', '6', '0', '', '675', '675'),
('665', '34', '0', '0', '1', '6', '6', '0', '', '676', '676'),
('666', '45', '0', '0', '1', '3', '3', '0', '', '678', '678'),
('667', '45', '0', '0', '5', '3', '554', '2', '', '679', '5990'),
('668', '45', '0', '0', '1', '3', '3', '0', '', '680', '680'),
('669', '45', '0', '0', '4', '3', '377', '1', '', '681', '6862'),
('670', '45', '0', '0', '7', '3', '582', '1', '', '682', '4609'),
('671', '38', '0', '0', '5', '3', '3', '0', '', '683', '683'),
('672', '41', '0', '0', '0', '3', '3', '0', '', '684', '684'),
('673', '31', '0', '0', '2', '6', '6', '0', '', '685', '685'),
('674', '41', '0', '0', '1', '3', '3', '0', '', '689', '689'),
('675', '41', '0', '0', '1', '3', '3', '0', '', '690', '690'),
('676', '41', '0', '0', '1', '3', '3', '0', '', '691', '691'),
('677', '32', '0', '0', '1', '3', '3', '0', '', '692', '692'),
('678', '34', '0', '0', '1', '3', '3', '0', '', '693', '693'),
('679', '44', '0', '0', '1', '3', '3', '0', '', '694', '694'),
('680', '41', '0', '0', '1', '3', '3', '0', '', '695', '695'),
('681', '41', '0', '0', '1', '3', '3', '0', '', '696', '696'),
('682', '31', '0', '0', '0', '3', '3', '0', '', '697', '697'),
('683', '37', '0', '0', '0', '3', '3', '0', '', '698', '698'),
('684', '36', '0', '0', '1', '3', '3', '0', '', '699', '699'),
('685', '36', '0', '0', '1', '3', '3', '0', '', '700', '700'),
('686', '36', '0', '0', '2', '3', '3', '0', '', '701', '701'),
('687', '36', '0', '0', '2', '3', '3', '0', '', '702', '702'),
('688', '41', '0', '0', '2', '3', '3', '0', '', '703', '703'),
('689', '41', '0', '0', '0', '3', '3', '0', '', '704', '704'),
('690', '34', '0', '0', '0', '1', '1', '0', '', '705', '705'),
('691', '34', '0', '0', '3', '1', '1', '0', '', '706', '706'),
('692', '34', '0', '0', '4', '1', '215', '1', '', '707', '2142'),
('693', '33', '0', '0', '3', '1', '1247', '1', '', '708', '7495'),
('694', '33', '0', '0', '1', '1', '1', '0', '', '709', '709'),
('695', '33', '0', '0', '0', '1', '1', '0', '', '710', '710'),
('696', '33', '0', '0', '1', '1', '1', '0', '', '711', '711'),
('697', '33', '0', '0', '1', '1', '1', '0', '', '712', '712'),
('698', '33', '0', '0', '2', '1', '1', '0', '', '713', '713'),
('699', '42', '0', '0', '0', '1', '1', '0', '', '714', '714'),
('700', '42', '0', '0', '0', '1', '1', '0', '', '715', '715'),
('701', '42', '0', '0', '1', '1', '1', '0', '', '716', '716'),
('702', '42', '0', '0', '1', '1', '1', '0', '', '717', '717'),
('703', '42', '0', '0', '1', '1', '1', '0', '', '718', '718'),
('705', '41', '0', '0', '0', '1', '1', '0', '', '721', '721'),
('706', '21', '0', '0', '1', '1', '1', '0', '', '722', '722'),
('707', '21', '0', '0', '0', '1', '1', '0', '', '723', '723'),
('708', '19', '0', '0', '1', '1', '1', '0', '', '724', '724'),
('709', '19', '0', '0', '2', '1', '1', '0', '', '725', '725'),
('710', '19', '0', '0', '1', '1', '1', '0', '', '726', '726'),
('711', '19', '0', '0', '0', '1', '1', '0', '', '727', '727'),
('712', '19', '0', '0', '2', '1', '1', '0', '', '728', '728'),
('713', '19', '0', '0', '4', '1', '52', '1', '', '729', '1060'),
('714', '19', '0', '0', '5', '1', '52', '1', '', '730', '1079'),
('715', '19', '0', '0', '1', '1', '1', '0', '', '731', '731'),
('716', '41', '0', '0', '1', '3', '3', '0', '', '732', '732'),
('717', '41', '0', '0', '1', '3', '3', '0', '', '733', '733'),
('718', '19', '0', '0', '0', '1', '1', '0', '', '734', '734'),
('719', '19', '0', '0', '8', '1', '847', '2', '', '735', '6460'),
('720', '23', '0', '0', '1', '1', '1', '0', '', '736', '736'),
('721', '19', '0', '0', '2', '1', '1', '0', '', '737', '737'),
('722', '17', '0', '0', '10', '1', '731', '4', '', '738', '4878'),
('723', '17', '0', '0', '1', '1', '1', '0', '', '739', '739'),
('724', '17', '0', '0', '0', '1', '1', '0', '', '740', '740'),
('725', '17', '0', '0', '8', '1', '1', '2', '', '741', '986'),
('726', '17', '0', '0', '1', '1', '1', '0', '', '742', '742'),
('727', '17', '0', '0', '1', '1', '1', '0', '', '743', '743'),
('728', '17', '0', '0', '1', '1', '1', '0', '', '744', '744'),
('729', '17', '0', '0', '1', '1', '1', '0', '', '745', '745'),
('730', '22', '0', '0', '5', '1', '1', '0', '', '746', '746'),
('731', '24', '0', '0', '3', '1', '1', '0', '', '747', '747'),
('732', '24', '0', '0', '2', '1', '1', '0', '', '748', '748'),
('733', '24', '0', '0', '2', '1', '1', '0', '', '749', '749'),
('734', '24', '0', '0', '2', '1', '1', '0', '', '750', '750'),
('735', '32', '0', '0', '4', '3', '454', '2', '', '751', '5963'),
('736', '32', '0', '0', '5', '3', '454', '2', '', '752', '5964'),
('737', '32', '0', '0', '5', '3', '454', '2', '', '753', '5965'),
('738', '32', '0', '0', '4', '3', '454', '2', '', '754', '5968'),
('739', '39', '0', '0', '4', '3', '3', '0', '', '755', '755'),
('740', '8', '0', '0', '9', '3', '1', '1', '', '756', '758'),
('741', '39', '0', '0', '1', '3', '3', '0', '', '757', '757'),
('742', '39', '0', '0', '5', '3', '52', '1', '', '760', '1078'),
('743', '39', '0', '0', '4', '3', '613', '1', '', '761', '6768'),
('744', '39', '0', '0', '0', '3', '3', '0', '', '762', '762'),
('745', '39', '0', '0', '0', '3', '3', '0', '', '763', '763'),
('746', '39', '0', '0', '1', '3', '3', '0', '', '764', '764'),
('747', '39', '0', '0', '0', '3', '3', '0', '', '765', '765'),
('748', '39', '0', '0', '0', '3', '3', '0', '', '766', '766'),
('749', '39', '0', '0', '1', '3', '3', '0', '', '767', '767'),
('750', '33', '0', '0', '1', '6', '6', '0', '', '768', '768'),
('751', '33', '0', '0', '1', '6', '6', '0', '', '769', '769'),
('752', '41', '0', '0', '2', '3', '3', '0', '', '770', '770'),
('753', '34', '0', '0', '2', '6', '6', '0', '', '771', '771'),
('754', '14', '0', '0', '3', '3', '3', '0', '', '772', '772'),
('755', '14', '0', '0', '3', '3', '3', '0', '', '773', '773'),
('756', '14', '0', '0', '14', '3', '3', '3', '', '774', '2379'),
('757', '14', '0', '0', '4', '3', '3', '0', '', '775', '775'),
('758', '14', '0', '0', '4', '3', '3', '0', '', '776', '776'),
('759', '14', '0', '0', '3', '3', '3', '0', '', '777', '777'),
('760', '14', '0', '0', '6', '3', '3', '0', '', '778', '778'),
('761', '41', '0', '0', '1', '3', '3', '0', '', '779', '779'),
('762', '34', '0', '0', '1', '3', '3', '0', '', '780', '780'),
('763', '34', '0', '0', '3', '3', '1108', '1', '', '781', '6882'),
('764', '34', '0', '0', '3', '3', '561', '1', '', '782', '4016'),
('765', '34', '0', '0', '5', '3', '940', '2', '', '783', '5994'),
('766', '34', '0', '0', '5', '3', '940', '2', '', '784', '5995'),
('767', '34', '0', '0', '5', '3', '940', '2', '', '785', '5996'),
('768', '34', '0', '0', '6', '3', '940', '2', '', '786', '5997'),
('769', '34', '0', '0', '5', '3', '940', '2', '', '787', '5998'),
('770', '34', '0', '0', '4', '3', '940', '2', '', '788', '5999'),
('771', '32', '0', '0', '5', '3', '454', '2', '', '789', '5966'),
('772', '32', '0', '0', '5', '3', '454', '2', '', '790', '5967'),
('773', '41', '0', '0', '1', '4', '4', '0', '', '791', '791'),
('774', '42', '0', '0', '1', '4', '4', '0', '', '792', '792'),
('776', '42', '0', '0', '1', '4', '4', '0', '', '794', '794'),
('777', '42', '0', '0', '1', '4', '4', '0', '', '795', '795'),
('778', '41', '0', '0', '1', '4', '4', '0', '', '796', '796'),
('779', '41', '0', '0', '2', '4', '4', '0', '', '797', '797'),
('780', '44', '0', '0', '1', '4', '4', '0', '', '798', '798'),
('783', '19', '0', '0', '0', '4', '4', '0', '', '801', '801'),
('787', '20', '0', '0', '2', '4', '4', '0', '', '805', '805'),
('788', '19', '0', '0', '3', '4', '1', '1', '', '806', '978'),
('791', '19', '0', '0', '0', '1', '1', '0', '', '809', '809'),
('792', '19', '0', '0', '17', '1', '837', '3', '', '810', '6136'),
('793', '23', '0', '0', '0', '4', '4', '0', '', '811', '811'),
('794', '23', '0', '0', '0', '4', '4', '0', '', '812', '812'),
('795', '19', '0', '0', '0', '4', '4', '0', '', '813', '813'),
('796', '22', '0', '0', '1', '4', '4', '0', '', '814', '814'),
('797', '19', '0', '0', '22', '4', '52', '1', '', '815', '977'),
('799', '17', '0', '0', '1', '4', '4', '0', '', '817', '817'),
('800', '17', '0', '0', '1', '4', '4', '0', '', '818', '818'),
('801', '22', '0', '0', '7', '4', '169', '1', '', '819', '2250'),
('802', '24', '0', '0', '0', '4', '4', '0', '', '820', '820'),
('803', '24', '0', '0', '0', '4', '4', '0', '', '821', '821'),
('804', '24', '0', '0', '1', '1', '1', '0', '', '822', '822'),
('805', '17', '0', '0', '18', '1', '168', '2', '', '824', '7005'),
('806', '24', '0', '0', '4', '1', '1', '0', '', '826', '826'),
('807', '8', '0', '0', '17', '1', '1200', '3', '', '827', '7292'),
('808', '26', '0', '0', '0', '1', '1', '0', '', '828', '828'),
('809', '32', '0', '0', '0', '3', '3', '0', '', '829', '829'),
('810', '32', '0', '0', '0', '3', '3', '0', '', '830', '830'),
('811', '32', '0', '0', '0', '3', '3', '0', '', '831', '831'),
('812', '32', '0', '0', '2', '3', '3', '0', '', '832', '832'),
('813', '32', '0', '0', '0', '3', '3', '0', '', '833', '833'),
('814', '14', '0', '0', '7', '3', '3', '0', '', '834', '834'),
('815', '18', '0', '0', '0', '3', '3', '0', '', '835', '835'),
('816', '18', '0', '0', '0', '3', '3', '0', '', '836', '836'),
('817', '18', '0', '0', '0', '3', '3', '0', '', '837', '837'),
('818', '18', '0', '0', '0', '3', '3', '0', '', '838', '838'),
('819', '18', '0', '0', '0', '3', '3', '0', '', '839', '839'),
('820', '18', '0', '0', '0', '3', '3', '0', '', '840', '840'),
('821', '18', '0', '0', '0', '3', '3', '0', '', '841', '841'),
('822', '18', '0', '0', '1', '3', '3', '0', '', '842', '842'),
('823', '18', '0', '0', '0', '3', '3', '0', '', '843', '843'),
('824', '18', '0', '0', '0', '3', '3', '0', '', '844', '844'),
('825', '18', '0', '0', '6', '3', '64', '1', '', '845', '1424'),
('826', '22', '0', '0', '1', '1', '1', '0', '', '846', '846'),
('827', '18', '0', '0', '0', '3', '3', '0', '', '847', '847'),
('828', '18', '0', '0', '1', '3', '3', '0', '', '848', '848'),
('829', '20', '0', '0', '9', '1', '1015', '2', '', '849', '6663'),
('830', '20', '0', '0', '5', '1', '823', '1', '', '850', '5807'),
('831', '20', '0', '0', '1', '1', '1', '0', '', '851', '851'),
('832', '20', '0', '0', '2', '1', '1', '0', '', '852', '852'),
('833', '23', '0', '0', '1', '4', '4', '0', '', '853', '853'),
('834', '23', '0', '0', '0', '4', '4', '0', '', '854', '854'),
('835', '21', '0', '0', '1', '4', '4', '0', '', '855', '855'),
('836', '19', '0', '0', '4', '4', '52', '1', '', '856', '1057'),
('837', '39', '0', '0', '2', '1', '1', '0', '', '857', '857'),
('838', '38', '0', '0', '5', '3', '3', '0', '', '858', '858'),
('849', '6', '0', '0', '16', '50', '50', '2', '', '869', '914'),
('852', '19', '0', '0', '0', '3', '3', '0', '', '876', '876'),
('853', '32', '0', '0', '1', '6', '6', '0', '', '877', '877'),
('854', '42', '0', '0', '0', '3', '3', '0', '', '878', '878'),
('855', '42', '0', '0', '0', '3', '3', '0', '', '879', '879'),
('856', '41', '0', '0', '1', '3', '3', '0', '', '880', '880'),
('857', '41', '0', '0', '0', '3', '3', '0', '', '881', '881'),
('858', '41', '0', '0', '1', '3', '3', '0', '', '882', '882'),
('859', '34', '0', '0', '1', '6', '6', '0', '', '883', '883'),
('860', '39', '0', '0', '9', '6', '444', '2', '', '884', '5326'),
('861', '34', '0', '0', '9', '3', '50', '1', '', '885', '915'),
('862', '33', '0', '0', '1', '3', '3', '0', '', '886', '886'),
('863', '33', '0', '0', '6', '3', '1268', '1', '', '887', '7602'),
('864', '33', '0', '0', '1', '3', '3', '0', '', '888', '888'),
('865', '33', '0', '0', '0', '3', '3', '0', '', '889', '889'),
('866', '33', '0', '0', '0', '3', '3', '0', '', '890', '890'),
('867', '33', '0', '0', '0', '3', '3', '0', '', '891', '891'),
('890', '37', '0', '0', '0', '3', '3', '0', '', '916', '916'),
('891', '37', '0', '0', '1', '3', '3', '0', '', '917', '917'),
('892', '37', '0', '0', '0', '3', '3', '0', '', '918', '918'),
('893', '37', '0', '0', '0', '3', '3', '0', '', '919', '919'),
('894', '37', '0', '0', '0', '3', '3', '0', '', '920', '920'),
('895', '37', '0', '0', '0', '3', '3', '0', '', '921', '921'),
('896', '37', '0', '0', '0', '3', '3', '0', '', '922', '922'),
('897', '37', '0', '0', '1', '3', '3', '0', '', '923', '923'),
('898', '23', '0', '0', '3', '3', '3', '0', '', '924', '924'),
('899', '36', '0', '0', '0', '3', '3', '0', '', '925', '925'),
('900', '36', '0', '0', '0', '3', '3', '0', '', '926', '926'),
('901', '32', '0', '0', '1', '6', '6', '0', '', '927', '927'),
('902', '36', '0', '0', '0', '3', '3', '0', '', '928', '928'),
('903', '36', '0', '0', '1', '3', '3', '0', '', '929', '929'),
('904', '31', '0', '0', '11', '6', '1282', '2', '', '930', '7521'),
('905', '36', '0', '0', '0', '3', '3', '0', '', '931', '931'),
('906', '36', '0', '0', '0', '3', '3', '0', '', '932', '932'),
('907', '14', '0', '0', '1', '3', '3', '0', '', '933', '933'),
('908', '45', '0', '0', '5', '6', '6', '0', '', '934', '934'),
('909', '14', '0', '0', '20', '3', '582', '1', '', '935', '4148'),
('910', '14', '0', '0', '4', '3', '3', '2', '', '936', '1018'),
('911', '19', '0', '0', '0', '1', '1', '0', '', '937', '937'),
('912', '19', '0', '0', '0', '1', '1', '0', '', '938', '938'),
('913', '19', '0', '0', '0', '1', '1', '0', '', '939', '939'),
('914', '19', '0', '0', '1', '1', '1', '0', '', '940', '940'),
('915', '8', '0', '0', '8', '1', '411', '1', '', '941', '3307'),
('916', '42', '0', '0', '1', '1', '1', '0', '', '942', '942'),
('917', '42', '0', '0', '1', '1', '1', '0', '', '943', '943'),
('918', '41', '0', '0', '0', '1', '1', '0', '', '944', '944'),
('919', '41', '0', '0', '1', '1', '1', '0', '', '945', '945'),
('920', '41', '0', '0', '0', '1', '1', '0', '', '946', '946'),
('921', '41', '0', '0', '0', '1', '1', '0', '', '947', '947'),
('922', '44', '0', '0', '1', '1', '1', '0', '', '948', '948'),
('923', '19', '0', '0', '9', '1', '236', '1', '', '949', '2596'),
('924', '19', '0', '0', '0', '1', '1', '0', '', '950', '950'),
('925', '20', '0', '0', '6', '1', '215', '2', '', '951', '7535'),
('926', '17', '0', '0', '0', '1', '1', '0', '', '952', '952'),
('927', '19', '0', '0', '1', '4', '4', '0', '', '953', &
Title: Re: Duplicate entry '1071' for key 1 how to fix
Post by: jetli68 on January 13, 2010, 05:09:00 AM
and this on the end of it

Caused the error:
Duplicate entry '517' for key 1
Title: Re: Duplicate entry '1071' for key 1 how to fix
Post by: Norv on January 13, 2010, 06:35:10 AM
Please, login in phpMyAdmin, and select your SMF database, and the smf_topics table. (replace "smf_" with your actual database prefix). Then, choose to "empty" it. (not drop)
Then please run the conversion again.
Title: Re: Duplicate entry '1071' for key 1 how to fix
Post by: jetli68 on January 15, 2010, 06:12:20 AM
hi m8  how do i    change the setting for this    i got  2  smf topic  things

smf_topics

smf_log_search_topics
i can not see how to change the prefix

any help with this would be great
Title: Re: Duplicate entry '1071' for key 1 how to fix
Post by: jetli68 on January 15, 2010, 11:44:00 AM
i renamed it   m8 but now says  can not find smf_topics
Title: Re: Duplicate entry '1071' for key 1 how to fix
Post by: Norv on January 15, 2010, 11:55:51 AM
Sorry, it seems to be a misunderstanding. I meant you should find the table named "smf_topics", or, if you use on your installation another prefix than "smf_", then the table to find will have the name your_prefix_topics.

Since you had something named exactly "smf_topics", then that's the table. No need to rename anything: please empty it. There should be in phpmyadmin a link to empty it: if you select the table smf_topics, then in the Operations tab there should be a way to empty it (not drop, not rename, just empty it).
Title: Re: Duplicate entry '1071' for key 1 how to fix
Post by: jetli68 on January 15, 2010, 12:55:11 PM
i have empty  it m8 but still come up with that  error  again m8   copys all  members  just not topics and posts

tia

jet
Title: Re: Duplicate entry '1071' for key 1 how to fix
Post by: Norv on January 28, 2010, 08:24:41 AM
Sorry for the delay. Can you please copy paste the error message, or make a screenshot? It's a little strange, that ID should be taken from MyBB, and there is should not be duplicated as well. It seems you once got the error for id "1071" and then for "517"?