News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Convert Vbulletin 3.6.3 to SMF

Started by wk38, November 23, 2006, 09:36:01 PM

Previous topic - Next topic

wk38

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.

winrules



winrules
SMF Developer
               
My Mods
Please do not PM me for support.


wk38

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

wk38

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.

hellmet

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

winrules

Can you try running these two queries in phpMyAdmin, and then try converting again?


ALTER TABLE smf_categories CHANGE ID_CAT ID_CAT SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT


ALTER TABLE smf_categories CHANGE catOrder catOrder SMALLINT(5) NOT NULL


winrules
SMF Developer
               
My Mods
Please do not PM me for support.


nesrelshark

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

JayBachatero

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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Advertisement: