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
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
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
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
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
you could empty the arabteam_forum table in vbulletin
or you could delete the line by phpMyAdmin
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
You can't merge two SMF forums together at the moment.
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
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.
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)
Running MySQL in strict mode.