Advertisement:

Author Topic: [SMF Converter] XMB - 1.9.8  (Read 100027 times)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
[SMF Converter] XMB - 1.9.8
« on: January 08, 2007, 09:21:48 AM »
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.
« Last Edit: July 18, 2009, 03:01:21 PM by TE »
Follow me on Twitter

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

Offline weec

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] XMB - 1.9.6
« Reply #1 on: January 08, 2007, 02:39:48 PM »
yes, standart converter have this trouble "255 characters"
i am trying new converter

Quote
Converting...
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
« Last Edit: January 09, 2007, 12:58:00 AM by weec »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] XMB - 1.9.6
« Reply #2 on: January 08, 2007, 03:17:01 PM »
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

Offline weec

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] XMB - 1.9.6
« Reply #3 on: January 08, 2007, 03:36:28 PM »
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
« Last Edit: January 08, 2007, 03:38:26 PM by weec »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] XMB - 1.9.6
« Reply #4 on: January 08, 2007, 03:46:55 PM »
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

Offline weec

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] XMB - 1.9.6
« Reply #5 on: January 08, 2007, 11:56:26 PM »
I can send mysqldump of forum`s databases xmb & smf
to your E-mail

OK?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] XMB - 1.9.6
« Reply #6 on: January 09, 2007, 12:15:02 AM »
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

Offline weec

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] XMB - 1.9.6
« Reply #7 on: January 09, 2007, 01:15:37 AM »
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)
« Last Edit: January 09, 2007, 04:19:39 AM by weec »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] XMB - 1.9.6
« Reply #8 on: January 09, 2007, 08:39:54 AM »
Replied to the email.
Follow me on Twitter

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

Offline babyjuker

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] XMB - 1.9.6
« Reply #9 on: January 11, 2007, 11:33:32 AM »
i keep getting this error when converting

Converting topics... Unsuccessful!
This query:
Code: [Select]
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.
« Last Edit: January 14, 2007, 07:45:32 PM by JayBachatero »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] XMB - 1.9.6
« Reply #10 on: January 11, 2007, 01:39:45 PM »
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

Offline weec

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] XMB - 1.9.6
« Reply #11 on: January 11, 2007, 11:58:28 PM »
Quote
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.

this steps is maked double personal messages
« Last Edit: January 12, 2007, 01:28:17 AM by weec »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] XMB - 1.9.6
« Reply #12 on: January 12, 2007, 12:00:11 AM »
Quote
Converting 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

Offline weec

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] XMB - 1.9.6
« Reply #13 on: January 12, 2007, 01:36:58 AM »
ok, i am tryed new  convert.php January 10, 2007

« Last Edit: January 12, 2007, 04:22:06 PM by weec »

Offline zamorc

  • Semi-Newbie
  • *
  • Posts: 29
Re: [SMF Converter] XMB - 1.9.6
« Reply #14 on: January 13, 2007, 05:14:13 AM »
How long should it take to convert xmb forum with about 80.000 posts, 500 members? My is working now more than 15 hours???

Offline weec

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] XMB - 1.9.6
« Reply #15 on: January 13, 2007, 09:50:53 AM »
yes
80.000 - very big base
try convert your base on local mashine
« Last Edit: January 13, 2007, 09:52:39 AM by weec »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] XMB - 1.9.6
« Reply #16 on: January 13, 2007, 01:57:56 PM »
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

Offline zamorc

  • Semi-Newbie
  • *
  • Posts: 29
Re: [SMF Converter] XMB - 1.9.6
« Reply #17 on: January 13, 2007, 04:15:46 PM »
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.


Offline themortalgod

  • Semi-Newbie
  • *
  • Posts: 28
Re: [SMF Converter] XMB - 1.9.6
« Reply #18 on: January 13, 2007, 04:50:28 PM »
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
« Last Edit: January 13, 2007, 04:53:29 PM by themortalgod »

Offline zamorc

  • Semi-Newbie
  • *
  • Posts: 29
Re: [SMF Converter] XMB - 1.9.6
« Reply #19 on: January 13, 2007, 06:37:52 PM »
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:
Code: [Select]
    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.
« Last Edit: January 14, 2007, 12:05:50 AM by JayBachatero »