[SMF Converter] MyBB 1.2.x

[JayBachatero]

What is the exact error that you get?  Seems like it got cut off from the post. Just post the last part to the error.

What version of MyBB are you running?

[el canadiano]

MyBB 1.2.10

[JayBachatero]

Of course. I was also getting Curiousgeo's error too, but took Fog's advice and that error was fixed.

The converter in the first post should not give you that error.  I just downloaded it to double check and that line is not in the file.

I noticed that the password field is empty for the users that you posted.  What is the error that you are getting now?  I don't see the error since it got cut off.

[el canadiano]

It was something about member 2001. Let me retry and see what's happening

EDIT: nvm, I got it fixed, thanks for SMF. Top free forum Software (though MyBB comes a close second)
EDIT: I have to do it again, cus it isn't working.

[el canadiano]

BTW, the error was

INSERT INTO `stone_smf`.smf_members
(ID_MEMBER, memberName, realName, emailAddress, passwd, passwordSalt, posts, usertitle, lastLogin, ID_GROUP, dateRegistered, websiteUrl, websiteTitle, ICQ, AIM, YIM, MSN, signature, hideEmail, buddy_list, memberIP, memberIP2, pm_ignore_list, totalTimeLoggedIn, birthdate)
VALUES ('2062', 'Jibaro', 'Jibaro', '[email protected]', '', '[jR9m', '0', '', '1173221496', '0', '1173221451', '', '', '0', '', '', '', '', 'yes', '', '75.21.67.136', '75.21.67.136', '', '0', '----'),
('2063', 'sureshisgreat', 'sureshisgreat', '[email protected]', '', '7AfPD', '0', '', '1176763601', '0', '1173221638', '', '', '0', '', '', '', '', 'yes', '', '91.4.86.117', '91.4.86.117', '', '0', '----'),
('2064', 'Luminux', 'Luminux', '[email protected]', '', 'Ziv`o', '0', '', '1173756259', '0', '1173224779', '', '', '0', '', '', '', '', 'yes', '', '74.13.110.19', '74.13.110.19', '', '0', '----'),
('2065', 'lyrical_headspin', 'lyrical_headspin', '[email protected]', '', 'KIc\"d', '1', '', '1173333634', '0', '1173333607', '', '', '0', '', '', '', '', 'yes', '', '158.136.163.110', '158.136.163.110', '', '0', '----'),
('2066', 'webspinner', 'webspinner', '[email protected]', '', 'xGk*5', '0', '', '1173367632', '0', '1173367595', '', '', '0', '', '', '', '', 'yes', '', '72.1.206.12', '72.1.206.12', '', '0', '----'),
('2067', 'hollathina', 'hollathina', '[email protected]', '', 'cQZ>?', '0', '', '1173385799', '0', '1173385765', '', '', '0', '', '', '', '', 'yes', '', '82.152.204.39', '82.152.204.39', '', '0', '----'),
('2068', 'stokesg', 'stokesg', '[email protected]', '', ']d_xK', '0', '', '1173388551', '0', '1173388157', '', '', '0', '', '', '', '', 'yes', '', '62.253.128.12', '62.253.128.12', '', '0', '----'),
('2069', 'Brillig', 'Brillig', '[email protected]', '', 't*gwx', '3', '', '1174336859', '0', '1173388839', '', '', '0', '', '', '', '', 'yes', '', '72.54.129.226', '72.54.129.226', '', '0', '----'),
('2070', 'miki', 'miki', '[email protected]', '', '_mruR', '0', '', '1173451748', '0', '1173451661', '', '', '0', '', '', '', '', 'yes', '', '84.2.150.192', '84.2.150.192', '', '0', '----'),
('2071', 'bartinjapan', 'bartinjapan', '[email protected]', '', 'Tc-p8', '0', '', '1176988532', '0', '1173492760', '', '', '0', '', '', '', '', 'yes', '', '124.26.164.2', '124.26.164.2', '', '0', '----'),
('2072', 'forget.regret', 'forget.regret', '[email protected]', '', 'O&B\"R', '0', '', '1173518483', '0', '1173518458', '', '', '0', '', '', '', '', 'yes', '', '75.71.244.177', '75.71.244.177', '', '0', '----'),
('2073', 'oliversam123', 'oliversam123', '[email protected]', '', '-%}\'4', '0', '', '1173466610', '0', '1173466584', '', '', '0', '', '', '', '', 'yes', '', '82.36.105.112', '82.36.105.112', '', '0', '----'),
('2074', 'simpsonsfan102', 'simpsonsfan102', '[email protected]', '', '/^ynC', '0', '', '1173665982', '0', '1173665967', '', '', '0', '', '', '', '', 'yes', '', '209.162.47.60', '209.162.47.60', '', '0', '----'),
('2075', 'cooltown', 'cooltown', '[email protected]', '', 'cnt|K', '0', '', '1173561667', '0', '1173561603', '', '', '0', '', '', '', '', 'yes', '', '59.92.130.181', '59.92.130.181', '', '0', '----'),
('2076', 'K3vin', 'K3vin', '[email protected]', '', 'j2gWG', '0', '', '1175696514', '0', '1175696494', '', '', '0', '', '', '', '', 'yes', '', '84.99.7.210', '84.99.7.210', '', '0', '----'),
('2077', 'twingats54', 'twingats54', '[email protected]', '', ')jHJZ', '0', '', '1173669452', '0', '1173669418', '', '', '0', '', '', '', '', 'yes', '', '67.37.190.23', '67.37.190.23', '', '0', '----'),
('2078', 'flavinoska', 'flavinoska', '[email protected]', '', 'RA;9O', '0', '', '1173783192', '0', '1173674380', '', '', '0', '', '', '', '', 'yes', '', '82.240.203.4', '82.240.203.4', '', '0', '----'),
('2079', 'poiuytre', 'poiuytre', '[email protected]', '', '(ju6`', '0', '', '1173815740', '0', '1173748700', '', '', '0', '', '', '', '', 'yes', '', '84.196.242.33', '84.196.242.33', '', '0', '----'),
('2080', 'someone', 'someone', '[email protected]', '', '+nb9j', '0', '', '1177011811', '0', '1173693009', '', '', '0', '', '', '', '', 'yes', '', '88.105.54.217', '88.105.54.217', '', '0', '----'),
('2081', 'simpson boy', 'simpson boy', '[email protected]', '', ';ne\"H', '0', '', '1174070735', '0', '1174070700', '', '', '0', '', '', '', '', 'yes', '', '81.77.104.151', '81.77.104.151', '', '0', '----'),
('2082', 'Vaibhav007', 'Vaibhav007', '[email protected]', '', 'xhnFE', '0', '', '1173793410', '0', '1173793373', '', '', '0', '', '', '', '', 'yes', '', '59.178.83.202', '59.178.83.202', '', '0', '----'),
('2083', 'stappo', 'stappo', '[email protected]', '', 'UyyYh', '0', '', '1173819908', '0', '1173819883', '', '', '0', '', '', '', '', 'yes', '', '84.197.50.31', '84.197.50.31', '', '0', '----'),
('2084', 'nix', 'nix', '[email protected]', '', '`5ze^', '0', '', '1173835362', '0', '1173835329', '', '', '0', '', '', '', '', 'yes', '', '200.116.173.103', '200.116.173.103', '', '0', '----'),
('2085', 'jn1978', 'jn1978', '[email protected]', '', 'AeX7G', '0', '', '1173876389', '0', '1173876366', '', '', '0', '', '', '', '', 'yes', '', '82.233.53.142', '82.233.53.142', '', '0', '----'),
('2086', 'Jimbob2110', 'Jimbob2110', '[email protected]', '', '|VIVz', '0', '', '1173890450', '0', '1173889655', '', '', '0', '', '', '', '', 'yes', '', '86.7.64.178', '86.7.64.178', '', '0', '----'),
('2087', 'pyro666', 'pyro666', '[email protected]', '', '-\"S|(', '0', '', '1174209491', '0', '1173899947', '', '', '0', '', '', '', '', 'yes', '', '221.135.251.166', '221.135.251.166', '', '0', '----'),
('2088', 'BadCase', 'BadCase', '[email protected]', '', 'FS<|b', '0', '', '1173979335', '0', '1173979315', '', '', '0', '', '', '', '', 'yes', '', '70.190.147.10', '70.190.147.10', '', '0', '----'),
('2089', 'benj_au', 'benj_au', '[email protected]', '', '/!^^?', '0', '', '1174110501', '0', '1174110469', '', '', '0', '', '', '', '', 'yes', '', '203.214.147.224', '203.214.147.224', '', '0', '----'),
('2090', 'mcilroga', 'mcilroga', '[email protected]', '', '8-|^Y', '0', '', '1174016583', '0', '1174016571', '', '', '0', '', '', '', '', 'yes', '', '74.114.67.102', '74.114.67.102', '', '0', '----'),
('2091', 'NightTerrors', 'NightTerrors', '[email protected]', '', 'X-E2V', '0', '', '0', '0', '1174083639', '', '', '0', '', '', '', '', 'yes', '', '124.183.225.246', '124.183.225.246', '', '0', '----'),
('2092', 'ronroms', 'ronroms', '[email protected]', '', 'snv2G', '0', '', '1174088319', '0', '1174088308', '', '', '0', '', '', '', '', 'yes', '', '201.143.81.254', '201.143.81.254', '', '0', '----'),
('2093', 'Shen', 'Shen', '[email protected]', '', 'GL*rm', '0', '', '1174112043', '0', '1174111989', '', '', '0', '', '', '', '', 'yes', '', '74.241.165.226', '74.241.165.226', '', '0', '----'),
('2094', 'Version1', 'Version1', '[email protected]', '', 'IQ^Vv', '0', '', '1174145129', '0', '1174145102', '', '', '0', '', '', '', '', 'yes', '', '124.189.66.15', '124.189.66.15', '', '0', '----'),
('2095', 'maame_masr', 'maame_masr', '[email protected]', '', 'Q_jkS', '0', '', '1174156441', '0', '1174156422', '', '', '0', '', '', '', '', 'yes', '', '67.41.132.94', '67.41.132.94', '', '0', '----'),
('2096', 'doodster', 'doodster', '[email protected]', '', 'r(-&8', '0', '', '1174211082', '0', '1174211062', '', '', '0', '', '', '', '', 'yes', '', '194.42.116.11', '194.42.116.11', '', '0', '----'),
('2097', 'mekeskispas', 'mekeskispas', '[email protected]', '', 'sDZjI', '0', '', '1174248771', '0', '1174248746', '', '', '0', '', '', '', '', 'yes', '', '193.51.16.187', '193.51.16.187', '', '0', '----'),
('2098', 'HomerSimpson76-07', 'HomerSimpson76-07', '[email protected]', '', '1p#pV', '0', '', '1175805473', '0', '1174268339', '', '', '0', '', '', '', '', 'yes', '', '70.143.58.203', '70.143.58.203', '', '0', '----'),
('2100', 'homer_rulz', 'homer_rulz', '[email protected]', '', '^$%%<', '0', '', '1174283419', '0', '1174283396', '', '', '0', '', '', '', '', 'yes', '', '124.187.149.74', '124.187.149.74', '', '0', '----'),
('2102', 'Drama Queen 1', 'Drama Queen 1', '[email protected]', '', '!+)>[', '0', '', '1174335780', '0', '1174333563', '', '', '0', '', '', '', '', 'yes', '', '86.137.87.113', '86.137.87.113', '', '0', '1996-5-14'),
('2103', 'Aussie_pridez', 'Aussie_pridez', '[email protected]', '', 'mVBW/', '0', '', '1174374814', '0', '1174374779', '', '', '0', '', '', '', '', 'yes', '', '124.184.58.89', '124.184.58.89', '', '0', '1992-4-27'),
('2104', 'Pakaveli', 'Pakaveli', '[email protected]', '', 'osxU}', '0', '', '1175555225', '0', '1175555204', '', '', '0', '', '', '', '', 'yes', '', '82.36.219.76', '82.36.219.76', '', '0', '----'),
('2105', 'kamoku', 'kamoku', '[email protected]', '', '4br*e', '1', '', '1175353692', '0', '1174426488', '', '', '0', '', '', '', '', 'yes', '', '213.22.156.150', '213.22.156.150', '', '0', '----'),
('2106', 'turlach', 'turlach', '[email protected]', '', 'FZ;9M', '0', '', '1174446966', '0', '1174446938', '', '', '0', '', '', '', '', 'yes', '', '87.192.246.215', '87.192.246.215', '', '0', '----'),
('2107', 'lisine', 'lisine', '[email protected]', '', '{OE}E', '3', '', '1175697917', '0', '1174481724', '', '', '0', '', '', '', '', 'yes', '', '147.91.173.31', '147.91.173.31', '', '0', '----'),
('2108', 'thesimpsonsmanic141', 'thesimpsonsmanic141', '[email protected]', '', 'r{@Nm', '19', '', '1176254205', '0', '1174816318', '', '', '0', '', '', '', '', 'yes', '', '58.110.136.156', '58.110.136.156', '', '0', '----'),
('2109', 'aruku', 'aruku', '[email protected]', '', '*}qDL', '0', '', '1174827518', '0', '1174827494', '', '', '0', '', '', '', '', 'yes', '', '155.232.128.10', '155.232.128.10', '', '0', '----'),
('2110', 'Alexness', 'Alexness', '[email protected]', '', '0|<@P', '0', '', '1175346281', '0', '1174860004', '', '', '0', '', '', '', '', 'yes', '', '81.164.5.63', '81.164.5.63', '', '0', '----'),
('2112', 'majora', 'majora', '[email protected]', '', 'Xi`\"&', '0', '', '1174954977', '0', '1174954961', '', '', '0', '', '', '', '', 'yes', '', '80.47.114.36', '80.47.114.36', '', '0', '----'),
('2113', 'Craig', 'Craig', '[email protected]', '', 'lQ<TS', '1', '', '1175023640', '0', '1174937965', '', '', '0', '', '', '', '', 'yes', '', '24.187.130.93', '24.187.130.93', '', '0', '----'),
('2114', 'ravensedge', 'ravensedge', '[email protected]', '', '~EWl{', '0', '', '1174950389', '0', '1174950368', '', '', '0', '', '', '', '', 'yes', '', '204.209.17.254', '204.209.17.254', '', '0', '1985-10-4'),
('2115', 'KarinaLG87', 'KarinaLG87', '[email protected]', '', 'vVU?9', '1', '', '1175037117', '0', '1174956892', 'http://', 'http://', '0', '', '', '', '', 'yes', '', '198.202.25.212', '198.202.25.212', '', '0', '1987-4-29'),
('2116', 'Xmell', 'Xmell', '[email protected]', '', 'kr=UJ', '0', '', '1175084217', '0', '1175080786', '', '', '0', '', '', '', '', 'yes', '', '213.141.159.112', '213.141.159.112', '', '0', '----'),
('2117', 'juniorpassa', 'juniorpassa', '[email protected]', '', 'mn.F1', '0', '', '1175730084', '0', '1175018555', '', '', '0', '', '', '', '', 'yes', '', '68.36.83.193', '68.36.83.193', '', '0', '----'),
('2118', 'Craig_no27', 'Craig_no27', '[email protected]', '', '#Hr6\"', '0', '', '1175220311', '0', '1175215976', '', '', '0', '', '', '', '', 'yes', '', '218.214.141.73', '218.214.141.73', '', '0', '----'),
('2119', 'harrymorrison', 'harrymorrison', '[email protected]', '', 'J#>tx', '0', '', '1175042015', '0', '1175041958', '', '', '0', '', '', '', '', 'yes', '', '62.252.0.7', '62.252.0.7', '', '0', '----'),
('2120', 'doroti', 'doroti', '[email protected]', '', 'FWngJ', '0', '', '1175173045', '0', '1175091112', '', '', '0', '', '', '', '', 'yes', '', '195.56.186.198', '195.56.186.198', '', '0', '----'),
('2121', 'fantabulacious', 'fantabulacious', '[email protected]', '', 'Z4Liq', '0', '', '1175116115', '0', '1175116091', '', '', '0', '', '', '', '', 'yes', '', '12.193.224.21', '12.193.224.21', '', '0', '----'),
('2122', 'saldejums', 'saldejums', '[email protected]', '', '}+9ke', '0', '', '1175194807', '0', '1175194789', '', '', '0', '', '', '', '', 'yes', '', '132.183.13.1', '132.183.13.1', '', '0', '----'),
('2123', 'absolon', 'absolon', '[email protected]', '', '5d;!j', '0', '', '1175421667', '0', '1175271737', '', '', '0', '', '', '', '', 'yes', '', '218.186.10.11', '218.186.10.11', '', '0', '----'),
('2124', 'thatguywhoposts', 'thatguywhoposts', '[email protected]', '', '_Tk\'z', '0', '', '1175276738', '0', '1175276376', '', '', '0', '', '', '', '', 'yes', '', '82.34.247.156', '82.34.247.156', '', '0', '----'),
('2126', 'SpambotVersion2', 'SpambotVersion2', '[email protected]', '', 'a3O[>', '8', '', '1175406258', '0', '1175401351', '', '', '0', '', '', '', '', 'yes', '', '208.68.99.185', '208.68.99.185', '', '0', '----'),
('2127', 'chu_ri_su', 'chu_ri_su', '[email protected]', '', 'f]1b=', '0', '', '1175334042', '0', '1175333818', '', '', '0', '', '', '', '', 'yes', '', '60.52.178.218', '60.52.178.218', '', '0', '----'),
('2128', 'xxvikkixx', 'xxvikkixx', '[email protected]', '', 'k)ycS', '0', '', '1175354883', '0', '1175354703', '', '', '0', '', '', '', '', 'yes', '', '88.109.235.165', '88.109.235.165', '', '0', '----'),
('2129', 'ImwithInvaderButters', 'ImwithInvaderButters', '[email protected]', '', 'e!dO;', '13', '', '1175402035', '0', '1175402010', '', '', '0', '', '', '', '', 'yes', '', '68.205.64.97', '68.205.64.97', '', '0', '----'),
('2130', 'thaihung', 'thaihung', '[email protected]', '', '7S3Lq', '0', '', '1175414886', '0', '1175414792', '', '', '0', '', '', '', '', 'yes', '', '125.214.63.35', '125.214.63.35', '', '0', '----'),
('2131', 'MrBitter805', 'MrBitter805', '[email protected]', '', 'WO>`x', '0', '', '1175481616', '0', '1175481453', '', '', '0', '', '', '', '', 'yes', '', '207.200.116.70', '207.200.116.70', '', '0', '----'),
('2132', 'erikyates', 'erikyates', '[email protected]', '', 'K}IIy', '0', '', '1175455058', '0', '1175455030', '', '', '0', '', '', '', '', 'yes', '', '70.146.6.36', '70.146.6.36', '', '0', '----'),
('2133', 'KrustyBurgerLad', 'KrustyBurgerLad', '[email protected]', '', '#Ys.S', '0', '', '1175457727', '0', '1175457664', '', '', '0', '', '', '', '', 'yes', '', '74.235.213.164', '74.235.213.164', '', '0', '----'),
('2135', 'vvthanh', 'vvthanh', '[email protected]', '', '?\"h<;', '0', '', '1177325006', '0', '1175577820', '', '', '0', '', '', '', '', 'yes', '', '74.116.34.153', '74.116.34.153', '', '0', '----'),
('2136', 'tester', 'tester', '[email protected]', '', 'J}O]m', '2', '', '1175553114', '0', '1175485879', '', '', '0', '', '', '', '', 'yes', '', '24.195.161.215', '24.195.161.215', '', '0', '----'),
('2137', 'tulpa', 'tulpa', '[email protected]', '', 'VZ5y-', '0', '', '1175595019', '0', '1175594994', '', '', '0', '', '', '', '', 'yes', '', '64.59.144.85', '64.59.144.85', '', '0', '----'),
('2138', 'theoneh', 'theoneh', '[email protected]', '', '|ku:\"', '0', '', '1175607798', '0', '1175607782', '', '', '0', '', '', '', '', 'yes', '', '194.112.196.135', '194.112.196.135', '', '0', '----'),
('2139', 'overlord13', 'overlord13', '[email protected]', '', 'a6^9p', '1', '', '1175634272', '0', '1175634244', '', '', '0', '', '', '', '', 'yes', '', '195.166.203.156', '195.166.203.156', '', '0', '----'),
('2140', 'theresalwaysanotherway', 'theresalwaysanotherway', '[email protected]', '', 'am\'!z', '2', '', '1176244450', '0', '1175636046', '', '', '0', '', '', '', '', 'yes', '', '209.149.16.47', '209.149.16.47', '', '0', '----'),
('2141', 'xviper2k', 'xviper2k', '[email protected]', '', 'u{lYE', '0', '', '1175652063', '0', '1175652013', '', '', '0', '', '', '', '', 'yes', '', '68.202.139.212', '68.202.139.212', '', '0', '----'),
('2142', 'pansy', 'pansy', '******[email protected]', '', '=Icn~', '0', '', '1175679838', '0', '1175679827', '', '', '0', '', '', '', '', 'yes', '', '86.0.247.34', '86.0.247.34', '', '0', '----'),
('2143', 'Caesar', 'Caesar', '[email protected]', '', 'f|>?x', '0', '', '1175697202', '0', '1175697187', '', '', '0', '', '', '', '', 'yes', '', '84.151.235.74', '84.151.235.74', '', '0', '----'),
('2144', 'homerdies', 'homerdies', '[email protected]', '', ':l]xH', '0', '', '1175705453', '0', '1175705428', '', '', '0', '', '', '', '', 'yes', '', '81.84.12.15', '81.84.12.15', '', '0', '----'),
('2145', 'simpsonsmad', 'simpsonsmad', '[email protected]', '', 'UPQWH', '0', '', '1175711073', '0', '1175711047', '', '', '0', '', '', '', '', 'yes', '', '172.189.179.156', '172.189.179.156', '', '0', '----'),
('2146', 'quackspanner', 'quackspanner', '[email protected]', '', 'JU]$u', '0', '', '1175724229', '0', '1175724205', '', '', '0', '', '', '', '', 'yes', '', '217.44.215.248', '217.44.215.248', '', '0', '----'),
('2147', 'niall_23', 'niall_23', '[email protected]', '', '.Fb=j', '0', '', '1175758300', '0', '1175758263', '', '', '0', '', '', '', '', 'yes', '', '58.178.60.70', '58.178.60.70', '', '0', '----'),
('2148', 'Jadams805', 'Jadams805', '[email protected]', '', '[l4&p', '0', '', '1176437703', '0', '1175759665', '', '', '0', '', '', '', '', 'yes', '', '69.231.48.237', '69.231.48.237', '', '0', '----'),
('2149', 'The_Gambler', 'The_Gambler', '[email protected]', '', 'tdJV}', '0', '', '1180128593', '0', '1175770073', '', '', '0', '', '', '', '', 'yes', '', '80.186.125.93', '80.186.125.93', '', '0', '1989-3-23'),
('2150', 'lordrayden11', 'lordrayden11', '[email protected]', '', '?_kRJ', '1', '', '1175814218', '0', '1175773229', '', '', '0', '', '', '', '', 'yes', '', '220.239.159.193', '220.239.159.193', '', '0', '----'),
('2151', 'bloodygutsmurphy', 'bloodygutsmurphy', '[email protected]', '', 'v;m_2', '0', '', '1175777098', '0', '1175776048', '', '', '0', '', '', '', '', 'yes', '', '194.80.238.40', '194.80.238.40', '', '0', '----'),
('2152', 'tokyoknights', 'tokyoknights', '[email protected]', '', 'iVwWE', '0', '', '1175786294', '0', '1175786262', '', '', '0', '', '', '', '', 'yes', '', '60.229.61.151', '60.229.61.151', '', '0', '----'),
('2153', 'manchester united', 'manchester united', '[email protected]', '', 'u{$e\'', '0', '', '1176202759', '0', '1175787108', '', '', '0', '', '', '', '', 'yes', '', '168.213.1.134', '168.213.1.134', '', '0', '----'),
('2154', 'FatalRemedy', 'FatalRemedy', '[email protected]', '', 'kz+hB', '0', '', '1175790845', '0', '1175790229', '', '', '0', '', '', '', '', 'yes', '', '74.103.85.181', '74.103.85.181', '', '0', '----'),
('2155', 'rocari09', 'rocari09', '[email protected]', '', '7k3j|', '0', '', '1175830510', '0', '1175830340', '', '', '0', '', '', '', '', 'yes', '', '200.21.65.154', '200.21.65.154', '', '0', '----'),
('2156', 'jiws88', 'jiws88', '[email protected]', '', '#7VKG', '0', '', '1175992274', '0', '1175962122', '', '', '0', '', '', '', '', 'yes', '', '203.79.252.193', '203.79.252.193', '', '0', '----'),
('2157', 'jerm', 'jerm', '[email protected]', '', 'u[o60', '0', '', '1175843012', '0', '1175842928', '', '', '0', '', '', '', '', 'yes', '', '211.31.87.180', '211.31.87.180', '', '0', '----'),
('2158', 'ASSMAN', 'ASSMAN', '[email protected]', '', 'aeZl/', '0', '', '1175851907', '0', '1175851869', '', '', '0', '', '', '', '', 'yes', '', '58.178.3.132', '58.178.3.132', '', '0', '----'),
('2159', 'cao9317', 'cao9317', '[email protected]', '', 'fO]du', '0', '', '1175906447', '0', '1175905777', '', '', '0', '', '', '', '', 'yes', '', '200.120.147.133', '200.120.147.133', '', '0', '----'),
('2160', 'superman', 'superman', '[email protected]', '', '10YEO', '0', '', '1180115196', '0', '1175880602', '', '', '0', '', '', '', '', 'yes', '', '202.133.71.55', '202.133.71.55', '', '0', '----'),
('2161', 'bigkris', 'bigkris', '[email protected]', '', '0{LI]', '0', '', '1176247864', '0', '1175911247', '', '', '0', '', '', '', '', 'yes', '', '24.96.111.163', '24.96.111.163', '', '0', '----'),
('2162', 'CARLOS', 'CARLOS', '[email protected]', '', '_{qU]', '0', '', '1176015212', '0', '1176015194', '', '', '0', '', '', '', '', 'yes', '', '189.174.64.30', '189.174.64.30', '', '0', '----'),
('2163', 'simpsonstube', 'simpsonstube', '[email protected]', '', 'fmRr`', '2', '', '1179903863', '0', '1175943078', '', '', '0', '', '', '', '', 'yes', '', '144.137.46.185', '144.137.46.185', '', '0', '1993-4-14'),
('2164', 'best member', 'best member', '[email protected]', '', 'Br/:L', '3', '', '1180135735', '0', '1176083655', '', '', '0', '', '', '', '', 'yes', '', '71.139.42.142', '71.139.42.142', '', '0', '----'),
('2165', 'fluffynut racoontree', 'fluffynut racoontree', '[email protected]', '', ']&d^9', '7', '', '1176234001', '0', '1176047367', '', '', '0', '', '', '', 'oo ya ', 'yes', '', '24.62.146.153', '24.62.146.153', '', '0', '----'),
('2166', 'Tobias', 'Tobias', '[email protected]', '', 'e}W|W', '12', '', '1180671628', '0', '1176055867', '', '', '0', '', '', '[email protected]', '', 'yes', '', '80.217.81.121', '80.217.81.121', '', '0', '1994-5-7'),
('2167', 'rossrobinson1987', 'rossrobinson1987', '[email protected]', '', 'D?9mx', '0', '', '1177512200', '0', '1176056365', '', '', '0', '', '', '', '', 'yes', '', '82.19.27.32', '82.19.27.32', '', '0', '----'),
('2168', 'Smilis', 'Smilis', '[email protected]', '', '+A[H6', '0', '', '1176062454', '0', '1176062448', '', '', '0', '', '', '', '', 'yes', '', '84.217.74.203', '84.217.74.203', '', '0', '----'),
('2169', 'clandestine_chick', 'clandestine_chick', '[email protected]', '', 'q1j.|', '0', '', '1176189643', '0', '1176179636', '', '', '0', '', '', '', '<span style=\"font-family:Impact\">I love I love I love BlessTheFall!!!!<!--fontc--><!--/fontc--><!--sizec--></span><!--/sizec-->', 'yes', '', '71.139.200.129', '71.139.200.129', '', '0', '----'),
('2170', 'daexorcist', 'daexorcist', '[email protected]', '', 'z9R-j', '0', '', '1176137182', '0', '1176137163', '', '', '0', '', '', '', '', 'yes', '', '128.239.155.187', '128.239.155.187', '', '0', '----'),
('2171', 'Bartoman22', 'Bartoman22', '[email protected]', '', '|he<\'', '1', '', '1180456977', '0', '1176147405', '', '', '0', '', '', '', '', 'yes', '', '88.107.218.76', '88.107.218.76', '', '0', '----'),
('2172', 'deadbadger', 'deadbadger', '[email protected]', '', 'wNY-}', '0', '', '1176152183', '0', '1176152148', '', '', '0', '', '', '', '', 'yes', '', '217.44.215.248', '217.44.215.248', '', '0', '----'),
('2173', 'giffy', 'giffy', '[email protected]', '', 'c];U3', '1', '', '1176154073', '0', '1176154060', '', '', '0', '', '', '', '', 'yes', '', '69.156.1.78', '69.156.1.78', '', '0', '----'),
('2174', 'meghansfriend', 'meghansfriend', '[email protected]', '', 'bRZoi', '0', '', '1176163776', '0', '1176163582', '', '', '0', '', '', '', '', 'yes', '', '72.226.71.31', '72.226.71.31', '', '0', '----'),
('2175', 'marceloln', 'marceloln', '[email protected]', '', ']rCt2', '0', '', '0', '0', '1176339658', '', '', '0', '', '', '', '', 'yes', '', '201.17.39.201', '201.17.39.201', '', '0', '----'),
('2176', 'qdqqqq', 'qdqqqq', '[email protected]', '', '&fqrU', '0', '', '1176205323', '0', '1176205289', '', '', '0', '', '', '', '', 'yes', '', '221.0.142.62', '221.0.142.62', '', '0', '----'),
('2177', 'Homer94', 'Homer94', '[email protected]', '', '+PA2J', '0', '', '1176248268', '0', '1176246940', '', '', '0', '', '', '', '', 'yes', '', '74.103.234.117', '74.103.234.117', '', '0', '----'),
('2178', 'Dan_Yankees', 'Dan_Yankees', '[email protected]', '', 'jKt]U', '0', '', '1176258312', '0', '1176257688', '', '', '0', '', '', '', '', 'yes', '', '24.161.110.100', '24.161.110.100', '', '0', '----'),
('2179', 'bob_141', 'bob_141', '[email protected]', '', 'CWX41', '0', '', '1176261581', '0', '1176261546', '', '', '0', '', '', '', '', 'yes', '', '58.110.136.156', '58.110.136.156', '', '0', '----'),
('2180', 'piloto-43', 'piloto-43', '[email protected]', '', 'G]|$-', '2', '', '1176445437', '0', '1176304458', '', '', '0', '', '', '', '', 'yes', '', '190.40.42.13', '190.40.42.13', '', '0', '----'),
('2181', 'fulltimecasual', 'fulltimecasual', '[email protected]', '', '\"b(l6', '0', '', '1176387499', '0', '1176385013', '', '', '0', '', '', '', '', 'yes', '', '220.233.9.164', '220.233.9.164', '', '0', '----'),
('2182', 'deepak.stoic', 'deepak.stoic', '[email protected]', '', ']L2|7', '0', '', '1176387853', '0', '1176387530', '', '', '0', '', '', '', '', 'yes', '', '202.141.145.38', '202.141.145.38', '', '0', '----'),
('2183', 'KIM', 'KIM', '[email protected]', '', '$Fh`F', '0', '', '1176415550', '0', '1176414749', '', '', '0', '', '', '', '', 'yes', '', '81.106.22.99', '81.106.22.99', '', '0', '----'),
('2184', 'shortguy', 'shortguy', '[email protected]', '', 'g*g0;', '0', '', '1176416432', '0', '1176416401', '', '', '0', '', '', '', '', 'yes', '', '81.79.194.253', '81.79.194.253', '', '0', '----'),
('2185', 'James 2007', 'James 2007', '[email protected]', '', '~-kuI', '0', '', '1176460126', '0', '1176460080', '', '', '0', '', '', '', '', 'yes', '', '58.178.73.231', '58.178.73.231', '', '0', '----'),
('2187', 'kian2112', 'kian2112', '[email protected]', '', '$DOco', '0', '', '1176485689', '0', '1176485654', '', '', '0', '', '', '', '', 'yes', '', '155.69.5.236', '155.69.5.236', '', '0', '----'),
('2188', 'coolguy111', 'coolguy111', '[email protected]', '', 'tC-[!', '16', '', '1177893536', '0', '1176835801', '', '', '0', '', '', '', '', 'yes', '', '64.30.77.179', '64.30.77.179', '', '0', '----'),
('2189', 'hugz', 'hugz', '[email protected]', '', 'zAHp?', '0', '', '1176494613', '0', '1176494277', '', '', '0', '', '', '', '', 'yes', '', '67.82.133.130', '67.82.133.130', '', '0', '----'),
('2190', 'HpseoJ', 'HpseoJ', '[email protected]', '', 'Mr>}m', '0', '', '1176504106', '0', '1176498654', '', '', '0', '', '', '', '', 'yes', '', '80.177.167.71', '80.177.167.71', '', '0', '----'),
('2191', 'Mr Smee', 'Mr Smee', '[email protected]', '', '&xmL~', '0', '', '1176886524', '0', '1176552195', 'http://www.google.co.uk', 'http://www.google.co.uk', '0', '', '', '', '
<span style=\"color:#000000\">Reggae Reggae Sauce!(tastes so nice I had to name it twice)
', 'yes', '', '62.253.48.108', '62.253.48.108', '', '0', '1994-1-1'),
('2192', 'adam', 'adam', '[email protected]', '', '=<+[+', '6', '', '1177780190', '0', '1176552244', '', '', '0', '', '', '', '', 'yes', '', '121.44.68.31', '121.44.68.31', '', '0', '----'),
('2193', 'CyPhUr', 'CyPhUr', '[email protected]', '', ']hPH_', '0', '', '0', '0', '1176580457', '', '', '0', '', '', '', '', 'yes', '', '74.111.152.101', '74.111.152.101', '', '0', '----'),
('2195', 'mmm_aggressive', 'mmm_aggressive', '[email protected]', '', '4q_%b', '0', '', '1176843107', '0', '1176724501', '', '', '0', '', '', '', '', 'yes', '', '217.228.91.151', '217.228.91.151', '', '0', '----'),
('2196', 'Derflanner', 'Derflanner', '[email protected]', '', 'EsFl}', '0', '', '1176736752', '0', '1176734934', '', '', '0', '', '', '', '', 'yes', '', '81.157.193.214', '81.157.193.214', '', '0', '----'),
('2197', 'superkirby', 'superkirby', '[email protected]', '', 'PYF\';', '0', '', '1176770738', '0', '1176770703', '', '', '0', '', '', '', '', 'yes', '', '75.6.231.205', '75.6.231.205', '', '0', '----'),
('2198', 'untouchable', 'untouchable', '[email protected]', '', '_m3uJ', '0', '', '1176737203', '0', '1176737194', '', '', '0', '', '', '', '', 'yes', '', '68.39.78.61', '68.39.78.61', '', '0', '----'),
('2199', 'Punkgal', 'Punkgal', '[email protected]', '', 'K|1nO', '0', '', '1176771123', '0', '1176771092', '', '', '0', '', '', '', '', 'yes', '', '203.26.16.66', '203.26.16.66', '', '0', '----'),
('2201', 'zoltain73', 'zoltain73', '[email protected]', '', 'lK[l/', '0', '', '1176810480', '0', '1176810453', '', '', '0', '', '', '', '', 'yes', '', '196.25.255.194', '196.25.255.194', '', '0', '----'),
('2202', 'digitus', 'digitus', '[email protected]', '', ']_X1W', '0', '', '1176914707', '0', '1176914693', '', '', '0', '', '', '', '', 'yes', '', '200.155.38.1', '200.155.38.1', '', '0', '----'),
('2203', 'Trae', 'Trae', '[email protected]', '', 'ghG~6', '1', '', '1176930250', '0', '1176930235', '', '', '0', '', '', '', '', 'yes', '', '75.58.152.198', '75.58.152.198', '', '0', '----'),
('2204', 'pank', 'pank', '[email protected]', '', '?t3!R', '0', '', '1176937962', '0', '1176937950', '', '', '0', '', '', '', '', 'yes', '', '24.1.49.167', '24.1.49.167', '', '0', '----'),
('2205', 'eh3', 'eh3', '[email protected]', '', 'e6rx4', '8', '', '1177030456', '0', '1177023694', '', '', '0', '', '', '', '', 'yes', '', '66.90.73.41', '66.90.73.41', '', '0', '----'),
('2206', 'Elbarto', 'Elbarto', '[email protected]', '', '\'*JAi', '0', '', '1177047115', '0', '1177047075', '', '', '0', '', '', '', '', 'yes', '', '202.67.67.45', '202.67.67.45', '', '0', '----'),
('2207', 'The Homega Man', 'The Homega Man', '[email protected]', '', 'Mq\'ry', '0', '', '1177063921', '0', '1177063457', '', '', '0', '', '', '', '', 'yes', '', '58.69.54.51', '58.69.54.51', '', '0', '----'),
('2208', 'x03x', 'x03x', '[email protected]', '', 'p5Fg|', '0', '', '1177166790', '0', '1177087175', '', '', '0', '', '', '', '', 'yes', '', '208.109.89.43', 

[JayBachatero]

Still cutting off the actual error.  Just post the LAST part of the error.

[el canadiano]

It's long :S

[Gary]

AW, don't post the whole thing, as Jay, just the end will do (there should be some more inserts and a query that it's trying to run).

That or put the code into a txt and attach it.

[Faisal Shah]

Software: MyBB
Version: 1.2.x

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

Changelog
! When converting users also convert the passwordSalt. (mybb12_to_smf.sql)
! Typo
! logTime is no longer used (mybb12_to_smf.sql)
! When converting polls make sure that questions column has an alias. (mybb12_to_smf.sql)
! Updated converter to convert attachments. (mybb12_to_smf.sql)
! When converting attachments and it's an image add the width and height for it. (mybb12_to_smf.sql)
! Cast $width and $height as a string or else it wont return a value if the file is not an image. (mybb12_to_smf.sql)

convert.php
Use this convert.php with the .sql file attached in this topic.

Well. I WAN\T to use the converter!
Please tell me what what things i need to use this stuff??
I mean this convert.php and that sql file thats it?
Or i have to install a SMF and MyBB before running conversion??

I AM waiting for answer!

THANKS

[JayBachatero]

Converting to SMF

[roguevalleyforums]

Thanks for the great program, I have converted all successfully, however the passwords don't convert for some reason.  In looking at the user tables for SMF, it has carried the password hash over, but if I try to log in, it won't let me. 

I am using Mybb 1.2.12.   With the most recent converters posted through this thread and the sql table converter file as well.

EDIT: Funny thing - if I paste the password hash into the password box, it lets me in. 

Any ideas?

[roguevalleyforums]

Any answers to my above post?  It has been a couple of days.

[JayBachatero]

Is the salt field blank for SMF?  If not try emptying it.

[roguevalleyforums]

It is empty for everyone else but mine.  I had logged in with the original password hash in the table and it let me in so literally "4fd79e0e2bca4755757ecfd3a2e13aec"  (test account no worries on exposure) let me in when logging in, instead of usual password.  So, after I got in under my account, I changed it in the control panel through SMF to a regular password.  So, mine has a Salt entry. 

[roguevalleyforums]

BUMP

[JayBachatero]

Umm I wonder if they changed their password encryption method.  I'll take a look at it and see if they did.

[alwa7eed]

after convert all topic like ?

http://www.bloo2th.info/smf/
what this error

[JayBachatero]

Means that the database connection info is incorrect.  Use repair_settings.php and put in the correct info.
What is repair_settings.php?

[jinji55]

When I'm trying to convert the mybb forum it apears me:
"Converting members... Unsuccessful!
This query:

    SELECT
    uid AS ID_MEMBER, SUBSTRING(username, 1, 255) AS memberName,
    SUBSTRING(username, 1, 255) AS realName,
    SUBSTRING(password, 1, 64) AS passwd, email AS emailAddress,
    postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
    lastvisit AS lastLogin, IF(usergroup = 4, 1, 0) AS ID_GROUP,
    regdate AS dateRegistered, SUBSTRING(website, 1, 255) AS websiteUrl,
    SUBSTRING(website, 1, 255) AS websiteTitle,
    SUBSTRING(icq, 1, 255) AS ICQ, SUBSTRING(aim, 1, 16) AS AIM,
    SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hideEmail,
    SUBSTRING(buddylist, 1, 255) AS buddy_list,
    SUBSTRING(regip, 1, 255) AS memberIP, SUBSTRING(regip, 1, 255) AS memberIP2,
    SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
    timeonline AS totalTimeLoggedIn,
    IF(birthday = '', '0001-01-01', CONCAT_WS('-', RIGHT(birthday, 4), SUBSTRING(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), LEFT(birthday, LOCATE('-', birthday) - 1))) AS birthdate
    FROM `zmelcu1`.myf_users
    LIMIT 0, 500;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS MSN, 1, 255) AS MSN,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail ' at line 10"

[JayBachatero]

Use the file in the first post.