Simple Machines Community Forum

SMF Support => Converting to SMF => vBulletin => Topic started by: SleePy on September 17, 2008, 03:03:37 PM

Title: [SMF Converter] vBulletin 3.7
Post by: 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 (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic. 
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: minos 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'
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: SleePy on September 25, 2008, 02:12:03 PM
Does this one work?
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: minos on September 25, 2008, 03:40:59 PM
yes it works  thank you
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: HR 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
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: SleePy 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.
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: bigi_18 on October 08, 2008, 08:40:54 PM
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 ''


:-[ :-[
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: ThorstenE on October 09, 2008, 01:41:38 AM
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0) or Converting to SMF (http://docs.simplemachines.org/index.php?topic=15) 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..
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: southernlady 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
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: adamcanada 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
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: ThorstenE 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:

---* {$to_prefix}messages 200

replace it with

---* {$to_prefix}messages 100

then upload the changed file and restart the conversion..
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: ReVoKe on October 27, 2008, 10:28:03 PM
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\"', '(http://mythix.us/mclove.jpg)
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

(http://i157.photobucket.com/albums/t63/Botimus/ProS-SO7-FreSty.jpg)

(http://i157.photobucket.com/albums/t63/Botimus/Pros-boxer.jpg)

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', '(http://s254.photobucket.com/albums/hh119/riksin808/?action-view&current=ichigo-animation2.gif)
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'
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: ThorstenE on October 28, 2008, 01:56:45 PM
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..
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: ReVoKe on October 28, 2008, 03:12:12 PM
Ohh that explains it, Thanks very much ;)
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: galton on November 02, 2008, 06:24:16 AM
How do i convert sleepy i don know how to convert smf to v bulletin
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: ThorstenE on November 02, 2008, 11:20:53 AM
Our guide should help you: Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: xRooTx on November 12, 2008, 05:11:51 PM
Hi I got a Character set problem how can ı fix it ?
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: ThorstenE 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? (http://www.simplemachines.org/community/index.php?topic=21919.0) ). c
If this doesn't help, can you post the error message here?
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: assam_siddibapa 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'
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: assam_siddibapa 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
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: ThorstenE on November 15, 2008, 01:38:54 PM
the error is not a real problem, one of the attachments was not converted..maybe the file (MemberDownloads/6/3.attach) doesn't exist anymore?
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: assam_siddibapa on November 15, 2008, 03:00:55 PM
So i think so its not a big problem right ....
any ways thanks
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: SleePy on November 16, 2008, 08:37:00 AM
The setting in the vBulletin database called "attachpath" seems to be empty.

Can you make sure in the vBulletin settings table has that varname and has a value that is correct :)
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: Suarez on November 18, 2008, 11:06:25 PM
I Have this error


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

    `urbanscr_foro`.smf_10log_notify
    SELECT userid AS ID_MEMBER, threadid AS ID_TOPIC
    FROM urbanscr_foro.12subscribethread
    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 '`urbanscr_foro`.smf_10log_notify
    SELECT userid AS ID_MEMBER, threadid AS ID_TOPI' at line 1
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: ThorstenE on November 19, 2008, 03:01:34 AM
which version from the vbulletin37_to_smf.sql are you using? try the file attached on the first post of this topic.
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: Suarez on November 19, 2008, 08:51:17 PM
Quote from: TE on November 19, 2008, 03:01:34 AM
which version from the vbulletin37_to_smf.sql are you using? try the file attached on the first post of this topic.

I use you file 4 vbulletin 3.7 and have this bug
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on November 20, 2008, 01:40:33 AM
have you tried the version attached here?
http://www.simplemachines.org/community/index.php?topic=262571.msg1712521#msg1712521

I noticed from the other topic that your vBulletin is 3.8
Maybe there was a database change between vBulletin 3.7 and 3.8

You can edit the vbulletin37_to_smf.sql and remove this block. this part is for the topic notifications, so you won't loose any important content.
/******************************************************************************/
--- Converting topic notifications...
/******************************************************************************/

TRUNCATE {$to_prefix}log_notify;

---* {$to_prefix}log_notify
SELECT userid AS ID_MEMBER, threadid AS ID_TOPIC
FROM {$from_prefix}subscribethread;
---*
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Ploot on November 21, 2008, 11:16:06 PM
I get the same 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: Incorrect database name ''

Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on November 22, 2008, 01:35:38 AM
Is SMF installed into the same database or a different database? Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: NesTT on January 03, 2009, 08:13:50 PM
Where's the link to the vBulletin 3.7.x converter? I need to convert my vBulletin 3.7.2 to SMF, thanks!
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on January 04, 2009, 02:38:46 AM
you need two files (vbulletin37_to_smf.sql and convert.php)

the vbulletin37_to_smf.sql is attached here (first post):
http://www.simplemachines.org/community/index.php?topic=262571.0

convert.php is attached here (scroll down):
http://www.simplemachines.org/community/index.php?topic=140741.0

Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: NesTT on January 04, 2009, 03:06:02 PM
Thanks man, I'll try that now  ;)

+10
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Ploot on January 07, 2009, 08:53:50 AM
Quote from: TE on November 22, 2008, 01:35:38 AM
Is SMF installed into the same database or a different database? Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)

It is using the same database. But still I get the same error. I have tried converting from IPB to SMF. The other converter seems to work..its just vbulletin 3.7 to Smf that is not working
Title: Re: [SMF Converter] vBulletin 3.7
Post by: assam_siddibapa on January 07, 2009, 12:03:06 PM
Hi got this error ... i am unable to contiue


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 'legenda1_dl'@'localhost' for table 'user'
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on January 07, 2009, 02:21:14 PM
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Ploot on January 08, 2009, 12:26:29 AM
Anyone else able to convert their vb 3.7 to smf?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on January 08, 2009, 02:44:15 AM
Ploot, please check your vBulletin installation.. is there a file named /admin/config.php or  includes/config.php?

these variables are in that file(s):

$config['Database']['dbname']
$config['Database']['tableprefix']


maybe the dbname or the tableprefix is missing / wrong?


Title: Re: [SMF Converter] vBulletin 3.7
Post by: Ploot on January 12, 2009, 10:41:16 PM
Quote from: TE on January 08, 2009, 02:44:15 AM
Ploot, please check your vBulletin installation.. is there a file named /admin/config.php or  includes/config.php?

these variables are in that file(s):

$config['Database']['dbname']
$config['Database']['tableprefix']


maybe the dbname or the tableprefix is missing / wrong?




I have both of them in the config.php file. Tableprefix is just blank because I installed it without any tableprefix like vb3_

Edit : These are the two errors I get at the top

Notice: Undefined variable: config in /home/public_html/smf/convert.php(407) : eval()'d code on line 1

Notice: Undefined variable: config in /home/public_html/smf/convert.php(407) : eval()'d code on line 1
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on January 13, 2009, 01:05:57 AM
ah ok, the missing prefix is the cause .. that's not a problem I think.. is there a line
$config['Database']['tableprefix']  = '';
in config.php?
If not please at this line to the config.php, then re-start the conversion.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Ploot on January 13, 2009, 01:57:08 PM
yes I do

$config['Database']['tableprefix'] = ' ';

I even tried it with a space in between the quotes $config['Database']['tableprefix'] = ' ';
Title: Re: [SMF Converter] vBulletin 3.7
Post by: sirNemanjapro on January 15, 2009, 05:18:30 PM
I have a problem.

Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics... Unsuccessful!
This query:

    TRUNCATE `ckndva_cknsmf`.smf_topics;

Caused the error:

    Table 'ckndva_cknsmf.smf_topics' doesn't exist


After some research I have looked into phpMyAdmin and see the following. I have only 40 tables in my install, but in vBulletin I have 147 tables?!

(http://img57.imageshack.us/img57/8324/smfdatabase40rk6.th.png) (http://img57.imageshack.us/my.php?image=smfdatabase40rk6.png)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: SleePy on January 15, 2009, 06:57:18 PM
SMF doesn't have 147 tables. But you are missing your topics table.

Was your install of SMF working before you tried to convert? The converter assumes your install of SMF is working. If there is something broken in the install before you convert it will most likely mess up something during the conversion process.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: chakru on January 16, 2009, 02:28:29 AM
thank you very much I have been looking for this!

Title: Re: [SMF Converter] vBulletin 3.7
Post by: chakru on January 16, 2009, 04:53:37 AM
Quote from: Ploot on January 13, 2009, 01:57:08 PM
yes I do

$config['Database']['tableprefix'] = ' ';

I even tried it with a space in between the quotes $config['Database']['tableprefix'] = ' ';

having the same problem as ploot please help

thank you
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on January 16, 2009, 06:34:58 AM
chakru, your vBulletin was installed without a table prefix? then check this post please:
http://www.simplemachines.org/community/index.php?topic=271437.msg1879677#msg1879677
Title: Re: [SMF Converter] vBulletin 3.7
Post by: chakru on January 16, 2009, 08:09:42 AM
Quote from: TE on January 16, 2009, 06:34:58 AM
chakru, your vBulletin was installed without a table prefix? then check this post please:
http://www.simplemachines.org/community/index.php?topic=271437.msg1879677#msg1879677

man you are just awesome thank you so much for this help!! :D
Title: Re: [SMF Converter] vBulletin 3.7
Post by: chakru on January 16, 2009, 08:49:54 AM
one doubt after convertion how can I get my smf board to actual url that is I converted my forums at www.xxx.yyy/smf so I want my board to this location www.xxx.yyy how can it be done??

thank you
Title: Re: [SMF Converter] vBulletin 3.7
Post by: sirNemanjapro on January 16, 2009, 08:59:03 AM
Quote from: SleePy on January 15, 2009, 06:57:18 PM
SMF doesn't have 147 tables. But you are missing your topics table.

Was your install of SMF working before you tried to convert? The converter assumes your install of SMF is working. If there is something broken in the install before you convert it will most likely mess up something during the conversion process.

Well if it doesn't have 147, how many dose it have?
I know what I am missing, I just don't know how much of it am I missing. :)

Yes the install was working before convert.

I see I must reupload install, and do it all over.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: HIsPoCratiC on January 22, 2009, 03:00:38 PM
Any know's about this error when I try to enter convert.php??

Parse error: syntax error, unexpected T_VARIABLE in /web/htdocs/www.miwebsite.com/home/smf/convert.php on line 1

I have the vbulletin in the root and SMF on a folder (root/smf) and the db in the same server, but can't solve this witch 3.7
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on January 22, 2009, 03:20:24 PM
try the convert.php from this topic:
http://www.simplemachines.org/community/index.php?topic=140741.0
(it's attached at the end of the post)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: HIsPoCratiC on January 22, 2009, 03:27:13 PM
Quote from: TE on January 22, 2009, 03:20:24 PM
try the convert.php from this topic:
http://www.simplemachines.org/community/index.php?topic=140741.0
(it's attached at the end of the post)

Thanks, but this is the file i'm using right now..
Title: Re: [SMF Converter] vBulletin 3.7
Post by: HIsPoCratiC on January 22, 2009, 03:34:35 PM
Sorry double posting. Ignore the last error, I solved using the one I downloaded from "Downloads area".

1.- I get the "eval d`code 404 on line 1 error, them I make this -> http://www.simplemachines.org/community/index.php?topic=271437.msg1879677#msg1879677

And the result was "no access to vbulletin db".

VB and SMF db are in the same host. Vbulletin is db #1 and the other #2 so I can't understand what the problem is..
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on January 22, 2009, 04:11:06 PM
the changes for  vbulletin37_to_smf.sql are only needed when using vBulltetin without a table prefix. Are you sure the path to vBulletin in convert.php was the right one?

both forums can use different databases but the MySQL user from SMF must be able to read the vBulletin database.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: HIsPoCratiC on January 22, 2009, 04:40:15 PM
Well, I'm now stopped in this error.

The error MySQL gave was: Table 'XXXXXX_1.user' doesn't exist
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on January 22, 2009, 04:49:43 PM
do you get this error with the modified version (from my post) or with the original vbulletin37_to_smf.sql? when using my "modified" version  you must also create a migration.php with your database name in it.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: HIsPoCratiC on January 22, 2009, 05:02:07 PM
I'm using your modified version,and I mean

---~ settings: "/migration.php"
---~ from_prefix: "" . $database . "."

Of course, I created a migration.php and put it on the root just where vb , and also in smf folder ...

Of course I just copy your example, and put my db name like follows;

<?php
$database = 'mydbname';
?>

All the tables for vbulletin, have and "vb" at the beggining, like "vbuser" so maybe here is the error?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on January 23, 2009, 12:58:15 AM
ah ok, that's the problem:
then change
---~ from_prefix: "" . $database . "."

to
---~ from_prefix: "`" . $database . "`." . $prefix . ""

and create a migration.php with this content:
<?php
$database 
'mydbname';
$prefix 'vb';
?>


in this file replace mydbname with the real database name.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: HIsPoCratiC on January 23, 2009, 08:00:11 AM
YeS!!! You'r the one!!


Thanks man, without you this was impsible!
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Streakealth on January 29, 2009, 11:32:07 AM
No matter what I put in the boxes on the convert.php box it always says successful, but never is successful (even with the correct data entered).  The command line use doesn't work either, it always informs me that I haven't defined 'path_to' (which I have).

The process I do is as follows:
1. place both vbulletin37_to_smf.sql and convert.php in the web root of http://forums.quicknbrite.net
2. visit the page, and fill in the correct details (knocking off the s as the old forum is http://forum.quicknbrite.net
3. Hit continue, and get greeted with a success page almost immediately (even though nothing was very successful at all)

Much help would be appreciated, if you need more details in order to help me with my problem just say :)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on January 29, 2009, 01:17:02 PM
maybe the session_save_path isn't writeable, please check Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)..
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Weerapat on February 02, 2009, 12:52:23 PM
I have a some problem follow..

Quote
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 'smfboard'@'localhost' for table 'user'


How can I do ?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on February 02, 2009, 01:39:51 PM
see Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0) .. the MySQL user for both forums must be the same.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: pandusetiawan on February 08, 2009, 10:39:47 PM
The convert process was success....but no one can login after that unless they resetting pass. even after reseting pass, admin user can't admin the board.
Can somebody help me please? thx in advanced.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on February 09, 2009, 01:31:44 AM
The old passwords should work, I don't know what's going wrong..This should help you getting back the admin access:
I accidentally deleted my admin account, what do I do? (http://docs.simplemachines.org/index.php?topic=466)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: kevinshah82 on February 19, 2009, 12:07:04 PM
not able to get the attachment of vb 3.7 convert.php

got the sql file now what?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on February 19, 2009, 12:44:11 PM
convert.php is attached to this topic (scroll down):
http://www.simplemachines.org/community/index.php?topic=140741.0
Title: Re: [SMF Converter] vBulletin 3.7
Post by: blackcab94 on February 27, 2009, 01:11:44 PM
Excellent piece of work guys converted from vb 3.7.1 to smf 1.1.8 no problem at all took about 5 secs to convert!!
Title: Re: [SMF Converter] vBulletin 3.7
Post by: sirNemanjapro on March 01, 2009, 06:40:07 AM
I have a problem with converting from vBulletin 3.7.2 to SMF 1.1.8.
My forum is 80% in Cyrillic, when I convert, only first forum room gets converted properly, others get weird signs. :(
Title: Re: [SMF Converter] vBulletin 3.7
Post by: sirNemanjapro on March 01, 2009, 08:31:18 AM
Преко плота
Приче из чаршије... 79 Posts
14 Topics Last post by Mello
in Нова година о...
on January 14, 2009, 12:08:25 PM
New Posts Корзо
Ð"оле клабинг, живео корзо! 5 Posts
1 Topics Last post by Milos Dedijer
in Da su živi danas...
on January 13, 2009, 09:43:33 AM
New Posts Крајем наше улице
Званични Ñ,,орум AVN + production Ñ,в емисије 28 Posts
5 Topics Last post by DzoA
in Krajem naše ulice - kom...
on November 14, 2008, 04:28:44 PM
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on March 01, 2009, 12:53:40 PM
sirNemanjapro, Sorry but I cannot read your language.. can you explain your issues please?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: sirNemanjapro on March 01, 2009, 03:13:34 PM
You see the first part, you can actually read the letters\words.

Other stuff is gibberish.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on March 01, 2009, 03:41:48 PM
do you know the vbulletin charset? (you can see the tables collation with phpMyAdmin) you should install SMF with the same charset and then run the conversion.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: sirNemanjapro on March 01, 2009, 05:45:05 PM
Its the same collation. It dosent work. Can some one help me over IM?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: sirNemanjapro on March 01, 2009, 06:41:46 PM
I didnt mentioned this, but I tried to fix HTML to UTF8 in admin panel, it didnt work.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on March 02, 2009, 01:38:20 AM
both are UTF-8? then install SMF and use a Cyrillic charset instead. during the conversion you should use "UTF-8".
Title: Re: [SMF Converter] vBulletin 3.7
Post by: benz1 on March 15, 2009, 04:27:50 AM
Hi,

I've been given a backup of a vBulletin 3.7.4 database to import into an fresh SMF install. I do not have access to the original vBulletin forum am an unlikely to get it as this database is a subset of the main forum.

Is there any way I am going to be able to import this without having access to the original forum?

Thanks in anticipation,
Benz1
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on March 15, 2009, 05:24:59 AM
our converter needs the old config.php from vBulletin, but you also can emulate this file:
http://www.simplemachines.org/community/index.php?topic=262571.msg1891729#msg1891729
Title: Re: [SMF Converter] vBulletin 3.7
Post by: benz1 on March 15, 2009, 03:52:29 PM
Quote from: TE on March 15, 2009, 05:24:59 AM
our converter needs the old config.php from vBulletin, but you also can emulate this file:
http://www.simplemachines.org/community/index.php?topic=262571.msg1891729#msg1891729

Thanks TE but can you please treat me like a 6 yr old and tell me step by step what I need to do? What file do I change

---~ from_prefix: "" . $database . "." to ---~ from_prefix: "`" . $database . "`." . $prefix . "

in? I can't find this line in vbulletin37_to_smf.sql or convert.php but did find the following in vbulletin37_to_smf.sql

---~ from_prefix: "`" . $config['Database']['dbname'] . "`." . $config['Database']['tableprefix'] . ""

Do I need to change this line?

Is the process as follows?


Is there anything else I need to do?

Many thanks,
Benz1
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on March 15, 2009, 04:15:43 PM
Ok, we go the easy way ;) try the attached version. you should be asked for a database and table prefix.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: benz1 on March 15, 2009, 10:36:14 PM
Quote from: TE on March 15, 2009, 04:15:43 PM
Ok, we go the easy way ;) try the attached version. you should be asked for a database and table prefix.

Thanks TE, that's really cool. Just having a few problems trying to import the database (it's 40MB zipped, 288MB unzipped!) and uses charset ISO-8859-1 which isn't one of the options in phpMyAdmin but otherwise it's all good  :)  (Any ideas how to overcome these issues?)

As and when we get it imported will try the convert with this custom file.

Many thanks,
Benz1
Title: Re: [SMF Converter] vBulletin 3.7
Post by: benz1 on March 15, 2009, 11:48:59 PM
Quote from: TE on March 15, 2009, 04:15:43 PM
Ok, we go the easy way ;) try the attached version. you should be asked for a database and table prefix.

OK, we're making progress. Managed to import the vBulletin database into the new database I created but can't get past the first page of convert.php.

If the details in Settings.php are as follows:
$db_name = 'account_smf1';
$db_user = 'account_smf1';
$db_passwd = 'xxxxxxxx';
$db_prefix = 'smf_';

and the VB database details are:
db_name: account_vbdump
db_user: account_vb
db_passwd: yyyyyy
prefix: account

What should the correct details be for MySQL database & Table Prefix & passowrd?

Thanks,
Benz1
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on March 16, 2009, 02:52:20 AM
ups, different databases with different MySQL users / passwords is a problem. SMF must be allowed to read the vBulletin database. you shoul use the same database for both SMF and vBulletin.
Then use this for the database and "account" for the prefix (your vBulletin table prefix).
Title: Re: [SMF Converter] vBulletin 3.7
Post by: benz1 on March 16, 2009, 03:04:43 AM
Quote from: TE on March 16, 2009, 02:52:20 AM
ups, different databases with different MySQL users / passwords is a problem. SMF must be allowed to read the vBulletin database. you shoul use the same database for both SMF and vBulletin.
Then use this for the database and "account" for the prefix (your vBulletin table prefix).

Oh ok, so I should have imported the VB database into the existing SMF database? I could point Settings.php to the new one but I guess I'd lose my admin account on SMF then. I actually had to get my host to import the dbase as I couldn't do it. If this is the answer then I'll have to ask them to re-import it into the SMF database.

Thanks,
Benz1
Title: Re: [SMF Converter] vBulletin 3.7
Post by: benz1 on March 16, 2009, 09:34:50 PM
Hi TE,

Made more progress but am stuck again.

Managed to import the vBulletin database into my SMF database.
Ran convert.php using your updated .sql file. Worked out that the prefix actually relates to the prefix of the imported database so
MySQL database: massive_smf1
Table Prefix is mos_ (from imported VB database)

When I ran it I got
Converting members... Unsuccessful!
The error was that massive_smf1.mos_user was not found

I noticed that there was no table mos_user but there was mos_users so I edited your sql file and changed 4 occurrences of user to users.

Ran convert again but this time got:

Converting members... Unsuccessful!
This query:

    SELECT
    u.userid AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
    SUBSTRING(u.username, 1, 255) AS realName,
    SUBSTRING(u.password, 1, 64) AS passwd,
    SUBSTRING(u.email, 1, 255) AS emailAddress,
    SUBSTRING(u.homepage, 1, 255) AS websiteTitle,
    SUBSTRING(u.homepage, 1, 255) AS websiteUrl,
    SUBSTRING(u.icq, 1, 255) AS ICQ, SUBSTRING(u.aim, 1, 16) AS AIM,
    SUBSTRING(u.yahoo, 1, 32) AS YIM, SUBSTRING(u.msn, 1, 255) AS MSN,
    SUBSTRING(IF(u.customtitle, u.usertitle, ''), 1, 255) AS usertitle,
    u.lastvisit AS lastLogin, u.joindate AS dateRegistered, u.posts,
    u.reputation AS karmaGood, u.birthday_search AS birthdate,
    SUBSTRING(u.ipaddress, 1, 255) AS memberIP,
    SUBSTRING(u.ipaddress, 1, 255) AS memberIP2,
    CASE
    WHEN u.usergroupid = 6 THEN 1
    WHEN u.usergroupid = 5 THEN 2
    WHEN u.usergroupid = 7 THEN 2
    ELSE 0
    END AS ID_GROUP,
    CASE WHEN u.usergroupid IN (3, 4) THEN 0 ELSE 1 END AS is_activated,
    SUBSTRING(u.salt, 1, 5) AS passwordSalt,
    SUBSTRING(ut.signature, 1, 65534) AS signature, '' AS lngfile,
    '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
    '' AS personalText, '' AS timeFormat, '' AS avatar, '' AS secretQuestion,
    '' AS secretAnswer, '' AS validation_code, '' AS additionalGroups,
    '' AS smileySet
    FROM `massive_smf1`.mos_users AS u
    LEFT JOIN `massive_smf1`.mos_usertextfield AS ut ON (ut.userid = u.userid)
    WHERE u.userid != 0
    LIMIT 0, 500;

Caused the error:

    Table 'massive_smf1.mos_usertextfield' doesn't exist

Tried changing this to users to but still didn't work. There is no field called textfield in the mos_users table.

Have now reached the limits of my technical knowledge so would be grateful if you could assist.

Thanks,
Benz1
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on March 17, 2009, 02:54:47 AM
can you check your database with phpMyAdmin please? is there a table named "mos_usertextfield' ? Are you sure this is a vBulletin 3.7.4 backup?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: benz1 on March 17, 2009, 03:04:42 AM
Definitely no mos_usertextfield. Full list of tables below.

The footer of the forum it was exported from says, Powered by vBulletin® Version 3.7.4

massive_smf1 (123)

    beta_users
    mos_banner
    mos_bannerclient
    mos_bannerfinish
    mos_bookmarks
    mos_bookmarks_categories
    mos_bookmarks_columns
    mos_bookmarks_itemcat
    mos_bookmarks_prefs
    mos_bookmarks_vote
    mos_categories
    mos_combomax
    mos_components
    mos_contact_details
    mos_content
    mos_content_frontpage
    mos_content_rating
    mos_core_acl_aro
    mos_core_acl_aro_groups
    mos_core_acl_aro_sections
    mos_core_acl_groups_aro_map
    mos_core_log_items
    mos_core_log_searches
    mos_docman
    mos_docman_groups
    mos_docman_history
    mos_docman_licenses
    mos_docman_log
    mos_enewsfrontpage
    mos_groups
    mos_mambots
    mos_menu
    mos_messages
    mos_messages_cfg
    mos_modules
    mos_modules_menu
    mos_newsfeeds
    mos_polls
    mos_poll_data
    mos_poll_date
    mos_poll_menu
    mos_ptregions
    mos_sections
    mos_session
    mos_stats_agents
    mos_templates_menu
    mos_template_positions
    mos_tfs_bots
    mos_tfs_browsers
    mos_tfs_configuration
    mos_tfs_ipaddresses
    mos_tfs_iptocountry
    mos_tfs_keywords
    mos_tfs_pages
    mos_tfs_page_request
    mos_tfs_page_request_c
    mos_tfs_referrer
    mos_tfs_search_engines
    mos_tfs_systems
    mos_tfs_topleveldomains
    mos_tfs_visits
    mos_users
    mos_usertypes
    mos_weblinks
    phpads_acls
    phpads_adclicks
    phpads_adstats
    phpads_adviews
    phpads_affiliates
    phpads_banners
    phpads_cache
    phpads_clients
    phpads_config
    phpads_images
    phpads_session
    phpads_targetstats
    phpads_userlog
    smf_attachments
    smf_ban_groups
    smf_ban_items
    smf_boards
    smf_board_permissions
    smf_calendar
    smf_calendar_holidays
    smf_categories
    smf_collapsed_categories
    smf_log_actions
    smf_log_activity
    smf_log_banned
    smf_log_boards
    smf_log_errors
    smf_log_floodcontrol
    smf_log_karma
    smf_log_mark_read
    smf_log_notify
    smf_log_online
    smf_log_polls
    smf_log_search_messages
    smf_log_search_results
    smf_log_search_subjects
    smf_log_search_topics
    smf_log_topics
    smf_membergroups
    smf_members
    smf_messages
    smf_message_icons
    smf_moderators
    smf_package_servers
    smf_pages
    smf_permissions
    smf_personal_messages
    smf_pm_recipients
    smf_polls
    smf_poll_choices
    smf_sessions
    smf_settings
    smf_smileys
    smf_sp_articles
    smf_sp_blocks
    smf_sp_categories
    smf_sp_functions
    smf_themes
    smf_topics
Title: Re: [SMF Converter] vBulletin 3.7
Post by: benz1 on March 18, 2009, 10:31:52 PM
Have you given up on me?

Is it possible that the backup I imported was incomplete or didn't import correctly due to the size of the database?

Thanks,
Benz1
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Spark753 on March 20, 2009, 04:00:09 AM
woop ty ty ty. this works fine with vb 3.8.1
Title: Re: [SMF Converter] vBulletin 3.7
Post by: mobilewo on April 18, 2009, 09:54:29 AM
hi friends any one tel me how to install .sql file step by step
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on April 18, 2009, 10:02:08 AM
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)

You also need our convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0 attached - scroll down)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: mobilewo on April 18, 2009, 01:43:05 PM
hello sir when i open covert.php  file ($row['realName'] = trim($row['realName'], " \t\n\r\x0B\0\xA0"); if (strpos($row['realName'], '<') !== false || strpos($row['realName'], '>') !== false || strpos($row['realName'], '& ') !== false) $row['realName'] = htmlspecialchars($row['realName'], ENT_QUOTES); else $row['realName'] = strtr($row['realName'], array('\'' => ''')); } if (empty($no_add)) $rows[] = "'" . implode("', '", addslashes_recursive($row)) . "'"; else $no_add = false; if (empty($keys)) $keys = array_keys($row); } if (isset($ignore) && $ignore == true) $ignore = 'IGNORE'; else $ignore = ''; if (!empty($rows)) convert_query(" INSERT $ignore INTO $special_table (" . implode(', ', $keys) . ") VALUES (" . implode('), (', $rows) . ")"); $_REQUEST['start'] += $special_limit; if (empty($special_max) && convert_num_rows($special_result) < $special_limit) break; elseif (!empty($special_max) && convert_num_rows($special_result) == 0 && $_REQUEST['start'] > $special_max) break; convert_free_result($special_result); } } $_REQUEST['start'] = 0; $s)

same as words coming
Title: Re: [SMF Converter] vBulletin 3.7
Post by: SleePy on April 23, 2009, 10:04:13 PM
Please try to redownload the vb Converter package from the official downloads page. It looks like Convert.php is corrupted in the one you downloaded.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Hoof on May 19, 2009, 12:40:15 PM
This worked great, Thank You!

"54786 Posts in 11901 Topics by 2859 Members"  Pretty close to actual numbers from my vB site, I can live with it :) .
Title: Re: [SMF Converter] vBulletin 3.7
Post by: shawn666 on June 08, 2009, 07:09:46 PM
The convert.php link doesn't let me download...just takes me to a list of topics which just leads me back here, wtf?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on June 09, 2009, 02:04:26 AM
Quote from: shawn666 on June 08, 2009, 07:09:46 PM
..just takes me to a list of topics which just leads me back here, wtf?
Convert.php is attached at the end of that topic, scroll down and you'll hopefully find it..
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Les Paul on June 11, 2009, 08:59:39 AM
Quote from: 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

convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.

I can't download the convert.php for vBulletin. Where is it?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on June 11, 2009, 01:53:17 PM
Direct Link to vbulletin37_to_smf.sql:
http://www.simplemachines.org/community/index.php?action=dlattach;topic=262571.0;attach=68977

Direct link to convert.php:
http://www.simplemachines.org/community/index.php?action=dlattach;topic=140741.0;attach=79452
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Andreyguba on June 19, 2009, 11:49:48 PM
HI/ what doe it mean -


Notice: Undefined variable: config in /home/*/public_html/new/convert.php(407) : eval()'d code on line 1

Notice: Undefined variable: config in /home/*/public_html/new/convert.php(407) : eval()'d code on line 1

After -

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

Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on June 20, 2009, 08:58:22 AM
the database name from your vBulletin wasn't identified by the converter.

please check this post:
http://www.simplemachines.org/community/index.php?topic=262571.msg1976367#msg1976367
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Les Paul on June 24, 2009, 02:42:48 PM
I get an error when converting..


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 `ja000184_sarara`._vbpm
    LIMIT 0, 500;

Caused the error:

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


Hoy can I do?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Kool22Masta on June 25, 2009, 07:47:44 PM
My vbulletin is located on another server than my SMF.
When I use the URL of the vbulletin, it doesnt work.

So i uploaded the sql file with the vbulletin database in it to the server where the smf and the converter are.
instead of the vbulletin url i just put in the url of the sql file, and the converter said that it worked, but nothing happend in the SMF forum.

Wouldnt it be much easier if there were a converter, where you just put in an sql backup and then it just puts out an sql file that i can import into smf, so it would work for everyone?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on June 26, 2009, 02:41:17 PM
Quote from: Kool22Masta on June 25, 2009, 07:47:44 PM
My vbulletin is located on another server than my SMF.
When I use the URL of the vbulletin, it doesnt work.

Both Forums (SMF and vBulletin) must be installed on the same server .. please check:
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ecmrf on July 08, 2009, 07:09:44 PM
I just converted a VB 3.8.1 board, all went well except :

Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting smileys... Successful.
Converting attachments...
Fatal error: Call to undefined function getAttachmentFilename() in /home/muster/public_html/ecmrf.com/forum/convert.php(1097) : eval()'d code on line 26


Is there anything I need to do?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on July 09, 2009, 02:07:27 AM
sorry, the script attached to the first post is for SMF 1.1.8, attachments was redisigned for SMF 1.1.9..

you can replace the last two blocks in vbulletin37_to_smf.sql (attachments and avatars) with this code:

/******************************************************************************/
--- Converting attachments...
/******************************************************************************/

---* {$to_prefix}attachments
---{
$no_add = true;
$keys = array('ID_ATTACH', 'size', 'filename', 'ID_MSG', 'downloads', 'width', 'height');

if (!isset($vb_settings))
{
$result = convert_query("
SELECT varname, value
FROM {$from_prefix}setting
WHERE varname IN ('attachfile', 'attachpath', 'usefileavatar', 'avatarpath')
LIMIT 4");
$vb_settings = array();
while ($row2 = mysql_fetch_assoc($result))
{
if (substr($row2['value'], 0, 2) == './')
$row2['value'] = $_POST['path_from'] . substr($row2['value'], 1);
$vb_settings[$row2['varname']] = $row2['value'];
}
mysql_free_result($result);
}

// Is this an image???
$attachmentExtension = strtolower(substr(strrchr($row['filename'], '.'), 1));
if (!in_array($attachmentExtension, array('jpg', 'jpeg', 'gif', 'png')))
$attachmentExtention = '';

// Set the default empty values.
$width = '0';
$height = '0';

$newfilename = getLegacyAttachmentFilename($row['filename'], $ID_ATTACH);
if (empty($vb_settings['attachfile']))
{
$fp = @fopen($attachmentUploadDir . '/' . $newfilename, 'wb');
if (!$fp)
return;

fwrite($fp, $row['filedata']);
fclose($fp);
}
elseif ($vb_settings['attachfile'] == 1)
{
if (!copy($vb_settings['attachpath'] . '/' . $row['userid'] . '/' . $row['attachmentid'] . '.attach', $attachmentUploadDir . '/' . $newfilename))
return;
}
elseif ($vb_settings['attachfile'] == 2)
{
if (!copy($vb_settings['attachpath'] . '/' . chunk_split($row['userid'], 1, '/') . $row['attachmentid'] . '.attach', $attachmentUploadDir . '/' . $newfilename))
return;
}

// Is an an image?
if (!empty($attachmentExtension))
list ($width, $height) = getimagesize($attachmentUploadDir . '/' . $newfilename);

$rows[] = "$ID_ATTACH, " . filesize($attachmentUploadDir . '/' . $newfilename) . ", '" . addslashes($row['filename']) . "', $row[ID_MSG], $row[downloads], '$width', '$height'";
$ID_ATTACH++;
---}
SELECT
postid AS ID_MSG, counter AS downloads, filename, filedata, userid,
attachmentid
FROM {$from_prefix}attachment;
---*

/******************************************************************************/
--- Converting avatars...
/******************************************************************************/

---* {$to_prefix}attachments
---{
$no_add = true;
$keys = array('ID_ATTACH', 'size', 'filename', 'ID_MEMBER');

if (!isset($vb_settings))
{
$result = convert_query("
SELECT varname, value
FROM {$from_prefix}setting
WHERE varname IN ('attachfile', 'attachpath', 'usefileavatar', 'avatarpath')
LIMIT 4");
$vb_settings = array();
while ($row2 = mysql_fetch_assoc($result))
{
if (substr($row2['value'], 0, 2) == './')
$row2['value'] = $_POST['path_from'] . substr($row2['value'], 1);
$vb_settings[$row2['varname']] = $row2['value'];
}
mysql_free_result($result);
}


$newfilename = getLegacyAttachmentFilename($row['filename'], $ID_ATTACH);
if (strlen($newfilename) > 255)
return;
elseif (empty($vb_settings['usefileavatar']))
{
$fp = @fopen($attachmentUploadDir . '/' . $newfilename, 'wb');
if (!$fp)
return;

fwrite($fp, $row['filedata']);
fclose($fp);
}
elseif (!copy($vb_settings['avatarpath'] . '/avatar' . $row['ID_MEMBER'] . '_' . $row['avatarrevision'] . '.gif', $attachmentUploadDir . '/' . $newfilename))
return;

$rows[] = "$ID_ATTACH, " . filesize($attachmentUploadDir . '/' . $newfilename) . ", '" . addslashes($row['filename']) . "', $row[ID_MEMBER]";
$ID_ATTACH++;
---}
SELECT ca.userid AS ID_MEMBER, ca.filedata, ca.filename, u.avatarrevision
FROM ({$from_prefix}customavatar AS ca, {$from_prefix}user AS u)
WHERE u.userid = ca.userid;
---*
Title: Re: [SMF Converter] vBulletin 3.7
Post by: digger on July 10, 2009, 12:39:16 PM
Quote from: TE on July 09, 2009, 02:07:27 AM
sorry, the script attached to the first post is for SMF 1.1.8, attachments was redisigned for SMF 1.1.9..

you can replace the last two blocks in vbulletin37_to_smf.sql (attachments and avatars) with this code:

Converting attachments...
Fatal error: Call to undefined function getLegacyAttachmentFilename() in /home/uaforumo/domains/uaforum.org/public_html/new/convert.php(1097) : eval()'d code on line 26
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on July 10, 2009, 02:01:04 PM
digger, have you replaced the attachments conversion from the orginal script with my version above? the error you posted is related to our old attachments conversion.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sayrex on July 14, 2009, 08:49:25 AM
convert.php for vbulletin 3.7 is not available for download...
please check convert.php link .  :(
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on July 14, 2009, 12:58:56 PM
convert.php is the same file for ALL of our converters, you can download any converter from our downloads page and use the included convert.php, you only need the custom board_to_smf.sql (vbulletin37_to_smf.sql).
Title: Re: [SMF Converter] vBulletin 3.7
Post by: navjotjsingh on July 16, 2009, 07:46:24 AM
I am getting a error:


Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Unsuccessful!
This query:

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

Caused the error:

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



How to get past this?

I am trying to convert vb 3.8.1 to SMF 1.1.0.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on July 16, 2009, 02:09:50 PM
mhh, seems like vBulletin changed their database structure in version 3.8.1

can you please check the table vb_pm with phpMyAdmin? is there a column named pmid?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Fisch.666 on July 16, 2009, 07:27:31 PM
Hi!

I have the same problem like navjotjsingh when i try to convert my vbulletin 3.8.3 into smf 1.1.10.

There is an table called vb3_pm with an column called pmid in my database and the first step of the personal messages conversion with this query:

SELECT
pm.pmid AS ID_PM


runs without a problem. Any hints how we can fix this? Thanks in advance for an reply.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on July 17, 2009, 01:36:31 AM
navjotjsingh or Fish.666,
can anyone take a screenshot from the table vb3_pm.. (the structure -> column names are important)?

Thank you
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Fisch.666 on July 17, 2009, 02:22:59 AM
Hi!

Thanks again for your reply. I don't have accesss to phpmyadmin, but i hope this screens are ok:

Title: Re: [SMF Converter] vBulletin 3.7
Post by: navjotjsingh on July 17, 2009, 04:05:11 AM
Attached is the structure from my screenshot.

Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on July 17, 2009, 06:58:55 AM
ok, thank you :) it's a bug in vbulletin37_to_smf.sql:

in vbulletin37_to_smf.sql replace:

SELECT
pm.pmid AS ID_PM, pm.userid AS ID_MEMBER, pm.messageread != 0 AS is_read,
'-1' AS labels


with:
SELECT
pmid AS ID_PM, userid AS ID_MEMBER, messageread != 0 AS is_read,
'-1' AS labels
Title: Re: [SMF Converter] vBulletin 3.7
Post by: navjotjsingh on July 17, 2009, 08:30:10 AM
Thanks it worked. But for converting attachments for each attachment it shows this error:


Warning: copy(attachments/1/1.attach) [function.copy]: failed to open stream: No such file or directory in /home/navjot/public_html/sdemo/convert.php(1097) : eval()'d code on line 42


And for avtar it showed:

Warning: copy(/home/navjot/public_html/careertalk/customavatars/avatar378_1.gif) [function.copy]: failed to open stream: No such file or directory in /home/navjot/public_html/sdemo/convert.php(1097) : eval()'d code on line 30


Rest everything went smooth.

None of the avatar or attachment were converted.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Fisch.666 on July 17, 2009, 10:07:43 AM
Hi!

Thanks again for your help, the import works now without a problem.  :)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: SimpleJoe on July 21, 2009, 07:13:20 PM
I get a blank page that says "SMF Converter" but there's no other data:
http://birdcarversonline.com/convert.php

Both VB and SMF are using the same database on the same server ... any ideas?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on July 22, 2009, 01:11:00 AM
a blank page is often server related (strict php configuration: e.g. memory_limit, max_execution_time ...)
Any chance to modify the php.ini or to check the webservers error log?

Workaround: make a backup from your vBulletin and convert it on your local computer (XAMPP (http://www.apachefriends.org/de/xampp.html) is an easy installable Webserver incl. PHP- and MySQL)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: navjotjsingh on July 22, 2009, 02:08:50 AM
Quote from: navjotjsingh on July 17, 2009, 08:30:10 AM
Thanks it worked. But for converting attachments for each attachment it shows this error:


Warning: copy(attachments/1/1.attach) [function.copy]: failed to open stream: No such file or directory in /home/navjot/public_html/sdemo/convert.php(1097) : eval()'d code on line 42


And for avtar it showed:

Warning: copy(/home/navjot/public_html/careertalk/customavatars/avatar378_1.gif) [function.copy]: failed to open stream: No such file or directory in /home/navjot/public_html/sdemo/convert.php(1097) : eval()'d code on line 30


Rest everything went smooth.

None of the avatar or attachment were converted.

Please look at my error too.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on July 22, 2009, 06:35:51 AM
navjotjsingh,
I believe tha path for $vb_settings['attachpath'] wasn't detected or is missing in your vBulletin database..
Can you please execute the following Query with phpMyAdmin and post the result:

SELECT varname, value
FROM vb_setting
WHERE varname IN ('attachfile', 'attachpath', 'usefileavatar', 'avatarpath')

(replace vb_ with your vB database prefix)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: SimpleJoe on July 22, 2009, 09:44:06 AM
TE: I turned on display_errors and found it was a simple permission issue with convert.php, i did a chmod on it and the conversion worked  :D

many thanks for your expertise

happy to be bringing another forum hosting site into the simple machines community :)

Title: Re: [SMF Converter] vBulletin 3.7
Post by: navjotjsingh on July 22, 2009, 10:29:18 AM
Attached is the result of the SQL Query

Title: Re: [SMF Converter] vBulletin 3.7
Post by: maritoz on July 27, 2009, 09:37:38 PM
I have a problem at the end of my conversion .... Sgte I get the code which might be the solution?
Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1248744782),
    ("conversion_from", "vbulletin37_to_smf.sql");

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 '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1248744782)' at line 1
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on July 28, 2009, 01:40:55 AM
maritoz,
Don't care about these error, the conversion process has already finished.
QuoteRecalculating forum statistics... Successful.

Title: Re: [SMF Converter] vBulletin 3.7
Post by: red-g8r on August 02, 2009, 05:54:20 AM
QuoteNotice: Undefined variable: config in /home/######/public_html/smf/convert.php(407) : eval()'d code on line 1
This notice shows twice then hangs up the conversion with the normal error:
QuoteSorry, 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 table name 'user'

Having similar issue on fresh install of SMF 1.1.0
Trying to convert VB 3.7 over using the 3.7 converter n updated sql file.

All paths are correct, mysql permissions match (same user) same collation, etc.

Only 2 issue I can think of is my VB table prefix is simply "forum" no leading or trailing underscore, for example the user table is "forumuser" which is typically something like "forum_user"

The other issue might be that I have other table in my VB database that are used for advertising, mods, etc. that dont have the same "forum" prefix. for example I have old coppermine tables that have a "cpg_" table prefix...... any ideas?

Thanks
Title: Re: [Beta] [SMF Converter] vBulletin 3.7
Post by: whuru on August 14, 2009, 04:55:08 PM
Quote from: assam_siddibapa 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'

Need access user name 'legendar_smf' to db VBulletin.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: whuru on August 16, 2009, 11:03:48 AM
help me, please...

I want convert VBulletin 3.8.1 to SMF 1.1.10 and see next touble:

QuoteConverting...
Recalculating forum statistics... Successful.

Notice: Undefined variable: to_prefix in F:\xampp\htdocs\vb368\convert.php on line 1821
Unsuccessful!
This query:

    REPLACE INTO settings (variable, value)
    VALUES ('conversion_time', 1250433437),
    ('conversion_from', 'vbulletin37_to_smf.sql');

Caused the error:

    No database selected
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on August 16, 2009, 12:17:09 PM
http://www.simplemachines.org/community/index.php?topic=326107.msg2173140#msg2173140
Title: Re: [SMF Converter] vBulletin 3.7
Post by: red-g8r on August 16, 2009, 04:23:42 PM
Quote from: TE on August 16, 2009, 12:17:09 PM
http://www.simplemachines.org/community/index.php?topic=326107.msg2173140#msg2173140

Why are you referencing a PHPBB3 importer topic?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on August 17, 2009, 01:19:21 AM
the error is exactly the same (a minor bug in convert.php)..
Title: Re: [SMF Converter] vBulletin 3.7
Post by: indoboards on August 18, 2009, 11:45:47 PM
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Unsuccessful!
This query:

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

Caused the error:

    Unknown column 'pm.pmid' in 'field list'
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on August 19, 2009, 01:58:04 AM
indoboards,
which version is your vBulletin? The issue is related to a missing column "pmid".. Maybe you used the old vbulletin36_to_smf.sql?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: jugocas on August 30, 2009, 03:41:30 PM
first sorry for my english, but i'am spanish xd


O.o y can't donwload file "convert.php" for vbulletin 3.7, (is for one vbulletin 3.8.1), can you give direct link to donwload?¿?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on August 31, 2009, 11:38:10 AM
http://download.simplemachines.org/?converters;software=vbulletin
Title: Re: [SMF Converter] vBulletin 3.7
Post by: zalim5788 on October 17, 2009, 08:36:41 PM
convert.php nerde?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on October 17, 2009, 08:48:20 PM
I don't understand what you are asking. If you are looking for convert.php, you should note that on the page linked by TE, there are archives containing both the convert.php and the.sql file needed.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on October 20, 2009, 03:59:47 PM
zalim5788:  Please tell clearly what you need.

If you need help in another language than English, check out our international forums: Language Specific Support. (http://www.simplemachines.org/community/index.php?board=12.0)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Meow Doom on October 23, 2009, 02:10:55 PM
Good afternoon! I just recently converted from Vbulletin 3.8.2 to SMF 1.1.10 using your converter. Everything went well and was successfully converted, even the PMs! However, after deleting the old PM's from Vbulletin it still holds the number of pms I used to have in my smf install. Is there any fix after conversion for this wee phantom pm bug?

Nvm, I figured it out. XD I r noob.  :-[
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on October 23, 2009, 05:26:33 PM
Cheers, good to hear you got it sorted out!
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Suikojin on November 06, 2009, 07:49:24 PM
I am trying to convert my vB 3.8.0 to SMF 1.1.10 but I get this error.

Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1257554703),
    ("conversion_from", "vbulletin37_to_smf.sql");

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 '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1257554703)' at line 1
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on November 07, 2009, 02:12:48 AM
Your conversion has actually succeeded, as "Recalculating forum statistics... Successful." was the last step that matters. The last message is a bug in the converter itself.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: helmy1100 on January 09, 2010, 06:26:47 AM
thanks it works 
Title: Re: [SMF Converter] vBulletin 3.7
Post by: marazmus on January 16, 2010, 04:09:01 AM
Hello. Converter stops with this message:

"Converting polls...Wrong value type sent to the database. Integer expected. (expire_time)"

vBulletin 3.8.4, SMF 2 RC2.

Any suggestions?

Thank you for any help.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on January 17, 2010, 02:59:44 AM
marazmus, sorry but our 2.0 converters are still "buggy".. I'll look into this later this week. If you need a short in time solution you should use our 1.1.x converter (these are almost free of bugs). For sure you can upgrade the converted SMF 1.1 to SMF 2.0 RC2 then:
Upgrading SMF (http://docs.simplemachines.org/index.php?board=3.0;sort=subject)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: marazmus on January 17, 2010, 03:24:04 AM
TE, I'm sorry, this was my mistake. vB's database was corrupted in some case (poll tables), due to previous converting issues (from another forum script). There was not much polls on my board, so I've just cleared poll tables in vB database, and converter done his job smoothly.

And I tell you VERY BIG THANK YOU for this converter. And especially for saving forum, post and user ID's like them was in vB board. This is very useful to do simple htaccess rewrites now, to save my board in Google's search index with 301 redirects.

p.s. Some minor bugs, if posted already:
- board moderators lost
- vB moderators set as global moderators

And I was need to change my vB setting for attachments directory from "attachments" to "./attachments" ("setting" table in vB database) BEFORE conversion. After this change my boards and all attachments was converted perfectly.

Thank you.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: ThorstenE on January 17, 2010, 06:48:02 AM
Thanks for the bug reports and welcome to SMF :)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: gLLo on February 24, 2010, 03:00:33 AM
Hi, I am attempting to convert a vBulletin 3.7.0 to SMF 2.0 RC2, however I am getting the following error:
QuoteConverting posts (this may take some time)...
Successful.
Converting polls...The database value you're trying to insert does not exist: id_member

I hope someone can help, thanks.

Edit: Now it is giving the following message:
QuoteConverting polls...Wrong value type sent to the database. Integer expected. (id_member)

I have made sure that all entries in the current vBulletin table are integers so I don't see what the problem could be.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on February 24, 2010, 06:16:09 AM
Can you please make sure you are using the latest converter package? The vbulletin_3.7 one, not earlier ones. Eventually, please tell the exact name of the .sql file you are using?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: gLLo on February 24, 2010, 07:14:35 AM
I downloaded all the converter files yesterday:
smf_2-0-rc2_vbulletin37_converter.zip
vbulletin37_to_smf.sql

I assume the problem lies when it's doing this line in the SQL t.postuserid AS id_member
Could it be because there are a number of entries in my vBulletin thread table in the postuserid column that are 0 due to deleted user accounts?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on February 24, 2010, 07:36:32 AM
If it's 0 it should be fine, if it's NULL, or empty, it could be the problem.

Please try using instead of:
Code (find) Select

t.postuserid AS id_member

Code (replace) Select

IFNULL(t.postuserid, 0) AS id_member

Title: Re: [SMF Converter] vBulletin 3.7
Post by: gLLo on February 24, 2010, 10:10:21 AM
That fixed that thanks, but I have a new error now.
QuoteConverting personal messages (step 1)...
MySQL server has gone away

I'm pretty sure the MySQL server is still there.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on February 24, 2010, 10:39:31 AM
It seems the converter lost connection to it. :)
Please see if this helps:
http://docs.simplemachines.org/index.php?topic=1501.msg3891#msg3891
Title: Re: [SMF Converter] vBulletin 3.7
Post by: gLLo on February 25, 2010, 12:32:21 AM
After reading I found that there is some problems with PHP 5.3.0 and persistent connections, so I disabled persistent connect.
And then I had an error regarding receiving packet larger than 'max_allowed_packet', so I increased it from 1M to 10M temporarily in MySQL config, which is something--if I was not doing this on my testing server--I would be unable to do, so you may want to look into that.

'Conversion Complete' and everything seems correct so far, I am glad I did this test run first.

Thank you for your help Norv.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: rconmax on February 26, 2010, 04:04:02 PM
I just used vbulletin37_to_smf.sql to convert my vBulletin 3.8.3 over to SMF 1.1.11 (on MySQL 5.1.40)
Every thing seems to have gone perfectly.
Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting avatars... Successful.
Recalculating forum statistics... Successful.


Great job guys, Thanks  :D
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on March 19, 2010, 11:44:26 AM
Cheers, good to hear!
Quote from: gLLo on February 25, 2010, 12:32:21 AM
After reading I found that there is some problems with PHP 5.3.0 and persistent connections, so I disabled persistent connect.
And then I had an error regarding receiving packet larger than 'max_allowed_packet', so I increased it from 1M to 10M temporarily in MySQL config, which is something--if I was not doing this on my testing server--I would be unable to do, so you may want to look into that.

You're right, it happens sometimes, though very rarely (one or two conversions for all I know), to exceed max_allowed_packet as it happens to be set. In this case, you can also (besides making the value higher), add to the conversion data file a (lower) number of records to be sent to MySQL each time. It depends where you got it, at posts, at PMs, etc.

Title: Re: [SMF Converter] vBulletin 3.7
Post by: Tiozinho on March 19, 2010, 05:23:43 PM
oi... estou prescisando de um conversor ou qualquer coisa q me ajude a criar um novo tema q eu fiz... alguem pode me ajudar??
Title: Re: [SMF Converter] vBulletin 3.7
Post by: laogui on May 11, 2010, 05:52:35 AM
3.8.4 can't converter

QuoteConverting posts (this may take some time)...
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 'ORDER BY null' at line 203
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on May 11, 2010, 06:04:52 AM
Quote from: Tiozinho on March 19, 2010, 05:23:43 PM
oi... estou prescisando de um conversor ou qualquer coisa q me ajude a criar um novo tema q eu fiz... alguem pode me ajudar??
Please, use only English in this board.
For assistance in international languages, please see the board: http://www.simplemachines.org/community/index.php?board=12.0

Quote from: laogui on May 11, 2010, 05:52:35 AM
3.8.4 can't converter

QuoteConverting posts (this may take some time)...
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 'ORDER BY null' at line 203
Please, use the converter packages found on this site at Downloads > Converters, for your SMF version.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: laogui on June 11, 2010, 01:53:06 AM
I use Vbulletin 3.7 to SMF 2-0-rc3 ,my forum is 4.0.3

Converting posts (this may take some time)...
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 'ORDER BY null' at line 203
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on June 22, 2010, 05:01:37 PM
I would really appreciate any help guys.

I have converted my forums and everything went smoothly.

except........  except that in the final outcome all smf text appears in correct arabic, but names of my categories and boards is in Garbage characters.

I did choose during the conversion to use arabic-utf8

the encoding of my forum webpages is correctly in urf-8

any idea ??? I tried switching the browser encoding to any other possibility.... nothing gave the expected arabic characters.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on June 22, 2010, 05:33:32 PM
let me explain a bit more

smf is rendering data in the mysql db exactly as it is, as I see it in phpmyadmin, meaning that arabic characters are recorded therein as garbage characters and are rendered exactly as is.

Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on June 23, 2010, 04:29:36 PM
 >:( >:(
Title: Re: [SMF Converter] vBulletin 3.7
Post by: laogui on June 25, 2010, 11:11:43 AM
I can not convert attachment to SMF
Title: Re: [SMF Converter] vBulletin 3.7
Post by: king999 on June 25, 2010, 01:24:08 PM
can u tell me in breif how to do that can i install first vbulliten in my host then do this onvert or simple use this convert.php
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on July 13, 2010, 09:31:49 PM
ok that is it. we are being ignored. Sleepy is not even providing help with the vbulletin converter...

What should we do ?

we are stuck

we are unable to move forward with the conversion and we are not getting the help we need

Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on July 13, 2010, 09:32:43 PM
converting from vb3.8 to smf 2.0 rc3 using the vb3.7 converter I get stuck at this stage:

convert.php?step=1&substep=9&start=12600
Converting...
Converting posts (this may take some time)...
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 'ORDER BY null' at line 203

Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on July 19, 2010, 04:13:37 PM
Can you please tell, do you use the converter as available on the Downloads > Converters page? That is the latest available version.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on July 19, 2010, 06:41:05 PM
Quote from: Norv on July 19, 2010, 04:13:37 PM
Can you please tell, do you use the converter as available on the Downloads > Converters page? That is the latest available version.

Yes Norv. Yes Yes. we are using the very last version of the vbulletin converter available online on the downloads section, and it is terribly failing us.

your help would be very appreciated.

vbulletin has screwed up on their promise: even an OWNED licence now needs a new payment to be able to patch security updates......  hence, you certainly would be seeing more and more people converting...... if the converter works.

I am ready to pay money for that..... here is my promise: help me convert vbulletin 3.8.6 to smf (any version) and I would immediately be a charter member.

I really need a working vb - smf converter......  if possible, one that keeps private message too and that does not fail on avatars and other non-necessary stuff such as signature images.....

Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on July 20, 2010, 05:42:23 AM
Unfortunately my schedule is a complete mess for a number of objective reasons, so I cannot have a good timeframe as to when I can possibly get again to this.
However, I will try doing so, when I can. If you can make available to me the database dump, it would help.

I am certain we had successful conversions from 3.8, so it should be a little odd thing going on presumably easy to spot.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on July 20, 2010, 05:46:43 AM
Quote from: Norv on July 20, 2010, 05:42:23 AM
Unfortunately my schedule is a complete mess for a number of objective reasons, so I cannot have a good timeframe as to when I can possibly get again to this.
However, I will try doing so, when I can. If you can make available to me the database dump, it would help.

I am certain we had successful conversions from 3.8, so it should be a little odd thing going on presumably easy to spot.

hello Norv.
I am more than ready to fully cooperate on this.

we can work on this step by step, hand in hand.
let me know if this evening is an option for you.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on July 20, 2010, 06:21:23 AM
Evening according to which timezone?  O:)  :D

However, I'm afraid that anyway I cannot guarantee an online presence at a particular time on this, but I am very often present. Eventually, we could:
- I'll get to this asap, and attach a file useful for debugging, so that we get a better error message, and go from there step by step.
- you can send me a backup of your database, and I'll try replicating the issue myself. Please do not do this unless you are certain you want to and are able to, since I need a full backup and I fully understand there are confidential data in it, which no one should share unless they decide so.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on July 20, 2010, 04:22:16 PM
Quote from: Norv on July 20, 2010, 06:21:23 AM
Evening according to which timezone?  O:)  :D

However, I'm afraid that anyway I cannot guarantee an online presence at a particular time on this, but I am very often present. Eventually, we could:
- I'll get to this asap, and attach a file useful for debugging, so that we get a better error message, and go from there step by step.
- you can send me a backup of your database, and I'll try replicating the issue myself. Please do not do this unless you are certain you want to and are able to, since I need a full backup and I fully understand there are confidential data in it, which no one should share unless they decide so.

thank you for your kind and prompt reply.
you know very well I can't give you a dump of my database. First it is confidential as you mentioned, second, it is 1GB!!


would you please still help me '?? I have added you to my msn messenger for direct interaction. let me know please when you are online.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on July 20, 2010, 06:17:53 PM
As I said, whether you wish to share a database backup is entirely your choice. I don't "know" whether you wish or not, it is your choice. I completely understand and there is no problem whatsoever, if you do not feel comfortable with doing so. (The size is not a problem, but that is not the point.)

Of course I will try to help. However, I am not interested in a paid job on the matter, for all I understand, it falls under the assistance we, the SMF Team, provide for free, on these forums. I'm afraid I will restrict to these forums, however, these forums exist for exactly that: free support. I never provide assistance on instant messengers, I do not have that kind of time and never do that, sorry.

About the problem at hand:
Please try this:
Keep a backup copy of your original file Subs-Db-mysql.php, and restore it after working on the conversion; then, in Subs-Db-mysql.php:
Code (find) Select

// Here's where the variables are injected to the query.
$insertRows = array();
foreach ($data as $dataRow)
$insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection);

Code (replace) Select

// Here's where the variables are injected to the query.
echo "indexed_columns:<br>";
var_dump($indexed_columns);
echo "<br>";
$insertRows = array();
foreach ($data as $dataRow) {
echo "dataRow: <br>";
var_dump($dataRow);
echo "<br>";
$insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection);
}


Then, run the conversion again. Please post the last query and error message on the page (copy paste, or attach a screenshot, or both, as you see fit).
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on July 20, 2010, 06:21:25 PM
thank you. am doing that right now. I will update you as soon as I have news.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on July 20, 2010, 06:34:11 PM
to be certain am doing this correctly, I have just dropped all tables in my smf database and am re-installing the smf forum from scratch.

I will then  use this converter

http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc3_vbulletin3_converter.zip

Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on July 20, 2010, 06:40:47 PM
Quote from: Sincere on July 20, 2010, 06:34:11 PM
to be certain am doing this correctly, I have just dropped all tables in my smf database and am re-installing the smf forum from scratch.

I will then  use this converter

http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc3_vbulletin3_converter.zip

hey Norv. did you mean in your earlier post to say that we should rather be using this ?
http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc3_vbulletin37_converter.zip

Title: Re: [SMF Converter] vBulletin 3.7
Post by: Norv on July 20, 2010, 06:41:54 PM
Yes, please use the converter from vbulletin 3.7, if you have 3.8, it was tested and it did work with a number of 3.8 databases.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on July 21, 2010, 02:21:20 AM
Quote from: Norv on July 20, 2010, 06:17:53 PM
As I said, whether you wish to share a database backup is entirely your choice. I don't "know" whether you wish or not, it is your choice. I completely understand and there is no problem whatsoever, if you do not feel comfortable with doing so. (The size is not a problem, but that is not the point.)

Of course I will try to help. However, I am not interested in a paid job on the matter, for all I understand, it falls under the assistance we, the SMF Team, provide for free, on these forums. I'm afraid I will restrict to these forums, however, these forums exist for exactly that: free support. I never provide assistance on instant messengers, I do not have that kind of time and never do that, sorry.

About the problem at hand:
Please try this:
Keep a backup copy of your original file Subs-Db-mysql.php, and restore it after working on the conversion; then, in Subs-Db-mysql.php:
Code (find) Select

// Here's where the variables are injected to the query.
$insertRows = array();
foreach ($data as $dataRow)
$insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection);

Code (replace) Select

// Here's where the variables are injected to the query.
echo "indexed_columns:<br>";
var_dump($indexed_columns);
echo "<br>";
$insertRows = array();
foreach ($data as $dataRow) {
echo "dataRow: <br>";
var_dump($dataRow);
echo "<br>";
$insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection);
}


Then, run the conversion again. Please post the last query and error message on the page (copy paste, or attach a screenshot, or both, as you see fit).

Hey Norv.

I tried 3 times yesterday.......

I think the code replacement that you recommended here above (quoted again here) outputs extra debugging information.

The little problem with this is that the conversion in this way outputs so much text that it crashed both IE and FF on my little notebook. I will have to try this conversion again on my solid dekstop this evening.

Title: Re: [SMF Converter] vBulletin 3.7
Post by: LadyAngel on October 05, 2010, 02:20:26 PM
Hi, I realise the converter from vB4 to smf is not around yet, but I've managed to convert with just one problem...the attachments have converted, but they are not showing up in the posts. What can I do about this?

Thanks
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Sincere on October 05, 2010, 02:26:40 PM
ouf...... my experience with those converters is that if the creator of the convertor does not help you, you really won't find much help elsewhere.
Try ...... good luck
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Antes on October 05, 2010, 04:07:58 PM
Quote from: ladyengland on October 05, 2010, 02:20:26 PM
Hi, I realise the converter from vB4 to smf is not around yet, but I've managed to convert with just one problem...the attachments have converted, but they are not showing up in the posts. What can I do about this?

Thanks

Converter has bug about converting 'attachments'  :/ devs are still working on it but yet you discovered Norv now Lead Developer (SMF) he has no/limited time for converters ...

Thank you for all understanding :)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: LadyAngel on October 05, 2010, 05:03:40 PM
Ok, well thanks for the replies. I only have a couple of hundred or so attachments, to I suppose I'll be adding them all manually :(
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Nibogo on October 13, 2010, 10:51:09 PM
Quote from: ladyengland on October 05, 2010, 05:03:40 PM
Ok, well thanks for the replies. I only have a couple of hundred or so attachments, to I suppose I'll be adding them all manually :(

There is already a vB4 Conveter available here: http://www.simplemachines.org/community/index.php?topic=404729.0
Title: Re: [SMF Converter] vBulletin 3.7
Post by: 05185736 on January 04, 2012, 05:51:19 AM
my admincp doesn't include config.php which the converter cannot get the settings

QuoteUnable to find the settings for vBulletin 3. Please double check the path and try again.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: mr.Curiosity on April 09, 2012, 02:57:10 AM
Works...


Thanks :)
Title: Re: [SMF Converter] vBulletin 3.7
Post by: greenvet2 on April 08, 2016, 02:52:19 PM
I thought that I read somewhere that you had to run SMF 1.1 to use the converters, but I can't find that again and don't see any reference to it here.  Can I install the latest (SMF 2.0)and still use the converter?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: Xsen on May 17, 2018, 03:26:45 AM
Hi!

I wonder if this thread is still watched, but anyway - I'm trying to convert vb 3.7.2 to smf 2.0.15 and whenever I click Proceed I just get a blank page. If I mess up the parameters on purpose I get the page with warnings what exactly went wrong. But if I use correct values - blank page.

I tried with various SMF versions - 2.0.15, 2.0.4 and 1.1.21, the result is the same.

I tried setting PHP for versions 5.6 and 7.1 for the SMF installation - no difference.

Anything I can do to fix this?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: sundar_83 on May 22, 2018, 12:07:59 AM
Hi i tried to convert my VB 3.8.1 database and getting this error

Warning: mysqli_error(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/srimeein/public_html/convert.php on line 469

Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/srimeein/public_html/convert.php on line 469
Title: Re: [SMF Converter] vBulletin 3.7
Post by: vbgamer45 on May 22, 2018, 12:48:52 AM
I recommend trying SMF 2.0.12 with the convertor and see if that helps then later upgrade SMF once you have it conveted
Title: Re: [SMF Converter] vBulletin 3.7
Post by: sundar_83 on May 22, 2018, 12:54:24 AM
download link for SMF 2.0.12 pls
Title: Re: [SMF Converter] vBulletin 3.7
Post by: vbgamer45 on May 22, 2018, 01:04:18 AM
https://download.simplemachines.org/index.php?archive
Title: Re: [SMF Converter] vBulletin 3.7
Post by: sundar_83 on May 22, 2018, 01:39:56 AM
Yes found it and installed and now converting process started members are converting once done will update here thanks for ur work
Title: Re: [SMF Converter] vBulletin 3.7
Post by: sundar_83 on May 22, 2018, 01:54:15 AM
Converting topic notifications...
Successful.
Converting board notifications... Successful.
Converting smileys... Successful.
Converting attachments...MySQL server has gone away

Any solution for this one to fix converting stopped if i start again will start from 1st onwards or will continue from attachement itself?
Title: Re: [SMF Converter] vBulletin 3.7
Post by: sundar_83 on May 22, 2018, 01:57:34 AM
and while login as member Password security has recently been upgraded. Please enter your password again.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: vbgamer45 on May 22, 2018, 10:18:51 AM
Attachments make sure your server has a high limit for packet size in mysql

Member logins the first time they use the password they have to reconfirm after that they can look as normal.
Title: Re: [SMF Converter] vBulletin 3.7
Post by: amadeos on March 13, 2019, 10:54:42 AM
Hey there!

Just curious, has anybody tried CMS2CMS?

https://cms2cms.com/cms/supported-cms/vbulletin-to-simple-machines-forum-migration/ (https://cms2cms.com/cms/supported-cms/vbulletin-to-simple-machines-forum-migration/)

Looks quite promising