News:

Wondering if this will always be free?  See why free is better.

Main Menu

[SMF Converter] vBulletin 3.7

Started by SleePy, September 17, 2008, 03:03:37 PM

Previous topic - Next topic

SleePy

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. 
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

minos

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

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

minos


HR

#4
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

I can explain this as simply as possible.. If I do it & implement I guarantee it.
If I do it and you implement it its a crap shoot.

SleePy

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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bigi_18

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 ''


:-[ :-[

ThorstenE

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

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

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

ThorstenE

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:

---* {$to_prefix}messages 200

replace it with

---* {$to_prefix}messages 100

then upload the changed file and restart the conversion..

ReVoKe

i get....

QuoteConverting...
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', '[email protected]', '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 :D
-------
Join This PvPGN Server!
Server info:
Name: Delta
Host: 71.208.217.108
Zone: -7
-------', '', '', '', '', '', '', '', '', '', '', '', ''),
('19', 'Chriso', 'Chriso', '951e4419e7b3ca0c5187086b9acf0605', '[email protected]', '', '', '', '', '', '', '', '1222401010', '1222401010', '1', '10', '0000-00-00', '58.106.174.187', '58.106.174.187', '0', '1', '.`w', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('3', 'JLane0', 'JLane0', 'c877c4e8517ccbeddb925364c5310e3b', '[email protected]', '', '', '', '', '', '', '', '1223488838', '1220902260', '20', '10', '0000-00-00', '69.113.121.254', '69.113.121.254', '0', '1', '>s.', 'Hipposaurous rex', '', '', '', '', '', '', '', '', '', '', '', ''),
('4', 'Felix', 'Felix', 'b45478aa2c70d538546c5ef769de6a99', '[email protected]', '', '', '', '', '', '', '', '1221016183', '1221016183', '1', '10', '0000-00-00', '63.22.107.143', '63.22.107.143', '0', '1', 'Qzw', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('5', 'Justin', 'Justin', '722b52caf81e6e87b25d1ade7ac6cabd', '[email protected]', '', '', '', 'HstLand', '', '', 'FireOps Creator/Administrator', '1225068179', '1221186900', '69', '20', '1992-07-18', '', '', '1', '1', '|2O', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('6', 'Thief', 'Thief', '85aecca851eb476b095a362fc50ebf4c', '[email protected]', '', '', '', '', '', '', '', '1223774233', '1221273687', '0', '10', '0000-00-00', '68.192.239.44', '68.192.239.44', '0', '1', 'ccd', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('7', 'XD-1000', 'XD-1000', 'da87c820dedeaaadfe7990659c603b33', '[email protected]', 'http://www.1-stop-isp.net', 'http://www.1-stop-isp.net', '', 'XD1000DG', '', '[email protected]', '', '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', '[email protected]', '', '', '', '', '', '', '', '1221428280', '1221428280', '0', '10', '0000-00-00', '88.15.146.115', '88.15.146.115', '0', '1', 'F+c', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('9', 'meni', 'meni', '59cce7bffcb2e57f54fb41fba7307834', '[email protected]', '', '', '', '', '', '', '', '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', '[email protected]', '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', '[email protected]', '', '', '', '', '', '', '', '1221442064', '1221442064', '0', '10', '0000-00-00', '24.21.158.62', '24.21.158.62', '0', '1', 'ZL(', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('12', 'andres1', 'andres1', '2bceba06e54a3f19af8bf6bde2f3f5a7', '[email protected]', '', '', '', '', '', '', '', '1221754157', '1221690439', '0', '10', '0000-00-00', '68.196.1.136', '68.196.1.136', '0', '1', '.r6', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('13', 'kerako', 'kerako', 'b2d5d348d1fe36c106150aeed1f3efa5', '[email protected]', '', '', '', '', '', '', '', '1224401962', '1222138458', '0', '10', '0000-00-00', '121.141.116.79', '121.141.116.79', '0', '1', 'F+^', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('14', 'Oik', 'Oik', '0faf25f47ef0de504a36e60e68b70537', '[email protected]', '', '', '', 'xkeithxcorexx', '', '[email protected]', '', '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', '[email protected]', '', '', '', '', '', '', '', '1222228570', '1222228570', '0', '10', '0000-00-00', '76.169.179.97', '76.169.179.97', '0', '1', '@/N', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('16', 'Weak', 'Weak', 'a4c0d732661c0670764a4eccd8a03202', '[email protected]', '', '', '', '', '', '', '', '1222628205', '1222229886', '0', '10', '0000-00-00', '74.129.193.220', '74.129.193.220', '0', '1', 'wQm', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('18', 'MienTommy', 'MienTommy', 'd8f184bb96ce6b5e7efffe92e030d5ed', '[email protected]', '', '', '', '', '', '', '', '1225138762', '1222319650', '0', '10', '0000-00-00', '69.238.196.211', '69.238.196.211', '0', '1', '|;-', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('20', 'STARCRAFTGOD', 'STARCRAFTGOD', '2f4c58f65f9eddcda7a9718afde62e78', '[email protected]', '', '', '', '', '', '', '', '1222458379', '1222401139', '0', '10', '0000-00-00', '219.89.38.190', '219.89.38.190', '0', '1', 'r=u', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('21', 'Vanquished', 'Vanquished', '055a4bd2e10b0294316436087986223d', '[email protected]', '', '', '', '', '', '', '', '1222479862', '1222479543', '1', '10', '0000-00-00', '69.49.149.103', '69.49.149.103', '0', '1', 'LBW', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('22', '[email protected]', '[email protected]', 'a3c8d99bbf15e2f8a2328b800df0d008', '[email protected]', '', '', '', '', '', '', '', '1222544635', '1222544635', '0', '10', '0000-00-00', '72.130.145.142', '72.130.145.142', '0', '1', 'Cf5', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('23', 'SyZo', 'SyZo', '4fd4bfd7b487d8437bb5d68c7dd0130c', '[email protected]', '', '', '', '', '', '', '', '1222580832', '1222580772', '0', '10', '0000-00-00', '99.163.234.41', '99.163.234.41', '0', '1', '%ah', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('24', 'Google', 'Google', '263935812be84773552ce2e3ba12eb9a', '[email protected]', '', '', '', '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', '[email protected]', 'http://mclovin.co.nr', 'http://mclovin.co.nr', '', 'lolmclovin', '', '[email protected]', '', '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', '[email protected]', '', '', '', '', '', '', '', '1222644617', '1222644617', '1', '10', '0000-00-00', '71.226.135.41', '71.226.135.41', '0', '1', '2I%', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('27', 'Punk', 'Punk', 'a913e649515b71e14208520d0bca6d18', '[email protected]', '', '', '', '', '', '', '', '1222660311', '1222660311', '0', '10', '0000-00-00', '67.150.171.210', '67.150.171.210', '0', '1', 'd.W', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('28', 'ComBaT', 'ComBaT', 'e8cfba6bab8f632859be030e8f9528c8', '[email protected]', 'http://myspace.com/halo_player15';, 'http://myspace.com/halo_player15';, '', 'mobious26', '[email protected]', '[email protected]', '', '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', '[email protected]', 'http://clanah.net', 'http://clanah.net', '', 'ProSpeCtofAH', '', '[email protected]', '', '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 \'\'[email protected]\'\'
', '', '', '', '', '', '', '', '', '', '', '', ''),
('30', 'Disease', 'Disease', '320bf5f8dd444bec6be65db68d0c7856', '[email protected]', '', '', '', 'YouGotDiseased', '', '', '', '1222915220', '1222915220', '0', '10', '1990-08-13', '69.146.153.26', '69.146.153.26', '0', '1', 'gY{', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('31', 'BnetLair', 'BnetLair', '1adf2c268091399112da8bf7001a0ef5', '[email protected]', '', '', '', '', '', '', '', '1224975855', '1222921920', '1', '10', '0000-00-00', '76.168.212.21', '76.168.212.21', '0', '1', '+M]', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('32', 'Helix', 'Helix', '4a7dbda890d84effbbc86f9b4311a442', '[email protected]', '', '', '', '', '', '', '', '1222990987', '1222990987', '0', '10', '0000-00-00', '76.181.54.248', '76.181.54.248', '0', '1', '!_9', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('33', 'Hunter', 'Hunter', 'c1414e89d9905d12621c7c9c24e98b02', '[email protected]', '', '', '', '', '', '', '', '1222992898', '1222992898', '0', '10', '0000-00-00', '68.199.223.73', '68.199.223.73', '0', '1', 'l-9', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('34', 'Admin', 'Admin', 'a6c3bb5be54ce0322262eb19fc0487be', '[email protected]', '', '', '', '', '', '', '', '1223004260', '1223004180', '0', '10', '0000-00-00', '', '', '0', '1', '/cs', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('38', 'Hoitobini', 'Hoitobini', '67842d80e48220da33bc54fb9d5df3a2', '[email protected]', '', '', '', '', '', '', '', '1223171430', '1223171430', '0', '10', '0000-00-00', '71.142.72.135', '71.142.72.135', '0', '1', 'c&j', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('35', 'boxer', 'boxer', '2cfe024d36278497ac8d7c978ae1542b', '[email protected]', '', '', '', '', '', '', '', '1223092142', '1223092142', '0', '10', '0000-00-00', '71.181.179.220', '71.181.179.220', '0', '1', '._\"', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('36', 'shoes', 'shoes', 'dc54c1d7c431e91353264603cf710356', '[email protected]', '', '', '', '', '', '', '', '1223144914', '1223144914', '0', '10', '0000-00-00', '67.181.246.68', '67.181.246.68', '0', '1', 'lE5', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('37', 'Rancid', 'Rancid', '4375784730339b6e280332b0989958b5', '[email protected]', '', '', '', '', '', '', '', '1223146840', '1223146840', '0', '10', '0000-00-00', '70.233.178.12', '70.233.178.12', '0', '1', '\"sm', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('39', 'Dan', 'Dan', '190c5f9e96cc05fa07250fada46b451a', '[email protected]', '', '', '', '', '', '', '', '1223238294', '1223238294', '0', '10', '0000-00-00', '98.216.182.80', '98.216.182.80', '0', '1', '%O&', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('40', 'Blak-', 'Blak-', 'ef4d4d135db02add56efa0c001b6b0e2', '[email protected]', '', '', '', '', '', '', '', '1223258736', '1223258736', '0', '10', '0000-00-00', '69.237.163.149', '69.237.163.149', '0', '1', 'P@U', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('41', 'DooMeD', 'DooMeD', 'de96a334f5d607c2ee6fae7c0bd70f04', '[email protected]', '', '', '', '', '', '', '', '1223260751', '1223260751', '0', '10', '0000-00-00', '69.21.250.35', '69.21.250.35', '0', '1', ':/T', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('42', 'JLaneZero', 'JLaneZero', 'f6383f6fec8154fdb705b7896bd12fb1', '[email protected]', '', '', '', '', '', '', '', '1223521862', '1223521862', '0', '10', '0000-00-00', '68.80.146.69', '68.80.146.69', '0', '1', 's]r', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('43', 'HydraulicS', 'HydraulicS', 'd0cc9214396b2200066d1cfac3991ad4', '[email protected]', '', '', '', '', '', '', '', '1223594486', '1223594486', '0', '10', '0000-00-00', '69.230.58.196', '69.230.58.196', '0', '1', '3.P', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('44', 'Vengeance', 'Vengeance', '1a2ee8cd40710aac50147dc54428f9a1', '[email protected]', '', '', '', '', '', '', '', '1223723213', '1223722549', '0', '10', '0000-00-00', '220.255.7.194', '220.255.7.194', '0', '1', '/Wv', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('45', 'Maddi', 'Maddi', 'f17dd84228a7b9e08dfbb9abcfabc977', '[email protected]', '', '', '', '', '', '', '', '1224122556', '1223775011', '20', '10', '1990-05-14', '66.222.233.247', '66.222.233.247', '0', '1', 'iy\\', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('46', 'JOYKILLAH', 'JOYKILLAH', 'ce74e8e9e204236f40bf66831cd61257', '[email protected]', '', '', '', '', '', '', '', '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', '[email protected]', '', '', '', '', '', '', '', '1223850597', '1223850597', '1', '10', '0000-00-00', '24.127.194.43', '24.127.194.43', '0', '1', ';?y', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('48', 'Gail', 'Gail', '0d31750c7dd63be57ddc515a81204326', '[email protected]', '', '', '', '', '', '', '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', '[email protected]', '', '', '', '', '', '', '', '1224540197', '1223922510', '0', '10', '0000-00-00', '68.196.1.136', '68.196.1.136', '0', '1', 'TMc', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('50', 'Else', 'Else', '52dff3f5c75162836f1fb0b6fdcf1eaa', '[email protected]', '', '', '', '', '', '', '', '1223946085', '1223945580', '1', '10', '0000-00-00', '65.175.236.57', '65.175.236.57', '0', '1', '7Ig', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('51', 'Chromy', 'Chromy', 'baae014cbe004c7de3ca68805f2ec437', '[email protected]', '', '', '', '', '', '', '', '1223949300', '1223949300', '0', '10', '0000-00-00', '70.251.45.162', '70.251.45.162', '0', '1', 'n2J', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('52', 'Ichigo', 'Ichigo', '3f09d29424ec6274ec787521b13a2853', '[email protected]', '', '', '', '', '', '', '', '1224371180', '1224371143', '0', '10', '0000-00-00', '70.162.138.245', '70.162.138.245', '0', '1', '.iO', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('53', 'Riksin808', 'Riksin808', '711cc38d5a3d8b79721070b648ad3726', '[email protected]', '', '', '', '', '', '', '', '1224371420', '1224371420', '0', '10', '0000-00-00', '70.162.138.245', '70.162.138.245', '0', '1', '=no', '
 Riksin808
', '', '', '', '', '', '', '', '', '', '', '', ''),
('54', 'blinkedkid22', 'blinkedkid22', 'e39890dce93858b97f43032d85edcd68', '[email protected]', '', '', '', '', '', '', '', '1224375091', '1224375091', '0', '10', '0000-00-00', '74.177.83.209', '74.177.83.209', '0', '1', '+uo', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('55', 'saef', 'saef', 'bc47e5e1943b2d05ef2fc4ca6e736cc1', '[email protected]', '', '', '', '', '', '', '', '1224437727', '1224437727', '0', '10', '0000-00-00', '84.191.238.76', '84.191.238.76', '0', '1', ')D!', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('56', 'kAiih', 'kAiih', '1b17ba7476ff4c6208102f90be476bcc', '[email protected]', '', '', '', '', '', '', '', '1224449257', '1224449257', '0', '10', '0000-00-00', '86.56.53.207', '86.56.53.207', '0', '1', 'HFE', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('57', 'nolife', 'nolife', '19bc2a6fdd531a6cad9af25acb107967', '[email protected]', '', '', '', '', '', '', '', '1224456583', '1224456182', '0', '10', '1994-09-01', '74.15.233.181', '74.15.233.181', '0', '1', 'p|=', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('58', 'Coollue', 'Coollue', 'c60d47284dc2655d94e2c091b66f4118', '[email protected]', '', '', '', '', '', '', '', '1224456205', '1224456205', '0', '10', '0000-00-00', '74.233.151.98', '74.233.151.98', '0', '1', '(kL', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('59', 'MA[Night]', 'MA[Night]', 'f7b90e5b15bc03e4363983ca3fb9777f', '[email protected]', '', '', '', '', '', '', '', '1224456461', '1224456461', '0', '10', '0000-00-00', '24.21.238.216', '24.21.238.216', '0', '1', 'uZ#', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('60', 'rouben', 'rouben', '9195aba9be3c30692941e091e645b1e3', '[email protected]', '', '', '', '', '', '', '', '1224500955', '1224462203', '0', '10', '0000-00-00', '77.49.72.75', '77.49.72.75', '0', '1', '[X<', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('61', 'bh3t', 'bh3t', 'c90ac2e2296cf7a378ec2bd5c1e377ce', '[email protected]', '', '', '', '', '', '', '', '1224617966', '1224617966', '0', '10', '0000-00-00', '200.86.247.94', '200.86.247.94', '0', '1', 'P(M', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('62', 'dust', 'dust', '9a27dbfb525d4ccd55d3c5afa5e85247', '[email protected]', '', '', '', '', '', '', '', '1224730763', '1224730763', '0', '10', '0000-00-00', '70.55.74.233', '70.55.74.233', '0', '1', 'vhr', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('63', 'dead man', 'dead man', 'd958a08d9b68a2aae6a19391986d1a85', '[email protected]', '', '', '', '', '', '', '', '1224803681', '1224803681', '0', '10', '0000-00-00', '79.73.178.39', '79.73.178.39', '0', '1', ')%+', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('64', 'Kommwths', 'Kommwths', '46b5cad43a1e10c8103267f454057787', '[email protected]', '', '', '', '', '', '', '', '1224964470', '1224964470', '0', '10', '0000-00-00', '85.73.175.171', '85.73.175.171', '0', '1', 'a9D', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('65', 'sixgig', 'sixgig', 'f361499ec1b108478a98ddac01e1b18a', '[email protected]', '', '', '', '', '', '', '', '1224964506', '1224964506', '0', '10', '0000-00-00', '72.241.232.235', '72.241.232.235', '0', '1', '5YN', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('66', 'FooL', 'FooL', '9ae0c952ac5586765c7847facd730bfb', '[email protected]', '', '', '', '', '', '', '', '1224966441', '1224966441', '0', '10', '0000-00-00', '68.186.145.197', '68.186.145.197', '0', '1', '8Hh', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('67', 'dvdx', 'dvdx', '184a5ef61eecf716ca0053e9e373374f', '[email protected]', '', '', '', '', '', '', '', '1224966572', '1224966572', '0', '10', '0000-00-00', '77.126.209.202', '77.126.209.202', '0', '1', '\'&}', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('68', 'Demo', 'Demo', '4c148b5052aa812b70748974931f71bd', '[email protected]', '', '', '', '', '', '', '', '1224974635', '1224970229', '0', '10', '0000-00-00', '69.141.182.213', '69.141.182.213', '0', '1', 'ccN', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('69', 'ackack', 'ackack', '333a8bc0d20d346132a734faa5b19bb1', '[email protected]', '', '', '', '', '', '', '', '1224974969', '1224974501', '0', '10', '0000-00-00', '24.255.105.86', '24.255.105.86', '0', '1', 'd;m', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('70', 'BaN', 'BaN', 'd8d35a80a7911c6fce31ff3b01c41229', '[email protected]', '', '', '', '', '', '', '', '1224983713', '1224982861', '0', '10', '0000-00-00', '203.206.99.246', '203.206.99.246', '0', '1', 'Xi]', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('71', 'KooLz', 'KooLz', 'a97db5d81cbfb6f76ebb60edce5f26c0', '[email protected]', '', '', '', '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', '[email protected]', '', '', '', '', '', '', '', '1224993984', '1224993961', '0', '10', '0000-00-00', '69.208.151.102', '69.208.151.102', '0', '1', 'md\'', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('73', 'james89', 'james89', 'cce131cd5b91bf0ab8629f0d62a0a08d', '[email protected]', '', '', '', '', '', '', '', '1225001882', '1225001882', '0', '10', '0000-00-00', '129.110.198.23', '129.110.198.23', '0', '1', 'P{>', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('74', 'Stevsta', 'Stevsta', '51486404385724508e06ef7f6c05d255', '[email protected]', '', '', '', '', '', '', '', '1225035690', '1225035690', '0', '10', '0000-00-00', '220.238.225.125', '220.238.225.125', '0', '1', '4qD', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('75', 'technobeats', 'technobeats', '7b346df1d255230e13d98d4739263286', '[email protected]', '', '', '', '', '', '', '', '1225054369', '1225054369', '0', '10', '0000-00-00', '78.21.68.222', '78.21.68.222', '0', '1', ':I&', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('76', 'DowsFelfFeeks', 'DowsFelfFeeks', 'b9742dea6566de577c6d792824ccb163', '[email protected]', '', '', '', '', '', '', '', '1225063412', '1225063412', '0', '10', '0000-00-00', '79.143.177.3', '79.143.177.3', '0', '1', 'chl', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('77', 'bonemaster007', 'bonemaster007', '806ec833b941ca5025e5d41626024635', '[email protected]', '', '', '', '', '', '', '', '1225063844', '1225063844', '0', '10', '0000-00-00', '85.72.141.239', '85.72.141.239', '0', '1', '8f|', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('78', '0o@USWest', '0o@USWest', '45caf52cfb93782e754d380fba1197f9', '[email protected]', '', '', '', '', '', '', '', '1225065638', '1225065638', '0', '10', '0000-00-00', '75.175.51.31', '75.175.51.31', '0', '1', 'L=#', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('79', 'SlickXanny', 'SlickXanny', '80a7ddd2aaffd76e04d0d069bcee8cba', '[email protected]', '', '', '', '', '', '', '', '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'

ThorstenE

Which version of SMF are you using?
QuoteUnknown 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

Ohh that explains it, Thanks very much ;)

galton

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

ThorstenE


xRooTx

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

ThorstenE

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

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

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

Advertisement: