Simple Machines Community Forum

SMF Support => Converting to SMF => vBulletin => Topic started by: nesrelshark on January 20, 2007, 05:52:20 AM

Title: converting from vbulletin 3.6.1 to smf 1.1.1 error
Post by: nesrelshark on January 20, 2007, 05:52:20 AM
hi i have an error converting vbulletin 3.6.1 to smf 1.1.1 using the offecial 3.5 convertor
this is the 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: converting from vbulletin 3.6.1 to smf 1.1.1 error
Post by: Croco on January 23, 2007, 02:41:25 AM
try to empty the smf_polls and try again
in phpMyAdmin choose the smf database and then select the smf_polls and press empty after that try again
Title: Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
Post by: nesrelshark on January 23, 2007, 03:04:51 AM
the same problem
    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 '5' for key 1
Title: Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
Post by: Croco on January 23, 2007, 03:24:06 AM
here as you can see there is
('5', 'هل الموضوع يستحق التثبيت', '0', '0', 'weea2002', '0', '627'),

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

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

the 5 is here 3 times so you could delete 2 lines of it it would be the best solution cause if you gave it a new value it could cause a problem in the future 
Title: Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
Post by: nesrelshark on January 23, 2007, 03:47:43 AM
how can i delete it?
if u can learn me how to avoid converting polls ?
i don't want them i just want the members , topics,posts , forums , personal messaes and attachments
thanks for your help
Title: Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
Post by: Croco on January 23, 2007, 04:07:59 AM
you could empty the arabteam_forum table in vbulletin
or you could delete the line by phpMyAdmin
Title: Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
Post by: nesrelshark on January 23, 2007, 04:43:09 AM
thanks very much for your help i'm done bu have another two problems
1- the bbcodes:
some topics like this [SIZE="4"][COLOR="Red"]بسم الله الرحمن الرحيم
2- i have two vbulletin forums i converted them to two smf but i want to make one of them part of the other
how can i do that ?
thanks again and again for your help 
Title: Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
Post by: JayBachatero on January 29, 2007, 06:38:02 PM
You can't merge two SMF forums together at the moment.
Title: Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
Post by: ntas on February 04, 2007, 09:37:44 AM
I convert form VBB 3.6.0 ( or 3.5.3) to SMF 1.1.1 by converter tools provided by download section. But I had an error when I converted members.
The error :
This query:

    INSERT INTO `smf2`.smf_members
    (ID_MEMBER, memberName, realName, passwd, emailAddress, websiteTitle, websiteUrl, ICQ, AIM, YIM, usertitle, lastLogin, dateRegistered, posts, karmaGood, birthdate, memberIP, memberIP2, MSN, ID_GROUP, passwordSalt, signature, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, timeFormat, avatar, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet)
    VALUES ('1', 'admin', 'admin', 'ef9963dde925830c39a8835b8c2b4906', '[email protected]', '', '', '', '', '', '', '1170595169', '1170594843', '1', '10', '0000-00-00', '', '', '', '1', 'wM\'', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('2', 'ntas', 'ntas', 'c6f2ff7bcec3ecd4fa6ebb5681464731', '[email protected]', '', '', '', '', '', '', '1170595127', '1170595041', '1', '10', '0000-00-00', '127.0.0.1', '127.0.0.1', '', '0', 'Ap{', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('3', 'asdf', 'asdf', '6fdcd801d1942fe02d896f6eeeb5a3c1', '[email protected]', '', '', '', '', '', '', '1170595455', '1170595380', '0', '10', '0000-00-00', '', '', '', '0', 'Y:c', '', '', '', '', '', '', '', '', '', '', '', '', '');

Caused the error:
    Field 'location' doesn't have a default value


( I installed SMF 1.1.1 and converted immediately ).
What's the reason of  my problem and how can I solve it?
Thanks for helping
Title: Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
Post by: JayBachatero on February 04, 2007, 11:22:51 PM
ntas the converter is not updated for 3.6.  I have a test converter locally that I need to test.  If you can PM me FTP info I can finish upgrading it and testing it out then converting your board.
Title: Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
Post by: ntas on February 04, 2007, 11:44:04 PM
I converted it in localhost.
I don't know why everyone passes the step converting members but I don't. What is the main cause of my problem?( field "location" doesn't have a default value)
Title: Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
Post by: JayBachatero on February 04, 2007, 11:46:20 PM
Running MySQL in strict mode.