Advertisement:

Author Topic: converting from vbulletin 3.6.1 to smf 1.1.1 error  (Read 8689 times)

Offline nesrelshark

  • Newbie
  • *
  • Posts: 6
converting from vbulletin 3.6.1 to smf 1.1.1 error
« 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
« Last Edit: January 23, 2007, 02:14:49 AM by nesrelshark »

Offline Croco

  • SMF Hero
  • ******
  • Posts: 2,812
    • Andareena.com
Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
« Reply #1 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
I am back. I will try to catch up with some stuff soon.
Regards,
Croco

My sites
Andareena.com
Andareen.net(Under Constraction :P)

New plans coming soon


Good links for you to visit:
Docs
Search

Offline nesrelshark

  • Newbie
  • *
  • Posts: 6
Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
« Reply #2 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

Offline Croco

  • SMF Hero
  • ******
  • Posts: 2,812
    • Andareena.com
Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
« Reply #3 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 
I am back. I will try to catch up with some stuff soon.
Regards,
Croco

My sites
Andareena.com
Andareen.net(Under Constraction :P)

New plans coming soon


Good links for you to visit:
Docs
Search

Offline nesrelshark

  • Newbie
  • *
  • Posts: 6
Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
« Reply #4 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
« Last Edit: January 23, 2007, 04:04:07 AM by nesrelshark »

Offline Croco

  • SMF Hero
  • ******
  • Posts: 2,812
    • Andareena.com
Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
« Reply #5 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
I am back. I will try to catch up with some stuff soon.
Regards,
Croco

My sites
Andareena.com
Andareen.net(Under Constraction :P)

New plans coming soon


Good links for you to visit:
Docs
Search

Offline nesrelshark

  • Newbie
  • *
  • Posts: 6
Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
« Reply #6 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 

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
« Reply #7 on: January 29, 2007, 06:38:02 PM »
You can't merge two SMF forums together at the moment.
Follow me on Twitter

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

Offline ntas

  • Newbie
  • *
  • Posts: 2
Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
« Reply #8 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', 'cocacola1310@yahoo.com', '', '', '', '', '', '', '1170595169', '1170594843', '1', '10', '0000-00-00', '', '', '', '1', 'wM\'', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('2', 'ntas', 'ntas', 'c6f2ff7bcec3ecd4fa6ebb5681464731', 'cocacola@yahoo.com', '', '', '', '', '', '', '1170595127', '1170595041', '1', '10', '0000-00-00', '127.0.0.1', '127.0.0.1', '', '0', 'Ap{', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('3', 'asdf', 'asdf', '6fdcd801d1942fe02d896f6eeeb5a3c1', 'asad@abc.com', '', '', '', '', '', '', '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
« Last Edit: February 04, 2007, 09:59:22 AM by ntas »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
« Reply #9 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.
Follow me on Twitter

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

Offline ntas

  • Newbie
  • *
  • Posts: 2
Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
« Reply #10 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)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: converting from vbulletin 3.6.1 to smf 1.1.1 error
« Reply #11 on: February 04, 2007, 11:46:20 PM »
Running MySQL in strict mode.
Follow me on Twitter

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