Converting from phpBB

Started by TheLastLegion, January 03, 2007, 09:50:49 PM

Previous topic - Next topic

TheLastLegion

SMF Version: SMF 1.1.1
I was converting from the latest phpBB 2.22 to this latest SMF.
So i got through the part where it located the phpBB folder and it successfully transferred over the board settings. But its having trouble bringing over the topics/posts.

Heres the error i get:
Converting topics... Unsuccessful!
This query:

    INSERT INTO `aonserve_smf`.smf_topics
    (ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
    VALUES ('1764', '0', '11370', '11378', '661', '554', '9', '40', '0', '1', '41'),
    ('1765', '0', '11373', '11664', '662', '590', '5', '', '0', '9', '220'),
    ('1766', '0', '11379', '11407', '554', '623', '10', '', '0', '3', '64'),
    ('1767', '0', '11383', '13443', '448', '419', '4', '', '0', '5', '95'),
    ('1768', '0', '11397', '14344', '658', '723', '42', '', '0', '2', '50'),
    ('1769', '0', '11399', '15008', '658', '684', '42', '', '0', '6', '93'),
    ('1770', '0', '11403', '11426', '539', '448', '25', '', '0', '3', '27'),
    ('1771', '0', '11414', '13528', '586', '419', '6', '', '0', '7', '94'),
    ('1772', '0', '11429', '11465', '539', '273', '12', '', '1', '4', '101'),
    ('1773', '0', '11438', '11446', '664', '273', '30', '', '0', '1', '96'),
    ('1774', '0', '11440', '11556', '539', '448', '25', '', '1', '7', '40'),
    ('1775', '0', '11442', '11484', '539', '593', '6', '', '0', '1', '30'),
    ('1776', '0', '11449', '11473', '448', '448', '26', '', '1', '6', '153'),
    ('1778', '0', '11467', '11522', '554', '98', '33', '', '0', '1', '14'),
    ('1779', '0', '11469', '14372', '652', '723', '10', '', '0', '5', '79'),
    ('1780', '0', '11474', '12728', '5', '12', '1', '', '0', '14', '717'),
    ('1781', '0', '11485', '11535', '658', '448', '15', '', '1', '3', '42'),
    ('1782', '0', '11487', '14446', '658', '442', '42', '', '0', '6', '71'),
    ('1783', '0', '11488', '13495', '658', '419', '23', '', '0', '7', '209'),
    ('1784', '0', '11489', '12327', '539', '590', '39', '', '0', '5', '114'),
    ('1785', '0', '11490', '11490', '658', '658', '23', '', '0', '0', '30'),
    ('1786', '0', '11493', '11660', '629', '273', '25', '', '1', '8', '107'),
    ('1787', '0', '11518', '11569', '586', '259', '6', '', '0', '2', '37'),
    ('1788', '0', '11520', '11692', '259', '657', '6', '', '0', '4', '89'),
    ('1789', '0', '11524', '11830', '98', '98', '33', '', '1', '19', '78'),
    ('1790', '0', '11530', '13642', '358', '715', '4', '', '0', '8', '78'),
    ('1791', '0', '11539', '11611', '590', '448', '2', '', '1', '6', '95'),
    ('1792', '1', '11554', '11554', '289', '289', '24', '', '1', '0', '19'),
    ('1793', '0', '11555', '11626', '289', '554', '4', '', '0', '1', '19'),
    ('1794', '0', '11567', '13521', '448', '419', '4', '', '0', '9', '142'),
    ('1795', '0', '11572', '11572', '358', '358', '24', '', '0', '0', '7'),
    ('1796', '0', '11584', '12599', '358', '685', '6', '', '0', '4', '67'),
    ('1797', '0', '11586', '11630', '669', '42', '25', '', '0', '3', '37'),
    ('1798', '0', '11592', '11822', '539', '448', '25', '', '0', '12', '76'),
    ('1799', '0', '11609', '13611', '160', '715', '21', '', '0', '7', '203'),
    ('1800', '0', '11622', '11622', '629', '629', '4', '', '0', '0', '17'),
    ('1801', '0', '11634', '14026', '667', '698', '5', '', '0', '16', '251'),
    ('1802', '0', '11635', '11655', '119', '448', '25', '', '0', '2', '16'),
    ('1803', '0', '11650', '12932', '667', '699', '7', '', '0', '9', '245'),
    ('1804', '0', '11659', '11744', '629', '629', '25', '', '0', '8', '54'),
    ('1805', '0', '11665', '11972', '590', '629', '2', '', '1', '6', '94'),
    ('1806', '0', '11674', '14454', '659', '727', '21', '', '0', '12', '277'),
    ('1807', '0', '11675', '13816', '657', '419', '17', '', '0', '14', '280'),
    ('1808', '0', '11676', '15685', '657', '783', '17', '', '0', '8', '180'),
    ('1809', '0', '11679', '12557', '657', '657', '43', '', '0', '3', '74'),
    ('1810', '0', '11681', '12355', '657', '684', '11', '', '0', '4', '137'),
    ('1811', '0', '11686', '14813', '657', '358', '2', '', '0', '15', '92'),
    ('1812', '0', '11690', '11728', '657', '289', '39', '', '1', '1', '89'),
    ('1813', '0', '11707', '12004', '659', '629', '48', '', '0', '2', '116'),
    ('1814', '0', '11708', '12193', '659', '442', '24', '', '0', '2', '11'),
    ('1815', '0', '11738', '11819', '658', '448', '25', '', '0', '2', '19'),
    ('1816', '0', '11743', '15461', '658', '827', '42', '', '0', '3', '16'),
    ('1817', '0', '11746', '15123', '629', '801', '9', '41', '0', '7', '85'),
    ('1818', '0', '11757', '13527', '586', '419', '6', '', '0', '10', '96'),
    ('1819', '0', '11758', '11815', '657', '554', '21', '', '1', '6', '285'),
    ('1820', '0', '11776', '11776', '658', '658', '12', '', '0', '0', '47'),
    ('1821', '0', '11784', '14019', '674', '699', '5', '', '0', '8', '133'),
    ('1822', '0', '11786', '11786', '674', '674', '4', '', '0', '0', '26'),
    ('1823', '0', '11788', '11801', '629', '629', '25', '', '0', '3', '28'),
    ('1824', '0', '11793', '13398', '658', '698', '4', '', '0', '14', '242'),
    ('1825', '0', '11796', '12880', '119', '5', '25', '', '0', '8', '72'),
    ('1826', '0', '11797', '13258', '35', '358', '1', '', '0', '16', '672'),
    ('1827', '1', '11805', '13043', '114', '98', '42', '', '0', '5', '157'),
    ('1828', '0', '11806', '12601', '388', '685', '6', '', '0', '4', '83'),
    ('1829', '0', '11809', '14343', '388', '723', '42', '', '0', '10', '79'),
    ('1830', '0', '11817', '14295', '289', '17', '33', '', '0', '16', '59'),
    ('1831', '0', '11887', '11891', '98', '554', '33', '', '0', '1', '7'),
    ('1832', '0', '11893', '11893', '554', '554', '10', '', '0', '0', '7'),
    ('1833', '0', '11896', '12098', '-1', '114', '26', '', '1', '2', '104'),
    ('1834', '0', '11904', '11938', '619', '114', '10', '', '0', '1', '41'),
    ('1835', '0', '11906', '13530', '539', '419', '6', '', '0', '4', '33'),
    ('1836', '0', '11907', '12730', '677', '12', '5', '', '0', '8', '166'),
    ('1837', '0', '11922', '11922', '678', '678', '8', '', '0', '0', '28'),
    ('1838', '0', '11940', '13440', '652', '419', '4', '', '0', '7', '77'),
    ('1839', '0', '11943', '11973', '448', '629', '4', '', '0', '5', '46'),
    ('1840', '0', '11947', '11971', '448', '629', '10', '', '0', '1', '24'),
    ('1842', '0', '11949', '11982', '448', '448', '10', '', '0', '3', '29'),
    ('1843', '0', '11950', '11987', '448', '623', '10', '', '0', '1', '26'),
    ('1844', '0', '11951', '11970', '448', '629', '10', '', '0', '2', '41'),
    ('1845', '0', '11957', '13770', '560', '114', '24', '', '0', '2', '13'),
    ('1846', '0', '11964', '12077', '560', '629', '25', '', '0', '6', '39'),
    ('1847', '0', '11984', '13363', '448', '419', '4', '', '0', '9', '71'),
    ('1848', '0', '11985', '12481', '629', '629', '4', '', '0', '11', '91'),
    ('1849', '0', '11989', '15785', '35', '828', '1', '', '0', '4', '243'),
    ('1850', '0', '11996', '12244', '448', '448', '10', '', '0', '4', '59'),
    ('1851', '0', '11997', '12030', '658', '681', '42', '', '0', '2', '34'),
    ('1852', '0', '11999', '13677', '680', '419', '4', '', '0', '6', '167'),
    ('1853', '0', '12020', '12348', '358', '259', '2', '', '0', '22', '206'),
    ('1854', '0', '12029', '12029', '448', '448', '10', '', '0', '0', '17'),
    ('1855', '0', '12036', '14029', '681', '698', '5', '', '0', '5', '64'),
    ('1856', '0', '12057', '12108', '681', '658', '42', '', '0', '3', '55'),
    ('1857', '0', '12059', '12225', '681', '681', '42', '', '0', '2', '24'),
    ('1858', '0', '12067', '12068', '681', '681', '25', '', '1', '1', '15'),
    ('1859', '0', '12074', '12075', '590', '629', '4', '', '0', '1', '12'),
    ('1860', '0', '12099', '12151', '114', '98', '33', '', '0', '5', '37'),
    ('1861', '0', '12111', '15648', '629', '448', '4', '', '0', '228', '4124'),
    ('1862', '0', '12118', '12186', '629', '629', '25', '', '0', '2', '22'),
    ('1863', '0', '12127', '15708', '657', '830', '17', '', '0', '8', '217'),
    ('1864', '0', '12130', '12296', '652', '5', '2', '', '1', '14', '146'),
    ('1865', '0', '12134', '12329', '114', '35', '33', '', '0', '5', '34'),
    ('1866', '0', '12137', '12161', '448', '114', '12', '', '0', '2', '40'),
    ('1867', '0', '12146', '12467', '448', '442', '48', '', '0', '16', '417'),
    ('1868', '0', '12165', '13509', '98', '419', '17', '', '0', '6', '133'),
    ('1869', '0', '12174', '12343', '451', '582', '25', '', '0', '3', '37'),
    ('1870', '0', '12176', '12266', '273', '448', '33', '', '0', '5', '37'),
    ('1871', '0', '12181', '12686', '448', '448', '4', '', '0', '2', '84'),
    ('1872', '0', '12182', '14370', '448', '723', '12', '', '0', '5', '91'),
    ('1873', '0', '12183', '14739', '448', '727', '7', '', '0', '13', '350'),
    ('1874', '0', '12192', '12287', '442', '442', '23', '', '0', '2', '51'),
    ('1875', '0', '12207', '14077', '119', '442', '9', '42', '0', '6', '118'),
    ('1876', '0', '12213', '12213', '592', '592', '25', '', '0', '0', '13'),
    ('1877', '0', '12215', '12273', '657', '657', '17', '', '0', '3', '90'),
    ('1878', '0', '12216', '12247', '657', '119', '2', '', '0', '4', '51'),
    ('1879', '0', '12219', '12490', '657', '448', '42', '', '0', '5', '50'),
    ('1880', '0', '12229', '12411', '155', '593', '6', '', '0', '1', '47'),
    ('1881', '0', '12230', '14774', '155', '727', '6', '', '0', '16', '228'),
    ('1882', '0', '12231', '12409', '155', '593', '6', '', '0', '1', '45'),
    ('1883', '0', '12232', '12407', '155', '593', '6', '', '0', '2', '45'),
    ('1884', '0', '12233', '12408', '155', '593', '6', '', '0', '2', '75'),
    ('1885', '0', '12234', '15593', '155', '448', '23', '', '0', '12', '145'),
    ('1886', '0', '12235', '12235', '155', '155', '24', '', '0', '0', '6'),
    ('1887', '0', '12236', '14229', '155', '555', '24', '', '0', '1', '8'),
    ('1888', '0', '12237', '15320', '155', '682', '24', '', '0', '2', '11'),
    ('1889', '0', '12245', '13396', '448', '698', '4', '', '0', '5', '83'),
    ('1890', '0', '12246', '12775', '448', '684', '24', '', '0', '2', '6'),
    ('1891', '0', '12248', '13541', '448', '419', '7', '', '0', '15', '314'),
    ('1892', '0', '12249', '12269', '119', '358', '2', '', '0', '2', '36'),
    ('1893', '0', '12256', '13410', '657', '686', '17', '', '0', '5', '210'),
    ('1894', '0', '12300', '12405', '539', '593', '6', '', '0', '3', '70'),
    ('1895', '0', '12315', '14325', '289', '554', '33', '', '0', '6', '29'),
    ('1896', '0', '12318', '13087', '623', '629', '42', '', '0', '3', '52'),
    ('1897', '0', '12336', '12336', '-1', '-1', '26', '', '1', '0', '36'),
    ('1898', '1', '12341', '12385', '5', '98', '33', '', '0', '1', '25'),
    ('1899', '0', '12349', '14856', '657', '759', '17', '', '0', '4', '93'),
    ('1900', '0', '12350', '14455', '632', '727', '21', '', '0', '2', '125'),


Continuing from above:
('1901', '0', '12354', '12523', '684', '684', '5', '', '0', '6', '140'),
('1902', '0', '12369', '13494', '684', '419', '8', '', '0', '4', '44'),
('1903', '0', '12370', '12392', '684', '684', '42', '', '0', '2', '34'),
('1904', '0', '12372', '12423', '684', '684', '38', '', '0', '4', '129'),
('1905', '0', '12384', '14457', '684', '727', '21', '', '0', '12', '307'),
('1906', '0', '12399', '12498', '684', '98', '2', '', '0', '4', '41'),
('1907', '0', '12426', '13032', '658', '5', '48', '', '1', '2', '70'),
('1908', '0', '12429', '12449', '684', '684', '25', '', '0', '3', '26'),
('1909', '0', '12432', '13276', '448', '629', '4', '', '0', '15', '120'),
('1910', '0', '12433', '14657', '448', '727', '6', '', '0', '7', '67'),
('1912', '0', '12439', '12439', '448', '448', '10', '', '0', '0', '25'),
('1913', '0', '12440', '12850', '448', '623', '10', '', '0', '4', '26'),
('1914', '0', '12443', '12510', '448', '554', '23', '', '0', '6', '86'),
('1915', '0', '12445', '13725', '448', '419', '12', '', '0', '3', '41'),
('1916', '0', '12456', '12456', '539', '539', '6', '', '0', '0', '30'),
('1917', '0', '12459', '12851', '155', '155', '25', '', '0', '5', '33'),
('1918', '0', '12465', '13531', '586', '419', '6', '', '0', '3', '35'),
('1919', '0', '12469', '12469', '442', '442', '23', '', '0', '0', '40'),
('1920', '0', '12470', '13431', '442', '629', '31', '', '0', '9', '78'),
('1921', '0', '12471', '14322', '442', '442', '31', '', '0', '12', '89'),
('1922', '0', '12473', '13659', '442', '419', '14', '', '0', '4', '90'),
('1923', '0', '12474', '14835', '442', '682', '23', '', '0', '1', '76'),
('1924', '0', '12475', '13111', '442', '698', '24', '', '0', '9', '37'),
('1925', '0', '12482', '12573', '448', '448', '9', '', '0', '6', '32'),
('1926', '0', '12484', '13067', '448', '448', '10', '', '0', '2', '21'),
('1927', '0', '12500', '14294', '448', '17', '33', '', '0', '7', '32'),
('1928', '0', '12503', '12503', '293', '293', '9', '', '0', '0', '25'),
('1929', '0', '12504', '14563', '448', '727', '48', '', '0', '24', '586'),
('1930', '0', '12505', '12552', '582', '5', '26', '', '1', '6', '83'),
('1931', '0', '12514', '12514', '681', '681', '42', '', '0', '0', '45'),
('1932', '0', '12515', '12812', '685', '442', '42', '', '0', '2', '24'),
('1933', '0', '12516', '15122', '685', '801', '9', '43', '0', '9', '61'),
('1934', '0', '12517', '15673', '685', '830', '17', '44', '0', '6', '134'),
('1935', '0', '12518', '12522', '685', '684', '36', '45', '0', '1', '40'),
('1936', '0', '12519', '12519', '685', '685', '22', '', '0', '0', '25'),
('1937', '0', '12520', '12574', '685', '448', '22', '', '0', '1', '29'),
('1938', '0', '12532', '12575', '686', '448', '2', '', '0', '1', '33'),
('1939', '0', '12535', '14028', '686', '698', '5', '', '0', '12', '103'),
('1940', '0', '12537', '12537', '685', '685', '6', '', '0', '0', '23'),
('1941', '0', '12538', '12538', '685', '685', '6', '', '0', '0', '24'),
('1942', '0', '12539', '12539', '685', '685', '6', '', '0', '0', '17'),
('1943', '0', '12540', '12540', '685', '685', '6', '', '0', '0', '23'),
('1944', '0', '12569', '13553', '684', '419', '8', '', '0', '6', '38'),
('1945', '0', '12580', '13810', '686', '419', '17', '', '0', '8', '162'),
('1946', '0', '12583', '13555', '686', '419', '8', '', '0', '7', '61'),
('1947', '0', '12586', '13252', '448', '691', '1', '', '0', '25', '900'),
('1948', '0', '12589', '12629', '448', '629', '31', '', '0', '1', '48'),
('1949', '0', '12593', '13517', '685', '419', '42', '', '0', '10', '38'),
('1950', '0', '12618', '12718', '685', '273', '4', '', '0', '5', '116'),
('1951', '0', '12619', '12699', '554', '554', '33', '', '0', '5', '48'),
('1952', '0', '12626', '13652', '155', '448', '2', '', '0', '5', '57'),
('1953', '0', '12644', '12864', '689', '448', '26', '', '1', '1', '47'),
('1955', '0', '12650', '13526', '539', '419', '6', '', '0', '14', '57'),
('1956', '0', '12651', '12665', '539', '629', '12', '', '0', '2', '48'),
('1957', '0', '12652', '12765', '539', '442', '48', '', '0', '5', '155'),
('1959', '0', '12694', '12698', '448', '554', '33', '', '0', '1', '9'),
('1960', '0', '12695', '13176', '448', '691', '12', '', '0', '3', '59'),
('1961', '0', '12697', '14027', '691', '698', '5', '', '0', '8', '83'),
('1962', '0', '12704', '12704', '691', '691', '11', '', '0', '0', '54'),
('1963', '0', '12705', '13689', '691', '419', '11', '', '0', '6', '134'),
('1964', '0', '12720', '13933', '448', '419', '22', '', '0', '2', '73'),
('1965', '0', '12721', '12868', '691', '691', '11', '', '0', '2', '93'),
('1966', '0', '12733', '13025', '12', '448', '4', '', '1', '11', '168'),
('1967', '0', '12739', '13057', '388', '448', '17', '', '0', '1', '44'),
('1968', '0', '12743', '12743', '388', '388', '23', '', '0', '0', '37'),
('1969', '0', '12745', '12770', '693', '448', '4', '', '0', '4', '150'),
('1970', '0', '12747', '12763', '590', '5', '2', '', '0', '3', '51'),
('1972', '0', '12753', '12874', '684', '684', '25', '', '0', '4', '26'),
('1973', '0', '12795', '13322', '698', '699', '5', '', '0', '10', '127'),
('1974', '0', '12801', '12971', '698', '701', '6', '', '0', '3', '85'),
('1975', '0', '12809', '13112', '698', '698', '24', '', '0', '2', '12'),
('1976', '0', '12811', '14066', '442', '442', '24', '', '0', '16', '53'),
('1977', '0', '12813', '12813', '442', '442', '23', '', '0', '0', '21'),
('1978', '0', '12814', '14836', '442', '682', '23', '', '0', '1', '74'),
('1979', '0', '12815', '13147', '442', '442', '35', '', '0', '3', '32'),
('1980', '0', '12816', '12816', '442', '442', '48', '', '0', '0', '41'),
('1981', '0', '12817', '12817', '442', '442', '36', '', '0', '0', '30'),
('1982', '0', '12820', '12820', '442', '442', '31', '', '0', '0', '31'),
('1983', '0', '12821', '14847', '442', '759', '42', '', '0', '9', '82'),
('1984', '0', '12824', '12845', '442', '554', '48', '', '0', '1', '42'),
('1985', '0', '12841', '12844', '289', '448', '2', '', '0', '1', '25'),
('1986', '0', '12854', '13016', '698', '35', '21', '', '1', '9', '237'),
('1987', '0', '12865', '12866', '619', '619', '10', '', '0', '1', '5'),
('1988', '0', '12870', '12879', '119', '5', '25', '', '0', '1', '14'),
('1989', '0', '12881', '13525', '586', '419', '6', '', '0', '3', '11'),
('1990', '0', '12886', '13397', '442', '698', '4', '', '0', '6', '50'),
('1991', '0', '12888', '14565', '442', '727', '48', '', '0', '7', '189'),
('1992', '0', '12897', '13713', '554', '419', '2', '', '0', '6', '54'),
('1993', '0', '12900', '13319', '699', '699', '5', '', '0', '10', '703'),
('1994', '0', '12912', '13380', '448', '419', '7', '', '0', '3', '99'),
('1995', '0', '12915', '14703', '448', '698', '6', '', '0', '12', '212'),


Continuing from above:
('1996', '0', '12930', '13106', '699', '698', '6', '', '0', '3', '63'),
('1998', '0', '12951', '15132', '623', '801', '7', '', '0', '2', '66'),
('1999', '0', '12978', '12978', '701', '701', '42', '', '0', '0', '44'),
('2000', '0', '12981', '13321', '701', '699', '5', '', '0', '7', '138'),
('2001', '0', '12982', '12985', '701', '698', '24', '', '0', '1', '9'),
('2002', '0', '12997', '12997', '442', '442', '4', '', '0', '0', '85'),
('2003', '0', '12998', '13238', '442', '419', '4', '', '0', '9', '47'),
('2005', '0', '13028', '14713', '448', '114', '42', '', '0', '7', '71'),
('2006', '0', '13029', '13422', '448', '629', '4', '', '0', '3', '55'),
('2007', '0', '13039', '13040', '701', '539', '6', '', '0', '1', '51'),
('2008', '0', '13058', '13107', '448', '698', '6', '', '0', '4', '71'),
('2009', '0', '13059', '13059', '-1', '-1', '26', '', '0', '0', '50'),
('2010', '0', '13082', '15492', '119', '629', '48', '46', '0', '17', '332'),
('2011', '0', '13088', '15299', '629', '629', '25', '', '0', '21', '108'),
('2012', '0', '13108', '14551', '698', '727', '6', '', '0', '12', '210'),
('2013', '0', '13118', '15621', '188', '188', '11', '47', '0', '9', '190'),
('2014', '0', '13121', '13170', '706', '448', '8', '', '0', '3', '28'),
('2015', '0', '13132', '15486', '706', '119', '13', '', '0', '1', '42'),
('2016', '0', '13142', '13142', '629', '629', '10', '', '0', '0', '13'),
('2017', '0', '13143', '13143', '629', '629', '10', '', '0', '0', '8'),
('2018', '0', '13144', '13184', '629', '629', '10', '', '0', '6', '88'),
('2019', '0', '13148', '13148', '442', '442', '23', '', '0', '0', '37'),
('2020', '0', '13149', '14574', '442', '727', '48', '', '0', '3', '106'),
('2021', '0', '13150', '13150', '442', '442', '35', '', '0', '0', '18'),
('2022', '0', '13151', '13197', '442', '442', '35', '', '0', '2', '43'),
('2023', '0', '13153', '13153', '442', '442', '31', '', '0', '0', '25'),
('2024', '0', '13154', '15589', '442', '448', '24', '', '0', '3', '12'),
('2025', '0', '13183', '13257', '691', '5', '2', '', '1', '5', '74'),
('2026', '0', '13189', '13189', '561', '561', '23', '', '0', '0', '35'),
('2027', '0', '13190', '13190', '561', '561', '23', '', '0', '0', '41'),
('2029', '0', '13192', '13561', '561', '419', '23', '', '0', '12', '240'),
('2030', '0', '13199', '14293', '114', '17', '33', '48', '1', '3', '25'),
('2031', '0', '13209', '13974', '442', '419', '4', '', '0', '15', '174'),
('2032', '0', '13210', '13210', '442', '442', '4', '', '0', '0', '17'),
('2033', '0', '13211', '13211', '442', '442', '48', '', '0', '0', '44'),
('2034', '0', '13213', '13308', '681', '448', '10', '', '0', '3', '53'),
('2035', '0', '13216', '13519', '710', '419', '42', '49', '0', '2', '36'),
('2036', '0', '13250', '13250', '684', '684', '10', '', '0', '0', '11'),
('2037', '0', '13253', '13271', '691', '698', '6', '', '0', '3', '63'),
('2038', '0', '13261', '13461', '358', '712', '4', '', '0', '5', '107'),
('2039', '0', '13273', '15352', '188', '188', '8', '', '0', '5', '37'),
('2040', '0', '13275', '13523', '701', '419', '6', '', '0', '3', '14'),
('2041', '0', '13289', '13567', '712', '590', '5', '', '0', '10', '95'),
('2042', '0', '13292', '13292', '712', '712', '6', '', '0', '0', '20'),
('2043', '0', '13293', '13293', '712', '712', '6', '', '0', '0', '18'),
('2044', '0', '13294', '14695', '712', '556', '6', '', '0', '8', '101'),
('2045', '0', '13296', '13296', '712', '712', '6', '', '0', '0', '18'),
('2046', '0', '13297', '13485', '712', '419', '6', '', '0', '1', '14'),
('2047', '0', '13298', '13306', '712', '448', '6', '', '0', '1', '24'),
('2048', '0', '13299', '15051', '712', '698', '24', '', '0', '6', '29'),
('2049', '0', '13309', '14456', '696', '727', '21', '', '0', '14', '256'),
('2050', '0', '13327', '13427', '698', '629', '10', '', '0', '6', '75'),
('2052', '0', '13389', '13920', '448', '629', '1', '', '0', '10', '377'),
('2053', '0', '13403', '13583', '698', '419', '4', '', '0', '1', '68'),
('2054', '0', '13414', '14064', '442', '442', '23', '50', '0', '5', '92'),
('2055', '0', '13417', '14815', '442', '358', '4', '51', '0', '24', '231'),
('2056', '0', '13466', '13466', '712', '712', '6', '', '0', '0', '12'),
('2057', '0', '13467', '13484', '712', '419', '6', '', '0', '1', '6'),
('2058', '0', '13468', '13524', '712', '419', '6', '', '0', '1', '7'),
('2059', '0', '13469', '13771', '712', '114', '6', '', '0', '5', '60'),
('2060', '0', '13470', '13470', '712', '712', '43', '', '0', '0', '45'),
('2061', '0', '13471', '15039', '712', '119', '43', '', '0', '3', '67'),
('2062', '0', '13473', '13782', '712', '539', '6', '', '0', '4', '44'),
('2063', '1', '13476', '13476', '127', '127', '42', '', '1', '0', '34'),
('2064', '1', '13477', '14266', '127', '590', '64', '', '0', '3', '78'),
('2065', '0', '13482', '14022', '127', '699', '5', '', '0', '7', '79'),
('2066', '0', '13488', '14118', '419', '698', '4', '52', '0', '17', '380'),
('2067', '0', '13491', '14932', '419', '259', '2', '', '0', '4', '58'),
('2068', '0', '13492', '13492', '419', '419', '2', '', '0', '0', '20'),



Then after whole bunch of those i see this:
     ('2309', '0', '15313', '15328', '554', '554', '33', '', '0', '4', '24'),
    ('2310', '0', '15322', '15403', '629', '629', '4', '', '0', '5', '30'),
    ('2311', '0', '15341', '15351', '188', '448', '35', '57', '0', '3', '10'),
    ('2312', '0', '15342', '15780', '188', '188', '37', '', '0', '5', '15');

Caused the error:

    Duplicate entry '13043-42' for key 2


TheLastLegion

Then when i hit "try again"
i get this error:
Caused the error:

    Duplicate entry '1764' for key 1

TheLastLegion

SOMEONE PLZZ HELP!!!

I HAVE 15,000 POSTS AND NEED HELP!

margarett

Debated question... You have duplica entries in phpbb_topics_watch (or maybe another table...)

Check here
http://www.simplemachines.org/community/index.php?topic=84659.0
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

april

Im having the same problem -- ran the sql query that they suggested and it came up with nothing :(

If someone can please help me :(


SillyCone

#5
You have indeed duplicates in the phpbb_topics tables.

I had the same problem, it happened on some moved topics, they end up with the same first_post_id and smf doesn't like that.

My solution was to delete manually from the db (using a "DELETE FROM phpbb_topics WHERE ..." statement) the "offending" topics. You'll probably loose the marker to the moved forum on the original forum the topic was in.
Do delete the original topic, not the destination one. You can notice the difference by checking the topic_moved_id field : the record you have to delete has the id of the topic you have to keep in this field...
Hmm, kinda hard to explain for me.

Once you deleted that topic, run the converter again from the start (just convert.php, get rid of the url arguments). It will stop again giving you the next first_post_id failing. Do a search in the table phpbb_topic tables again on that field, and delete the matching record that has a value different of 0 in the topic_moved_id field. Then start the convert again, etc, until you have no more errors at all.

Do check the permissions on the forum directory structure so the convertor can copy files from the original phpBB directory, too (like attachements...)

I never converted my board in one shot, for a good perfect conversion, I do it in a few steps : first conversion is to note all the offending issues (do note down the settings you changed in the Settings.inc.php, and the ids of the topics you deleted, then you can do a batch to run when you do the successive possible installations and conversions), I do it on a test server (on my machine, locally, using a WAMP of some sort) and second conversion is done on the final server.
Do empty the smf tables before running the conversion again, else you'll have double records again, for totally unrelated and otherwise perfectly "healthy" tables.

Do not give up SMF, anyway : my moderators love it already !

Cheers,
SillyCone.

Advertisement: