Simple Machines Community Forum

SMF Support => Converting to SMF => vBulletin => Topic started by: wk38 on November 23, 2006, 09:36:01 PM

Title: Convert Vbulletin 3.6.3 to SMF
Post by: wk38 on November 23, 2006, 09:36:01 PM
SMF Version: SMF 1.1 RC3
I tried the converter that is posted here for vBulletin 3.5 but it's not working. Is there a newer one that someone is making? Sure would love to move away from vBulletin but I can't unless I can get my categories and forums converted over.
Title: Re: Convert Vbulletin 3.6.3 to SMF
Post by: winrules on November 23, 2006, 09:50:51 PM
What error are you getting?
Title: Re: Convert Vbulletin 3.6.3 to SMF
Post by: wk38 on November 24, 2006, 02:20:47 AM
Converting members... Successful.
Converting categories... Unsuccessful!
This query:
INSERT INTO `talkofthevillages_com_-_smf`.smf_categories
(ID_CAT, name, catOrder)
VALUES ('1', 'Main Category', '1'),
('3', 'Partners', '1'),
('5', 'Support Groups', '1'),
('10', 'Athletic Activates', '1'),
('19', 'Rumor Mill', '1'),
('21', 'Just 4 Fun', '1'),
('27', 'Stay in touch', '1'),
('30', 'Employment Opportunities', '1'),
('33', 'Restaurants', '1'),
('36', 'Village Talk & Events', '1'),
('95', 'General Clubs', '142'),
('291', 'Recreation Centers', '1'),
('305', 'Ethnic Clubs', '1'),
('309', 'Churches', '1'),
('320', 'The Villages Charter Schools', '1'),
('327', 'Villages Government', '1'),
('332', 'Regional Clubs', '1');
Caused the error:

Duplicate entry '255' for key 1
Title: Re: Convert Vbulletin 3.6.3 to SMF
Post by: wk38 on November 24, 2006, 02:36:25 AM
BTY, If someone can the script working and I can get my categories and forums converted from vBullletin, I'm going to drop them so fast it will make your head swim. I'm starting to really despise Jelsoft. Problem is, I have a total of about 300 categories and forms to convert. I'm not concerned with users, just my forums. We're not live yet and I still have 4 more days. Otherwise I'm going to be stuck with vBulletin.
Title: Re: Convert Vbulletin 3.6.3 to SMF
Post by: hellmet on November 24, 2006, 06:29:08 AM
if you've paid for vBulletin, why not stick with then?
btw, why did u decide to install vBulletin first,
adding all those categories and then think of SMF??
Title: Re: Convert Vbulletin 3.6.3 to SMF
Post by: winrules on November 26, 2006, 12:45:55 PM
Can you try running these two queries in phpMyAdmin, and then try converting again?

Code: [Select]
ALTER TABLE smf_categories CHANGE ID_CAT ID_CAT SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT
Code: [Select]
ALTER TABLE smf_categories CHANGE catOrder catOrder SMALLINT(5) NOT NULL
Title: Re: Convert Vbulletin 3.6.3 to SMF
Post by: nesrelshark on January 20, 2007, 06:29:28 AM
i was having the same problem and worked fine after i did these queries but after that i got this error
Converting polls... Unsuccessful!
This query:

    INSERT INTO `arabteam_forum`.smf_polls

    (ID_POLL, question, votingLocked, maxVotes, posterName, expireTime, ID_MEMBER)

    VALUES ('3', 'مارايك هل هذا الموضوع مهم بالنسبة للشركات وشبكات الانترنت ام لا', '0', '0', 'Guest', '1160106971', ''),

    ('4', 'مارايك فى البرنامج', '0', '0', 'Guest', '0', ''),

    ('5', 'هل الموضوع يستحق التثبيت', '0', '0', 'weea2002', '0', '627'),

    ('5', 'هل الموضوع يستحق التثبيت', '0', '0', 'القلب الطيب', '0', '835'),

    ('5', 'هل الموضوع يستحق التثبيت', '0', '0', 'ابو يزن', '0', '412'),

    ('6', 'مارايك هل هذا الموضوع مهم بالنسبة للشركات وشبكات الانترنت ام لا', '0', '0', 'weea2002', '1160106971', '1267'),

    ('7', 'مارايك فى البرنامج', '0', '0', 'القلب الطيب', '0', '1475'),

    ('8', 'هل الموضوع يستحق التثبيت', '0', '0', 'ابو يزن', '0', '1052');

Caused the error:

    Duplicate entry '3' for key 1
Title: Re: Convert Vbulletin 3.6.3 to SMF
Post by: JayBachatero on January 29, 2007, 09:38:05 PM
nesrelshark how big is your board?  I am working on the vB 3.6.x converter but need a board to test it on.  I'm looking for an average sized board.  Not more than 50k posts.