[SMF Converter] MyBB 1.2.x

[JayBachatero]

Actually now that I look at the errors they are because you went to step 2 but didn't have any of the session variables set that are defined in step 1.  If you want I can take a look at this for you.  Just send me FTP info.

[marc25v]

Actually I took action before you replied.  I decided to manually import and export and rename all my threads tables and posts.  The members got imported oddly using the converter.  It looks ok now except a couple of things such as the IP only shows 2 numbers.  Here I could send you a link to the forums.   hxxp:forums.zendurl.com/smf [nonactive]

Thansk a lot.. Although it was a lot of trouble :S

[JayBachatero]

First time I see that IP issue.  But if that's the only remaining issue then you don't have to worry.  The IP's get updated for the users.

[curiousgeo]

I get stopped immediately with the following error, which I have seen a lot in previous posts but no resolution:

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 `gdogforum`.mybb_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 sign

[JayBachatero]

Are you using the converter in this topic?

[curiousgeo]

Yes, of course I am.  I have gone through this entire thread and used every one that is mentioned.  Still same exact error.

But if you'd like to link me to the exact one I'm supposed to use, maybe I'll have better luck.

[curiousgeo]

Hmmm...well, I guess I won't be converting to smf.

By the way, that is really irritating to be thrown to the index after you post instead of being able to view the post you just made (without having to look for it).

[SleePy]

curiousgeo,

Please remember we are all volunteers here and do not get paid for what we do.

Can you verify in your conversion .sql file that on line 30 you have exactly this:

Code Select Expand

SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn, 1, 255) AS MSN,

If you can't find the line or want me to look. Just post everything from "Converting members" to "Converting categories".

As for the post, Just go to your Look and Layout and Check "Return to topics after posting by default."

You can make this a default option for all new users and/or your current users in these places
Admin -> Current Theme -> Reset Options -> Reset all members' current options for this theme
Admin -> Current Theme -> Reset Options -> Reset default (guest) options for this theme

[JayBachatero]

Hmmm...well, I guess I won't be converting to smf.

By the way, that is really irritating to be thrown to the index after you post instead of being able to view the post you just made (without having to look for it).

Can you give me FTP access so that I can give this a try and debug it?

[f0g]

The converter in the topic has an error on line 28. AS MSN is repeated twice, incorrectly the first time through.

Code Select Expand


        SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,

should be

Code Select Expand


        SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn, 1, 255) AS MSN,


Also, I'm trying to do a convert of a very large forum.  When I do a show full processlist on mysql, I see that the same query is executing simultaneously... and obviously, it takes a while. Right now it's still running, but...

Code Select Expand


Id      User    Host    db      Command Time    State   Info
69      smf     localhost       NULL    Query   1231    Copying to tmp table    SELECT\n\tt.tid AS ID_TOPIC, t.fid AS ID_BOARD, t.sticky AS isSticky,\n\tt.poll AS ID_POLL, t.views AS numViews, t.uid AS ID_MEMBER_STARTED,\n\tul.uid AS ID_MEMBER_UPDATED, t.replies AS numReplies, t.closed AS locked,\n\tMIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG\nFROM (`fur`.mybb_threads AS t, `fur`.mybb_posts AS p)\n\tLEFT JOIN `fur`.mybb_users AS ul ON (BINARY ul.username = t.lastposter)\nWHERE p.tid = t.tid\nGROUP BY t.tid\nHAVING ID_FIRST_MSG != 0\n\tAND ID_LAST_MSG != 0\nLIMIT 0, 500
72      smf     localhost       NULL    Query   842     Copying to tmp table    SELECT\n\tt.tid AS ID_TOPIC, t.fid AS ID_BOARD, t.sticky AS isSticky,\n\tt.poll AS ID_POLL, t.views AS numViews, t.uid AS ID_MEMBER_STARTED,\n\tul.uid AS ID_MEMBER_UPDATED, t.replies AS numReplies, t.closed AS locked,\n\tMIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG\nFROM (`fur`.mybb_threads AS t, `fur`.mybb_posts AS p)\n\tLEFT JOIN `fur`.mybb_users AS ul ON (BINARY ul.username = t.lastposter)\nWHERE p.tid = t.tid\nGROUP BY t.tid\nHAVING ID_FIRST_MSG != 0\n\tAND ID_LAST_MSG != 0\nLIMIT 0, 500



Edit #2:
Well, the web page timed out (I reset the timeout to one hour, but it's been running longer).

But those same queries are still running. 6119 seconds and counting...

Edit #3:
Over 8000. I'm killing it because I haven't seen mysql chewing up any CPU the entire time...

what's going on?

[JayBachatero]

Do an explain on the queries and post the results here.

[f0g]

1       SIMPLE  p       ALL     NULL    NULL    NULL    NULL    253021  Using temporary; Using filesort
1       SIMPLE  t       eq_ref  PRIMARY PRIMARY 4       fur.p.tid       1
1       SIMPLE  ul      ALL     NULL    NULL    NULL    NULL    9485

[f0g]

I hope that means more to you than it does to me.

[f0g]

Is there more information I can get you?

[JayBachatero]

Seems like it's not using any keys.  Can you PM me access to phpMyAdmin?

[f0g]

Sent you a PM.

[JayBachatero]

Alright I'll take a look at it in a bit.  What version of MyBB are you exactly using?

[el canadiano]

I'm getting this error.

Converting members... Unsuccessful!
This query:

    INSERT INTO `stone_smfdb`.smf_members
    (ID_MEMBER, memberName, realName, passwd, emailAddress, posts, usertitle, lastLogin, ID_GROUP, dateRegistered, websiteUrl, websiteTitle, ICQ, AIM, YIM, MSN, signature, hideEmail, buddy_list, memberIP, memberIP2, pm_ignore_list, totalTimeLoggedIn, birthdate)
    VALUES ('2001', 'dascmaniac', 'dascmaniac', '', '[email protected]', '0', '', '1171923355', '0', '1171923295', '', '', '0', '', '', '', '', 'yes', '', '132.73.80.129', '132.73.80.129', '', '0', '----'),
    ('2002', 'Morbo', 'Morbo', '', '[email protected]', '4', '', '1172045585', '0', '1171932555', '', '', '0', '', '', '', '', 'yes', '', '207.41.34.50', '207.41.34.50', '', '0', '----'),
    ('2003', 'profumi', 'profumi', '', '[email protected]', '0', '', '1172048762', '0', '1172048741', '', '', '0', '', '', '', '', 'yes', '', '84.197.12.108', '84.197.12.108', '', '0', '----'),
    ('2004', 'homer 408', 'homer 408', '', '[email protected]', '1', '', '1172124458', '0', '1172124427', '', '', '0', '', '', '', '', 'yes', '', '69.228.199.195', '69.228.199.195', '', '0', '----'),
    ('2005', 'Taktloss', 'Taktloss', '', '[email protected]', '0', '', '1172096354', '0', '1172096311', '', '', '0', '', '', '', '', 'yes', '', '84.61.4.135', '84.61.4.135', '', '0', '----'),
    ('2006', 'Stranger', 'Stranger', '', '[email protected]', '1', '', '1172157377', '0', '1172157359', '', '', '0', '', '', '', '', 'yes', '', '82.32.48.236', '82.32.48.236', '', '0', '----'),
    ('2007', 'poupounousse', 'poupounousse', '', '[email protected]', '0', '', '1172238290', '0', '1172157350', '', '', '0', '', '', '', '', 'yes', '', '194.4.232.242', '194.4.232.242', '', '0', '----'),
    ('2008', 'msimplay', 'msimplay', '', '[email protected]', '0', '', '1172165708', '0', '1172165649', '', '', '0', '', '', '', '', 'yes', '', '62.30.74.65', '62.30.74.65', '', '0', '----'),
    ('2009', 'gupouoit7uy', 'gupouoit7uy', '', '[email protected]', '0', '', '1172167620', '0', '1172166018', '', '', '0', '', '', '', '', 'yes', '', '80.41.181.188', '80.41.181.188', '', '0', '----'),
    ('2010', 'markrenton', 'markrenton', '', '[email protected]', '0', '', '1172166689', '0', '1172166559', '', '', '0', '', '', '', '', 'yes', '', '217.86.77.190', '217.86.77.190', '', '0', '----'),
    ('2011', 'gillym8', 'gillym8', '', '[email protected]', '0', '', '1172196745', '0', '1172196720', '', '', '0', '', '', '', '', 'yes', '', '210.49.196.17', '210.49.196.17', '', '0', '----'),
    ('2012', 'sbbfooks', 'sbbfooks', '', '[email protected]', '0', '', '1180187815', '0', '1172198681', '', '', '0', '', '', '', '', 'yes', '', '65.93.146.45', '65.93.146.45', '', '0', '----'),
    ('2013', 'cesarix', 'cesarix', '', '[email protected]', '0', '', '1180044591', '0', '1172253987', '', '', '0', '', '', '', '', 'yes', '', '89.152.172.204', '89.152.172.204', '', '0', '----'),
    ('2014', 'bdbucky', 'bdbucky', '', '[email protected]', '80', '', '1177517826', '0', '1172258190', 'http://', 'http://', '0', '', '', '', '

    [size=11]<span style=\"color:#FF0000\">Don't mess with the Sess<!--sizec-->[/size]<!--/sizec--><!--fontc--><!--/fontc-->', 'yes', '', '192.138.205.144', '192.138.205.144', '', '0', '1988-4-22'),
    ('2015', 'GGP_ipb2_import2024', 'GGP_ipb2_import2024', '', '[email protected]', '30', '', '1180640025', '0', '1172344729', '', '', '0', '', '', '', '', 'yes', '', '66.31.75.235', '66.31.75.235', '', '0', '----'),
    ('2016', 'Evil1', 'Evil1', '', '[email protected]', '0', '', '1172308853', '0', '1172308331', '', '', '0', '', '', '', '', 'yes', '', '138.217.217.219', '138.217.217.219', '', '0', '----'),
    ('2017', 'IRISHDUDE27', 'IRISHDUDE27', '', '[email protected]', '0', '', '0', '0', '1172378056', '', '', '0', '', '', '', '', 'yes', '', '68.98.39.208', '68.98.39.208', '', '0', '----'),
    ('2018', 'Kyle', 'Kyle', '', '[email protected]', '0', '', '1172387209', '0', '1172383631', '', '', '0', '', '', '', '', 'yes', '', '124.177.150.106', '124.177.150.106', '', '0', '----'),
    ('2019', 'jaygray94', 'jaygray94', '', '[email protected]', '0', '', '1172431836', '0', '1172431796', '', '', '0', '', '', '', '', 'yes', '', '81.151.206.169', '81.151.206.169', '', '0', '----'),
    ('2020', 'theonemaster', 'theonemaster', '', '[email protected]', '0', '', '1172433320', '0', '1172433263', '', '', '0', '', '', '', '', 'yes', '', '72.160.185.108', '72.160.185.108', '', '0', '----'),
    ('2021', 'simpsongampl', 'simpsongampl', '', '[email protected]', '0', '', '1172492641', '0', '1172492608', '', '', '0', '', '', '', '', 'yes', '', '217.173.20.106', '217.173.20.106', '', '0', '----'),
    ('2022', 'TravisG', 'TravisG', '', '[email protected]', '1', '', '1172524445', '0', '1172449101', '', '', '0', '', '', '', '', 'yes', '', '62.253.32.5', '62.253.32.5', '', '0', '----'),
    ('2023', 'dodabartmanx4', 'dodabartmanx4', '', '[email protected]', '0', '', '0', '0', '1172455944', '', '', '0', '', '', '', '', 'yes', '', '12.217.128.82', '12.217.128.82', '', '0', '----'),
    ('2024', 'snocker', 'snocker', '', '[email protected]', '0', '', '1172548748', '0', '1172548716', '', '', '0', '', '', '', '', 'yes', '', '137.226.181.106', '137.226.181.106', '', '0', '----'),
    ('2025', 'dmc2005', 'dmc2005', '', '[email protected]', '0', '', '1173919807', '0', '1172499601', '', '', '0', '', '', '', '', 'yes', '', '82.141.146.20', '82.141.146.20', '', '0', '----'),
    ('2026', 'borikong', 'borikong', '', '[email protected]', '0', '', '1172572766', '0', '1172572749', '', '', '0', '', '', '', '', 'yes', '', '122.2.30.213', '122.2.30.213', '', '0', '----'),
    ('2027', 'dadflea', 'dadflea', '', '[email protected]', '0', '', '1172517739', '0', '1172517710', '', '', '0', '', '', '', '', 'yes', '', '71.53.35.214', '71.53.35.214', '', '0', '----'),
    ('2028', 'Alexander86', 'Alexander86', '', '[email protected]', '0', '', '1172524052', '0', '1172518617', '', '', '0', '', '', '', '', 'yes', '', '80.217.128.54', '80.217.128.54', '', '0', '----'),
    ('2029', 'tintinza', 'tintinza', '', '[email protected]', '0', '', '1172519930', '0', '1172519906', '', '', '0', '', '', '', '', 'yes', '', '90.194.198.75', '90.194.198.75', '', '0', '----'),
    ('2030', 'damhomersfunny', 'damhomersfunny', '', '[email protected]', '0', '', '1172629118', '0', '1172629082', '', '', '0', '', '', '', '', 'yes', '', '74.96.106.227', '74.96.106.227', '', '0', '----'),
    ('2031', 'Shogg', 'Shogg', '', '[email protected]', '3', '', '1174866790', '0', '1174779433', '', '', '0', '', '', '', '', 'yes', '', '68.197.6.182', '68.197.6.182', '', '0', '----'),
    ('2032', 'jeffbaldwin', 'jeffbaldwin', '', '[email protected]', '0', '', '1172648331', '0', '1172648297', '', '', '0', '', '', '', '', 'yes', '', '64.17.80.155', '64.17.80.155', '', '0', '----'),
    ('2033', 'Sirz', 'Sirz', '', '[email protected]', '0', '', '1172648415', '0', '1172648373', '', '', '0', '', '', '', '', 'yes', '', '91.121.13.44', '91.121.13.44', '', '0', '----'),
    ('2034', 'Kikkerkont', 'Kikkerkont', '', '[email protected]', '30', '', '1180780585', '0', '1172648966', '', '', '0', '', '', '', 'South Park Source - The ultimate source for everything about South Park!
    South Park Source Forums', 'yes', '', '145.53.234.161', '145.53.234.161', '', '0', '----'),
    ('2035', 'The_Black_Smoke_Monster', 'The_Black_Smoke_Monster', '', '[email protected]', '26', '', '1176932591', '0', '1172678462', 'http://www.futuramaff.com', 'http://www.futuramaff.com', '0', '', '', '', 'Nearly 700 members
    Over 45,000 posts
    5 and a half months old
    FUTURAMA FANS
    www.futuramaff.com
    ', 'yes', '', '84.64.255.89', '84.64.255.89', '', '0', '1989-6-29'),
    ('2036', 'izhan_ipb2_import2036', 'izhan_ipb2_import2036', '', '[email protected]', '0', '', '1172681694', '0', '1172681678', '', '', '0', '', '', '', '', 'yes', '', '80.7.241.116', '80.7.241.116', '', '0', '----'),
    ('2037', 'frostie', 'frostie', '', '[email protected]', '0', '', '1172683900', '0', '1172683879', '', '', '0', '', '', '', '', 'yes', '', '89.216.147.195', '89.216.147.195', '', '0', '----'),
    ('2038', 'leprechaun27', 'leprechaun27', '', '[email protected]', '1', '', '1175316983', '0', '1172692238', '', '', '0', '', '', '', '', 'yes', '', '68.98.39.208', '68.98.39.208', '', '0', '----'),
    ('2039', 'tardistraveller15', 'tardistraveller15', '', '[email protected]', '0', '', '1177516217', '0', '1172696159', '', '', '0', '', '', '', '', 'yes', '', '80.192.164.6', '80.192.164.6', '', '0', '----'),
    ('2040', 'malcolm333', 'malcolm333', '', '[email protected]', '1', '', '1172700975', '0', '1172700954', '', '', '0', '', '', '', '', 'yes', '', '74.15.81.141', '74.15.81.141', '', '0', '----'),
    ('2041', 'hardtodie0', 'hardtodie0', '', '[email protected]', '0', '', '1172729343', '0', '1172711498', '', '', '0', '', '', '', '', 'yes', '', '63.252.66.201', '63.252.66.201', '', '0', '----'),
    ('2042', 'hassanrca', 'hassanrca', '', '[email protected]', '0', '', '1173305253', '0', '1172714989', '', '', '0', '', '', '', '', 'yes', '', '82.231.152.210', '82.231.152.210', '', '0', '----'),
    ('2043', 'baxter316', 'baxter316', '', '[email protected]', '0', '', '1172927423', '0', '1172927399', '', '', '0', '', '', '', '', 'yes', '', '195.93.21.39', '195.93.21.39', '', '0', '----'),
    ('2044', 'ratsco', 'ratsco', '', '[email protected]', '0', '', '1175773383', '0', '1172832497', '', '', '0', '', '', '', '', 'yes', '', '203.59.159.130', '203.59.159.130', '', '0', '----'),
    ('2045', 'LazyPeanut', 'LazyPeanut', '', '[email protected]', '6', '', '1173364317', '0', '1172763102', '', '', '0', '', '', '', '', 'yes', '', '81.243.142.239', '81.243.142.239', '', '0', '----'),
    ('2046', 'huggies', 'huggies', '', '[email protected]', '0', '', '1173466808', '0', '1172769489', '', '', '0', '', '', '', '', 'yes', '', '204.8.198.2', '204.8.198.2', '', '0', '----'),
    ('2047', 'eastfifearabman', 'eastfifearabman', '', '[email protected]', '0', '', '1172783784', '0', '1172783324', '', '', '0', '', '', '', '', 'yes', '', '82.41.124.189', '82.41.124.189', '', '0', '----'),
    ('2048', 'Ghost_Rider_666', 'Ghost_Rider_666', '', '[email protected]', '0', '', '1172860385', '0', '1172859584', '', '', '0', '', '', '', '', 'yes', '', '80.192.163.139', '80.192.163.139', '', '0', '----'),
    ('2049', 'kagakaga1', 'kagakaga1', '', '[email protected]', '0', '', '1172868706', '0', '1172868685', '', '', '0', '', '', '', '', 'yes', '', '172.142.109.64', '172.142.109.64', '', '0', '----'),
    ('2050', 'wentworth2006', 'wentworth2006', '', '[email protected]', '0', '', '1177177644', '0', '1172871972', '', '', '0', '', '', '', '', 'yes', '', '86.133.124.17', '86.133.124.17', '', '0', '----'),
    ('2051', 'Jamesisfun93', 'Jamesisfun93', '', '[email protected]', '0', '', '1172873144', '0', '1172872500', '', '', '0', '', '', '', '', 'yes', '', '211.27.246.184', '211.27.246.184', '', '0', '----'),
    ('2052', 'aussie2000', 'aussie2000', '', '[email protected]', '0', '', '1172902607', '0', '1172902539', '', '', '0', '', '', '', '', 'yes', '', '58.178.226.251', '58.178.226.251', '', '0', '----'),
    ('2053', 'kkojot', 'kkojot', '', '[email protected]', '0', '', '1172955587', '0', '1172955542', '', '', '0', '', '', '', '', 'yes', '', '91.143.221.169', '91.143.221.169', '', '0', '----'),
    ('2054', 'jokern102', 'jokern102', '', '[email protected]', '0', '', '1172959847', '0', '1172959828', '', '', '0', '', '', '', '', 'yes', '', '217.209.9.33', '217.209.9.33', '', '0', '----'),
    ('2055', 'shady45', 'shady45', '', '[email protected]', '0', '', '1172977975', '0', '1172977954', '', '', '0', '', '', '', '', 'yes', '', '69.116.131.71', '69.116.131.71', '', '0', '----'),
    ('2056', 'olexinski', 'olexinski', '', '[email protected]', '0', '', '1173192857', '0', '1173192770', '', '', '0', '', '', '', '', 'yes', '', '83.27.92.102', '83.27.92.102', '', '0', '----'),
    ('2057', 'deathman', 'deathman', '', '[email protected]', '0', '', '1173010282', '0', '1172995673', '', '', '0', '', '', '', '', 'yes', '', '217.194.149.227', '217.194.149.227', '', '0', '----'),
    ('2058', 'saj72', 'saj72', '', '[email protected]', '0', '', '1173576654', '0', '1172996474', '', '', '0', '', '', '', '', 'yes', '', '211.30.200.190', '211.30.200.190', '', '0', '----'),
    ('2059', 'kerry24', 'kerry24', '', '[email protected]', '0', '', '1173108502', '0', '1173100544', 'http://', 'http://', '0', '', '', '[email protected]', 'I love Simon 4 eva and eva.', 'yes', '', '144.137.249.153', '144.137.249.153', '', '0', '1983-2-19'),
    ('2060', 'Replay', 'Replay', '', '[email protected]', '26', '', '1180202088', '0', '1173300416', '', '', '0', 'Da Finest of NY', '[email protected]', '[email protected]', 'My One Click Movie Downloads', 'yes', '', '70.23.85.179', '70.23.85.179', '', '0', '1990-4-4'),
    ('2061', 'banderas', 'banderas', '', '[email protected]', '0', '', '1173819165', '0', '1173218804', '', '', '0', '', '', '', '', 'yes', '', '84.71.26.103', '84.71.26.103', '', '0', '----'),
    ('2062', 'Jibaro', 'Jibaro', '', '[email protected]', '0', '', '1173221496', '0', '1173221451', '', '', '0', '', '', '', '', 'yes', '', '75.21.67.136', '75.21.67.136', '', '0', '----'),
    ('2063', 'sureshisgreat', 'sureshisgreat', '', '[email protected]', '0', '', '1176763601', '0', '1173221638', '', '', '0', '', '', '', '', 'yes', '', '91.4.86.117', '91.4.86.117', '', '0', '----'),
    ('2064', 'Luminux', 'Luminux', '', '[email protected]', '0', '', '1173756259', '0', '1173224779', '', '', '0', '', '', '', '', 'yes', '', '74.13.110.19', '74.13.110.19', '', '0', '----'),
    ('2065', 'lyrical_headspin', 'lyrical_headspin', '', '[email protected]', '1', '', '1173333634', '0', '1173333607', '', '', '0', '', '', '', '', 'yes', '', '158.136.163.110', '158.136.163.110', '', '0', '----'),
    ('2066', 'webspinner', 'webspinner', '', '[email protected]', '0', '', '1173367632', '0', '1173367595', '', '', '0', '', '', '', '', 'yes', '', '72.1.206.12', '72.1.206.12', '', '0', '----'),
    ('2067', 'hollathina', 'hollathina', '', '[email protected]', '0', '', '1173385799', '0', '1173385765', '', '', '0', '', '', '', '', 'yes', '', '82.152.204.39', '82.152.204.39', '', '0', '----'),
    ('2068', 'stokesg', 'stokesg', '', '[email protected]', '0', '', '1173388551', '0', '1173388157', '', '', '0', '', '', '', '', 'yes', '', '62.253.128.12', '62.253.128.12', '', '0', '----'),
    ('2069', 'Brillig', 'Brillig', '', '[email protected]', '3', '', '1174336859', '0', '1173388839', '', '', '0', '', '', '', '', 'yes', '', '72.54.129.226', '72.54.129.226', '', '0', '----'),
    ('2070', 'miki', 'miki', '', '[email protected]', '0', '', '1173451748', '0', '1173451661', '', '', '0', '', '', '', '', 'yes', '', '84.2.150.192', '84.2.150.192', '', '0', '----'),
    ('2071', 'bartinjapan', 'bartinjapan', '', '[email protected]', '0', '', '1176988532', '0', '1173492760', '', '', '0', '', '', '', '', 'yes', '', '124.26.164.2', '124.26.164.2', '', '0', '----'),
    ('2072', 'forget.regret', 'forget.regret', '', '[email protected]', '0', '', '1173518483', '0', '1173518458', '', '', '0', '', '', '', '', 'yes', '', '75.71.244.177', '75.71.244.177', '', '0', '----'),
    ('2073', 'oliversam123', 'oliversam123', '', '[email protected]', '0', '', '1173466610', '0', '1173466584', '', '', '0', '', '', '', '', 'yes', '', '82.36.105.112', '82.36.105.112', '', '0', '----'),
    ('2074', 'simpsonsfan102', 'simpsonsfan102', '', '[email protected]', '0', '', '1173665982', '0', '1173665967', '', '', '0', '', '', '', '', 'yes', '', '209.162.47.60', '209.162.47.60', '', '0', '----'),
    ('2075', 'cooltown', 'cooltown', '', '[email protected]', '0', '', '1173561667', '0', '1173561603', '', '', '0', '', '', '', '', 'yes', '', '59.92.130.181', '59.92.130.181', '', '0', '----'),
    ('2076', 'K3vin', 'K3vin', '', '[email protected]', '0', '', '1175696514', '0', '1175696494', '', '', '0', '', '', '', '', 'yes', '', '84.99.7.210', '84.99.7.210', '', '0', '----'),
    ('2077', 'twingats54', 'twingats54', '', '[email protected]', '0', '', '1173669452', '0', '1173669418', '', '', '0', '', '', '', '', 'yes', '', '67.37.190.23', '67.37.190.23', '', '0', '----'),
    ('2078', 'flavinoska', 'flavinoska', '', '[email protected]', '0', '', '1173783192', '0', '1173674380', '', '', '0', '', '', '', '', 'yes', '', '82.240.203.4', '82.240.203.4', '', '0', '----'),
    ('2079', 'poiuytre', 'poiuytre', '', '[email protected]', '0', '', '1173815740', '0', '1173748700', '', '', '0', '', '', '', '', 'yes', '', '84.196.242.33', '84.196.242.33', '', '0', '----'),
    ('2080', 'someone', 'someone', '', '[email protected]', '0', '', '1177011811', '0', '1173693009', '', '', '0', '', '', '', '', 'yes', '', '88.105.54.217', '88.105.54.217', '', '0', '----'),
    ('2081', 'simpson boy', 'simpson boy', '', '[email protected]', '0', '', '1174070735', '0', '1174070700', '', '', '0', '', '', '', '', 'yes', '', '81.77.104.151', '81.77.104.151', '', '0', '----'),
    ('2082', 'Vaibhav007', 'Vaibhav007', '', '[email protected]', '0', '', '1173793410', '0', '1173793373', '', '', '0', '', '', '', '', 'yes', '', '59.178.83.202', '59.178.83.202', '', '0', '----'),
    ('2083', 'stappo', 'stappo', '', '[email protected]', '0', '', '1173819908', '0', '1173819883', '', '', '0', '', '', '', '', 'yes', '', '84.197.50.31', '84.197.50.31', '', '0', '----'),
    ('2084', 'nix', 'nix', '', '[email protected]', '0', '', '1173835362', '0', '1173835329', '', '', '0', '', '', '', '', 'yes', '', '200.116.173.103', '200.116.173.103', '', '0', '----'),
    ('2085', 'jn1978', 'jn1978', '', '[email protected]', '0', '', '1173876389', '0', '1173876366', '', '', '0', '', '', '', '', 'yes', '', '82.233.53.142', '82.233.53.142', '', '0', '----'),
    ('2086', 'Jimbob2110', 'Jimbob2110', '', '[email protected]', '0', '', '1173890450', '0', '1173889655', '', '', '0', '', '', '', '', 'yes', '', '86.7.64.178', '86.7.64.178', '', '0', '----'),
    ('2087', 'pyro666', 'pyro666', '', '[email protected]', '0', '', '1174209491', '0', '1173899947', '', '', '0', '', '', '', '', 'yes', '', '221.135.251.166', '221.135.251.166', '', '0', '----'),
    ('2088', 'BadCase', 'BadCase', '', '[email protected]', '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]', '0', '', '1174016583', '0', '1174016571', '', '', '0', '', '', '', '', 'yes', '', '74.114.67.102', '74.114.67.102', '', '0', '----'),
    ('2091', 'NightTerrors', 'NightTerrors', '', '[email protected]', '0', '', '0', '0', '1174083639', '', '', '0', '', '', '', '', 'yes', '', '124.183.225.246', '124.183.225.246', '', '0', '----'),
    ('2092', 'ronroms', 'ronroms', '', '[email protected]', '0', '', '1174088319', '0', '1174088308', '', '', '0', '', '', '', '', 'yes', '', '201.143.81.254', '201.143.81.254', '', '0', '----'),
    ('2093', 'Shen', 'Shen', '', '[email protected]', '0', '', '1174112043', '0', '1174111989', '', '', '0', '', '', '', '', 'yes', '', '74.241.165.226', '74.241.165.226', '', '0', '----'),
    ('2094', 'Version1', 'Version1', '', '[email protected]', '0', '', '1174145129', '0', '1174145102', '', '', '0', '', '', '', '', 'yes', '', '124.189.66.15', '124.189.66.15', '', '0', '----'),
    ('2095', 'maame_masr', 'maame_masr', '', '[email protected]', '0', '', '1174156441', '0', '1174156422', '', '', '0', '', '', '', '', 'yes', '', '67.41.132.94', '67.41.132.94', '', '0', '----'),
    ('2096', 'doodster', 'doodster', '', '[email protected]', '0', '', '1174211082', '0', '1174211062', '', '', '0', '', '', '', '', 'yes', '', '194.42.116.11', '194.42.116.11', '', '0', '----'),
    ('2097', 'mekeskispas', 'mekeskispas', '', '[email protected]', '0', '', '1174248771', '0', '1174248746', '', '', '0', '', '', '', '', 'yes', '', '193.51.16.187', '193.51.16.187', '', '0', '----'),
    ('2098', 'HomerSimpson76-07', 'HomerSimpson76-07', '', '[email protected]', '0', '', '1175805473', '0', '1174268339', '', '', '0', '', '', '', '', 'yes', '', '70.143.58.203', '70.143.58.203', '', '0', '----'),
    ('2099', 'KarinaLG06_ipb2_import2103', 'KarinaLG06_ipb2_import2103', '', '[email protected]', '0', '', '0', '0', '1174279363', '', '', '0', '', '', '', '', 'yes', '', '198.202.25.212', '198.202.25.212', '', '0', '----'),
    ('2100', 'homer_rulz', 'homer_rulz', '', '[email protected]', '0', '', '1174283419', '0', '1174283396', '', '', '0', '', '', '', '', 'yes', '', '124.187.149.74', '124.187.149.74', '', '0', '----'),
    ('2101', 'huricane85_ipb2_import2105', 'huricane85_ipb2_import2105', '', '[email protected]', '0', '', '1174669795', '0', '1174319832', '', '', '0', '', '', '', '', 'yes', '', '193.54.215.253', '193.54.215.253', '', '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]', '0', '', '1174374814', '0', '1174374779', '', '', '0', '', '', '', '', 'yes', '', '124.184.58.89', '124.184.58.89', '', '0', '1992-4-27'),
    ('2104', 'Pakaveli', 'Pakaveli', '', '[email protected]', '0', '', '1175555225', '0', '1175555204', '', '', '0', '', '', '', '', 'yes', '', '82.36.219.76', '82.36.219.76', '', '0', '----'),
    ('2105', 'kamoku', 'kamoku', '', '[email protected]', '0', '', '1175353692', '0', '1174426488', '', '', '0', '', '', '', '', 'yes', '', '213.22.156.150', '213.22.156.150', '', '0', '----'),
    ('2106', 'turlach', 'turlach', '', '[email protected]', '0', '', '1174446966', '0', '1174446938', '', '', '0', '', '', '', '', 'yes', '', '87.192.246.215', '87.192.246.215', '', '0', '----'),
    ('2107', 'lisine', 'lisine', '', '[email protected]', '3', '', '1175697917', '0', '1174481724', '', '', '0', '', '', '', '', 'yes', '', '147.91.173.31', '147.91.173.31', '', '0', '----'),
    ('2108', 'thesimpsonsmanic141', 'thesimpsonsmanic141', '', '[email protected]', '16', '', '1176254205', '0', '1174816318', '', '', '0', '', '', '', '', 'yes', '', '58.110.136.156', '58.110.136.156', '', '0', '----'),
    ('2109', 'aruku', 'aruku', '', '[email protected]', '0', '', '1174827518', '0', '1174827494', '', '', '0', '', '', '', '', 'yes', '', '155.232.128.10', '155.232.128.10', '', '0', '----'),
    ('2110', 'Alexness', 'Alexness', '', '[email protected]', '0', '', '1175346281', '0', '1174860004', '', '', '0', '', '', '', '', 'yes', '', '81.164.5.63', '81.164.5.63', '', '0', '----'),
    ('2111', 'dayday_ipb2_import2116', 'dayday_ipb2_import2116', '', '[email protected]', '0', '', '1177325392', '0', '1174903453', '', '', '0', '', '', '', '', 'yes', '', '88.106.186.212', '88.106.186.212', '', '0', '----'),
    ('2112', 'majora', 'majora', '', '[email protected]', '0', '', '1174954977', '0', '1174954961', '', '', '0', '', '', '', '', 'yes', '', '80.47.114.36', '80.47.114.36', '', '0', '----'),
    ('2113', 'Craig', 'Craig', '', '[email protected]', '1', '', '1175023640', '0', '1174937965', '', '', '0', '', '', '', '', 'yes', '', '24.187.130.93', '24.187.130.93', '', '0', '----'),
    ('2114', 'ravensedge', 'ravensedge', '', '[email protected]', '0', '', '1174950389', '0', '1174950368', '', '', '0', '', '', '', '', 'yes', '', '204.209.17.254', '204.209.17.254', '', '0', '1985-10-4'),
    ('2115', 'KarinaLG87', 'KarinaLG87', '', '[email protected]', '0', '', '1175037117', '0', '1174956892', 'http://', 'http://', '0', '', '', '', '', 'yes', '', '198.202.25.212', '198.202.25.212', '', '0', '1987-4-29'),
    ('2116', 'Xmell', 'Xmell', '', '[email protected]', '0', '', '1175084217', '0', '1175080786', '', '', '0', '', '', '', '', 'yes', '', '213.141.159.112', '213.141.159.112', '', '0', '----'),
    ('2117', 'juniorpassa', 'juniorpassa', '', '[email protected]', '0', '', '1175730084', '0', '1175018555', '', '', '0', '', '', '', '', 'yes', '', '68.36.83.193', '68.36.83.193', '', '0', '----'),
    ('2118', 'Craig_no27', 'Craig_no27', '', '[email protected]', '0', '', '1175220311', '0', '1175215976', '', '', '0', '', '', '', '', 'yes', '', '218.214.141.73', '218.214.141.73', '', '0', '----'),
    ('2119', 'harrymorrison', 'harrymorrison', '', '[email protected]', '0', '', '1175042015', '0', '1175041958', '', '', '0', '', '', '', '', 'yes', '', '62.252.0.7', '62.252.0.7', '', '0', '----'),
    ('2120', 'doroti', 'doroti', '', '[email protected]', '0', '', '1175173045', '0', '1175091112', '', '', '0', '', '', '', '', 'yes', '', '195.56.186.198', '195.56.186.198', '', '0', '----'),
    ('2121', 'fantabulacious', 'fantabulacious', '', '[email protected]', '0', '', '1175116115', '0', '1175116091', '', '', '0', '', '', '', '', 'yes', '', '12.193.224.21', '12.193.224.21', '', '0', '----'),
    ('2122', 'saldejums', 'saldejums', '', '[email protected]', '0', '', '1175194807', '0', '1175194789', '', '', '0', '', '', '', '', 'yes', '', '132.183.13.1', '132.183.13.1', '', '0', '----'),
    ('2123', 'absolon', 'absolon', '', '[email protected]', '0', '', '1175421667', '0', '1175271737', '', '', '0', '', '', '', '', 'yes', '', '218.186.10.11', '218.186.10.11', '', '0', '----'),
    ('2124', 'thatguywhoposts', 'thatguywhoposts', '', '[email protected]', '0', '', '1175276738', '0', '1175276376', '', '', '0', '', '', '', '', 'yes', '', '82.34.247.156', '82.34.247.156', '', '0', '----'),
    ('2125', 'Daniel_ipb2_import2125', 'Daniel_ipb2_import2125', '', '[email protected]', '0', '', '1175314238', '0', '1175314154', '', '', '0', '', '', '', '', 'yes', '', '125.237.40.98', '125.237.40.98', '', '0', '----'),
    ('2126', 'SpambotVersion2', 'SpambotVersion2', '', '[email protected]', '8', '', '1175406258', '0', '1175401351', '', '', '0', '', '', '', '', 'yes', '', '208.68.99.185', '208.68.99.185', '', '0', '----'),
    ('2127', 'chu_ri_su', 'chu_ri_su', '', '[email protected]', '0', '', '1175334042', '0', '1175333818', '', '', '0', '', '', '', '', 'yes', '', '60.52.178.218', '60.52.178.218', '', '0', '----'),
    ('2128', 'xxvikkixx', 'xxvikkixx', '', '[email protected]', '0', '', '1175354883', '0', '1175354703', '', '', '0', '', '', '', '', 'yes', '', '88.109.235.165', '88.109.235.165', '', '0', '----'),
    ('2129', 'ImwithInvaderButters', 'ImwithInvaderButters', '', '[email protected]', '13', '', '1175402035', '0', '1175402010', '', '', '0', '', '', '', '', 'yes', '', '68.205.64.97', '68.205.64.97', '', '0', '----'),
    ('2130', 'thaihung', 'thaihung', '', '[email protected]', '0', '', '1175414886', '0', '1175414792', '', '', '0', '', '', '', '', 'yes', '', '125.214.63.35', '125.214.63.35', '', '0', '----'),
    ('2131', 'MrBitter805', 'MrBitter805', '', '[email protected]', '0', '', '1175481616', '0', '1175481453', '', '', '0', '', '', '', '', 'yes', '', '207.200.116.70', '207.200.116.70', '', '0', '----'),
    ('2132', 'erikyates', 'erikyates', '', '[email protected]', '0', '', '1175455058', '0', '1175455030', '', '', '0', '', '', '', '', 'yes', '', '70.146.6.36', '70.146.6.36', '', '0', '----'),
    ('2133', 'KrustyBurgerLad', 'KrustyBurgerLad', '', '[email protected]', '0', '', '1175457727', '0', '1175457664', '', '', '0', '', '', '', '', 'yes', '', '74.235.213.164', '74.235.213.164', '', '0', '----'),
    ('2134', 'Phil K_ipb2_import2134', 'Phil K_ipb2_import2134', '', '[email protected]', '3', '', '1180008349', '0', '1175470040', 'http://', 'http://', '0', '', '', '', '', 'yes', '', '82.39.227.248', '82.39.227.248', '', '0', '1908-4-13'),
    ('2135', 'vvthanh', 'vvthanh', '', '[email protected]', '0', '', '1177325006', '0', '1175577820', '', '', '0', '', '', '', '', 'yes', '', '74.116.34.153', '74.116.34.153', '', '0', '----'),
    ('2136', 'tester', 'tester', '', '[email protected]', '2', '', '1175553114', '0', '1175485879', '', '', '0', '', '', '', '', 'yes', '', '24.195.161.215', '24.195.161.215', '', '0', '----'),
    ('2137', 'tulpa', 'tulpa', '', '[email protected]', '0', '', '1175595019', '0', '1175594994', '', '', '0', '', '', '', '', 'yes', '', '64.59.144.85', '64.59.144.85', '', '0', '----'),
    ('2138', 'theoneh', 'theoneh', '', '[email protected]', '0', '', '1175607798', '0', '1175607782', '', '', '0', '', '', '', '', 'yes', '', '194.112.196.135', '194.112.196.135', '', '0', '----'),
    ('2139', 'overlord13', 'overlord13', '', '[email protected]', '1', '', '1175634272', '0', '1175634244', '', '', '0', '', '', '', '', 'yes', '', '195.166.203.156', '195.166.203.156', '', '0', '----'),
    ('2140', 'theresalwaysanotherway', 'theresalwaysanotherway', '&

[JayBachatero]

Are you using the converter in this topic?

[el canadiano]

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