Ir para conteúdo
Fórum Script Brasil
  • 0

Problemas na conversão de banco


tectec

Pergunta

Olá pessoal

Eu tenho um fórum PHPbb2,e estou fazendo uma conversão do banco de dados para o SMF

Aqui vai o link do qual estou me auxiliando:

http://www.cms-pt.com/forum/showthread.php?t=1704

Fiz tudo certinho,se que nas tabelas dos tópicos eu não consigo obter sucesso

Abaixo segue o erro apresentado:

Converting...

Converting members... Successful.

Converting additional member groups... Successful.

Converting categories... Successful.

Converting boards... Successful.

Converting topics... Unsuccessful!

This query:

INSERT INTO `forcehac_SMF32`.forceha_topics

(ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)

VALUES ('572', '0', '1505', '4018', '46', '658', '9', '', '0', '10', '250'),

('573', '0', '1508', '1508', '46', '46', '9', '', '0', '0', '149'),

('574', '0', '1512', '1527', '46', '2', '9', '', '0', '1', '52'),

('575', '0', '1514', '1534', '46', '108', '9', '', '0', '3', '186'),

('576', '0', '1515', '1696', '46', '46', '9', '', '0', '3', '76'),

('577', '0', '1517', '1517', '46', '46', '9', '', '0', '0', '77'),

('578', '0', '1520', '7178', '46', '1411', '9', '', '0', '4', '172'),

('579', '0', '1521', '1521', '46', '46', '9', '', '0', '0', '72'),

('580', '0', '1522', '28255', '46', '922', '9', '', '0', '2', '241'),

('581', '0', '1523', '1573', '46', '46', '9', '', '0', '2', '49'),

('582', '0', '1524', '1524', '46', '46', '9', '', '0', '0', '177'),

('583', '0', '1539', '1539', '2', '2', '5', '', '0', '0', '170'),

('584', '0', '1542', '2829', '108', '312', '34', '', '0', '1', '81'),

('585', '0', '1544', '21130', '434', '1998', '17', '', '0', '12', '229'),

('586', '0', '1545', '18470', '434', '705', '17', '', '0', '1', '57'),

('587', '0', '1547', '5692', '434', '917', '17', '', '0', '2', '121'),

('588', '1', '1549', '21709', '46', '1744', '39', '', '0', '27', '358'),

('589', '0', '1556', '2400', '434', '208', '17', '', '0', '1', '55'),

('591', '0', '1562', '1562', '434', '434', '35', '', '0', '0', '18'),

('593', '0', '1569', '1570', '191', '2', '28', '', '0', '1', '62'),

('594', '0', '1576', '1909', '2', '208', '21', '', '0', '2', '440'),

('595', '0', '1580', '1699', '108', '197', '45', '', '0', '1', '13'),

('597', '0', '1588', '2278', '434', '46', '12', '', '0', '8', '261'),

('598', '0', '1591', '1591', '434', '434', '20', '', '0', '0', '10'),

('599', '0', '1596', '2802', '434', '104', '20', '', '0', '5', '62'),

('600', '0', '1599', '1599', '434', '434', '20', '', '0', '0', '30'),

('601', '0', '1600', '1600', '312', '312', '39', '', '0', '0', '56'),

('602', '0', '1603', '3666', '31', '792', '15', '', '0', '2', '132'),

('603', '0', '1604', '3664', '46', '792', '12', '', '0', '9', '126'),

('604', '0', '1613', '1613', '31', '31', '8', '', '1', '0', '300'),

('605', '0', '1614', '1614', '31', '31', '10', '', '1', '0', '129'),

('606', '0', '1615', '1615', '31', '31', '12', '', '1', '0', '197'),

('607', '0', '1616', '1616', '31', '31', '13', '', '1', '0', '170'),

('608', '0', '1617', '1617', '31', '31', '24', '', '1', '0', '31'),

('609', '0', '565', '1623', '108', '31', '8', '', '0', '1', '21'),

('610', '0', '890', '1629', '208', '31', '8', '', '0', '2', '14'),

('611', '0', '869', '1631', '208', '31', '8', '', '0', '3', '20'),

('612', '0', '566', '1632', '108', '31', '8', '', '0', '1', '25'),

('613', '0', '868', '1636', '208', '31', '8', '', '0', '2', '16'),

('614', '0', '686', '1644', '108', '31', '12', '', '0', '8', '62'),

('615', '0', '1645', '1754', '108', '31', '9', '', '0', '6', '148'),

('616', '0', '190', '220', '31', '67', '10', '', '0', '2', '118'),

('617', '0', '631', '1652', '2', '31', '10', '', '0', '6', '75'),

('618', '0', '12', '1653', '2', '31', '10', '', '0', '7', '130'),

('619', '0', '572', '1656', '108', '31', '11', '', '0', '1', '14'),

('620', '0', '11', '1657', '2', '31', '24', '', '0', '1', '7'),

('623', '0', '392', '1667', '2', '31', '24', '', '0', '1', '8'),

('624', '0', '1109', '1669', '208', '31', '25', '', '0', '1', '3'),

('625', '0', '1678', '17531', '434', '2', '12', '', '0', '8', '174'),

('626', '0', '1679', '1679', '2', '2', '39', '', '0', '0', '39'),

('627', '0', '1680', '1680', '2', '2', '39', '', '0', '0', '21'),

('628', '0', '1681', '1681', '2', '2', '39', '', '0', '0', '37'),

('629', '0', '1682', '1682', '2', '2', '39', '', '0', '0', '49'),

('630', '0', '1683', '1683', '2', '2', '39', '', '0', '0', '27'),

('631', '0', '1684', '1697', '2', '31', '39', '', '0', '1', '57'),

('632', '0', '1686', '1693', '2', '46', '39', '', '0', '3', '77'),

('633', '0', '1689', '1776', '2', '40', '28', '', '0', '1', '36'),

('634', '0', '1692', '1730', '46', '312', '10', '', '0', '2', '147'),

('635', '1', '1694', '30484', '2', '4924', '8', '', '0', '23', '504'),

('636', '0', '570', '1698', '108', '31', '42', '', '0', '2', '20'),

('637', '0', '1700', '4727', '2', '2', '39', '', '1', '35', '422'),

('638', '0', '1706', '1729', '431', '2', '10', '', '0', '5', '96'),

('639', '0', '1708', '15176', '431', '312', '26', '', '0', '5', '88'),

('641', '0', '1720', '22489', '431', '2908', '31', '', '0', '7', '63'),

('642', '0', '1722', '7409', '108', '40', '9', '', '0', '6', '137'),

('643', '0', '1735', '1749', '431', '312', '30', '', '0', '2', '26'),

('644', '0', '1741', '1838', '46', '357', '43', '', '0', '5', '24'),

('645', '0', '1742', '10267', '46', '312', '43', '', '0', '7', '35'),

('646', '0', '1743', '10233', '46', '705', '43', '', '0', '4', '30'),

('647', '0', '1758', '1759', '431', '46', '30', '', '0', '1', '17'),

('648', '0', '1764', '1766', '431', '46', '30', '', '0', '1', '18'),

('649', '0', '1769', '1960', '431', '208', '30', '', '0', '2', '29'),

('650', '0', '1770', '3013', '197', '705', '10', '', '0', '20', '302'),

('652', '0', '1780', '9891', '108', '2205', '28', '', '0', '7', '108'),

('653', '0', '1781', '6940', '364', '1316', '14', '', '0', '7', '209'),

('654', '0', '1785', '30476', '69', '6619', '9', '', '0', '30', '2078'),

('655', '0', '1786', '25246', '434', '3906', '20', '', '0', '11', '201'),

('656', '0', '1787', '24193', '434', '4416', '20', '', '0', '5', '63'),

('657', '0', '1788', '13557', '434', '2439', '20', '', '0', '2', '33'),

('658', '0', '1790', '13148', '434', '2844', '20', '', '0', '5', '104'),

('659', '0', '1791', '12887', '434', '2735', '20', '', '0', '1', '20'),

('660', '0', '1797', '1797', '2', '2', '31', '', '0', '0', '45'),

('661', '0', '1799', '1799', '2', '2', '17', '', '0', '0', '36'),

('662', '0', '1800', '1800', '2', '2', '31', '', '0', '0', '15'),

('663', '0', '1801', '26745', '2', '4416', '30', '', '0', '6', '74'),

('664', '0', '1802', '14240', '2', '2975', '49', '', '0', '19', '547'),

('666', '0', '1832', '1832', '2', '2', '36', '', '0', '0', '18'),

('668', '0', '1844', '1880', '2', '46', '36', '', '0', '1', '24'),

('669', '0', '1845', '1846', '108', '2', '8', '', '0', '1', '36'),

('671', '0', '1848', '1994', '431', '2', '10', '', '0', '4', '113'),

('672', '0', '1863', '1874', '431', '312', '26', '', '0', '1', '27'),

('673', '0', '1877', '7064', '431', '312', '10', '', '1', '20', '512'),

('674', '0', '1878', '1878', '431', '431', '30', '', '0', '0', '18'),

('675', '0', '1895', '9036', '312', '357', '43', '', '0', '3', '23'),

('676', '0', '1897', '1906', '431', '208', '10', '', '0', '3', '125'),

('679', '0', '1911', '2672', '535', '2', '18', '', '0', '7', '169'),

('680', '0', '1914', '22650', '2', '619', '28', '', '0', '21', '345'),

('681', '0', '1916', '21795', '2', '357', '43', '', '0', '5', '45'),

('682', '0', '1920', '1920', '448', '448', '29', '', '0', '0', '5'),

('683', '0', '1921', '1921', '448', '448', '29', '', '0', '0', '49'),

('684', '0', '1922', '1922', '448', '448', '29', '', '0', '0', '7'),

('685', '0', '1923', '1923', '448', '448', '29', '', '0', '0', '10'),

('686', '0', '1924', '3554', '448', '208', '29', '', '0', '1', '17'),

('687', '0', '1925', '1925', '448', '448', '29', '', '0', '0', '7'),

('688', '0', '1926', '3610', '448', '658', '29', '', '0', '9', '56'),

('689', '0', '1927', '1927', '448', '448', '29', '', '0', '0', '11'),

('690', '0', '1928', '1928', '448', '448', '29', '', '0', '0', '6'),

('691', '0', '1929', '1929', '448', '448', '29', '', '0', '0', '25'),

('692', '0', '1930', '1931', '448', '2', '8', '', '0', '1', '57'),

('693', '0', '1932', '29579', '448', '6040', '8', '', '0', '3', '183'),

('694', '1', '1933', '13574', '448', '574', '15', '', '0', '9', '328'),

('695', '0', '1934', '5224', '448', '917', '8', '', '0', '4', '121'),

('696', '0', '1935', '1935', '448', '448', '8', '', '0', '0', '24'),

('697', '0', '1936', '1936', '448', '448', '8', '', '0', '0', '30'),

('698', '0', '1937', '1937', '448', '448', '8', '', '0', '0', '22'),

('699', '0', '1938', '1938', '448', '448', '8', '', '0', '0', '35'),

('700', '0', '1939', '1939', '448', '448', '8', '', '0', '0', '28'),

('701', '0', '1940', '1940', '448', '448', '8', '', '0', '0', '30'),

('702', '0', '1941', '2045', '431', '2', '30', '', '0', '1', '23'),

('703', '0', '1942', '15714', '448', '1117', '8', '', '0', '6', '105'),

('704', '0', '1943', '1976', '448', '208', '20', '', '0', '3', '56'),

('705', '0', '1944', '22247', '448', '4927', '20', '', '0', '3', '72'),

('706', '0', '1945', '1945', '448', '448', '20', '', '0', '0', '9'),

('707', '0', '1947', '2399', '448', '208', '41', '', '0', '2', '62'),

('708', '0', '1956', '1990', '431', '431', '26', '', '0', '2', '22'),

('709', '0', '1977', '4212', '208', '40', '10', '', '0', '14', '382'),

('711', '0', '1988', '1988', '40', '40', '28', '', '0', '0', '35'),

('712', '0', '1991', '2367', '431', '423', '31', '', '0', '1', '22'),

('713', '0', '1995', '1995', '545', '545', '8', '', '0', '0', '26'),

('714', '0', '1996', '2027', '545', '2', '8', '', '0', '1', '44'),

('715', '0', '2001', '2077', '363', '208', '10', '', '0', '3', '104'),

('716', '0', '2005', '2005', '363', '363', '20', '', '0', '0', '14'),

('717', '1', '2009', '28479', '2', '4150', '11', '', '0', '209', '11925'),

('718', '0', '2013', '2013', '2', '2', '28', '', '0', '0', '38'),

('719', '0', '1933', '2023', '448', '31', '8', '', '0', '1', '7'),

('720', '0', '2026', '22555', '108', '5019', '13', '', '0', '19', '572'),

('721', '0', '2029', '2087', '431', '208', '24', '', '0', '3', '40'),

('722', '0', '2032', '2426', '431', '208', '26', '', '0', '1', '37'),

('723', '0', '2033', '3551', '431', '208', '24', '', '0', '5', '41'),

('724', '0', '2034', '5127', '431', '588', '10', '', '0', '13', '344'),

('725', '0', '2043', '2555', '431', '431', '30', '', '0', '3', '41'),

('726', '0', '2063', '2119', '46', '312', '30', '', '0', '8', '39'),

('728', '0', '2098', '5278', '108', '251', '34', '', '0', '8', '117'),

('729', '0', '2098', '2100', '108', '31', '8', '', '0', '2', '13'),

('730', '0', '2107', '2186', '431', '2', '26', '', '0', '4', '41'),

('731', '0', '2114', '2226', '108', '31', '45', '', '0', '5', '46'),

('732', '0', '2108', '2115', '564', '31', '64', '', '1', '1', '84'),

('733', '1', '2117', '21925', '312', '2', '8', '', '0', '21', '1254'),

('734', '0', '2120', '2129', '431', '46', '8', '', '0', '1', '42'),

('735', '0', '2122', '2158', '431', '208', '25', '', '0', '5', '34'),

('738', '0', '2138', '2141', '431', '2', '26', '', '0', '1', '23'),

('740', '0', '2156', '18723', '2', '4089', '10', '', '0', '44', '1827'),

('741', '0', '2164', '5228', '2', '233', '12', '', '0', '2', '126'),

('742', '0', '2169', '2617', '46', '2', '39', '', '0', '9', '157'),

('743', '0', '2179', '2427', '431', '208', '31', '', '0', '1', '15'),

('745', '0', '2195', '3974', '431', '658', '11', '', '0', '5', '95'),

('746', '0', '2196', '2386', '431', '208', '11', '', '0', '3', '28'),

('747', '0', '2206', '3267', '365', '251', '12', '', '0', '12', '88'),

('748', '0', '2207', '2260', '197', '108', '45', '', '0', '1', '10'),

('749', '0', '2214', '2395', '143', '208', '42', '', '0', '1', '104'),

('751', '0', '2239', '2383', '431', '208', '8', '', '0', '7', '72'),

('752', '0', '2246', '2330', '619', '619', '22', '', '0', '4', '37'),

('753', '0', '2253', '2315', '2', '598', '28', '', '0', '3', '54'),

('755', '1', '2262', '23470', '108', '-1', '15', '', '0', '13', '2366'),

('756', '0', '2263', '4003', '108', '40', '9', '', '0', '2', '91'),

('758', '0', '2267', '2280', '108', '46', '39', '', '0', '3', '180'),

('759', '0', '2271', '2271', '2', '2', '34', '', '0', '0', '16'),

('761', '0', '2287', '2403', '431', '208', '25', '', '0', '2', '52'),

('762', '0', '2311', '2327', '598', '598', '30', '', '0', '2', '25'),

('763', '0', '2317', '2317', '598', '598', '17', '', '0', '0', '46'),

('764', '0', '2334', '2749', '619', '312', '31', '', '0', '6', '41'),

('766', '0', '2338', '2338', '619', '619', '22', '', '0', '0', '10'),

('767', '0', '2355', '5641', '40', '728', '12', '', '0', '15', '150'),

('768', '0', '2371', '14937', '619', '2831', '7', '', '0', '8', '220'),

('769', '0', '2372', '4797', '619', '904', '14', '', '0', '5', '166'),

('770', '0', '2382', '25343', '46', '5586', '10', '', '0', '22', '1350'),

('774', '0', '2430', '2554', '20', '312', '10', '', '0', '7', '116'),

('776', '0', '2435', '6494', '208', '208', '41', '', '0', '5', '96'),

('778', '1', '2442', '27162', '2', '3610', '7', '', '0', '47', '1628'),

('779', '0', '2455', '5325', '645', '963', '42', '', '0', '1', '250'),

('780', '0', '2469', '2644', '2', '208', '17', '', '0', '2', '133'),

('781', '0', '2480', '3206', '645', '728', '8', '', '0', '4', '138'),

('782', '0', '2482', '5631', '645', '312', '13', '', '1', '7', '262'),

('786', '0', '2502', '2502', '312', '312', '13', '', '0', '0', '75'),

('788', '1', '2504', '2520', '312', '31', '43', '', '0', '1', '18'),

('789', '0', '2509', '2827', '431', '312', '41', '', '0', '1', '47'),

('790', '0', '2510', '29878', '431', '2054', '41', '', '0', '5', '75'),

('791', '0', '2511', '2825', '431', '312', '41', '', '0', '4', '91'),

('792', '0', '2262', '2518', '108', '31', '8', '', '0', '5', '32'),

('793', '0', '2533', '8987', '363', '837', '10', '', '0', '13', '205'),

('794', '0', '2564', '2653', '619', '619', '34', '', '0', '2', '61'),

('795', '0', '2565', '15032', '619', '619', '34', '', '0', '10', '134'),

('796', '0', '2571', '11307', '294', '2352', '22', '', '0', '14', '357'),

('797', '0', '2572', '2647', '431', '208', '25', '', '0', '2', '23'),

('799', '0', '2599', '10441', '239', '1744', '9', '', '0', '16', '490'),

('800', '1', '2600', '30485', '239', '6047', '10', '', '0', '26', '2776'),

('802', '0', '2623', '5796', '2', '31', '12', '', '0', '28', '287'),

('803', '0', '2629', '2780', '229', '229', '30', '', '0', '3', '24'),

('804', '0', '2646', '2688', '431', '312', '10', '', '0', '4', '110'),

('805', '0', '2655', '2678', '645', '645', '8', '', '0', '2', '76'),

('806', '0', '2656', '3302', '645', '645', '8', '', '0', '5', '101'),

('807', '0', '2658', '2658', '645', '645', '8', '', '0', '0', '19'),

('808', '0', '2659', '3388', '645', '208', '8', '', '0', '4', '106'),

('809', '0', '2660', '3261', '645', '251', '8', '', '0', '1', '60'),

('810', '0', '2661', '2681', '645', '2', '34', '', '0', '1', '10'),

('811', '0', '2663', '2799', '645', '229', '34', '', '0', '2', '23'),

('812', '0', '2664', '2664', '645', '645', '34', '', '0', '0', '22'),

('813', '0', '2665', '2665', '645', '645', '34', '', '0', '0', '9'),

('814', '0', '2666', '2666', '645', '645', '34', '', '0', '0', '11'),

('815', '0', '2667', '2667', '645', '645', '34', '', '0', '0', '14'),

('816', '0', '2668', '2668', '645', '645', '8', '', '0', '0', '23'),

('817', '0', '2670', '3343', '619', '83', '35', '', '0', '4', '36'),

('818', '0', '2676', '3593', '645', '645', '8', '', '0', '3', '92'),

('819', '0', '2677', '8857', '645', '357', '8', '', '0', '17', '478'),

('820', '0', '2685', '3547', '619', '229', '35', '', '0', '3', '51'),

('821', '0', '2689', '5945', '208', '658', '10', '', '0', '24', '643'),

('822', '0', '2690', '2810', '645', '378', '8', '', '0', '2', '46'),

('823', '0', '2693', '3301', '645', '645', '8', '', '0', '4', '59'),

('824', '0', '2694', '17996', '645', '357', '10', '', '0', '5', '488'),

('825', '0', '2696', '4437', '645', '917', '8', '', '0', '10', '202'),

('826', '0', '2699', '17435', '645', '3845', '12', '', '0', '12', '529'),

('829', '0', '2699', '2707', '645', '312', '13', '', '0', '1', '8'),

('831', '0', '2727', '4190', '108', '208', '9', '', '0', '6', '101'),

('832', '0', '2736', '2847', '423', '2', '10', '', '0', '6', '153'),

('833', '0', '2694', '2745', '645', '312', '13', '', '0', '1', '20'),

('835', '0', '2769', '2769', '2', '2', '35', '', '0', '0', '10'),

('836', '0', '2770', '2770', '2', '2', '35', '', '0', '0', '31'),

('837', '0', '2771', '2771', '2', '2', '25', '', '0', '0', '24'),

('838', '0', '2772', '6144', '2', '251', '25', '', '0', '1', '33'),

('839', '0', '2773', '15929', '2', '251', '34', '', '0', '5', '130'),

('840', '0', '2774', '2811', '2', '46', '9', '', '0', '8', '151'),

('841', '0', '2782', '2786', '312', '2', '8', '', '0', '1', '57'),

('842', '0', '2790', '3083', '2', '229', '35', '', '0', '5', '46'),

('843', '0', '2798', '2910', '365', '208', '31', '', '0', '1', '18'),

('844', '0', '2809', '7568', '378', '673', '25', '', '0', '2', '40'),

('845', '0', '2812', '2914', '46', '46', '30', '', '0', '16', '80'),

('846', '0', '2511', '2825', '431', '312', '26', '', '0', '4', '18'),

('847', '0', '2510', '2826', '431', '312', '26', '', '0', '4', '14'),

('848', '0', '2509', '2827', '431', '312', '26', '', '0', '1', '5'),

('849', '0', '1542', '1542', '108', '108', '26', '', '0', '0', '10'),

('851', '0', '2851', '8277', '2', '357', '46', '', '0', '6', '109'),

('852', '0', '2865', '3881', '229', '312', '26', '', '0', '4', '72'),

('854', '0', '2878', '15723', '229', '1387', '40', '', '0', '15', '564'),

('858', '0', '2912', '3614', '658', '658', '64', '', '1', '19', '495'),

('859', '0', '2927', '2990', '365', '208', '64', '', '1', '2', '63'),

('861', '0', '2958', '29124', '229', '619', '34', '', '0', '2', '34'),

('862', '0', '2959', '3023', '229', '229', '34', '', '0', '3', '30'),

('863', '0', '2960', '15869', '229', '3042', '34', '', '0', '5', '43'),

('864', '0', '2961', '2961', '229', '229', '34', '', '0', '0', '9'),

('865', '0', '2962', '21609', '229', '4686', '31', '', '0', '7', '133'),

('867', '0', '2964', '10507', '688', '2393', '36', '', '0', '6', '143'),

('870', '0', '2983', '2999', '312', '312', '36', '', '0', '2', '19'),

('873', '0', '3021', '4231', '312', '312', '10', '', '1', '17', '268'),

('874', '0', '3027', '11752', '705', '24', '10', '', '0', '20', '356'),

('878', '0', '3074', '4063', '747', '423', '9', '', '0', '9', '90'),

('879', '0', '3097', '3311', '740', '229', '8', '', '0', '2', '64'),

('880', '0', '3099', '29125', '229', '619', '2', '3', '0', '14', '251'),

('882', '0', '3108', '3635', '756', '40', '28', '', '0', '1', '69'),

('884', '0', '3118', '3402', '83', '208', '12', '', '0', '5', '49'),

('885', '0', '3119', '4799', '645', '963', '11', '', '0', '3', '96'),

('886', '0', '3128', '3159', '83', '312', '42', '', '0', '2', '284'),

('890', '0', '3137', '3151', '229', '229', '34', '', '0', '2', '45'),

('892', '0', '3163', '3163', '645', '645', '41', '', '0', '0', '49'),

('894', '0', '3172', '8474', '728', '588', '8', '', '0', '15', '208'),

('898', '0', '3227', '8088', '658', '312', '30', '', '0', '16', '55'),

('900', '0', '3241', '19603', '448', '4196', '10', '', '0', '58', '1845'),

('902', '0', '3244', '3975', '765', '658', '11', '', '0', '8', '138'),

('904', '1', '3262', '6280', '251', '31', '24', '', '0', '5', '57'),

('905', '0', '3263', '3263', '251', '251', '25', '', '0', '0', '20'),

('906', '0', '3264', '3308', '251', '31', '29', '', '0', '1', '24'),

('907', '0', '3265', '3265', '251', '251', '34', '', '0', '0', '20'),

('908', '0', '3266', '3266', '251', '251', '34', '', '0', '0', '40'),

('909', '1', '3271', '3482', '251', '312', '26', '', '0', '3', '79'),

('910', '0', '3272', '3275', '251', '2', '25', '', '0', '1', '17'),

('911', '0', '3284', '6097', '2', '229', '12', '', '0', '28', '416'),

('913', '0', '3286', '3453', '744', '2', '64', '', '1', '8', '141'),

('915', '0', '3300', '4925', '645', '251', '10', '', '0', '7', '180'),

('916', '0', '3314', '3314', '645', '645', '34', '', '0', '0', '12'),

('917', '0', '3318', '3963', '645', '423', '34', '', '0', '3', '35'),

('918', '0', '3321', '3321', '645', '645', '34', '', '0', '0', '9'),

('921', '0', '3325', '3325', '645', '645', '34', '', '0', '0', '16'),

('924', '0', '3363', '15327', '658', '2', '30', '', '0', '15', '104'),

('925', '0', '3366', '24443', '645', '1582', '17', '', '0', '17', '431'),

('926', '0', '3374', '3755', '20', '208', '31', '', '0', '8', '55'),

('927', '0', '3411', '11343', '208', '922', '19', '', '0', '25', '566'),

('930', '1', '3473', '8566', '448', '861', '10', '', '0', '12', '1050'),

('931', '0', '3474', '3476', '448', '229', '10', '', '0', '1', '90'),

('933', '1', '3499', '14820', '312', '378', '30', '', '0', '12', '355'),

('934', '1', '3500', '22315', '658', '357', '31', '', '0', '20', '177'),

('938', '0', '3519', '3699', '2', '2', '13', '', '0', '5', '218'),

('939', '0', '3545', '25912', '229', '229', '35', '', '0', '15', '149'),

('942', '0', '3607', '3980', '658', '658', '8', '', '0', '4', '53'),

('944', '1', '3626', '27344', '31', '251', '50', '', '0', '13', '68'),

('945', '0', '3654', '3763', '792', '40', '8', '', '0', '3', '121'),

('946', '0', '3656', '4824', '705', '229', '10', '', '0', '16', '510'),

('947', '0', '3668', '3672', '251', '251', '41', '', '0', '2', '39'),

('948', '0', '3673', '4610', '251', '208', '41', '', '0', '5', '93'),

('949', '0', '3675', '10075', '645', '739', '25', '', '0', '2', '33'),

('950', '0', '3678', '3754', '645', '208', '25', '', '0', '1', '23'),

('951', '0', '3683', '3765', '645', '229', '8', '', '0', '3', '59'),

('954', '0', '3710', '18249', '312', '819', '12', '', '0', '13', '420'),

('957', '0', '3715', '17753', '2', '1823', '22', '', '0', '5', '53'),

('958', '0', '3716', '4029', '2', '423', '9', '', '0', '11', '214'),

('959', '0', '3719', '17559', '2', '948', '42', '', '0', '7', '257'),

('960', '0', '3720', '9347', '2', '588', '36', '', '0', '8', '143'),

('961', '0', '3723', '3955', '2', '658', '9', '', '0', '1', '93'),

('963', '0', '3728', '30375', '2', '2237', '19', '', '0', '8', '288'),

('964', '0', '3739', '13948', '431', '2884', '26', '', '0', '6', '76'),

('966', '0', '3776', '4486', '2', '372', '12', '4', '0', '16', '112'),

('967', '0', '3787', '3787', '229', '229', '13', '', '0', '0', '74'),

('970', '0', '3794', '14676', '365', '3028', '31', '', '0', '9', '141'),

('974', '0', '3831', '3831', '31', '31', '45', '', '0', '0', '4'),

('975', '0', '3832', '11249', '658', '2449', '11', '', '0', '15', '806'),

('976', '0', '3838', '3838', '312', '312', '54', '', '0', '0', '115'),

('977', '0', '1802', '2095', '2', '312', '13', '', '0', '10', '54'),

('979', '0', '3841', '10231', '312', '705', '43', '', '0', '5', '28'),

('980', '0', '3845', '3845', '814', '814', '17', '', '0', '0', '59'),

('982', '0', '3853', '3880', '708', '312', '26', '', '0', '1', '30'),

('984', '0', '3859', '8917', '645', '658', '8', '', '0', '7', '207'),

('985', '0', '3860', '5080', '645', '588', '8', '', '0', '5', '147'),

('988', '0', '3870', '3991', '740', '40', '10', '', '1', '14', '150'),

('989', '0', '3853', '3880', '708', '312', '41', '', '0', '1', '8'),

('990', '0', '2865', '3881', '229', '312', '41', '', '0', '4', '22'),

('992', '0', '3906', '15121', '2', '3042', '8', '', '0', '7', '173'),

('1002', '0', '4028', '4041', '20', '229', '29', '', '0', '1', '23'),

('1003', '0', '4031', '29046', '645', '4150', '8', '', '0', '10', '705'),

('1004', '0', '4033', '8901', '645', '1820', '12', '', '0', '6', '254'),

('1005', '0', '4034', '4363', '645', '229', '12', '', '0', '5', '104'),

('1006', '0', '4035', '4047', '740', '31', '64', '', '1', '1', '72'),

('1008', '0', '4055', '4055', '229', '229', '21', '', '0', '0', '114'),

('1009', '0', '4056', '16380', '431', '3621', '19', '', '0', '1', '58'),

('1018', '0', '4110', '4160', '741', '702', '64', '', '1', '2', '101'),

('1019', '0', '4111', '23081', '2', '1888', '51', '', '0', '23', '190'),

('1021', '0', '4113', '8008', '312', '588', '37', '', '0', '6', '42'),

('1022', '0', '4120', '8662', '365', '357', '21', '', '0', '3', '146'),

('1023', '0', '4125', '24056', '2', '5310', '12', '', '0', '14', '446'),

('1024', '0', '4134', '4134', '431', '431', '34', '', '0', '0', '24'),

('1026', '0', '4158', '4192', '431', '312', '30', '', '0', '3', '37'),

('1030', '0', '4181', '29624', '40', '6282', '11', '', '0', '11', '560'),

('1031', '0', '4196', '16340', '208', '3621', '19', '', '0', '8', '195'),

('1032', '0', '4202', '4202', '776', '776', '11', '', '0', '0', '51'),

('1033', '0', '4213', '4959', '869', '588', '8', '', '0', '6', '149'),

('1035', '0', '4221', '4230', '869', '31', '64', '', '1', '1', '116'),

('1037', '0', '4240', '13405', '2', '2', '51', '', '0', '17', '161'),

('1038', '0', '4245', '4438', '40', '917', '12', '', '0', '5', '57'),

('1039', '0', '4248', '28738', '2', '5961', '20', '', '0', '10', '104'),

('1040', '1', '4249', '30371', '2', '819', '9', '', '0', '51', '2842'),

('1041', '0', '4254', '4299', '2', '2', '9', '', '0', '4', '221'),

('1042', '0', '4258', '12976', '2', '2469', '9', '', '0', '12', '493'),

('1043', '0', '4259', '4259', '2', '2', '9', '', '0', '0', '103'),

('1044', '0', '4260', '4260', '312', '312', '21', '', '0', '0', '179'),

('1045', '0', '4263', '4263', '2', '2', '9', '', '0', '0', '49'),

('1046', '0', '4264', '14042', '588', '2835', '9', '', '0', '24', '687'),

('1047', '0', '4267', '4271', '2', '229', '17', '', '0', '2', '111'),

('1048', '0', '4272', '4323', '765', '423', '8', '', '0', '1', '52'),

('1049', '1', '4296', '29804', '861', '3708', '10', '', '0', '37', '2527'),

('1050', '0', '4301', '19718', '2', '588', '40', '', '0', '11', '627'),

('1052', '0', '4309', '4756', '108', '312', '10', '', '1', '11', '197'),

('1053', '1', '4312', '30454', '312', '1285', '10', '', '0', '643', '15746'),

('1056', '0', '4341', '4341', '2', '2', '36', '', '0', '0', '29'),

('1057', '0', '4343', '4343', '2', '2', '36', '', '0', '0', '7'),

('1058', '0', '4344', '4344', '2', '2', '36', '', '0', '0', '45'),

('1061', '0', '4376', '4376', '251', '251', '41', '', '0', '0', '53'),

('1062', '0', '4377', '4463', '702', '702', '14', '', '0', '2', '70'),

('1064', '0', '4396', '4990', '423', '588', '64', '', '1', '4', '70'),

('1067', '0', '4425', '12346', '930', '46', '8', '', '0', '23', '426'),

('1068', '0', '4429', '5147', '2', '208', '10', '', '0', '14', '600'),

('1069', '0', '4431', '4445', '372', '917', '29', '', '0', '3', '36'),

('1070', '0', '4433', '4444', '856', '917', '11', '', '0', '1', '84'),

('1071', '1', '4439', '26285', '2', '4416', '10', '', '0', '24', '2304'),

('1072', '0', '4446', '13359', '2', '2', '40', '', '0', '4', '284'),

('1073', '0', '4447', '13268', '2', '2', '21', '', '0', '18', '1008'),

('1074', '1', '4449', '23145', '312', '312', '30', '', '0', '14', '239'),

('1075', '0', '4460', '4695', '2', '2', '12', '6', '1', '20', '279'),

('1076', '0', '4466', '7238', '925', '910', '11', '', '0', '4', '106'),

('1077', '0', '4468', '5267', '777', '917', '39', '', '0', '5', '135'),

('1078', '0', '4476', '4476', '924', '924', '26', '', '0', '0', '13'),

('1080', '0', '4479', '5732', '251', '1090', '12', '', '0', '2', '76'),

('1081', '0', '4482', '5241', '251', '2', '8', '', '0', '3', '174'),

('1082', '0', '4483', '4801', '251', '904', '8', '', '0', '10', '148'),

('1083', '0', '4484', '4502', '372', '312', '29', '', '0', '3', '25'),

('1084', '0', '4487', '4498', '924', '312', '26', '', '0', '1', '28'),

('1088', '0', '4516', '8608', '946', '585', '19', '', '0', '5', '299'),

('1089', '0', '4521', '4999', '449', '1006', '9', '', '0', '7', '175'),

('1090', '0', '4522', '6146', '449', '251', '9', '', '0', '6', '270'),

('1091', '0', '4532', '4606', '795', '208', '14', '', '0', '1', '417'),

('1093', '0', '4541', '16675', '2', '2817', '17', '', '0', '4', '116'),

('1094', '0', '4545', '11172', '2', '229', '37', '', '0', '4', '53'),

('1095', '0', '4547', '14639', '2', '2926', '41', '', '0', '14', '225'),

('1096', '0', '4551', '28928', '2', '5850', '11', '', '0', '11', '610'),

('1097', '0', '4557', '5131', '2', '588', '17', '', '0', '6', '172'),

('1098', '0', '4558', '4558', '2', '2', '39', '', '0', '0', '56'),

('1099', '0', '4559', '4714', '2', '40', '9', '', '0', '1', '88'),

('1100', '0', '4560', '8922', '2', '2044', '35', '', '0', '2', '45'),

('1101', '0', '4561', '9018', '2', '357', '9', '', '0', '4', '141'),

('1102', '0', '4562', '22020', '2', '2770', '35', '', '0', '6', '66'),

('1103', '0', '4564', '8693', '448', '357', '20', '', '0', '4', '69'),

('1104', '0', '4568', '15911', '2', '2975', '49', '', '0', '1', '84'),

('1105', '0', '4569', '5024', '2', '777', '42', '', '0', '2', '60'),

('1106', '0', '4570', '4583', '2', '312', '9', '', '0', '1', '56'),

('1108', '0', '4596', '8699', '312', '312', '36', '', '0', '3', '52'),

('1109', '0', '4597', '4638', '588', '841', '10', '', '0', '5', '109'),

('1111', '0', '4621', '27274', '448', '24', '37', '', '0', '17', '141'),

('1112', '0', '4623', '6430', '229', '1337', '42', '', '0', '7', '112'),

('1113', '0', '4632', '8025', '861', '1692', '10', '', '0', '22', '478'),

('1115', '0', '4662', '4788', '963', '208', '8', '', '0', '5', '57'),

('1116', '0', '4674', '25691', '841', '3715', '35', '', '0', '4', '410'),

('1117', '0', '4675', '4675', '841', '841', '35', '', '0', '0', '332'),

('1118', '1', '4696', '4696', '2', '2', '19', '', '0', '0', '172'),

('1119', '0', '4722', '4813', '449', '31', '9', '', '0', '2', '68'),

('1120', '0', '4728', '5334', '588', '658', '24', '', '0', '4', '48'),

('1122', '0', '4749', '4953', '925', '925', '30', '', '0', '5', '42'),

('1125', '0', '4762', '4802', '312', '423', '36', '', '0', '1', '33'),

('1126', '0', '4766', '5438', '312', '312', '41', '', '0', '4', '55'),

('1131', '0', '4819', '4893', '904', '932', '11', '', '0', '3', '112'),

('1132', '0', '4830', '6315', '861', '861', '14', '', '0', '14', '162'),

('1134', '0', '4854', '13118', '963', '1316', '7', '', '0', '21', '278'),

('1135', '0', '4860', '5739', '987', '619', '11', '', '0', '13', '144'),

('1137', '0', '4869', '4869', '2', '2', '39', '', '0', '0', '52'),

('1139', '0', '4877', '4933', '312', '841', '9', '', '0', '3', '111'),

('1140', '0', '4884', '4907', '431', '312', '28', '', '0', '2', '56'),

('1141', '0', '4887', '8658', '998', '357', '9', '', '0', '11', '421'),

('1142', '0', '4889', '11202', '312', '1744', '36', '', '0', '7', '81'),

('1145', '1', '4899', '4946', '312', '31', '30', '', '0', '2', '81'),

('1146', '1', '4901', '4922', '312', '2', '30', '', '0', '1', '98'),

('1148', '0', '4937', '4937', '2', '2', '36', '', '0', '0', '6'),

('1149', '0', '4940', '11052', '2', '1746', '36', '', '0', '3', '34'),

('1153', '1', '4977', '29367', '312', '312', '50', '', '0', '29', '116'),

('1157', '0', '5004', '5048', '658', '658', '9', '', '0', '5', '66'),

('1158', '0', '5005', '5005', '312', '312', '36', '', '0', '0', '5'),

('1159', '0', '5006', '5006', '312', '312', '36', '', '0', '0', '12'),

('1160', '0', '5008', '5092', '312', '251', '8', '', '0', '3', '46'),

('1162', '1', '5017', '5027', '312', '2', '26', '', '0', '2', '157'),

('1163', '0', '5025', '9497', '93', '2083', '12', '', '0', '13', '164'),

('1164', '0', '5034', '17540', '2', '1823', '37', '', '0', '2', '33'),

('1165', '0', '5041', '5051', '925', '312', '30', '', '0', '1', '35'),

('1167', '0', '5052', '5292', '992', '208', '8', '', '0', '5', '70'),

('1170', '0', '5069', '5139', '312', '208', '37', '', '0', '3', '42'),

('1171', '0', '5086', '5086', '372', '372', '19', '', '0', '0', '62'),

('1172', '0', '5099', '5099', '312', '312', '30', '', '0', '0', '20'),

('1173', '0', '5101', '5766', '588', '588', '26', '', '0', '6', '60'),

('1174', '0', '5103', '5645', '861', '861', '14', '', '0', '25', '176'),

('1177', '0', '5128', '5172', '588', '31', '20', '', '0', '2', '26'),

('1178', '0', '5149', '8296', '925', '925', '30', '', '0', '6', '96'),

('1179', '0', '5151', '5208', '372', '372', '27', '', '0', '2', '24'),

('1180', '0', '5164', '5164', '312', '312', '36', '', '0', '0', '7'),

('1181', '0', '5166', '5291', '312', '588', '36', '', '0', '3', '22'),

('1182', '0', '5167', '5304', '312', '312', '10', '', '1', '9', '134'),

('1183', '0', '5168', '11535', '312', '229', '13', '', '0', '7', '441'),

('1184', '1', '5204', '27138', '588', '1582', '10', '', '0', '26', '20789'),

('1186', '0', '5212', '28325', '588', '574', '46', '', '0', '29', '447'),

('1188', '0', '5244', '5283', '739', '739', '64', '', '1', '6', '119'),

('1189', '0', '5258', '10405', '917', '819', '20', '', '0', '1', '24'),

('1190', '0', '5262', '5262', '917', '917', '20', '', '0', '0', '26'),

('1191', '0', '5274', '6100', '2', '251', '46', '', '0', '9', '143'),

('1192', '0', '5279', '5286', '1092', '2', '31', '', '0', '1', '27'),

('1195', '0', '5300', '5485', '765', '229', '36', '', '0', '21', '180'),

('1196', '0', '5305', '5549', '963', '963', '64', '', '1', '4', '89'),

('1197', '0', '5319', '5348', '312', '917', '36', '', '0', '1', '36'),

('1198', '0', '5321', '8677', '588', '357', '8', '', '0', '7', '174'),

('1201', '0', '5328', '21779', '312', '2770', '49', '', '0', '3', '107'),

('1202', '0', '5329', '5355', '963', '251', '34', '', '0', '2', '23'),

('1203', '0', '5359', '6492', '1106', '208', '10', '', '0', '14', '198'),

('1204', '0', '5366', '8908', '312', '1820', '8', '', '0', '3', '150'),

('1205', '0', '5396', '10265', '229', '768', '42', '', '0', '12', '378'),

('1206', '0', '5397', '20766', '1110', '4592', '19', '', '0', '13', '311'),

('1207', '0', '5408', '5408', '312', '312', '25', '', '0', '0', '21'),

('1208', '0', '5410', '5410', '251', '251', '17', '', '0', '0', '98'),

('1209', '0', '5419', '28422', '251', '312', '41', '', '0', '14', '226'),

('1213', '1', '5440', '23478', '312', '5057', '36', '', '0', '25', '662'),

('1214', '0', '5442', '8048', '1052', '1692', '22', '', '0', '3', '25'),

('1215', '0', '5396', '5396', '229', '229', '42', '', '0', '0', '6'),

('1216', '0', '5396', '5396', '229', '229', '37', '', '0', '0', '7'),

('1217', '0', '5452', '5548', '251', '588', '24', '', '0', '7', '62'),

('1220', '0', '5486', '5577', '2', '312', '30', '', '0', '5', '84'),

('1221', '0', '5487', '5517', '2', '588', '41', '', '0', '1', '36'),

('1223', '0', '5494', '8228', '2', '108', '12', '8', '0', '18', '300'),

('1224', '0', '5498', '5500', '1130', '1130', '26', '', '0', '1', '36'),

('1226', '0', '5521', '7032', '619', '829', '11', '', '0', '10', '169'),

('1227', '0', '5532', '5570', '1141', '1141', '12', '', '0', '5', '89'),

('1228', '0', '5534', '5534', '1141', '1141', '12', '', '0', '0', '21'),

('1230', '0', '5419', '5529', '251', '423', '26', '', '0', '1', '10'),

('1232', '0', '5555', '5555', '312', '312', '24', '', '0', '0', '12'),

('1233', '0', '5556', '10746', '312', '357', '24', '', '0', '6', '68'),

('1234', '0', '5559', '5559', '963', '963', '41', '', '0', '0', '63'),

('1235', '0', '5561', '5561', '963', '963', '41', '', '0', '0', '18'),

('1236', '0', '5562', '5562', '963', '963', '41', '', '0', '0', '17'),

('1237', '0', '5564', '5564', '963', '963', '41', '', '0', '0', '22'),

('1238', '0', '5566', '5566', '963', '963', '41', '', '0', '0', '22'),

('1239', '0', '5567', '5567', '963', '963', '41', '', '0', '0', '41'),

('1240', '0', '5568', '14149', '963', '423', '41', '', '0', '4', '103'),

('1241', '0', '5569', '11461', '963', '1746', '41', '', '0', '2', '94'),

('1243', '0', '5585', '6531', '963', '312', '13', '', '1', '8', '278'),

('1244', '0', '5587', '5980', '963', '1227', '8', '', '0', '9', '76'),

('1245', '0', '5588', '5900', '963', '1227', '8', '', '0', '12', '159'),

('1249', '0', '5640', '7141', '728', '1557', '11', '', '0', '3', '130'),

('1250', '0', '5643', '5649', '963', '31', '8', '', '0', '1', '148'),

('1251', '0', '5646', '5753', '834', '834', '64', '', '1', '2', '41'),

('1252', '0', '5652', '5657', '898', '229', '12', '', '0', '1', '35'),

('1253', '0', '5654', '5656', '1177', '312', '13', '', '0', '1', '104');

Caused the error:

Duplicate entry '5396-42' for key 3

Não sei aqui posso conseguir este tipo de suporte,mas se alguém puder me ajudar eu agradeço muito

Obrigado pela atenção Abraços

Link para o comentário
Compartilhar em outros sites

4 respostass a esta questão

Posts Recomendados

  • 0

Segundo o que você passou o erro está nestes três registros:

('1205', '0', '5396', '10265', '229', '768', '42', '', '0', '12', '378'),

[...]

('1215', '0', '5396', '5396', '229', '229', '42', '', '0', '0', '6'),

('1216', '0', '5396', '5396', '229', '229', '37', '', '0', '0', '7'),

Também segundo o que você colou:

[...](ID_TOPIC, isSticky, ID_FIRST_MSG,[...]

A terceira coluna é o id da primeira mensagem postada no tópico, e ai se explica o erro, já que 3 tópicos diferentes não podem ter o mesmo ID para a mensagem inicial, ou seja, um erro de inconsistência dos dados, solução mais simples, entre no fórum, e vá até os tópicos relacionados ao problema e apague eles, assim você acaba com a inconsistência...

Link para o comentário
Compartilhar em outros sites

  • 0

Opa

Muito obrigado!

No caso como eu já converti algumas tabelas para o SMF,o PHPBb não vai mais funcionar,eu teria que apagar estes tópicos problemáticos de alguma outra forma

Estou tentando apagar pelo PHPmyadmin,por enquanto eu ainda não consegui,mas da certo?

EDITADO

COnsegui converter o banco os tópicos

Simplesmente atraves do PHPmyadmin eu exclui as 3 IDs dos tópicos problemáticos.

vejam

Converting members... Successful.

Converting additional member groups... Successful.

Converting categories... Successful.

Converting boards... Successful.

Converting topics... Successful.

Porém...

Converting posts (this may take some time)... Unsuccessful!

( Entre as duas mensagens aparece um monte de coisa,parece ser configurações e posts ( respostas ) a determinados tópicos.

Caused the error:

Got a packet bigger than 'max_allowed_packet' bytes

O erro foi grande pra caramba,alguma idéia ?

Obriado pelo suporte

Editado por tectec
Link para o comentário
Compartilhar em outros sites

  • 0

Não disse para você apagar pelo phpmyadmin pelo simples fato de que, teoricamente, deve haver outras tabelas que se relacionam com essa, e ai você estaria com mais dados que estarão inconsistentes (mas que não devem causar erros...).

Sobre o seu erro -> http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html

Link para o comentário
Compartilhar em outros sites

Visitante
Este tópico está impedido de receber novos posts.


  • Estatísticas dos Fóruns

    • Tópicos
      152,2k
    • Posts
      652k
×
×
  • Criar Novo...