Author Topic: [SMF Converter] vBulletin 3.7 (Read 130906 times)

SleePy · « **on:** September 17, 2008, 03:03:37 PM »

Software: vBulletin
Version: 3.7.x

The following is not converted:
- Permissions for boards are not converted.
- Membergorups are not converted.
- Avatar may not convert (under tested).

Changelog
- PM conversion failed

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

minos · « **Reply #1 on:** September 25, 2008, 04:45:53 AM »

when converter is in private messages gives an error

Converting personal messages (step 2)... Unsuccessful!
This query:

SELECT
pm.pmid AS ID_PM, pm.userid AS ID_MEMBER, pm.messageread != 0 AS is_read,
'-1' AS labels
FROM `forum`.vbpm
LIMIT 0, 500;

Caused the error:

Unknown column 'pm.pmid' in 'field list'

SleePy · « **Reply #2 on:** September 25, 2008, 02:12:03 PM »

Does this one work?

minos · « **Reply #3 on:** September 25, 2008, 03:40:59 PM »

yes it works thank you

HR · « **Reply #4 on:** October 02, 2008, 01:33:48 PM »

Boards dont seem to be coming over.. posts and what all show as successful but smf_boards retains a value of 0

Resolved.. manual edit of database revealed all parentid was set to -1, reset to value of 1 and POOF

SleePy · « **Reply #5 on:** October 02, 2008, 06:58:35 PM »

Ahh so they where converted? Just not showing.

Did you have any categories setup in vb? That would be the only reason I can think of there being that issue.

bigi_18 · « **Reply #6 on:** October 08, 2008, 08:40:54 PM »

Code: [Select]

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3.7. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: Incorrect database name ''

TE · « **Reply #7 on:** October 09, 2008, 01:41:38 AM »

Common conversion errors. or Converting to SMF should help..
The (absolute) path to vBulletin 3.7 is wrong or the mysql user from your SMF database cannot access the vBulletin 3.7 database..

southernlady · « **Reply #8 on:** October 13, 2008, 04:01:54 PM »

I used the config file from vb 3.6 and the sql file from first post in this thread to convert a vb 3.7.2 forum over this morning. I am pleased to report that the conversion went without a hitch. Avatars and ranks did not move over but that was the only stuff that came up missing. I did have to run a repair afterwards because I turned around and moved it to a new domain. But that was my fault, not the fault of the converter.

Well done. Liz

adamcanada · « **Reply #9 on:** October 15, 2008, 01:22:50 PM »

When I try to plug this database into my SMF + TinyPortal install I am getting the following even though I have raised the memory limit

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 122880 bytes) in /home/over/public_html/Sources/Load.php(1735) : eval()'d code on line 136

TE · « **Reply #10 on:** October 15, 2008, 01:41:02 PM »

That error means that converter script got to much data and was unable to hold it in memory, so php gave an error. was it while converting the posts? then you can try this:

edit the vbulletin37_to_smf.sql and find:

Code: [Select]

---* {$to_prefix}messages 200
replace it with

Code: [Select]

---* {$to_prefix}messages 100

then upload the changed file and restart the conversion..

ReVoKe · « **Reply #11 on:** October 27, 2008, 10:28:03 PM »

i get....

Quote

Converting...
Converting members... Unsuccessful!
This query:
INSERT IGNORE INTO `bnetfire_vb`.smf_members
(ID_MEMBER, memberName, realName, passwd, emailAddress, websiteTitle, websiteUrl, ICQ, AIM, YIM, MSN, usertitle, lastLogin, dateRegistered, posts, karmaGood, birthdate, memberIP, memberIP2, ID_GROUP, is_activated, passwordSalt, signature, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, timeFormat, avatar, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet)
VALUES ('1', 'ReVoKe', 'ReVoKe', '0ec17173bc74c9f88a6d96039e6666a8', 'bnetfire@hotmail.com', 'http://bnetfire.net/', 'http://bnetfire.net/', '', 'asmogar', '', '', 'Administrator/Creator/Owner', '1225148508', '1220822700', '78', '10', '0000-00-00', '', '', '1', '1', '&f/', '-------
[5:21:35 PM] <BraSs> <3 u ReVoKe
-------
Join This PvPGN Server!
Server info:
Name: Delta
Host: 71.208.217.108
Zone: -7
-------', '', '', '', '', '', '', '', '', '', '', '', ''),
('19', 'Chriso', 'Chriso', '951e4419e7b3ca0c5187086b9acf0605', 'lancergli@gmail.com', '', '', '', '', '', '', '', '1222401010', '1222401010', '1', '10', '0000-00-00', '58.106.174.187', '58.106.174.187', '0', '1', '.`w', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('3', 'JLane0', 'JLane0', 'c877c4e8517ccbeddb925364c5310e3b', 'woahhaow@hotmail.com', '', '', '', '', '', '', '', '1223488838', '1220902260', '20', '10', '0000-00-00', '69.113.121.254', '69.113.121.254', '0', '1', '>s.', 'Hipposaurous rex', '', '', '', '', '', '', '', '', '', '', '', ''),
('4', 'Felix', 'Felix', 'b45478aa2c70d538546c5ef769de6a99', 'sapdexplorers@hotmail.com', '', '', '', '', '', '', '', '1221016183', '1221016183', '1', '10', '0000-00-00', '63.22.107.143', '63.22.107.143', '0', '1', 'Qzw', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('5', 'Justin', 'Justin', '722b52caf81e6e87b25d1ade7ac6cabd', 'jlane0@pld.com', '', '', '', 'HstLand', '', '', 'FireOps Creator/Administrator', '1225068179', '1221186900', '69', '20', '1992-07-18', '', '', '1', '1', '|2O', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('6', 'Thief', 'Thief', '85aecca851eb476b095a362fc50ebf4c', 'Myst@DarkBlizz.org', '', '', '', '', '', '', '', '1223774233', '1221273687', '0', '10', '0000-00-00', '68.192.239.44', '68.192.239.44', '0', '1', 'ccd', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('7', 'XD-1000', 'XD-1000', 'da87c820dedeaaadfe7990659c603b33', 'xd-1000@sshandyman.com', 'http://www.1-stop-isp.net', 'http://www.1-stop-isp.net', '', 'XD1000DG', '', 'xd-1000@sshandyman.com', '', '1225017949', '1221280647', '21', '10', '1966-01-29', '71.208.230.176', '71.208.230.176', '0', '1', '%}A', 'XD-1000

Join Delta Server!
Server info:
Name: Delta
Host: delta.game-server.cc
Zone: -7

Game On!
-------', '', '', '', '', '', '', '', '', '', '', '', ''),
('8', 'elwizard', 'elwizard', '77307d3770c1d3aefc492598af306dd2', 'webmaster@desarrollo-mkportal.org', '', '', '', '', '', '', '', '1221428280', '1221428280', '0', '10', '0000-00-00', '88.15.146.115', '88.15.146.115', '0', '1', 'F+c', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('9', 'meni', 'meni', '59cce7bffcb2e57f54fb41fba7307834', 'asmogar@aol.com', '', '', '', '', '', '', '', '1221429788', '1221429764', '0', '10', '0000-00-00', '65.102.55.49', '65.102.55.49', '0', '1', 'QKO', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('10', '~m(O_o)m~', '~m(O_o)m~', '5264778555717c78ab525235c5ce370e', 'pud_doh@hotmail.com', 'http://gamerzgarage.co.nr/', 'http://gamerzgarage.co.nr/', '', '', '', '', '', '1221890773', '1221438480', '2', '10', '1982-11-11', '67.159.44.138', '67.159.44.138', '0', '1', 'Bzf', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('11', 'Oizumi03', 'Oizumi03', 'ac4d70306f5024b2dceda465d510bd61', 'oizumikun3@yahoo.com', '', '', '', '', '', '', '', '1221442064', '1221442064', '0', '10', '0000-00-00', '24.21.158.62', '24.21.158.62', '0', '1', 'ZL(', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('12', 'andres1', 'andres1', '2bceba06e54a3f19af8bf6bde2f3f5a7', 'ownage-warchamp@live.com', '', '', '', '', '', '', '', '1221754157', '1221690439', '0', '10', '0000-00-00', '68.196.1.136', '68.196.1.136', '0', '1', '.r6', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('13', 'kerako', 'kerako', 'b2d5d348d1fe36c106150aeed1f3efa5', 'onlyisjh@paran.com', '', '', '', '', '', '', '', '1224401962', '1222138458', '0', '10', '0000-00-00', '121.141.116.79', '121.141.116.79', '0', '1', 'F+^', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('14', 'Oik', 'Oik', '0faf25f47ef0de504a36e60e68b70537', 'a7xkid123@hotmail.com', '', '', '', 'xkeithxcorexx', '', 'a7xkid123@hotmail.com', '', '1223331594', '1222222980', '69', '10', '1991-04-22', '76.111.133.60', '76.111.133.60', '0', '1', ';7+', '(Insert Witty Comment Here)', '', '', '', '', '', '', '', '', '', '', '', ''),
('15', 'Carrier', 'Carrier', '12f21162a87f0d3d623c6b6f567836f2', 'Harry@Donihue.com', '', '', '', '', '', '', '', '1222228570', '1222228570', '0', '10', '0000-00-00', '76.169.179.97', '76.169.179.97', '0', '1', '@/N', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('16', 'Weak', 'Weak', 'a4c0d732661c0670764a4eccd8a03202', 'zh0823@gmail.com', '', '', '', '', '', '', '', '1222628205', '1222229886', '0', '10', '0000-00-00', '74.129.193.220', '74.129.193.220', '0', '1', 'wQm', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('18', 'MienTommy', 'MienTommy', 'd8f184bb96ce6b5e7efffe92e030d5ed', 'MienTommy@gmail.com', '', '', '', '', '', '', '', '1225138762', '1222319650', '0', '10', '0000-00-00', '69.238.196.211', '69.238.196.211', '0', '1', '|;-', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('20', 'STARCRAFTGOD', 'STARCRAFTGOD', '2f4c58f65f9eddcda7a9718afde62e78', 'ab@xtra.co.nz', '', '', '', '', '', '', '', '1222458379', '1222401139', '0', '10', '0000-00-00', '219.89.38.190', '219.89.38.190', '0', '1', 'r=u', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('21', 'Vanquished', 'Vanquished', '055a4bd2e10b0294316436087986223d', 'c.merrow1337@gmail.com', '', '', '', '', '', '', '', '1222479862', '1222479543', '1', '10', '0000-00-00', '69.49.149.103', '69.49.149.103', '0', '1', 'LBW', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('22', 'TeRR@n.BeST', 'TeRR@n.BeST', 'a3c8d99bbf15e2f8a2328b800df0d008', 'gac_forever@yahoo.com', '', '', '', '', '', '', '', '1222544635', '1222544635', '0', '10', '0000-00-00', '72.130.145.142', '72.130.145.142', '0', '1', 'Cf5', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('23', 'SyZo', 'SyZo', '4fd4bfd7b487d8437bb5d68c7dd0130c', 'eavina7@yahoo.com', '', '', '', '', '', '', '', '1222580832', '1222580772', '0', '10', '0000-00-00', '99.163.234.41', '99.163.234.41', '0', '1', '%ah', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('24', 'Google', 'Google', '263935812be84773552ce2e3ba12eb9a', 'Hyphern@aim.com', '', '', '', 'Hyphern', '', '', '', '1224800503', '1222581000', '35', '20', '0000-07-29', '71.108.205.147', '71.108.205.147', '1', '1', '{Z9', 'Sublime@USWest', '', '', '', '', '', '', '', '', '', '', '', ''),
('25', 'mclovin', 'mclovin', '310cf13503b41a0496071bf0e2e2bfd5', 'lolmclovin@gmail.com', 'http://mclovin.co.nr', 'http://mclovin.co.nr', '', 'lolmclovin', '', 'lolmclovin@live.com', '', '1222649200', '1222621789', '1', '10', '1986-09-01', '70.55.72.142', '70.55.72.142', '0', '1', 'Nk\"', '
War does not determine who is right - only who is left. ~Bertrand Russell', '', '', '', '', '', '', '', '', '', '', '', ''),
('26', 'MasterX', 'MasterX', 'dc0a9e68bd4c036c6bd96d90a3eaa98b', 'bjb_135@yahoo.com', '', '', '', '', '', '', '', '1222644617', '1222644617', '1', '10', '0000-00-00', '71.226.135.41', '71.226.135.41', '0', '1', '2I%', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('27', 'Punk', 'Punk', 'a913e649515b71e14208520d0bca6d18', 'a@yahoo.com', '', '', '', '', '', '', '', '1222660311', '1222660311', '0', '10', '0000-00-00', '67.150.171.210', '67.150.171.210', '0', '1', 'd.W', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('28', 'ComBaT', 'ComBaT', 'e8cfba6bab8f632859be030e8f9528c8', 'kgmoreno7@yahoo.com', 'http://myspace.com/halo_player15', 'http://myspace.com/halo_player15', '', 'mobious26', 'kgmoreno7@yahoo.com', 'kgmoreno7@hotmail.com', '', '1223750458', '1222736297', '13', '10', '1992-12-26', '24.155.118.156', '24.155.118.156', '0', '1', 'P+d', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('29', 'ProSpeCt.of.AH', 'ProSpeCt.of.AH', '3a87c9e6631b46d704050427498dcd22', 'HutnanScoresAgain@hotmail.com', 'http://clanah.net', 'http://clanah.net', '', 'ProSpeCtofAH', '', 'HutnanScoresAgain@hotmail.com', '', '1224654872', '1222861320', '156', '10', '1992-02-15', '24.71.244.35', '24.71.244.35', '2', '1', '_T}', '
Current Verbytes:
Stacraft = D1
Starcraft: Brood War = D1
Warcraft 2 = 4F
Diablo 2 = 0C
DIablo 2: Lord of Destruction = 0C
Warcraft 3 = 16
Warcraft 3: The Frozen Throne = 16

All of my downloads have the password \'\'ProSpeCt.of.AH@BNetFire.net\'\'
', '', '', '', '', '', '', '', '', '', '', '', ''),
('30', 'Disease', 'Disease', '320bf5f8dd444bec6be65db68d0c7856', 'petboy_lazyboy@yahoo.com', '', '', '', 'YouGotDiseased', '', '', '', '1222915220', '1222915220', '0', '10', '1990-08-13', '69.146.153.26', '69.146.153.26', '0', '1', 'gY{', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('31', 'BnetLair', 'BnetLair', '1adf2c268091399112da8bf7001a0ef5', 'admin@bnetlair.com', '', '', '', '', '', '', '', '1224975855', '1222921920', '1', '10', '0000-00-00', '76.168.212.21', '76.168.212.21', '0', '1', '+M]', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('32', 'Helix', 'Helix', '4a7dbda890d84effbbc86f9b4311a442', 'ftwkid56@yahoo.com', '', '', '', '', '', '', '', '1222990987', '1222990987', '0', '10', '0000-00-00', '76.181.54.248', '76.181.54.248', '0', '1', '!_9', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('33', 'Hunter', 'Hunter', 'c1414e89d9905d12621c7c9c24e98b02', 'griffinigin@aim.com', '', '', '', '', '', '', '', '1222992898', '1222992898', '0', '10', '0000-00-00', '68.199.223.73', '68.199.223.73', '0', '1', 'l-9', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('34', 'Admin', 'Admin', 'a6c3bb5be54ce0322262eb19fc0487be', 'info@hostingland.org', '', '', '', '', '', '', '', '1223004260', '1223004180', '0', '10', '0000-00-00', '', '', '0', '1', '/cs', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('38', 'Hoitobini', 'Hoitobini', '67842d80e48220da33bc54fb9d5df3a2', 'arrelfweenzep@gawab.com', '', '', '', '', '', '', '', '1223171430', '1223171430', '0', '10', '0000-00-00', '71.142.72.135', '71.142.72.135', '0', '1', 'c&j', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('35', 'boxer', 'boxer', '2cfe024d36278497ac8d7c978ae1542b', 'wisesolutions200@gmail.com', '', '', '', '', '', '', '', '1223092142', '1223092142', '0', '10', '0000-00-00', '71.181.179.220', '71.181.179.220', '0', '1', '._\"', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('36', 'shoes', 'shoes', 'dc54c1d7c431e91353264603cf710356', 'whiteguitar666@aol.com', '', '', '', '', '', '', '', '1223144914', '1223144914', '0', '10', '0000-00-00', '67.181.246.68', '67.181.246.68', '0', '1', 'lE5', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('37', 'Rancid', 'Rancid', '4375784730339b6e280332b0989958b5', 'xero12363@yahoo.com', '', '', '', '', '', '', '', '1223146840', '1223146840', '0', '10', '0000-00-00', '70.233.178.12', '70.233.178.12', '0', '1', '\"sm', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('39', 'Dan', 'Dan', '190c5f9e96cc05fa07250fada46b451a', 'clansevilpower@yahoo.com', '', '', '', '', '', '', '', '1223238294', '1223238294', '0', '10', '0000-00-00', '98.216.182.80', '98.216.182.80', '0', '1', '%O&', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('40', 'Blak-', 'Blak-', 'ef4d4d135db02add56efa0c001b6b0e2', 'cheeko_559@hotmail.com', '', '', '', '', '', '', '', '1223258736', '1223258736', '0', '10', '0000-00-00', '69.237.163.149', '69.237.163.149', '0', '1', 'P@U', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('41', 'DooMeD', 'DooMeD', 'de96a334f5d607c2ee6fae7c0bd70f04', 'joe69roy@hotmail.com', '', '', '', '', '', '', '', '1223260751', '1223260751', '0', '10', '0000-00-00', '69.21.250.35', '69.21.250.35', '0', '1', ':/T', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('42', 'JLaneZero', 'JLaneZero', 'f6383f6fec8154fdb705b7896bd12fb1', 'jlane0@hotmail.com', '', '', '', '', '', '', '', '1223521862', '1223521862', '0', '10', '0000-00-00', '68.80.146.69', '68.80.146.69', '0', '1', 's]r', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('43', 'HydraulicS', 'HydraulicS', 'd0cc9214396b2200066d1cfac3991ad4', 'hydraulics-@hotmail.com', '', '', '', '', '', '', '', '1223594486', '1223594486', '0', '10', '0000-00-00', '69.230.58.196', '69.230.58.196', '0', '1', '3.P', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('44', 'Vengeance', 'Vengeance', '1a2ee8cd40710aac50147dc54428f9a1', 'NecroDragon_666@Hotmail.com', '', '', '', '', '', '', '', '1223723213', '1223722549', '0', '10', '0000-00-00', '220.255.7.194', '220.255.7.194', '0', '1', '/Wv', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('45', 'Maddi', 'Maddi', 'f17dd84228a7b9e08dfbb9abcfabc977', 'lil_maddi@hotmail.com', '', '', '', '', '', '', '', '1224122556', '1223775011', '20', '10', '1990-05-14', '66.222.233.247', '66.222.233.247', '0', '1', 'iy\\', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('46', 'JOYKILLAH', 'JOYKILLAH', 'ce74e8e9e204236f40bf66831cd61257', 'NARINPOTPOT@YAHOO.COM', '', '', '', '', '', '', '', '1223817420', '1223815915', '0', '10', '0000-00-00', '71.107.128.105', '71.107.128.105', '0', '1', '8}r', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('47', 'vK.LoRd', 'vK.LoRd', '0249278d2b01b863fa0ea96fd692ee42', 'tauro91@gmail.com', '', '', '', '', '', '', '', '1223850597', '1223850597', '1', '10', '0000-00-00', '24.127.194.43', '24.127.194.43', '0', '1', ';?y', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('48', 'Gail', 'Gail', '0d31750c7dd63be57ddc515a81204326', 'yomega_420@yahoo.com', '', '', '', '', '', '', 'Gail\'s Keytester Creator', '1224120668', '1223922300', '7', '10', '0000-00-00', '65.175.236.57', '65.175.236.57', '0', '1', 'ex{', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('49', 'LostOne', 'LostOne', 'cee06d1fcf80de34ba5e5fe87a532aee', 'grand.theft@hotmail.com', '', '', '', '', '', '', '', '1224540197', '1223922510', '0', '10', '0000-00-00', '68.196.1.136', '68.196.1.136', '0', '1', 'TMc', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('50', 'Else', 'Else', '52dff3f5c75162836f1fb0b6fdcf1eaa', 'reapersdesign@gmail.com', '', '', '', '', '', '', '', '1223946085', '1223945580', '1', '10', '0000-00-00', '65.175.236.57', '65.175.236.57', '0', '1', '7Ig', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('51', 'Chromy', 'Chromy', 'baae014cbe004c7de3ca68805f2ec437', 'insaneflame89@yahoo.com', '', '', '', '', '', '', '', '1223949300', '1223949300', '0', '10', '0000-00-00', '70.251.45.162', '70.251.45.162', '0', '1', 'n2J', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('52', 'Ichigo', 'Ichigo', '3f09d29424ec6274ec787521b13a2853', 'frastahouse@yahoo.com', '', '', '', '', '', '', '', '1224371180', '1224371143', '0', '10', '0000-00-00', '70.162.138.245', '70.162.138.245', '0', '1', '.iO', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('53', 'Riksin808', 'Riksin808', '711cc38d5a3d8b79721070b648ad3726', 'delta81@ymail.com', '', '', '', '', '', '', '', '1224371420', '1224371420', '0', '10', '0000-00-00', '70.162.138.245', '70.162.138.245', '0', '1', '=no', '
Riksin808
', '', '', '', '', '', '', '', '', '', '', '', ''),
('54', 'blinkedkid22', 'blinkedkid22', 'e39890dce93858b97f43032d85edcd68', 'chelyanrocks@yahoo.com', '', '', '', '', '', '', '', '1224375091', '1224375091', '0', '10', '0000-00-00', '74.177.83.209', '74.177.83.209', '0', '1', '+uo', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('55', 'saef', 'saef', 'bc47e5e1943b2d05ef2fc4ca6e736cc1', 'ssggss@web.de', '', '', '', '', '', '', '', '1224437727', '1224437727', '0', '10', '0000-00-00', '84.191.238.76', '84.191.238.76', '0', '1', ')D!', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('56', 'kAiih', 'kAiih', '1b17ba7476ff4c6208102f90be476bcc', '94kai@gmx.de', '', '', '', '', '', '', '', '1224449257', '1224449257', '0', '10', '0000-00-00', '86.56.53.207', '86.56.53.207', '0', '1', 'HFE', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('57', 'nolife', 'nolife', '19bc2a6fdd531a6cad9af25acb107967', 'imadboss999@hotmail.com', '', '', '', '', '', '', '', '1224456583', '1224456182', '0', '10', '1994-09-01', '74.15.233.181', '74.15.233.181', '0', '1', 'p|=', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('58', 'Coollue', 'Coollue', 'c60d47284dc2655d94e2c091b66f4118', 'gson48thstreet@yahoo.com', '', '', '', '', '', '', '', '1224456205', '1224456205', '0', '10', '0000-00-00', '74.233.151.98', '74.233.151.98', '0', '1', '(kL', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('59', 'MA[Night]', 'MA[Night]', 'f7b90e5b15bc03e4363983ca3fb9777f', 'firegodheat@aol.com', '', '', '', '', '', '', '', '1224456461', '1224456461', '0', '10', '0000-00-00', '24.21.238.216', '24.21.238.216', '0', '1', 'uZ#', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('60', 'rouben', 'rouben', '9195aba9be3c30692941e091e645b1e3', 'roubel13@yahoo.com', '', '', '', '', '', '', '', '1224500955', '1224462203', '0', '10', '0000-00-00', '77.49.72.75', '77.49.72.75', '0', '1', '[X<', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('61', 'bh3t', 'bh3t', 'c90ac2e2296cf7a378ec2bd5c1e377ce', 'rk2_rkl@hotmail.com', '', '', '', '', '', '', '', '1224617966', '1224617966', '0', '10', '0000-00-00', '200.86.247.94', '200.86.247.94', '0', '1', 'P(M', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('62', 'dust', 'dust', '9a27dbfb525d4ccd55d3c5afa5e85247', 'tehseven@hotmail.com', '', '', '', '', '', '', '', '1224730763', '1224730763', '0', '10', '0000-00-00', '70.55.74.233', '70.55.74.233', '0', '1', 'vhr', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('63', 'dead man', 'dead man', 'd958a08d9b68a2aae6a19391986d1a85', 'warriors_520@yahoo.com', '', '', '', '', '', '', '', '1224803681', '1224803681', '0', '10', '0000-00-00', '79.73.178.39', '79.73.178.39', '0', '1', ')%+', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('64', 'Kommwths', 'Kommwths', '46b5cad43a1e10c8103267f454057787', 'sar_bel_18@hotmail.com', '', '', '', '', '', '', '', '1224964470', '1224964470', '0', '10', '0000-00-00', '85.73.175.171', '85.73.175.171', '0', '1', 'a9D', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('65', 'sixgig', 'sixgig', 'f361499ec1b108478a98ddac01e1b18a', 'mycelitiva@yahoo.com', '', '', '', '', '', '', '', '1224964506', '1224964506', '0', '10', '0000-00-00', '72.241.232.235', '72.241.232.235', '0', '1', '5YN', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('66', 'FooL', 'FooL', '9ae0c952ac5586765c7847facd730bfb', 'MiraGe1285@Yahoo.com', '', '', '', '', '', '', '', '1224966441', '1224966441', '0', '10', '0000-00-00', '68.186.145.197', '68.186.145.197', '0', '1', '8Hh', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('67', 'dvdx', 'dvdx', '184a5ef61eecf716ca0053e9e373374f', 'dvdx@zahav.net.il', '', '', '', '', '', '', '', '1224966572', '1224966572', '0', '10', '0000-00-00', '77.126.209.202', '77.126.209.202', '0', '1', '\'&}', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('68', 'Demo', 'Demo', '4c148b5052aa812b70748974931f71bd', 'extremosteveo@yahoo.com', '', '', '', '', '', '', '', '1224974635', '1224970229', '0', '10', '0000-00-00', '69.141.182.213', '69.141.182.213', '0', '1', 'ccN', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('69', 'ackack', 'ackack', '333a8bc0d20d346132a734faa5b19bb1', 'googood92@gmail.com', '', '', '', '', '', '', '', '1224974969', '1224974501', '0', '10', '0000-00-00', '24.255.105.86', '24.255.105.86', '0', '1', 'd;m', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('70', 'BaN', 'BaN', 'd8d35a80a7911c6fce31ff3b01c41229', 'unamedperson@gmail.com', '', '', '', '', '', '', '', '1224983713', '1224982861', '0', '10', '0000-00-00', '203.206.99.246', '203.206.99.246', '0', '1', 'Xi]', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('71', 'KooLz', 'KooLz', 'a97db5d81cbfb6f76ebb60edce5f26c0', 'bert_heidel@yahoo.com', '', '', '', 'kakarah99', 'Bert_Heidel', '', '', '1225045882', '1224993800', '0', '10', '1982-07-30', '75.65.99.53', '75.65.99.53', '0', '1', 'b(e', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('72', 'GruntLord', 'GruntLord', 'ef8e74d07206af348996837c9b19b8e3', 'GruntLord23@yahoo.com', '', '', '', '', '', '', '', '1224993984', '1224993961', '0', '10', '0000-00-00', '69.208.151.102', '69.208.151.102', '0', '1', 'md\'', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('73', 'james89', 'james89', 'cce131cd5b91bf0ab8629f0d62a0a08d', 'james89@gmail.com', '', '', '', '', '', '', '', '1225001882', '1225001882', '0', '10', '0000-00-00', '129.110.198.23', '129.110.198.23', '0', '1', 'P{>', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('74', 'Stevsta', 'Stevsta', '51486404385724508e06ef7f6c05d255', 'sxtxexvxexn@hotmail.com', '', '', '', '', '', '', '', '1225035690', '1225035690', '0', '10', '0000-00-00', '220.238.225.125', '220.238.225.125', '0', '1', '4qD', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('75', 'technobeats', 'technobeats', '7b346df1d255230e13d98d4739263286', 'jellegame@hotmail.com', '', '', '', '', '', '', '', '1225054369', '1225054369', '0', '10', '0000-00-00', '78.21.68.222', '78.21.68.222', '0', '1', ':I&', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('76', 'DowsFelfFeeks', 'DowsFelfFeeks', 'b9742dea6566de577c6d792824ccb163', 'mowsswaks@gmail.com', '', '', '', '', '', '', '', '1225063412', '1225063412', '0', '10', '0000-00-00', '79.143.177.3', '79.143.177.3', '0', '1', 'chl', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('77', 'bonemaster007', 'bonemaster007', '806ec833b941ca5025e5d41626024635', 'james_my_name_ud@hotmail.com', '', '', '', '', '', '', '', '1225063844', '1225063844', '0', '10', '0000-00-00', '85.72.141.239', '85.72.141.239', '0', '1', '8f|', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('78', '0o@USWest', '0o@USWest', '45caf52cfb93782e754d380fba1197f9', 'kewl.-.420@hotmail.com', '', '', '', '', '', '', '', '1225065638', '1225065638', '0', '10', '0000-00-00', '75.175.51.31', '75.175.51.31', '0', '1', 'L=#', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('79', 'SlickXanny', 'SlickXanny', '80a7ddd2aaffd76e04d0d069bcee8cba', 'cjrapcrew@cox.net', '', '', '', '', '', '', '', '1225150869', '1225150869', '0', '10', '0000-00-00', '76.2.136.147', '76.2.136.147', '0', '1', 'a-3', '', '', '', '', '', '', '', '', '', '', '', '', '');
Caused the error:

Unknown column 'memberName' in 'field list'

TE · « **Reply #12 on:** October 28, 2008, 01:56:45 PM »

Which version of SMF are you using?

Quote

Unknown column 'memberName' in 'field list'

Sounds like you have installed SMF 2.0B4? the converters are for SMF 1.1.x at this time.. so you have to install SMF 1.1.6 first and convert your vBulletin, then run the large-upgrade from our downloads page..

ReVoKe · « **Reply #13 on:** October 28, 2008, 03:12:12 PM »

Ohh that explains it, Thanks very much

galton · « **Reply #14 on:** November 02, 2008, 06:24:16 AM »

How do i convert sleepy i don know how to convert smf to v bulletin

TE · « **Reply #15 on:** November 02, 2008, 11:20:53 AM »

Our guide should help you: Converting to SMF

xRooTx · « **Reply #16 on:** November 12, 2008, 05:11:51 PM »

Hi I got a Character set problem how can ı fix it ?

TE · « **Reply #17 on:** November 13, 2008, 01:34:06 AM »

both forums must have the same database / table collation during the conversion.. if your vBulletin is installed in latin (or your type of charset) your SMF must be installed in latin (or your type of charset). If VBulletin is installed in UTF-8, SMF must also be installed in UTF-8. You can check the collation with phpMyAdmin ( What is phpMyAdmin? ). c
If this doesn't help, can you post the error message here?

assam_siddibapa · « **Reply #18 on:** November 15, 2008, 12:54:57 PM »

I am geting this error

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3.7. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'legendar_smf'@'localhost' for table 'user'

assam_siddibapa · « **Reply #19 on:** November 15, 2008, 01:12:12 PM »

i figured it out

finaly got tis error
Converting smileys... Successful.
Converting attachments...
Warning: copy(MemberDownloads/6/3.attach) [function.copy]: failed to open stream: No such file or directory in /home/legendar/public_html/smf/convert.php(1094) : eval()'d code on line 42
Successful.
Converting avatars... Successful.

will this be a problem

News:

Author Topic: [SMF Converter] vBulletin 3.7 (Read 130906 times)