News:

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

Main Menu

[SMF Converter] XMB - 1.9.8

Started by JayBachatero, January 08, 2007, 09:21:48 AM

Previous topic - Next topic

JayBachatero

Software: XMB
Version: 1.9.8

This is the official support topic for XMB 1.9.8 converter.  Use this topic to ask for support for this converter.

Changelog
! Typo (xmb_to_smf.sql)
! Set the correct subject for posts without a subject. (xmb_to_smf.sql)
! When inserting into log_notify board use INSERT IGNORE INTO. (xmb_to_smf.sql)
! When converting topics make sure that "closed" column is set to the correct value (xmb_to_smf.sql)
! 255 characters are not enough to limit a post body to. (xmb_to_smf.sql)
! Make sure IN_CODE is defined. (xmb_to_smf.sql)


convert.php
Use this convert.php with the .sql file attached in this topic.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

weec

#1
yes, standart converter have this trouble "255 characters"
i am trying new converter

QuoteConverting...
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting banned users... Successful.
Converting settings... Successful.
Converting moderators... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Recalculating forum statistics... Successful.
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the XMB 1.9 Nexus installation.

We hope you had a smooth transition!
test passed !!!

'Converting posts... Successful' is lost in converter`s message ????

used XMB Nexus 1.9.6 RC2

JayBachatero

The reason for "Converting posts... Successful" not being there is because it's gone on the page reload.  Did everything convert correctly though?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

weec

#3
yes, now the posts full(comleted)

[bug]double personal messages
QuoteПрочитать     Октября 22, 2006, 03:12:39 pm     получение статуса admin     iPod     
Прочитать    Октября 23, 2006, 09:39:32 pm    хо4у ADMINKy    lmz.hunter    
Прочитать    Октября 23, 2006, 09:39:32 pm    хо4у ADMINKy    lmz.hunter    
Прочитать    Октября 25, 2006, 01:33:32 pm    плиз хелп    Sm0ke    
Прочитать    Октября 25, 2006, 01:33:32 pm    плиз хелп    Sm0ke    
Прочитать    Октября 27, 2006, 03:12:16 am    ADMIN    lmz.hunter    
Прочитать    Октября 27, 2006, 03:12:16 am    ADMIN    lmz.hunter    
Прочитать    Октября 28, 2006, 06:36:25 am    Объявление! Набор администраторов серверов    DDP    
Прочитать    Октября 28, 2006, 06:36:25 am    Объявление! Набор администраторов серверов    DDP    
Прочитать    Октября 29, 2006, 03:34:55 pm    Уточнение    iPod    
Прочитать    Октября 29, 2006, 03:34:55 pm    Уточнение    iPod    
Прочитать    Октября 29, 2006, 03:48:32 pm    Хачу стать админом    ardr!ck    
Прочитать    Октября 29, 2006, 03:48:32 pm    Хачу стать админом    ardr!ck    
Прочитать    Октября 29, 2006, 07:10:38 pm    сделай меня одмином pliss!!!    InkvezItor    
Прочитать    Октября 29, 2006, 07:10:38 pm    сделай меня одмином pliss!!!    InkvezItor    
Прочитать    Октября 30, 2006, 11:23:36 am    CS    zayka    
Прочитать    Октября 30, 2006, 11:23:36 am    CS    zayka    
Прочитать    Октября 30, 2006, 11:36:18 pm    заявка    InkvezItor    
Прочитать    Октября 30, 2006, 11:36:18 pm    заявка    InkvezItor    
Прочитать    Октября 31, 2006, 12:26:07 am    набор администраторов    mrFREEZE    
Прочитать    Октября 31, 2006, 12:26:07 am    набор администраторов    mrFREEZE    
Прочитать    Ноября 01, 2006, 10:11:26 pm    заявки    InkvezItor    
Прочитать    Ноября 01, 2006, 10:11:26 pm    заявки    InkvezItor    
Прочитать    Ноября 04, 2006, 05:15:51 pm    ADMINKA    best    
Прочитать    Ноября 04, 2006, 05:15:51 pm    ADMINKA    best

please fix this bug

JayBachatero

Can you PM me access to phpMyAdmin and an admin account for the forum?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

weec

I can send mysqldump of forum`s databases xmb & smf
to your E-mail

OK?

JayBachatero

Alright.  I'll look at it tom and see what's wrong.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

weec

#7
finded bugs
- converted only one moderator (not all moderators) of one forum
- cracked structure of forums and categories (all forums moved to General Category)

mysqldumps is sended on your e-mail (used mysql 3.23 & CP1251)

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

babyjuker

#9
i keep getting this error when converting

Converting topics... Unsuccessful!
This query:

INSERT INTO `iceyboar_dummy`.smf_topics
(ID_TOPIC, isSticky, ID_BOARD, ID_MEMBER_STARTED, numReplies, numViews, locked, ID_FIRST_MSG, ID_LAST_MSG, ID_POLL)
VALUES ('1620', '0', '103', '37', '12', '79', '0', '17457', '19561', '0'),
('1621', '0', '29', '32', '5', '49', '0', '17464', '24222', '0'),
('1622', '0', '29', '1', '16', '72', '0', '17480', '17773', '0'),
('1623', '0', '29', '32', '7', '31', '0', '17509', '20317', '0'),
('1624', '0', '20', '1', '19', '94', '0', '17517', '18168', '0'),
('1625', '0', '29', '6', '8', '37', '0', '17526', '17619', '0'),
('1626', '0', '96', '3', '5', '52', '0', '17531', '17633', '0'),
('1628', '0', '29', '12', '16', '90', '0', '17539', '23060', '0'),
('1629', '0', '96', '3', '8', '134', '0', '17545', '17628', '1629'),
('1631', '0', '29', '19', '10', '57', '0', '17562', '18027', '0'),
('1632', '0', '29', '45', '5', '37', '0', '17564', '18250', '0'),
('1633', '0', '29', '17', '4', '28', '0', '17578', '17873', '0'),
('1634', '0', '29', '13', '7', '22', '0', '17607', '18144', '0'),
('1635', '0', '96', '13', '11', '54', '0', '17609', '17934', '0'),
('1637', '0', '29', '6', '20', '95', '1', '17626', '19477', '0'),
('1638', '0', '29', '1', '0', '6', '0', '17652', '17652', '0'),
('1639', '0', '29', '1', '9', '58', '0', '17661', '18781', '0'),
('1640', '0', '29', '19', '2', '16', '0', '17663', '17674', '0'),
('1641', '0', '96', '1', '8', '72', '0', '17664', '32305', '0'),
('1642', '0', '29', '11', '7', '36', '1', '17665', '35132', '0'),
('1643', '0', '29', '11', '8', '36', '0', '17671', '17832', '0'),
('1644', '0', '29', '1', '14', '89', '0', '17678', '18018', '0'),
('1645', '0', '29', '1', '2', '44', '0', '17681', '18575', '0'),
('1646', '0', '29', '1', '1', '45', '0', '17683', '20107', '0'),
('1647', '0', '29', '1', '6', '26', '0', '17685', '18008', '0'),
('1649', '0', '29', '11', '7', '31', '0', '17697', '17742', '0'),
('1650', '0', '29', '22', '9', '85', '0', '17701', '19584', '0'),
('1651', '0', '94', '11', '4', '43', '1', '17704', '17718', '0'),
('1655', '0', '29', '1', '4', '20', '0', '17726', '18037', '0'),
('1656', '0', '29', '0', '29', '179', '0', '17744', '18510', '0'),
('1657', '0', '29', '9', '10', '61', '0', '17783', '29130', '0'),
('1658', '0', '29', '19', '3', '29', '0', '17811', '17835', '0'),
('1659', '0', '96', '19', '11', '86', '0', '17825', '17882', '0'),
('1660', '0', '92', '1', '4', '73', '0', '17839', '17848', '0'),
('1661', '0', '29', '1', '17', '65', '0', '17845', '18402', '0'),
('1662', '0', '116', '1', '4', '56', '0', '17878', '18611', '0'),
('1663', '0', '29', '20', '6', '41', '0', '17896', '18107', '0'),
('1664', '0', '29', '38', '3', '31', '1', '17945', '20620', '0'),
('1665', '0', '29', '38', '10', '39', '0', '17950', '18139', '0'),
('1667', '0', '29', '38', '8', '37', '0', '17969', '18387', '0'),
('1668', '0', '103', '9', '3', '41', '0', '17975', '18181', '0'),
('1669', '0', '108', '18', '12', '79', '0', '17980', '18720', '0'),
('1670', '0', '29', '13', '4', '33', '0', '17985', '18634', '0'),
('1671', '0', '93', '0', '16', '81', '0', '17993', '19664', '0'),
('1672', '0', '29', '0', '2', '62', '0', '18020', '18094', '0'),
('1673', '0', '29', '0', '5', '36', '1', '18021', '18072', '0'),
('1674', '0', '29', '32', '9', '52', '0', '18041', '18257', '0'),
('1675', '0', '15', '32', '9', '41', '0', '18043', '18778', '0'),
('1676', '0', '29', '24', '4', '17', '0', '18044', '18085', '0'),
('1678', '0', '29', '0', '16', '74', '1', '18066', '18258', '0'),
('1680', '0', '29', '0', '24', '139', '0', '18078', '29245', '0'),
('1683', '0', '29', '12', '8', '37', '0', '18116', '18478', '0'),
('1684', '0', '116', '12', '6', '51', '0', '18117', '18184', '0'),
('1685', '0', '29', '12', '22', '94', '0', '18149', '18809', '0'),
('1686', '0', '29', '12', '14', '64', '0', '18178', '19863', '0'),
('1687', '0', '29', '12', '13', '68', '0', '18185', '33726', '0'),
('1688', '0', '29', '12', '6', '24', '0', '18186', '18229', '0'),
('1689', '0', '29', '12', '16', '79', '0', '18193', '32453', '1689'),
('1691', '0', '29', '12', '6', '33', '0', '18253', '18540', '0'),
('1692', '0', '93', '47', '16', '91', '1', '18268', '19639', '0'),
('1693', '0', '29', '0', '7', '50', '0', '18269', '22493', '0'),
('1694', '0', '29', '0', '15', '119', '0', '18298', '20941', '0'),
('1696', '0', '29', '0', '22', '108', '0', '18309', '20608', '0'),
('1697', '0', '29', '32', '10', '44', '0', '18346', '18541', '0'),
('1698', '0', '29', '0', '10', '47', '0', '18355', '18536', '0'),
('1699', '0', '29', '0', '34', '117', '0', '18357', '18514', '0'),
('1700', '0', '93', '11', '3', '44', '1', '18391', '18492', '0'),
('1702', '0', '29', '11', '11', '56', '0', '18399', '18530', '0'),
('1705', '0', '29', '29', '23', '162', '0', '18452', '19277', '0'),
('1706', '0', '29', '36', '11', '38', '1', '18453', '18518', '0'),
('1707', '0', '116', '19', '20', '110', '0', '18475', '18801', '0'),
('1708', '0', '29', '1', '16', '95', '0', '18500', '27086', '0'),
('1709', '0', '29', '0', '15', '73', '0', '18529', '25320', '0'),
('1710', '0', '29', '1', '24', '137', '0', '18532', '32632', '0'),
('1711', '0', '29', '45', '21', '148', '0', '18543', '18856', '0'),
('1712', '0', '116', '1', '3', '26', '0', '18547', '18692', '0'),
('1713', '0', '116', '1', '16', '70', '0', '18551', '18927', '0'),
('1714', '0', '29', '1', '12', '79', '0', '18556', '20385', '0'),
('1715', '0', '116', '1', '11', '66', '0', '18581', '18676', '0'),
('1716', '0', '29', '1', '5', '27', '0', '18584', '18903', '0'),
('1717', '0', '29', '1', '7', '56', '0', '18587', '18909', '0'),
('1718', '0', '29', '0', '7', '39', '0', '18588', '18719', '0'),
('1719', '0', '104', '1', '29', '434', '0', '18599', '67985', '0'),
('1720', '0', '29', '40', '4', '30', '0', '18600', '18643', '0'),
('1721', '0', '29', '1', '10', '51', '0', '18617', '19151', '0'),
('1722', '0', '29', '13', '21', '88', '0', '18622', '21820', '0'),
('1723', '0', '137', '1', '4', '21', '0', '18632', '18649', '0'),
('1724', '0', '29', '18', '13', '66', '0', '18658', '24522', '0'),
('1725', '0', '29', '37', '0', '7', '0', '18671', '18671', '0'),
('1726', '0', '131', '37', '0', '84', '0', '18672', '18672', '1726'),
('1727', '0', '137', '33', '11', '52', '0', '18689', '18852', '0'),
('1728', '0', '29', '13', '2', '18', '0', '18706', '19086', '0'),
('1730', '0', '29', '12', '15', '44', '0', '18728', '18888', '0'),
('1731', '0', '93', '3', '33', '243', '1', '18730', '28847', '0'),
('1732', '0', '29', '3', '1', '24', '0', '18733', '18743', '0'),
('1733', '0', '29', '12', '2', '17', '0', '18741', '18914', '0'),
('1735', '0', '15', '0', '8', '65', '0', '18773', '20290', '0'),
('1736', '0', '29', '32', '11', '42', '0', '18787', '18922', '0'),
('1737', '0', '29', '19', '0', '8', '0', '18798', '18798', '0'),
('1738', '0', '29', '38', '4', '30', '0', '18806', '21233', '0'),
('1739', '0', '29', '38', '16', '98', '0', '18812', '20110', '0'),
('1740', '0', '29', '0', '0', '8', '1', '18821', '18821', '0'),
('1741', '0', '29', '0', '0', '9', '1', '18822', '18822', '0'),
('1742', '0', '29', '0', '4', '29', '0', '18824', '18895', '0'),
('1743', '0', '29', '32', '17', '73', '0', '18825', '19412', '0'),
('1744', '0', '137', '32', '9', '55', '0', '18830', '18962', '0'),
('1745', '0', '29', '32', '4', '32', '0', '18842', '18855', '0'),
('1746', '0', '29', '6', '18', '73', '0', '18859', '19214', '0'),
('1747', '0', '29', '0', '6', '39', '1', '18880', '19373', '0'),
('1748', '0', '29', '0', '3', '26', '0', '18884', '19040', '0'),
('1749', '0', '29', '1', '1', '14', '0', '18893', '18894', '0'),
('1750', '0', '29', '1', '15', '85', '0', '18896', '19202', '0'),
('1751', '0', '15', '0', '16', '98', '0', '18917', '20634', '0'),
('1753', '0', '29', '5', '5', '20', '0', '18933', '19011', '0'),
('1754', '0', '29', '26', '4', '20', '0', '18936', '18972', '0'),
('1755', '0', '29', '5', '2', '11', '0', '18938', '18945', '0'),
('1756', '0', '29', '26', '13', '71', '0', '18947', '20596', '0'),
('1757', '0', '29', '32', '6', '31', '0', '18949', '19123', '0'),
('1760', '0', '29', '32', '11', '49', '0', '18957', '20723', '0'),
('1761', '0', '103', '47', '10', '85', '0', '18961', '19981', '0'),
('1762', '0', '29', '0', '28', '13', '0', '6915', '18966', '0'),
('1764', '0', '29', '5', '12', '89', '0', '18992', '30387', '0'),
('1765', '0', '29', '5', '8', '49', '0', '18994', '19208', '0'),
('1767', '0', '29', '26', '6', '38', '0', '19018', '24694', '0'),
('1769', '0', '103', '9', '7', '58', '0', '19027', '19271', '0'),
('1770', '0', '104', '4', '13', '233', '1', '19028', '33088', '0'),
('1771', '0', '29', '1', '7', '47', '0', '19045', '19181', '0'),
('1772', '0', '29', '1', '35', '266', '0', '19060', '63319', '0'),
('1775', '0', '108', '12', '8', '48', '0', '19115', '19203', '0'),
('1776', '0', '29', '24', '7', '47', '0', '19116', '19377', '0'),
('1777', '0', '29', '12', '8', '51', '0', '19118', '20464', '0'),
('1778', '0', '29', '24', '21', '96', '0', '19133', '25504', '0'),
('1779', '0', '92', '5', '4', '60', '0', '19157', '20521', '0'),
('1780', '0', '29', '19', '12', '108', '0', '19160', '19376', '0'),
('1782', '0', '29', '13', '1', '14', '0', '19207', '19213', '0'),
('1785', '0', '29', '19', '4', '25', '0', '19223', '19267', '0'),
('1786', '0', '29', '19', '9', '51', '0', '19228', '19827', '0'),
('1788', '0', '29', '41', '26', '173', '0', '19280', '20149', '0'),
('1789', '0', '29', '0', '11', '59', '0', '19290', '19413', '0'),
('1790', '0', '29', '22', '3', '51', '0', '19312', '19656', '0'),
('1791', '0', '29', '19', '1', '12', '0', '19316', '19336', '0'),
('1793', '0', '15', '0', '12', '56', '0', '19375', '20667', '0'),
('1795', '0', '29', '5', '4', '34', '0', '19383', '19468', '0'),
('1796', '0', '29', '5', '8', '25', '0', '19384', '19959', '0'),
('1797', '0', '29', '5', '15', '68', '0', '19385', '20668', '0'),
('1798', '0', '29', '5', '18', '95', '0', '19386', '20182', '0'),
('1799', '0', '29', '41', '3', '21', '0', '19391', '20159', '0'),
('1800', '0', '29', '0', '12', '98', '0', '19402', '19918', '0'),
('1801', '0', '93', '0', '18', '87', '0', '19403', '19637', '0'),
('1802', '0', '29', '34', '1', '9', '0', '19419', '19420', '0'),
('1803', '0', '29', '0', '4', '31', '1', '19424', '19458', '0'),
('1804', '0', '29', '32', '9', '69', '0', '19430', '20585', '0'),
('1805', '0', '29', '0', '14', '72', '0', '19431', '20215', '0'),
('1806', '0', '29', '32', '3', '29', '0', '19434', '21222', '0'),
('1807', '0', '29', '32', '3', '19', '0', '19435', '23939', '0'),
('1808', '0', '96', '13', '8', '34', '0', '19443', '19520', '0'),
('1809', '0', '103', '28', '7', '67', '0', '19449', '20564', '0'),
('1810', '1', '24', '0', '0', '80', '0', '19471', '19471', '0'),
('1811', '0', '29', '5', '14', '47', '0', '19475', '22335', '0'),
('1812', '0', '29', '0', '44', '325', '0', '19476', '36996', '0'),
('1813', '0', '29', '32', '2', '15', '1', '19478', '19496', '0'),
('1814', '0', '29', '5', '18', '94', '0', '19481', '22204', '1814'),
('1815', '0', '29', '41', '10', '69', '1', '19486', '20619', '0'),
('1816', '0', '29', '13', '14', '93', '0', '19489', '29419', '0'),
('1817', '0', '103', '0', '13', '76', '0', '19529', '20458', '0'),
('1818', '0', '29', '32', '22', '145', '0', '19532', '27176', '0'),
('1819', '0', '29', '32', '9', '51', '1', '19534', '20566', '0'),
('1820', '0', '29', '32', '8', '43', '0', '19537', '20124', '0'),
('1821', '0', '116', '19', '10', '48', '0', '19550', '19627', '0'),
('1823', '0', '131', '32', '0', '99', '0', '19554', '19554', '1823'),
('1824', '0', '108', '39', '2', '27', '0', '19565', '19571', '0'),
('1825', '0', '29', '1', '16', '83', '0', '19578', '21305', '0'),
('1826', '0', '29', '27', '3', '16', '0', '19589', '20055', '0'),
('1827', '0', '29', '35', '20', '100', '0', '19604', '20939', '0'),
('1828', '0', '29', '19', '0', '6', '0', '19605', '19605', '0'),
('1829', '0', '103', '45', '18', '127', '0', '19616', '23540', '0'),
('1830', '0', '29', '19', '8', '48', '0', '19618', '20603', '0'),
('1831', '0', '93', '51', '17', '104', '0', '19638', '26167', '0'),
('1832', '0', '29', '20', '4', '24', '0', '19647', '24413', '0'),
('1833', '0', '92', '5', '19', '133', '0', '19651', '20892', '0'),
('1834', '0', '116', '19', '5', '43', '0', '19655', '24477', '0'),
('1835', '0', '29', '5', '5', '19', '0', '19678', '19729', '0'),
('1837', '0', '108', '44', '7', '69', '0', '19681', '21651', '0'),
('1838', '0', '29', '5', '20', '157', '0', '19693', '22852', '0'),
('1839', '0', '29', '5', '28', '118', '0', '19697', '32431', '0'),
('1840', '0', '29', '5', '12', '47', '0', '19705', '20145', '0'),
('1841', '0', '29', '5', '5', '37', '0', '19708', '19736', '0'),
('1842', '0', '29', '5', '12', '57', '0', '19709', '20726', '0'),
('1844', '0', '116', '5', '9', '52', '0', '19714', '21293', '0'),
('1845', '0', '29', '45', '18', '77', '0', '19747', '19961', '0'),
('1846', '0', '29', '19', '10', '64', '0', '19775', '19947', '0'),
('1848', '0', '29', '13', '2', '25', '0', '19785', '20485', '0'),
('1849', '0', '29', '12', '9', '52', '0', '19868', '20025', '0'),
('1850', '0', '29', '32', '7', '48', '1', '19883', '19934', '0'),
('1851', '0', '29', '29', '10', '56', '0', '19896', '20170', '0'),
('1852', '0', '29', '32', '2', '22', '0', '19943', '19945', '0'),
('1853', '0', '29', '47', '18', '102', '0', '19974', '21465', '0'),
('1854', '0', '29', '47', '15', '105', '0', '19986', '20072', '0'),
('1855', '0', '116', '19', '22', '138', '0', '19997', '21310', '0'),
('1856', '0', '116', '19', '13', '89', '0', '19998', '25411', '0'),
('1857', '0', '29', '32', '6', '51', '0', '20044', '20248', '0'),
('1858', '0', '29', '33', '13', '85', '0', '20066', '21587', '0'),
('1859', '0', '29', '1', '31', '193', '0', '20080', '21320', '0'),
('1860', '0', '29', '1', '2', '18', '0', '20082', '20089', '0'),
('1861', '0', '29', '32', '3', '25', '0', '20104', '20514', '0'),
('1862', '0', '29', '1', '8', '38', '0', '20109', '21125', '0'),
('1863', '0', '93', '41', '19', '148', '0', '20121', '21681', '0'),
('1864', '0', '29', '38', '9', '31', '0', '20130', '20467', '0'),
('1866', '0', '29', '1', '17', '74', '0', '20185', '22474', '0'),
('1867', '0', '131', '33', '0', '119', '0', '20187', '20187', '1867'),
('1868', '1', '57', '1', '33', '228', '0', '20191', '136171', '0'),
('1869', '0', '15', '45', '10', '48', '0', '20199', '21705', '0'),
('1870', '0', '29', '0', '30', '135', '0', '20219', '20567', '0'),
('1871', '0', '29', '0', '15', '89', '0', '20222', '20806', '0'),
('1872', '0', '29', '0', '15', '45', '0', '20223', '21415', '0'),
('1875', '0', '29', '0', '10', '43', '0', '20239', '20515', '1875'),
('1876', '0', '96', '3', '11', '94', '0', '20254', '20946', '1876'),
('1877', '0', '29', '0', '19', '90', '0', '20263', '26538', '0'),
('1878', '0', '15', '11', '16', '74', '0', '20292', '21352', '0'),
('1879', '0', '29', '0', '12', '55', '0', '20296', '21576', '0'),
('1883', '0', '29', '11', '12', '37', '0', '20360', '20453', '0'),
('1884', '0', '29', '0', '19', '100', '0', '20364', '20984', '1884'),
('1885', '0', '29', '11', '11', '68', '0', '20373', '20734', '0'),
('1886', '0', '93', '48', '11', '56', '0', '20386', '21470', '0'),
('1887', '0', '29', '11', '7', '38', '0', '20393', '27014', '0'),
('1888', '0', '29', '29', '10', '54', '0', '20399', '20601', '0'),
('1889', '0', '29', '33', '18', '100', '0', '20436', '28470', '0'),
('1890', '0', '29', '12', '3', '19', '0', '20469', '20525', '0'),
('1891', '0', '29', '45', '8', '44', '0', '20476', '20743', '0'),
('1892', '0', '29', '1', '9', '48', '0', '20481', '21279', '0'),
('1893', '0', '29', '32', '3', '23', '0', '20528', '20580', '0'),
('1894', '0', '29', '36', '7', '43', '1', '20530', '20704', '0'),
('1895', '0', '29', '0', '23', '169', '0', '20569', '20910', '0'),
('1896', '0', '29', '32', '8', '66', '0', '20572', '26075', '0'),
('1897', '0', '15', '41', '23', '154', '0', '20592', '20897', '0'),
('1898', '0', '29', '4', '7', '52', '1', '20642', '20731', '0'),
('1899', '0', '103', '20', '7', '60', '0', '20647', '21386', '0'),
('1901', '0', '29', '13', '3', '21', '0', '20671', '20842', '0'),
('1902', '0', '29', '33', '12', '71', '0', '20677', '26650', '0'),
('1903', '0', '96', '33', '10', '67', '0', '20679', '20953', '0'),
('1906', '0', '29', '0', '10', '53', '0', '20720', '20824', '0'),
('1907', '0', '29', '42', '3', '41', '0', '20728', '21476', '0'),
('1908', '0', '29', '12', '6', '35', '0', '20747', '20828', '0'),
('1909', '0', '15', '12', '12', '66', '0', '20748', '21707', '0'),
('1910', '0', '29', '12', '12', '59', '0', '20753', '24145', '0'),
('1912', '0', '29', '12', '8', '63', '0', '20755', '21553', '0'),
('1914', '0', '116', '12', '5', '51', '0', '20760', '21250', '0'),
('1915', '0', '29', '29', '4', '31', '0', '20761', '20778', '0'),
('1916', '0', '29', '32', '14', '87', '0', '20783', '24476', '1916'),
('1918', '0', '29', '1', '25', '151', '0', '20793', '22617', '0'),
('1919', '0', '15', '32', '8', '41', '0', '20812', '21774', '0'),
('1921', '0', '29', '19', '2', '17', '0', '20830', '20838', '0'),
('1922', '0', '29', '19', '7', '28', '0', '20832', '21805', '0'),
('1923', '0', '29', '13', '16', '116', '0', '20843', '24171', '0'),
('1925', '0', '29', '19', '17', '102', '0', '20848', '21304', '0'),
('1926', '0', '131', '33', '0', '100', '0', '20849', '20849', '1926'),
('1929', '0', '96', '19', '11', '73', '0', '20880', '22123', '0'),
('1930', '0', '29', '28', '12', '89', '0', '20906', '21384', '0'),
('1932', '0', '29', '42', '10', '52', '1', '20949', '32884', '0'),
('1933', '0', '29', '45', '11', '37', '0', '20950', '21199', '0'),
('1934', '0', '20', '33', '48', '640', '1', '20951', '27567', '0'),
('1935', '0', '29', '0', '17', '57', '0', '20956', '25088', '0'),
('1936', '0', '96', '13', '5', '48', '0', '20957', '21154', '0'),
('1937', '0', '29', '13', '2', '9', '0', '20958', '21224', '0'),
('1938', '0', '29', '0', '12', '50', '0', '20960', '21068', '0'),
('1939', '0', '15', '12', '20', '83', '0', '21018', '21166', '0'),
('1940', '0', '15', '11', '14', '55', '0', '21021', '21708', '0'),
('1941', '0', '116', '11', '10', '57', '0', '21032', '21299', '0'),
('1944', '0', '29', '5', '12', '74', '0', '21135', '33934', '1944'),
('1945', '0', '29', '32', '15', '73', '0', '21148', '21291', '0'),
('1946', '0', '29', '5', '15', '69', '0', '21171', '21373', '0'),
('1947', '0', '29', '0', '6', '25', '1', '21203', '21364', '0'),
('1948', '0', '116', '19', '1', '20', '0', '21223', '21252', '0'),
('1949', '0', '29', '0', '15', '63', '0', '21236', '21321', '0'),
('1950', '0', '116', '19', '1', '18', '0', '21307', '21541', '0'),
('1951', '0', '96', '11', '6', '48', '0', '21314', '21329', '0'),
('1952', '0', '103', '0', '6', '67', '0', '21324', '21366', '0'),
('1954', '0', '29', '45', '7', '37', '0', '21356', '23808', '0'),
('1955', '0', '29', '32', '9', '56', '0', '21359', '21451', '0'),
('1956', '0', '104', '32', '3', '75', '1', '21370', '21777', '0'),
('1957', '0', '108', '1', '6', '35', '0', '21372', '21392', '0'),
('1958', '0', '29', '0', '9', '52', '0', '21375', '24559', '0'),
('1959', '0', '29', '0', '8', '74', '0', '21387', '21603', '0'),
('1960', '0', '29', '32', '4', '35', '0', '21395', '21540', '0'),
('1961', '0', '29', '32', '7', '26', '0', '21396', '32319', '0'),
('1962', '0', '29', '32', '8', '34', '1', '21397', '21463', '0'),
('1963', '0', '29', '32', '7', '50', '0', '21398', '26077', '0'),
('1964', '0', '29', '32', '4', '28', '0', '21400', '24176', '0'),
('1965', '0', '108', '45', '5', '30', '0', '21409', '24664', '0'),
('1966', '0', '93', '49', '25', '129', '0', '21417', '23869', '0'),
('1967', '0', '15', '0', '13', '70', '0', '21426', '24066', '0'),
('1968', '0', '112', '5', '7', '53', '0', '21429', '26523', '0'),
('1969', '0', '29', '13', '1', '8', '0', '21431', '21733', '0'),
('1970', '0', '29', '0', '3', '19', '0', '21452', '21457', '0'),
('1971', '0', '29', '12', '2', '12', '0', '21464', '21549', '0'),
('1972', '0', '103', '22', '4', '40', '0', '21467', '21674', '0'),
('1973', '0', '29', '0', '5', '58', '0', '21472', '22251', '0'),
('1974', '0', '29', '12', '11', '74', '0', '21480', '21712', '0'),
('1975', '0', '108', '0', '7', '30', '0', '21482', '21534', '0'),
('1976', '0', '29', '12', '1', '8', '0', '21483', '21484', '0'),
('1978', '0', '29', '0', '15', '82', '0', '21496', '21725', '0'),
('1980', '0', '15', '6', '15', '70', '0', '21523', '22413', '0'),
('1981', '0', '29', '33', '14', '72', '0', '21527', '24807', '0'),
('1982', '0', '29', '17', '4', '30', '0', '21531', '21544', '0'),
('1983', '0', '29', '1', '6', '47', '0', '21542', '21562', '0'),
('1984', '0', '29', '0', '7', '72', '0', '21545', '21682', '0'),
('1985', '0', '29', '1', '8', '29', '0', '21559', '22411', '0'),
('1986', '0', '29', '0', '15', '116', '0', '21568', '27223', '0'),
('1987', '0', '93', '0', '23', '116', '0', '21580', '22087', '0'),
('1988', '0', '29', '0', '15', '129', '0', '21604', '29016', '0'),
('1989', '0', '29', '22', '19', '150', '0', '21610', '26250', '0'),
('1990', '0', '93', '3', '24', '170', '1', '21611', '27778', '0'),
('1991', '0', '29', '22', '3', '30', '0', '21615', '21662', '0'),
('1992', '0', '29', '0', '7', '41', '1', '21619', '23537', '0'),
('1993', '0', '29', '13', '13', '57', '0', '21624', '27521', '0'),
('1994', '0', '29', '1', '2', '26', '0', '21634', '21701', '0'),
('1996', '0', '29', '32', '7', '35', '0', '21669', '21862', '0'),
('1997', '0', '29', '32', '4', '20', '1', '21676', '22124', '0'),
('1998', '0', '29', '19', '6', '41', '0', '21691', '22243', '0'),
('1999', '0', '29', '32', '5', '26', '0', '21693', '22138', '0'),
('2000', '0', '29', '19', '6', '23', '0', '21698', '21931', '0'),
('2001', '0', '103', '37', '12', '84', '0', '21716', '38110', '0'),
('2002', '0', '29', '22', '5', '39', '1', '21721', '22089', '0'),
('2003', '0', '29', '0', '12', '48', '0', '21728', '24153', '0'),
('2004', '0', '103', '14', '16', '108', '0', '21739', '21983', '0'),
('2005', '0', '29', '0', '8', '57', '0', '21749', '22267', '0'),
('2006', '0', '15', '34', '11', '59', '0', '21754', '22483', '0'),
('2007', '0', '29', '13', '4', '19', '0', '21778', '22157', '0'),
('2008', '0', '29', '33', '9', '43', '0', '21787', '22780', '0'),
('2009', '0', '29', '45', '14', '68', '0', '21803', '26954', '0'),
('2011', '0', '29', '0', '9', '29', '0', '21843', '23550', '0'),
('2015', '0', '29', '5', '17', '69', '0', '21878', '22876', '0'),
('2016', '0', '15', '19', '8', '55', '0', '21879', '24232', '0'),
('2017', '0', '29', '5', '3', '22', '0', '21881', '30236', '0'),
('2018', '0', '29', '5', '4', '19', '0', '21885', '21904', '0'),
('2019', '0', '29', '5', '14', '77', '0', '21891', '26568', '0'),
('2020', '0', '29', '5', '13', '81', '0', '21900', '22387', '0'),
('2021', '0', '29', '5', '3', '21', '0', '21907', '21945', '0'),
('2022', '0', '29', '5', '7', '35', '0', '21911', '22316', '0'),
('2023', '0', '29', '5', '3', '15', '0', '21913', '22084', '0'),
('2024', '0', '29', '36', '8', '62', '0', '21914', '23683', '0'),
('2025', '0', '29', '19', '14', '72', '0', '21916', '22818', '0'),
('2026', '0', '29', '0', '45', '291', '1', '21918', '22899', '0'),
('2027', '0', '29', '17', '12', '69', '0', '21922', '22840', '0'),
('2028', '0', '29', '32', '18', '66', '0', '21935', '23081', '0'),
('2029', '0', '29', '0', '19', '118', '0', '21944', '29004', '0'),
('2030', '0', '29', '19', '14', '91', '0', '21950', '22384', '0'),
('2032', '0', '103', '47', '6', '48', '0', '21960', '22391', '0'),
('2033', '0', '103', '47', '7', '51', '0', '21968', '22715', '0'),
('2035', '0', '29', '47', '10', '50', '0', '21974', '22553', '0'),
('2036', '0', '103', '47', '4', '41', '0', '21978', '21998', '0'),
('2037', '0', '103', '47', '4', '46', '0', '21984', '22015', '0'),
('2038', '0', '103', '36', '5', '68', '0', '21985', '34439', '0'),
('2039', '0', '29', '47', '8', '73', '0', '21994', '24200', '0'),
('2040', '0', '29', '0', '24', '189', '0', '22002', '23025', '0'),
('2041', '0', '29', '0', '15', '50', '0', '22030', '23940', '0'),
('2042', '0', '29', '0', '21', '95', '0', '22032', '29682', '0'),
('2044', '0', '29', '47', '19', '96', '0', '22054', '22891', '2044'),
('2045', '0', '29', '0', '10', '59', '0', '22091', '24703', '0'),
('2046', '0', '29', '19', '23', '143', '0', '22097', '26585', '0'),
('2047', '0', '29', '0', '10', '49', '0', '22099', '22495', '0'),
('2048', '0', '93', '50', '21', '111', '0', '22100', '27587', '0'),
('2049', '0', '29', '0', '12', '45', '0', '22110', '23670', '0'),
('2050', '0', '29', '0', '10', '55', '0', '22130', '22681', '0'),
('2051', '0', '29', '1', '8', '59', '0', '22137', '22678', '0'),
('2052', '0', '29', '31', '29', '156', '0', '22161', '24167', '0'),
('2053', '0', '116', '9', '21', '120', '0', '22177', '24617', '0'),
('2054', '0', '29', '9', '10', '54', '0', '22211', '22419', '0'),
('2055', '0', '29', '0', '3', '33', '0', '22272', '22297', '0'),
('2056', '0', '15', '9', '11', '37', '0', '22274', '22380', '0'),
('2057', '0', '29', '1', '11', '38', '0', '22287', '22606', '0'),
('2058', '0', '29', '3', '14', '73', '0', '22293', '22869', '0'),
('2060', '0', '29', '1', '10', '61', '0', '22298', '24900', '0'),
('2061', '0', '29', '1', '10', '55', '0', '22303', '23983', '0'),
('2062', '0', '96', '1', '9', '55', '0', '22310', '26768', '0'),
('2063', '0', '29', '31', '15', '70', '0', '22329', '25695', '0'),
('2064', '0', '29', '1', '19', '92', '0', '22332', '24148', '0'),
('2065', '0', '29', '32', '13', '64', '0', '22348', '22853', '0'),
('2066', '0', '29', '6', '18', '85', '0', '22361', '23556', '0'),
('2067', '0', '29', '0', '7', '29', '0', '22367', '22690', '0'),

EDIT - use code tag.

JayBachatero

What is the error at the end of the page?  Duplicate key?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

weec

#11
QuoteConverting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.

this steps is maked double personal messages

JayBachatero

Quote from: weec on January 11, 2007, 11:58:28 PM
QuoteConverting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Quote

this steps is maked double personal messages
There are two steps in pm conversion.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

weec

#13
ok, i am tryed new  convert.php January 10, 2007


zamorc

How long should it take to convert xmb forum with about 80.000 posts, 500 members? My is working now more than 15 hours???

weec

#15
yes
80.000 - very big base
try convert your base on local mashine

JayBachatero

It shouldn't take that long.  What step are you up to?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

zamorc

try convert your base on local mashine
It means I need to install mysql and php. I am not sure I am sure that I can do this.

What step are you up to?
I don't know what do you mean.


themortalgod

#18
I recently tried to convert from XMB to SMF, I run the converter and it loads for  about 10 min then i get a blank white page and the message "done" in the status bar, when i go to my installation of SMF it has succesfully copied over the usernames and passwords, created 1 of 8 boards, but not copied any of the posts over,  I have tried a couple times and everytime it seems to only copy the same amount of data

the board i am copying has about 150 000 posts and about 7000 users if that effects anything

zamorc

#19
I have just received a message: (is there anything I can do and before I click "try again")

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Unsuccessful!
This query:

    INSERT INTO `zanimiv_smf`.zanimiv_log_notify
    (ID_MEMBER, ID_TOPIC)
    VALUES ('1', '30'),
    ('1', '34'),
    ('1', '38'),
    ('1', '57'),
    ('1', '74'),
    ('1', '86'),
    ('1', '105'),
    ('1', '108'),
    ('1', '109'),
    ('1', '110'),
    ('1', '130'),
    ('1', '142'),
    ('1', '160'),
    ('1', '162'),
    ('1', '166'),
    ('1', '182'),
    ('1', '193'),
    ('1', '196'),
    ('1', '204'),
    ('1', '206'),
    ('1', '227'),
    ('38', '12'),
    ('17', '7'),
    ('17', '1'),
    ('17', '1350'),
    ('376', '2878'),
    ('20', '94'),
    ('385', '1566'),
    ('47', '96'),
    ('47', '2046'),
    ('47', '71'),
    ('47', '4126'),
    ('47', '257'),
    ('47', '1269'),
    ('48', '560'),
    ('54', '120'),
    ('77', '2860'),
    ('77', '2705'),
    ('77', '2852'),
    ('77', '2569'),
    ('77', '2850'),
    ('90', '382'),
    ('90', '268'),
    ('91', '105'),
    ('91', '825'),
    ('94', '8'),
    ('277', '1049'),
    ('99', '2271'),
    ('99', '135'),
    ('99', '180'),
    ('100', '105'),
    ('116', '1170'),
    ('116', '1779'),
    ('116', '2868'),
    ('473', '1337'),
    ('122', '105'),
    ('131', '60'),
    ('131', '120'),
    ('135', '105'),
    ('158', '1666'),
    ('162', '71'),
    ('162', '643'),
    ('162', '71'),
    ('162', '307'),
    ('162', '71'),
    ('173', '3069'),
    ('206', '46'),
    ('210', '2096'),
    ('210', '1795'),
    ('210', '1921'),
    ('215', '1079'),
    ('215', '1759'),
    ('215', '1079'),
    ('219', '251'),
    ('229', '357'),
    ('229', '564'),
    ('229', '3479'),
    ('229', '933'),
    ('229', '1944'),
    ('229', '1421'),
    ('229', '1289'),
    ('229', '1458'),
    ('229', '1813'),
    ('229', '3097'),
    ('229', '2835'),
    ('229', '2877'),
    ('229', '1973'),
    ('229', '424'),
    ('229', '2204'),
    ('229', '3717'),
    ('229', '3612'),
    ('229', '3808'),
    ('229', '3819'),
    ('229', '3262'),
    ('264', '1973'),
    ('264', '306'),
    ('264', '2046'),
    ('264', '385'),
    ('264', '930'),
    ('264', '102'),
    ('264', '1011'),
    ('264', '50'),
    ('264', '794'),
    ('264', '927'),
    ('264', '1645'),
    ('263', '1774'),
    ('285', '766'),
    ('285', '71'),
    ('318', '685'),
    ('319', '3248'),
    ('415', '1017'),
    ('415', '43'),
    ('415', '2370'),
    ('415', '1041'),
    ('415', '1716'),
    ('342', '1676'),
    ('541', '1679'),
    ('394', '1326'),
    ('397', '1158'),
    ('397', '4209'),
    ('404', '2424'),
    ('404', '3262'),
    ('406', '71'),
    ('422', '2402'),
    ('422', '2195'),
    ('422', '424'),
    ('422', '424'),
    ('422', '2402'),
    ('422', '1892'),
    ('422', '1269'),
    ('422', '2419'),
    ('422', '448'),
    ('422', '2372'),
    ('422', '2456'),
    ('430', '448'),
    ('452', '1356'),
    ('466', '1277'),
    ('466', '1289'),
    ('466', '1361'),
    ('466', '1440'),
    ('466', '1449'),
    ('466', '1458'),
    ('466', '307'),
    ('464', '2550'),
    ('464', '2204'),
    ('464', '3262'),
    ('484', '1437'),
    ('484', '1373'),
    ('484', '1480'),
    ('670', '1637'),
    ('671', '2363'),
    ('866', '3692'),
    ('737', '3105'),
    ('499', '1931'),
    ('499', '1011'),
    ('499', '253'),
    ('499', '1011'),
    ('499', '1572'),
    ('499', '1225'),
    ('499', '1734'),
    ('499', '1716'),
    ('499', '1381'),
    ('499', '1378'),
    ('499', '1311'),
    ('499', '335'),
    ('499', '71'),
    ('499', '876'),
    ('499', '4172'),
    ('499', '844'),
    ('499', '1269'),
    ('499', '1379'),
    ('499', '1419'),
    ('499', '155'),
    ('499', '1779'),
    ('499', '307'),
    ('499', '1447'),
    ('499', '1430'),
    ('499', '2901'),
    ('499', '1779'),
    ('499', '2023'),
    ('499', '3262'),
    ('499', '1816'),
    ('499', '1817'),
    ('499', '1057'),
    ('499', '1241'),
    ('499', '1430'),
    ('499', '1181'),
    ('499', '910'),
    ('499', '71'),
    ('499', '1546'),
    ('499', '2702'),
    ('499', '1847'),
    ('499', '1848'),
    ('499', '1196'),
    ('499', '1610'),
    ('499', '2730'),
    ('499', '1136'),
    ('499', '2198'),
    ('499', '2826'),
    ('499', '4201'),
    ('499', '2971'),
    ('499', '1921'),
    ('499', '3096'),
    ('499', '3049'),
    ('499', '1637'),
    ('499', '3780'),
    ('499', '3036'),
    ('499', '3157'),
    ('499', '1041'),
    ('499', '3042'),
    ('499', '2736'),
    ('499', '3361'),
    ('499', '1954'),
    ('499', '1942'),
    ('499', '2046'),
    ('499', '2071'),
    ('499', '3222'),
    ('499', '3224'),
    ('499', '3199'),
    ('499', '1214'),
    ('499', '811'),
    ('499', '2932'),
    ('499', '593'),
    ('499', '2765'),
    ('499', '2482'),
    ('499', '1802'),
    ('499', '1843'),
    ('499', '3190'),
    ('499', '3130'),
    ('499', '3082'),
    ('499', '3092'),
    ('499', '50'),
    ('499', '280'),
    ('499', '1629'),
    ('499', '1970'),
    ('499', '2685'),
    ('499', '191'),
    ('499', '1921'),
    ('499', '3247'),
    ('499', '3420'),
    ('499', '2238'),
    ('499', '3253'),
    ('499', '1091'),
    ('499', '2780'),
    ('499', '1011'),
    ('499', '687'),
    ('499', '2768'),
    ('499', '3428'),
    ('499', '2677'),
    ('499', '3603'),
    ('499', '1892'),
    ('499', '353'),
    ('499', '3291'),
    ('499', '354'),
    ('499', '619'),
    ('499', '1897'),
    ('499', '3401'),
    ('499', '3336'),
    ('499', '3014'),
    ('499', '3416'),
    ('499', '43'),
    ('499', '3260'),
    ('499', '3350'),
    ('499', '3576'),
    ('499', '3553'),
    ('499', '3664'),
    ('499', '3653'),
    ('499', '2046'),
    ('499', '3654'),
    ('499', '3591'),
    ('499', '2204'),
    ('499', '3715'),
    ('499', '3721'),
    ('499', '1559'),
    ('499', '1624'),
    ('499', '1851'),
    ('499', '1413'),
    ('499', '3290'),
    ('499', '3656'),
    ('499', '3324'),
    ('499', '3723'),
    ('499', '3338'),
    ('499', '3736'),
    ('499', '3744'),
    ('499', '1248'),
    ('499', '1278'),
    ('499', '794'),
    ('499', '535'),
    ('499', '3743'),
    ('499', '2673'),
    ('499', '1985'),
    ('499', '3749'),
    ('499', '3506'),
    ('499', '2885'),
    ('499', '667'),
    ('499', '3669'),
    ('499', '3764'),
    ('499', '3760'),
    ('499', '1362'),
    ('499', '3683'),
    ('499', '1213'),
    ('499', '2802'),
    ('499', '3758'),
    ('499', '3655'),
    ('499', '231'),
    ('499', '347'),
    ('499', '361'),
    ('499', '3252'),
    ('499', '3612'),
    ('499', '3703'),
    ('499', '3259'),
    ('499', '3634'),
    ('499', '2030'),
    ('499', '35'),
    ('499', '2636'),
    ('499', '3304'),
    ('499', '3684'),
    ('499', '900'),
    ('499', '3289'),
    ('499', '261'),
    ('499', '3725'),
    ('499', '1549'),
    ('499', '424'),
    ('499', '615'),
    ('499', '2536'),
    ('499', '2082'),
    ('499', '3633'),
    ('499', '3320'),
    ('499', '3271'),
    ('499', '254'),
    ('499', '3108'),
    ('499', '1947'),
    ('499', '1902'),
    ('499', '1236'),
    ('499', '3484'),
    ('499', '3710'),
    ('499', '3197'),
    ('499', '3766'),
    ('499', '3502'),
    ('499', '3451'),
    ('499', '1956'),
    ('499', '2379'),
    ('499', '3145'),
    ('499', '3342'),
    ('499', '2956'),
    ('499', '3783'),
    ('499', '1742'),
    ('499', '3326'),
    ('499', '2622'),
    ('499', '4344'),
    ('499', '1015'),
    ('499', '2064'),
    ('499', '1713'),
    ('499', '3031'),
    ('499', '3552'),
    ('499', '1892'),
    ('499', '1973'),
    ('499', '146'),
    ('499', '3503'),
    ('499', '3495'),
    ('499', '3446'),
    ('499', '2034'),
    ('499', '3296'),
    ('499', '3699'),
    ('499', '2619'),
    ('499', '3496'),
    ('499', '1838'),
    ('499', '1555'),
    ('499', '1894'),
    ('499', '1004'),
    ('499', '3790'),
    ('499', '3226'),
    ('499', '3851'),
    ('499', '3732'),
    ('499', '3731'),
    ('499', '3302'),
    ('499', '3102'),
    ('499', '3023'),
    ('499', '2422'),
    ('499', '2247'),
    ('499', '1779'),
    ('499', '71'),
    ('499', '3557'),
    ('499', '3794'),
    ('499', '3793'),
    ('499', '3788'),
    ('499', '3801'),
    ('499', '3800'),
    ('499', '222'),
    ('499', '1113'),
    ('499', '3799'),
    ('499', '3795'),
    ('499', '1512'),
    ('499', '3775'),
    ('499', '805'),
    ('499', '1503'),
    ('499', '1233'),
    ('499', '3798'),
    ('499', '3806'),
    ('499', '3808'),
    ('499', '3809'),
    ('499', '3089'),
    ('499', '4190'),
    ('499', '4341'),
    ('499', '3813'),
    ('499', '1134'),
    ('499', '3820'),
    ('499', '3927'),
    ('499', '3882'),
    ('499', '3946'),
    ('499', '3283'),
    ('499', '3878'),
    ('499', '1689'),
    ('499', '3845'),
    ('499', '3894'),
    ('499', '1944'),
    ('499', '3084'),
    ('499', '3914'),
    ('499', '1839'),
    ('499', '961'),
    ('499', '448'),
    ('499', '3825'),
    ('499', '1259'),
    ('499', '2651'),
    ('499', '3839'),
    ('499', '3827'),
    ('499', '3868'),
    ('499', '3853'),
    ('499', '3840'),
    ('499', '3804'),
    ('499', '3915'),
    ('499', '3917'),
    ('499', '3925'),
    ('499', '3921'),
    ('499', '1757'),
    ('499', '3919'),
    ('499', '1188'),
    ('499', '584'),
    ('499', '3968'),
    ('499', '3963'),
    ('499', '3986'),
    ('499', '767'),
    ('499', '3874'),
    ('499', '3930'),
    ('499', '2004'),
    ('499', '3982'),
    ('499', '3985'),
    ('499', '2185'),
    ('499', '3987'),
    ('499', '1741'),
    ('499', '2118'),
    ('499', '2550'),
    ('499', '4000'),
    ('499', '543'),
    ('499', '4001'),
    ('499', '4005'),
    ('499', '3904'),
    ('499', '3937'),
    ('499', '3857'),
    ('499', '4007'),
    ('499', '3753'),
    ('499', '2698'),
    ('499', '3817'),
    ('499', '3828'),
    ('499', '1428'),
    ('499', '4025'),
    ('499', '3916'),
    ('499', '4018'),
    ('499', '4052'),
    ('499', '4053'),
    ('499', '4058'),
    ('499', '3984'),
    ('499', '3125'),
    ('499', '3711'),
    ('499', '3700'),
    ('499', '3122'),
    ('499', '2918'),
    ('499', '4055'),
    ('499', '3912'),
    ('499', '3967'),
    ('499', '4004'),
    ('499', '4047'),
    ('499', '3929'),
    ('499', '3945'),
    ('499', '4326'),
    ('499', '368'),
    ('499', '3842'),
    ('499', '3970'),
    ('499', '4099'),
    ('499', '3862'),
    ('499', '945'),
    ('499', '3737'),
    ('499', '4322'),
    ('499', '684'),
    ('499', '3936'),
    ('499', '3955'),
    ('499', '1041'),
    ('499', '4092'),
    ('499', '4105'),
    ('499', '1903');

Caused the error:

    Duplicate entry '162-71-0' for key 1


EDIT: Used code tag.

Advertisement: