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.
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'
Does this one work?
yes it works thank you
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
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.
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 ''
:-[ :-[
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..
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
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
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..
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 =
D1Starcraft: Brood War =
D1Warcraft 2 =
4FDiablo 2 =
0CDIablo 2: Lord of Destruction =
0CWarcraft 3 =
16Warcraft 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¤t=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'
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..
Ohh that explains it, Thanks very much ;)
How do i convert sleepy i don know how to convert smf to v bulletin
Our guide should help you: Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Hi I got a Character set problem how can ı fix it ?
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?
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'
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
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?
So i think so its not a big problem right ....
any ways thanks
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 :)
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
which version from the vbulletin37_to_smf.sql are you using? try the file attached on the first post of this topic.
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
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;
---*
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 ''
Is SMF installed into the same database or a different database? Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Where's the link to the vBulletin 3.7.x converter? I need to convert my vBulletin 3.7.2 to SMF, thanks!
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)
Thanks man, I'll try that now ;)
+10
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
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'
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Anyone else able to convert their vb 3.7 to smf?
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?
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
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.
yes I do
$config['Database']['tableprefix'] = ' ';
I even tried it with a space in between the quotes $config['Database']['tableprefix'] = ' ';
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)
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.
thank you very much I have been looking for this!
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
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
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
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
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.
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
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)
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..
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..
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.
Well, I'm now stopped in this error.
The error MySQL gave was: Table 'XXXXXX_1.user' doesn't exist
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.
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?
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.
YeS!!! You'r the one!!
Thanks man, without you this was impsible!
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 :)
maybe the session_save_path isn't writeable, please check Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)..
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 ?
see Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0) .. the MySQL user for both forums must be the same.
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.
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)
not able to get the attachment of vb 3.7 convert.php
got the sql file now what?
convert.php is attached to this topic (scroll down):
http://www.simplemachines.org/community/index.php?topic=140741.0
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!!
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. :(
Преко плота
Приче из чаршије... 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
sirNemanjapro, Sorry but I cannot read your language.. can you explain your issues please?
You see the first part, you can actually read the letters\words.
Other stuff is gibberish.
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.
Its the same collation. It dosent work. Can some one help me over IM?
I didnt mentioned this, but I tried to fix HTML to UTF8 in admin panel, it didnt work.
both are UTF-8? then install SMF and use a Cyrillic charset instead. during the conversion you should use "UTF-8".
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
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
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?
- Create a new database on the SMF server (does it need a user added to it?)
- Import the vBulletin backup into the new database
- Create a migration.php with my database name and prefix
- Edit ? to change the ---~ from_prefix: "" . $database . "." statement
- place migration.php in a folder on the SMF server and use the path to this as the Path to vBulletin 3.7 when I run convert.php
Is there anything else I need to do?
Many thanks,
Benz1
Ok, we go the easy way ;) try the attached version. you should be asked for a database and table prefix.
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
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
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).
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
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
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?
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
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
woop ty ty ty. this works fine with vb 3.8.1
hi friends any one tel me how to install .sql file step by step
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)
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
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.
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 :) .
The convert.php link doesn't let me download...just takes me to a list of topics which just leads me back here, wtf?
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..
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?
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
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 ''
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
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?
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?
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)
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?
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;
---*
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
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.
convert.php for vbulletin 3.7 is not available for download...
please check convert.php link . :(
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).
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.
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?
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.
navjotjsingh or Fish.666,
can anyone take a screenshot from the table vb3_pm.. (the structure -> column names are important)?
Thank you
Hi!
Thanks again for your reply. I don't have accesss to phpmyadmin, but i hope this screens are ok:
Attached is the structure from my screenshot.
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
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.
Hi!
Thanks again for your help, the import works now without a problem. :)
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?
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)
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.
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)
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 :)
Attached is the result of the SQL Query
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
maritoz,
Don't care about these error, the conversion process has already finished.
QuoteRecalculating forum statistics... Successful.
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
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.
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
http://www.simplemachines.org/community/index.php?topic=326107.msg2173140#msg2173140
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?
the error is exactly the same (a minor bug in convert.php)..
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'
indoboards,
which version is your vBulletin? The issue is related to a missing column "pmid".. Maybe you used the old vbulletin36_to_smf.sql?
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?¿?
http://download.simplemachines.org/?converters;software=vbulletin
convert.php nerde?
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.
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)
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. :-[
Cheers, good to hear you got it sorted out!
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
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.
thanks it works
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.
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)
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.
Thanks for the bug reports and welcome to SMF :)
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.
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?
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?
If it's 0 it should be fine, if it's NULL, or empty, it could be the problem.
Please try using instead of:
t.postuserid AS id_member
IFNULL(t.postuserid, 0) AS id_member
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.
It seems the converter lost connection to it. :)
Please see if this helps:
http://docs.simplemachines.org/index.php?topic=1501.msg3891#msg3891
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.
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
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.
oi... estou prescisando de um conversor ou qualquer coisa q me ajude a criar um novo tema q eu fiz... alguem pode me ajudar??
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
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.
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
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.
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.
>:( >:(
I can not convert attachment to SMF
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
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
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
Can you please tell, do you use the converter as available on the Downloads > Converters page? That is the latest available version.
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.....
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.
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.
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.
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.
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:
// 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);
// 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).
thank you. am doing that right now. I will update you as soon as I have news.
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
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
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.
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:
// 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);
// 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.
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
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
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 :)
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 :(
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
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.
Works...
Thanks :)
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?
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?
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
I recommend trying SMF 2.0.12 with the convertor and see if that helps then later upgrade SMF once you have it conveted
download link for SMF 2.0.12 pls
https://download.simplemachines.org/index.php?archive
Yes found it and installed and now converting process started members are converting once done will update here thanks for ur work
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?
and while login as member Password security has recently been upgraded. Please enter your password again.
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.
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