Advertisement:

Author Topic: Convert Vbulletin 3.6.3 to SMF  (Read 7452 times)

Offline wk38

  • Jr. Member
  • **
  • Posts: 185
Convert Vbulletin 3.6.3 to SMF
« 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.

Offline winrules

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 5,085
  • Gender: Male
Re: Convert Vbulletin 3.6.3 to SMF
« Reply #1 on: November 23, 2006, 09:50:51 PM »
What error are you getting?
winrules
SMF Developer
               My Mods
Please do not PM me for support.


Offline wk38

  • Jr. Member
  • **
  • Posts: 185
Re: Convert Vbulletin 3.6.3 to SMF
« Reply #2 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

Offline wk38

  • Jr. Member
  • **
  • Posts: 185
Re: Convert Vbulletin 3.6.3 to SMF
« Reply #3 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.

Offline hellmet

  • Semi-Newbie
  • *
  • Posts: 29
Re: Convert Vbulletin 3.6.3 to SMF
« Reply #4 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??

Offline winrules

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 5,085
  • Gender: Male
Re: Convert Vbulletin 3.6.3 to SMF
« Reply #5 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
winrules
SMF Developer
               My Mods
Please do not PM me for support.


Offline nesrelshark

  • Newbie
  • *
  • Posts: 6
Re: Convert Vbulletin 3.6.3 to SMF
« Reply #6 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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Convert Vbulletin 3.6.3 to SMF
« Reply #7 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.
Follow me on Twitter

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