News:

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

Main Menu

converting from vbulletin 3.6.1 to smf 1.1.1 error

Started by nesrelshark, January 20, 2007, 05:52:20 AM

Previous topic - Next topic

nesrelshark

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

Croco

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

nesrelshark

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

Croco

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

nesrelshark

#4
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

Croco

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

nesrelshark

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 

JayBachatero

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

ntas

#8
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

JayBachatero

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

ntas

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)

JayBachatero

Follow me on Twitter

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

Advertisement: