Advertisement:

Author Topic: converting topics unsuccessful  (Read 3825 times)

Offline mcapote

  • Newbie
  • *
  • Posts: 7
converting topics unsuccessful
« on: February 11, 2008, 12:00:53 PM »
vb 3.5.3 to SMF 1.1.3

Quote
Converting topics... Unsuccessful!
This query:
INSERT INTO `forums00_smf1`.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 ('5326', '20', '0', '0', '115', '48', '10', '11', '0', '48699', '48919'),
('5327', '18', '0', '0', '61', '115', '15', '3', '0', '48700', '48711'),
('5328', '18', '0', '0', '114', '198', '33', '6', '0', '48704', '49022'),
('5329', '18', '0', '0', '33', '33', '33', '0', '0', '48718', '48718'),
('5330', '18', '0', '0', '55', '651', '651', '4', '0', '48721', '48734'),
('5331', '13', '0', '0', '79', '198', '664', '5', '0', '48723', '48795'),
('5332', '26', '0', '0', '244', '213', '136', '17', '0', '48735', '49819'),
('5333', '26', '0', '0', '28', '213', '213', '1', '0', '48737', '48738'),
('5334', '57', '0', '0', '12', '48', '48', '2', '0', '48747', '48750'),
('5335', '18', '0', '0', '211', '76', '183', '17', '0', '48751', '48829'),
('5336', '18', '0', '0', '252', '10', '183', '19', '0', '48765', '48831'),
('5337', '50', '0', '0', '63', '20', '110', '7', '0', '48772', '49441'),
('5338', '18', '0', '0', '54', '67', '56', '1', '0', '48776', '48782'),
('5339', '26', '0', '0', '51', '48', '664', '3', '0', '48778', '48794'),
('5340', '25', '0', '0', '28', '33', '33', '1', '0', '48779', '48859'),
('5341', '20', '0', '0', '91', '272', '50', '4', '0', '48780', '48922'),
('5342', '18', '0', '0', '167', '33', '110', '9', '0', '48784', '49004'),
('5343', '35', '0', '0', '164', '340', '76', '7', '0', '48789', '49142'),
('5344', '30', '0', '0', '104', '229', '74', '9', '0', '48810', '48854'),
('5345', '33', '0', '0', '187', '272', '229', '12', '0', '48816', '48956'),
('5346', '18', '0', '0', '95', '183', '33', '5', '0', '48832', '48934'),
('5347', '25', '0', '0', '24', '651', '651', '0', '0', '48839', '48839'),
('5348', '20', '0', '0', '205', '651', '664', '16', '0', '48840', '49047'),
('5349', '18', '0', '0', '126', '33', '4', '6', '0', '48842', '49036'),
('5350', '25', '0', '0', '29', '373', '373', '0', '0', '48843', '48843'),
('5351', '57', '0', '0', '22', '48', '48', '5', '0', '48844', '48938'),
('5352', '18', '0', '0', '190', '229', '651', '14', '0', '48845', '48941'),
('5353', '24', '0', '0', '29', '30', '664', '1', '0', '48857', '48918'),
('5354', '18', '0', '0', '60', '13', '4', '1', '0', '48865', '48870'),
('5355', '25', '0', '0', '55', '198', '33', '4', '0', '48871', '48879'),
('5356', '18', '0', '0', '116', '53', '183', '7', '0', '48877', '48895'),
('5357', '26', '0', '0', '192', '213', '136', '17', '0', '48887', '50146'),
('5358', '37', '0', '0', '312', '213', '87', '17', '0', '48888', '49470'),
('5359', '20', '0', '0', '78', '213', '213', '9', '0', '48903', '48958'),
('5360', '18', '0', '0', '367', '30', '205', '20', '0', '48920', '49094'),
('5361', '20', '0', '0', '92', '110', '50', '7', '0', '48927', '49016'),
('5362', '17', '0', '0', '62', '33', '33', '4', '0', '48937', '48953'),
('5363', '12', '0', '0', '292', '33', '221', '24', '0', '48945', '49665'),
('5364', '25', '0', '0', '42', '10', '39', '3', '0', '48948', '48970'),
('5365', '18', '0', '0', '76', '33', '229', '4', '0', '48961', '48981'),
('5366', '24', '0', '0', '31', '356', '10', '1', '0', '48964', '48966'),
('5367', '24', '0', '0', '41', '48', '48', '3', '0', '48965', '48986'),
('5368', '48', '0', '0', '62', '272', '272', '2', '0', '48980', '48995'),
('5369', '26', '0', '0', '148', '10', '10', '13', '0', '48982', '49219'),
('5370', '20', '0', '0', '79', '183', '13', '7', '0', '49001', '49097'),
('5371', '14', '0', '0', '112', '211', '211', '10', '0', '49018', '49602'),
('5372', '38', '1', '0', '11', '4', '13', '2', '0', '49023', '49095'),
('5373', '18', '0', '0', '87', '30', '183', '9', '0', '49024', '49114'),
('5374', '18', '0', '0', '126', '272', '30', '4', '0', '49035', '49231'),
('5375', '18', '0', '0', '124', '184', '6', '9', '0', '49042', '49189'),
('5376', '13', '0', '0', '23', '229', '229', '0', '0', '49050', '49050'),
('5377', '18', '0', '0', '60', '30', '4', '5', '0', '49054', '49073'),
('5378', '18', '0', '68', '166', '229', '183', '8', '0', '49060', '49183'),
('5379', '12', '0', '0', '67', '110', '110', '7', '0', '49076', '49117'),
('5380', '26', '0', '0', '69', '48', '4', '7', '0', '49092', '49154'),
('5381', '13', '0', '0', '26', '240', '240', '0', '0', '49099', '49099'),
('5382', '18', '0', '0', '215', '30', '272', '16', '0', '49100', '49226'),
('5383', '18', '0', '0', '190', '13', '6', '13', '0', '49107', '49193'),
('5384', '24', '0', '0', '29', '664', '664', '0', '0', '49111', '49111'),
('5385', '28', '0', '0', '49', '10', '10', '3', '0', '49146', '49287'),
('5386', '21', '0', '0', '35', '213', '74', '1', '0', '49156', '49161'),
('5387', '25', '0', '0', '82', '198', '13', '6', '0', '49159', '49187'),
('5388', '24', '0', '0', '41', '33', '205', '1', '0', '49160', '49164'),
('5389', '57', '0', '0', '10', '13', '4', '2', '0', '49177', '49256'),
('5391', '20', '0', '0', '168', '10', '646', '12', '0', '49179', '49491'),
('5392', '18', '0', '0', '1096', '198', '308', '49', '0', '49194', '50461'),
('5393', '18', '0', '0', '228', '198', '183', '17', '0', '49196', '49284'),
('5394', '15', '0', '0', '44', '48', '48', '3', '0', '49217', '49236'),
('5395', '12', '0', '0', '59', '33', '33', '5', '0', '49225', '49246'),
('5396', '20', '0', '0', '75', '10', '41', '5', '0', '49243', '49278'),
('5397', '18', '0', '0', '85', '205', '4', '3', '0', '49247', '49251'),
('5398', '25', '0', '0', '35', '198', '198', '0', '0', '49250', '49250'),
('5399', '26', '0', '0', '28', '198', '243', '2', '0', '49254', '49260'),
('5400', '18', '0', '0', '96', '198', '198', '5', '0', '49257', '49272'),
('5401', '37', '0', '0', '327', '87', '4', '30', '0', '49262', '49450'),
('5402', '25', '0', '0', '276', '221', '205', '20', '0', '49274', '49416'),
('5403', '23', '0', '0', '41', '198', '198', '0', '0', '49286', '49286'),
('5404', '48', '0', '0', '176', '198', '689', '10', '0', '49288', '50862'),
('5405', '14', '0', '0', '32', '10', '110', '2', '0', '49293', '49372'),
('5406', '13', '0', '0', '151', '329', '110', '13', '0', '49303', '49363'),
('5407', '57', '0', '0', '15', '48', '6', '1', '0', '49310', '49407'),
('5408', '18', '0', '0', '121', '205', '110', '8', '0', '49319', '49474'),
('5409', '14', '0', '0', '35', '54', '54', '5', '0', '49329', '49397'),
('5410', '37', '0', '0', '66', '213', '213', '2', '0', '49331', '49463'),
('5411', '14', '0', '0', '33', '54', '110', '7', '0', '49332', '49359'),
('5412', '14', '0', '0', '33', '54', '110', '5', '0', '49364', '49399'),
('5413', '18', '0', '0', '50', '30', '243', '3', '0', '49365', '49384'),
('5414', '18', '0', '0', '51', '15', '15', '4', '0', '49388', '49402'),
('5416', '57', '0', '0', '17', '4', '13', '3', '0', '49418', '49443'),
('5417', '26', '0', '0', '18', '54', '54', '0', '0', '49420', '49420'),
('5418', '43', '0', '0', '31', '54', '54', '4', '0', '49424', '49440'),
('5419', '31', '0', '0', '72', '211', '211', '3', '0', '49442', '49601'),
('5420', '13', '0', '0', '324', '76', '76', '30', '0', '49446', '49640'),
('5421', '26', '0', '0', '36', '74', '4', '3', '0', '49454', '49466'),
('5422', '43', '0', '0', '68', '48', '48', '7', '0', '49468', '49528'),
('5423', '18', '0', '0', '140', '33', '33', '17', '0', '49472', '49504'),
('5424', '18', '0', '0', '52', '43', '651', '1', '0', '49492', '49523'),
('5425', '25', '0', '0', '31', '33', '33', '1', '0', '49501', '49511'),
('5426', '31', '0', '0', '49', '76', '632', '2', '0', '49503', '50167'),
('5427', '20', '0', '0', '41', '183', '110', '1', '0', '49517', '49521'),
('5428', '14', '0', '0', '33', '308', '110', '4', '0', '49529', '49542'),
('5429', '18', '0', '0', '315', '33', '50', '20', '0', '49533', '49636'),
('5430', '43', '0', '0', '49', '198', '183', '2', '0', '49537', '49580'),
('5431', '35', '0', '0', '54', '33', '33', '2', '0', '49553', '49572'),
('5432', '18', '0', '0', '28', '15', '15', '0', '0', '49559', '49559'),
('5434', '25', '0', '0', '146', '30', '13', '13', '0', '49562', '49608'),
('5435', '23', '0', '0', '59', '272', '110', '7', '0', '49581', '49600'),
('5436', '18', '0', '0', '142', '272', '48', '9', '0', '49586', '49614'),
('5437', '25', '0', '0', '34', '373', '272', '1', '0', '49589', '49595'),
('5438', '20', '0', '0', '42', '254', '254', '0', '0', '49610', '49610'),
('5439', '20', '0', '0', '81', '13', '48', '5', '0', '49615', '49638'),
('5440', '13', '0', '0', '27', '110', '110', '0', '0', '49620', '49620'),
('5441', '26', '0', '0', '77', '48', '4', '4', '0', '49625', '49646'),
('5442', '25', '0', '0', '54', '4', '229', '5', '0', '49642', '49654'),
('5443', '29', '0', '0', '68', '211', '211', '2', '0', '49645', '49923'),
('5444', '18', '0', '0', '402', '229', '243', '20', '0', '49651', '49830'),
('5445', '18', '0', '0', '2519', '229', '13', '156', '0', '49657', '50769'),
('5446', '20', '0', '0', '60', '4', '4', '4', '0', '49703', '49725'),
('5447', '20', '0', '0', '96', '48', '664', '14', '0', '49714', '49748'),
('5448', '50', '0', '0', '92', '6', '33', '15', '0', '49722', '49852'),
('5449', '24', '0', '0', '107', '211', '211', '11', '0', '49738', '49808'),
('5450', '47', '0', '0', '73', '54', '54', '6', '0', '49760', '49818'),
('5451', '24', '0', '0', '183', '54', '48', '12', '0', '49764', '50179'),
('5452', '37', '0', '0', '52', '4', '4', '0', '0', '49765', '49765'),
('5453', '15', '0', '0', '34', '48', '48', '2', '0', '49776', '49783'),
('5454', '18', '0', '0', '42', '33', '33', '0', '0', '49792', '49792'),
('5455', '57', '0', '0', '19', '48', '76', '3', '0', '49793', '50248'),
('5456', '20', '0', '0', '259', '651', '664', '23', '0', '49797', '50084'),
('5457', '20', '0', '0', '36', '229', '198', '1', '0', '49802', '49807'),
('5458', '12', '0', '0', '46', '30', '56', '2', '0', '49804', '49904'),
('5459', '13', '0', '0', '150', '198', '33', '10', '0', '49806', '49867'),
('5460', '16', '0', '0', '62', '41', '4', '3', '0', '49815', '49838'),
('5461', '18', '0', '0', '380', '33', '33', '24', '0', '49834', '50209'),
('5462', '25', '0', '0', '47', '33', '33', '1', '0', '49835', '49844'),
('5463', '33', '0', '0', '57', '54', '54', '2', '0', '49841', '49853'),
('5464', '35', '0', '0', '60', '229', '534', '3', '0', '49855', '49860'),
('5465', '20', '0', '0', '15', '10', '10', '0', '0', '49862', '49862'),
('5466', '18', '0', '0', '78', '213', '4', '6', '0', '49870', '50009'),
('5467', '20', '0', '0', '26', '272', '272', '0', '0', '49875', '49875'),
('5468', '18', '0', '0', '77', '272', '6', '6', '0', '49876', '49889'),
('5470', '18', '0', '0', '227', '30', '4', '24', '0', '49882', '50302'),
('5471', '25', '0', '0', '30', '13', '54', '1', '0', '49896', '49897'),
('5472', '18', '0', '0', '103', '213', '213', '7', '0', '49900', '49996'),
('5473', '13', '0', '0', '76', '664', '664', '8', '0', '49918', '49971'),
('5475', '43', '0', '0', '21', '243', '229', '1', '0', '49932', '49933'),
('5476', '18', '0', '0', '81', '33', '225', '1', '0', '49942', '49986'),
('5477', '20', '0', '0', '28', '272', '664', '1', '0', '49966', '49973'),
('5478', '24', '0', '0', '114', '373', '373', '10', '0', '49975', '50095'),
('5479', '18', '0', '0', '378', '132', '56', '22', '0', '49987', '50191'),
('5480', '18', '0', '0', '42', '229', '4', '1', '0', '50002', '50008'),
('5481', '18', '0', '0', '57', '33', '132', '3', '0', '50010', '50024'),
('5482', '18', '0', '0', '508', '33', '33', '40', '0', '50042', '50551'),
('5483', '18', '0', '0', '65', '76', '85', '3', '0', '50047', '50071'),
('5484', '34', '0', '0', '102', '264', '4', '8', '0', '50050', '50133'),
('5485', '34', '0', '0', '95', '212', '20', '8', '0', '50057', '50150'),
('5486', '14', '0', '0', '156', '272', '254', '14', '0', '50092', '50252'),
('5488', '20', '0', '0', '56', '10', '10', '9', '0', '50143', '50168'),
('5489', '24', '0', '0', '17', '52', '52', '0', '0', '50148', '50148'),
('5490', '12', '0', '0', '71', '48', '6', '4', '0', '50152', '50215'),
('5491', '20', '0', '0', '21', '48', '48', '1', '0', '50154', '50155'),
('5492', '20', '0', '0', '89', '272', '272', '6', '0', '50172', '50253'),
('5493', '29', '0', '0', '38', '33', '33', '4', '0', '50182', '50186'),
('5494', '14', '0', '0', '32', '205', '110', '1', '0', '50203', '50204'),
('5495', '21', '0', '0', '31', '229', '229', '2', '0', '50211', '50228'),
('5496', '47', '0', '0', '215', '54', '664', '14', '0', '50212', '50290'),
('5497', '16', '0', '0', '74', '436', '110', '3', '0', '50250', '50303'),
('5498', '18', '0', '0', '131', '229', '4', '8', '0', '50254', '50265'),
('5499', '18', '0', '0', '131', '198', '340', '5', '0', '50269', '50298'),
('5500', '20', '0', '0', '32', '198', '272', '1', '0', '50270', '50289'),
('5502', '37', '0', '0', '240', '198', '198', '16', '0', '50276', '50993'),
('5503', '20', '0', '0', '56', '651', '664', '1', '0', '50285', '50291'),
('5504', '26', '0', '0', '124', '10', '664', '16', '0', '50304', '50389'),
('5505', '47', '0', '0', '292', '556', '556', '20', '0', '50310', '50448'),
('5506', '24', '0', '0', '143', '243', '556', '12', '0', '50343', '50421'),
('5507', '43', '0', '0', '19', '115', '243', '1', '0', '50344', '50345'),
('5508', '25', '0', '0', '45', '272', '272', '5', '0', '50348', '50404'),
('5509', '20', '0', '0', '82', '340', '556', '7', '0', '50366', '50419'),
('5510', '20', '0', '0', '29', '4', '110', '1', '0', '50373', '50376'),
('5511', '17', '0', '0', '79', '48', '10', '9', '0', '50386', '50414'),
('5512', '20', '0', '0', '17', '340', '340', '0', '0', '50393', '50393'),
('5513', '51', '0', '0', '7', '48', '48', '2', '0', '50409', '50415'),
('5514', '24', '0', '0', '74', '33', '33', '5', '0', '50411', '50572'),
('5515', '17', '0', '0', '67', '33', '33', '3', '0', '50412', '50545'),
('5516', '18', '0', '0', '533', '15', '15', '33', '0', '50423', '50630'),
('5517', '20', '0', '0', '101', '183', '4', '12', '0', '50428', '50680'),
('5518', '18', '0', '0', '44', '229', '229', '0', '0', '50439', '50439'),
('5519', '18', '0', '0', '126', '198', '198', '7', '0', '50443', '50471'),
('5520', '14', '0', '0', '54', '198', '110', '4', '0', '50452', '50463'),
('5521', '18', '0', '0', '100', '4', '329', '3', '0', '50464', '50515'),
('5522', '34', '0', '0', '175', '30', '229', '20', '0', '50475', '50893'),
('5523', '18', '0', '0', '454', '13', '136', '34', '0', '50484', '50830'),
('5524', '18', '0', '0', '147', '6', '4', '10', '0', '50490', '50549'),
('5525', '50', '0', '0', '19', '4', '6', '2', '0', '50496', '50522'),
('5526', '18', '0', '0', '468', '54', '13', '31', '0', '50499', '50713'),
('5527', '18', '0', '0', '85', '76', '229', '7', '0', '50506', '50531'),
('5528', '25', '0', '0', '44', '15', '356', '1', '0', '50513', '50589'),
('5529', '20', '0', '0', '48', '183', '6', '1', '0', '50526', '50540'),
('5530', '18', '0', '0', '42', '15', '110', '1', '0', '50528', '50529'),
('5531', '56', '0', '0', '94', '248', '248', '0', '0', '50537', '50537'),
('5532', '18', '0', '0', '34', '168', '168', '0', '0', '50577', '50577'),
('5533', '13', '0', '0', '81', '48', '76', '9', '0', '50580', '50602'),
('5534', '25', '0', '0', '113', '33', '556', '8', '0', '50592', '50778'),
('5535', '18', '0', '0', '52', '30', '229', '4', '0', '50608', '50616'),
('5536', '18', '0', '0', '68', '30', '110', '5', '0', '50612', '50622'),
('5537', '48', '0', '0', '170', '39', '39', '18', '0', '50617', '50708'),
('5538', '56', '0', '0', '145', '248', '248', '0', '0', '50628', '50628'),
('5539', '18', '0', '0', '105', '213', '183', '7', '0', '50640', '50749'),
('5540', '18', '0', '0', '67', '340', '229', '2', '0', '50646', '50669'),
('5541', '43', '0', '0', '48', '198', '183', '3', '0', '50653', '50748'),
('5542', '23', '0', '0', '24', '65', '50', '1', '0', '50671', '50678'),
('5543', '23', '0', '0', '27', '76', '48', '2', '0', '50673', '50681'),
('5544', '57', '0', '0', '76', '13', '205', '18', '0', '50683', '51033'),
('5545', '29', '0', '0', '45', '198', '556', '3', '0', '50715', '50770'),
('5546', '24', '0', '0', '107', '102', '664', '11', '0', '50716', '50869'),
('5547', '57', '0', '0', '16', '48', '4', '3', '0', '50719', '50763'),
('5548', '18', '0', '0', '373', '33', '33', '28', '0', '50725', '51060'),
('5549', '25', '0', '0', '51', '33', '664', '6', '0', '50731', '50802'),
('5550', '18', '1', '69', '1249', '229', '50', '91', '0', '50739', '51065'),
('5551', '37', '0', '0', '32', '213', '213', '3', '0', '50758', '50812'),
('5552', '15', '0', '0', '20', '110', '46', '1', '0', '50761', '50772'),
('5553', '13', '0', '0', '15', '10', '10', '0', '0', '50785', '50785'),
('5554', '31', '0', '0', '27', '4', '221', '2', '0', '50790', '50803'),
('5555', '31', '0', '0', '47', '221', '632', '4', '0', '50806', '50833'),
('5556', '20', '0', '0', '300', '10', '10', '29', '0', '50807', '50975'),
('5557', '27', '0', '0', '85', '340', '4', '7', '0', '50808', '51053'),
('5558', '20', '0', '0', '106', '356', '356', '9', '0', '50842', '51074'),
('5559', '14', '0', '0', '65', '54', '556', '9', '0', '50846', '51037'),
('5560', '25', '0', '0', '35', '33', '556', '4', '0', '50854', '50886'),
('5561', '18', '0', '0', '64', '213', '651', '8', '0', '50867', '50909'),
('5562', '13', '0', '0', '49', '53', '254', '2', '0', '50924', '50935'),
('5563', '33', '0', '0', '75', '13', '183', '7', '0', '50933', '50971'),
('5564', '33', '0', '0', '17', '13', '13', '0', '0', '50936', '50936'),
('5565', '21', '0', '0', '34', '13', '13', '1', '0', '50943', '50945'),
('5566', '12', '0', '0', '32', '48', '184', '1', '0', '50946', '50963'),
('5567', '25', '0', '0', '122', '43', '54', '11', '0', '50947', '51080'),
('5568', '25', '0', '0', '34', '272', '183', '6', '0', '50957', '50972'),
('5569', '25', '0', '0', '13', '48', '48', '0', '0', '50974', '50974'),
('5570', '18', '0', '0', '40', '340', '15', '2', '0', '50977', '50983'),
('5571', '18', '0', '0', '113', '213', '213', '6', '0', '50981', '51022'),
('5572', '20', '0', '0', '40', '110', '39', '3', '0', '50997', '51008'),
('5573', '13', '1', '0', '81', '556', '10', '8', '0', '51024', '51057'),
('5574', '25', '0', '0', '21', '556', '556', '0', '0', '51039', '51039'),
('5575', '15', '0', '0', '19', '556', '110', '1', '0', '51058', '51061'),
('5576', '14', '0', '0', '20', '74', '74', '0', '0', '51059', '51059'),
('5577', '20', '0', '0', '29', '689', '13', '1', '0', '51062', '51064'),
('5578', '18', '0', '0', '36', '340', '110', '3', '0', '51069', '51078'),
('5579', '33', '0', '0', '13', '10', '10', '0', '0', '51072', '51072'),
('5580', '31', '0', '0', '16', '340', '340', '2', '0', '51075', '51079'),
('5581', '37', '0', '0', '2', '226', '226', '0', '0', '51083', '51083');
Caused the error:

Duplicate entry '5326' for key 1

I have a blank forum I removed the installed forum section before attempting the conversion and it didnt help.

Offline mcapote

  • Newbie
  • *
  • Posts: 7
Re: converting topics unsuccessful
« Reply #1 on: February 11, 2008, 03:41:05 PM »
figured it out, should make note that you do not need to hit continue like the installer states when converting a big forum, when I hit the continue button it tried to install the same thing twice, you just leave it and it auto refreshes to contuinue installing your topics 1k at a time.