Advertisement:

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

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,943
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
[SMF Converter] vBulletin 3.7
« on: September 17, 2008, 03:03:37 PM »
Software: vBulletin
Version: 3.7.x

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

Changelog
- PM conversion failed

convert.php
Use this convert.php with the .sql file attached in this topic. 
« Last Edit: July 18, 2009, 04:35:42 AM by TE »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline minos

  • Full Member
  • ***
  • Posts: 509
  • Gender: Male
  • metalminos.com
    • Metal Minos Foro
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #1 on: September 25, 2008, 04:45:53 AM »
when converter is in private messages gives an error

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

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

Caused the error:

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

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,943
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #2 on: September 25, 2008, 02:12:03 PM »
Does this one work?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline minos

  • Full Member
  • ***
  • Posts: 509
  • Gender: Male
  • metalminos.com
    • Metal Minos Foro
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #3 on: September 25, 2008, 03:40:59 PM »
yes it works  thank you

Offline HR

  • Jr. Member
  • **
  • Posts: 320
  • Gender: Male
  • There is only ONE 'Reality!
    • http://only-harshreality.com/forums/
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #4 on: October 02, 2008, 01:33:48 PM »
Boards dont seem to be coming over.. posts and what all show as successful but smf_boards retains a value of 0

Resolved.. manual edit of database revealed all parentid was set to -1, reset to value of 1 and POOF
« Last Edit: October 02, 2008, 02:11:10 PM by HR »
I can explain this as simply as possible.. If I do it & implement I guarantee it.
 If I do it and you implement it its a crap shoot.

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,943
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #5 on: October 02, 2008, 06:58:35 PM »
Ahh so they where converted? Just not showing.

Did you have any categories setup in vb? That would be the only reason I can think of there being that issue.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline bigi_18

  • Jr. Member
  • **
  • Posts: 166
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #6 on: October 08, 2008, 08:40:54 PM »
Code: [Select]
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3.7. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: Incorrect database name ''

 :-[ :-[

ThorstenE

  • Guest
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #7 on: October 09, 2008, 01:41:38 AM »
Common conversion errors. or Converting to SMF should help..
The (absolute) path to vBulletin 3.7 is wrong or the mysql user from your SMF database cannot access the vBulletin 3.7 database..

Offline southernlady

  • Semi-Newbie
  • *
  • Posts: 22
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #8 on: October 13, 2008, 04:01:54 PM »
I used the config file from vb 3.6 and the sql file from first post in this thread to convert a vb 3.7.2 forum over this morning. I am pleased to report that the conversion went without a hitch. Avatars and ranks did not move over but that was the only stuff that came up missing. I did have to run a repair afterwards because I turned around and moved it to a new domain. But that was my fault, not the fault of the converter.

Well done. Liz

Offline adamcanada

  • Semi-Newbie
  • *
  • Posts: 37
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #9 on: October 15, 2008, 01:22:50 PM »
When I try to plug this database into my SMF + TinyPortal install I am getting the following even though I have raised the memory limit

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

ThorstenE

  • Guest
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #10 on: October 15, 2008, 01:41:02 PM »
That error means that converter script got to much data and was unable to hold it in memory, so php gave an error. was it while converting the posts? then you can try this:

edit the vbulletin37_to_smf.sql and find:

Code: [Select]
---* {$to_prefix}messages 200
replace it with
Code: [Select]
---* {$to_prefix}messages 100
then upload the changed file and restart the conversion..

Offline ReVoKe

  • Jr. Member
  • **
  • Posts: 150
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #11 on: October 27, 2008, 10:28:03 PM »
i get....

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

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

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





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

Unknown column 'memberName' in 'field list'

ThorstenE

  • Guest
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #12 on: October 28, 2008, 01:56:45 PM »
Which version of SMF are you using?
Quote
Unknown column 'memberName' in 'field list'
Sounds like you have installed SMF 2.0B4? the converters are for SMF 1.1.x at this time.. so you have to install SMF 1.1.6 first and convert your vBulletin, then run the large-upgrade from our downloads page..

Offline ReVoKe

  • Jr. Member
  • **
  • Posts: 150
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #13 on: October 28, 2008, 03:12:12 PM »
Ohh that explains it, Thanks very much ;)

Offline galton

  • Newbie
  • *
  • Posts: 4
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #14 on: November 02, 2008, 06:24:16 AM »
How do i convert sleepy i don know how to convert smf to v bulletin

ThorstenE

  • Guest
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #15 on: November 02, 2008, 11:20:53 AM »
Our guide should help you: Converting to SMF

Offline xRooTx

  • Newbie
  • *
  • Posts: 1
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #16 on: November 12, 2008, 05:11:51 PM »
Hi I got a Character set problem how can ı fix it ?

ThorstenE

  • Guest
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #17 on: November 13, 2008, 01:34:06 AM »
both forums must have the same database / table collation during the conversion.. if your vBulletin is installed in latin (or your type of charset) your SMF must be installed in latin  (or your type of charset). If VBulletin is installed in UTF-8, SMF must also be installed in UTF-8. You can check the collation with phpMyAdmin ( What is phpMyAdmin? ). c
If this doesn't help, can you post the error message here?

Offline assam_siddibapa

  • Full Member
  • ***
  • Posts: 429
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #18 on: November 15, 2008, 12:54:57 PM »
I am geting this error

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

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

Offline assam_siddibapa

  • Full Member
  • ***
  • Posts: 429
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #19 on: November 15, 2008, 01:12:12 PM »
i figured it out


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

will this be a problem