News:

Wondering if this will always be free?  See why free is better.

Main Menu

[SMF Converter] MyBB 1.2.x

Started by JayBachatero, January 24, 2007, 11:57:28 AM

Previous topic - Next topic

Limer

I' trying to convert the latest version of MYBB t the latest Version of SMF this is my current error...any help would be appreciated thanks.

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Converting topic view logs... Unsuccessful!
This query:
INSERT INTO `notsafe4_forum`.smf_log_topics
(ID_TOPIC, ID_MEMBER, logTime)
VALUES ('209', '1', '1214331449'),
('208', '1', '1214326568'),
('373', '2', '1214829736'),
('45', '22', '1214321405'),
('207', '1', '1214326425'),
('206', '1', '1214325797'),
('205', '24', '1214325514'),
('200', '3', '1214324911'),
('216', '1', '1214486283'),
('212', '25', '1214334227'),
('201', '25', '1214334137'),
('228', '28', '1214358948'),
('207', '27', '1214356868'),
('231', '1', '1214358429'),
('230', '1', '1214358057'),
('183', '8', '1214364146'),
('233', '29', '1214368047'),
('199', '8', '1214364090'),
('213', '32', '1214421427'),
('252', '37', '1214477670'),
('227', '31', '1214407442'),
('266', '1', '1214483598'),
('199', '31', '1214407366'),
('239', '1', '1214498194'),
('236', '31', '1214407432'),
('40', '31', '1214407257'),
('265', '1', '1214479634'),
('238', '1', '1214396747'),
('237', '1', '1214396457'),
('236', '1', '1214418429'),
('241', '31', '1214407229'),
('203', '11', '1214400597'),
('206', '30', '1214401336'),
('210', '11', '1214400590'),
('267', '1', '1214480960'),
('226', '11', '1214400549'),
('237', '30', '1214401323'),
('185', '37', '1214477506'),
('241', '1', '1214404722'),
('240', '1', '1214404137'),
('247', '1', '1214525537'),
('249', '1', '1214413018'),
('250', '1', '1214418827'),
('186', '28', '1214432081'),
('256', '28', '1214432067'),
('241', '33', '1214428863'),
('225', '33', '1214428822'),
('251', '33', '1214428784'),
('166', '37', '1214477559'),
('270', '1', '1214483062'),
('269', '1', '1214482565'),
('268', '1', '1214481565'),
('246', '37', '1214477458'),
('245', '37', '1214477589'),
('260', '37', '1214477417'),
('107', '36', '1214473025'),
('275', '1', '1214486803'),
('266', '23', '1214489159'),
('275', '38', '1214487982'),
('272', '1', '1214485810'),
('274', '1', '1214486509'),
('273', '1', '1214486257'),
('266', '35', '1214488099'),
('278', '1', '1214513322'),
('277', '40', '1214489946'),
('211', '2', '1214843327'),
('279', '50', '1214590768'),
('213', '18', '1214523624'),
('295', '1', '1214523554'),
('236', '18', '1214523447'),
('302', '48', '1214750099'),
('280', '18', '1214551382'),
('294', '1', '1214523081'),
('266', '28', '1214522715'),
('280', '28', '1214522685'),
('279', '28', '1214522676'),
('293', '1', '1214522138'),
('292', '1', '1214521795'),
('265', '47', '1214521474'),
('286', '18', '1214523420'),
('290', '48', '1214536307'),
('296', '1', '1214524781'),
('301', '1', '1214533115'),
('300', '1', '1214532711'),
('298', '1', '1214593288'),
('304', '1', '1214594979'),
('291', '48', '1214536300'),
('297', '1', '1214531249'),
('299', '1', '1214532469'),
('297', '48', '1214536299'),
('247', '21', '1214542765'),
('301', '24', '1214541200'),
('278', '39', '1214568697'),
('270', '39', '1214568586'),
('296', '39', '1214568556'),
('74', '39', '1214568538'),
('391', '1', '1214858999'),
('278', '49', '1214568461'),
('280', '39', '1214587926'),
('303', '1', '1214570538'),
('247', '25', '1214586630'),
('280', '25', '1214586480'),
('38', '53', '1214600554'),
('304', '48', '1214578344'),
('93', '51', '1214582134'),
('256', '51', '1214582096'),
('338', '1', '1214676891'),
('305', '53', '1214600516'),
('289', '51', '1214582084'),
('360', '1', '1214771513'),
('275', '51', '1214582056'),
('259', '51', '1214582038'),
('298', '51', '1214656491'),
('279', '52', '1214583429'),
('98', '1', '1214683866'),
('280', '52', '1214583405'),
('295', '18', '1214607551'),
('323', '1', '1214646094'),
('322', '1', '1214659215'),
('321', '1', '1214645133'),
('305', '18', '1214639444'),
('320', '1', '1214644491'),
('319', '1', '1214644382'),
('315', '18', '1214639560'),
('314', '18', '1214641881'),
('306', '18', '1214607450'),
('306', '53', '1214600351'),
('53', '53', '1214601031'),
('51', '53', '1214600842'),
('302', '53', '1214600820'),
('303', '53', '1214600760'),
('280', '53', '1214600656'),
('304', '53', '1214600457'),
('106', '53', '1214600439'),
('395', '1', '1214863659'),
('318', '1', '1214634502'),
('317', '1', '1214634147'),
('316', '1', '1214681184'),
('315', '1', '1214627124'),
('314', '1', '1214662747'),
('313', '1', '1214626491'),
('270', '51', '1214625825'),
('312', '1', '1214625215'),
('311', '1', '1214625031'),
('310', '1', '1214646129'),
('309', '1', '1214625330'),
('308', '1', '1214633915'),
('307', '1', '1214623545'),
('342', '1', '1214681234'),
('305', '48', '1214669961'),
('334', '48', '1214750102'),
('341', '1', '1214697279'),
('340', '1', '1214677646'),
('339', '1', '1214677222'),
('337', '1', '1214674128'),
('334', '1', '1214672842'),
('387', '1', '1214852384'),
('336', '1', '1214673928'),
('335', '1', '1214696106'),
('337', '24', '1214712891'),
('357', '1', '1214772628'),
('358', '29', '1214759666'),
('83', '64', '1214823265'),
('304', '24', '1214713339'),
('311', '24', '1214713305'),
('313', '24', '1214713251'),
('323', '24', '1214713239'),
('330', '24', '1214713200'),
('331', '24', '1214713177'),
('334', '24', '1214713117'),
('340', '24', '1214713106'),
('341', '24', '1214713098'),
('349', '24', '1214713084'),
('340', '57', '1214713021'),
('20', '57', '1214712971'),
('134', '1', '1214412404'),
('392', '1', '1214862347'),
('280', '59', '1214771691'),
('335', '24', '1214712849'),
('106', '57', '1214712939'),
('141', '59', '1214771739'),
('44', '59', '1214771734'),
('352', '48', '1214750346'),
('54', '59', '1214771730'),
('352', '1', '1214752230'),
('354', '1', '1214752763'),
('353', '1', '1214752441'),
('355', '1', '1214753329'),
('279', '59', '1214771679'),
('305', '58', '1214757819'),
('357', '58', '1214764445'),
('356', '58', '1214757356'),
('356', '1', '1214771869'),
('358', '1', '1214771961'),
('359', '58', '1214764377'),
('53', '59', '1214771142'),
('314', '59', '1214776004'),
('51', '59', '1214771140'),
('383', '1', '1214850785'),
('38', '59', '1214771136'),
('20', '59', '1214771113'),
('375', '1', '1214803108'),
('340', '62', '1214806814'),
('341', '62', '1214806812'),
('375', '62', '1214806805'),
('235', '62', '1214806754'),
('345', '62', '1214806740'),
('342', '62', '1214806734'),
('360', '62', '1214806725'),
('214', '62', '1214806714'),
('346', '63', '1214808251'),
('50', '46', '1214847620'),
('275', '64', '1214823467'),
('75', '64', '1214823420'),
('81', '64', '1214823333'),
('107', '64', '1214823283'),
('373', '39', '1214828616'),
('375', '39', '1214828581'),
('369', '69', '1214866964'),
('50', '39', '1214828366'),
('320', '2', '1214829819'),
('354', '2', '1214829804'),
('367', '2', '1214829794'),
('371', '2', '1214829789'),
('376', '66', '1214832539'),
('374', '23', '1214832525'),
('50', '23', '1214832506'),
('12', '68', '1214834443'),
('107', '68', '1214834848'),
('183', '68', '1214834359'),
('330', '2', '1214842940'),
('324', '2', '1214842919'),
('331', '2', '1214842892'),
('333', '2', '1214842832'),
('334', '2', '1214843507'),
('336', '2', '1214842790'),
('337', '2', '1214843520'),
('377', '1', '1214843957'),
('340', '2', '1214842671'),
('341', '2', '1214843528'),
('348', '2', '1214842643'),
('349', '2', '1214842628'),
('361', '2', '1214842594'),
('362', '2', '1214842580'),
('363', '2', '1214843589'),
('364', '2', '1214843536'),
('375', '35', '1214841495'),
('177', '1', '1214410510'),
('365', '2', '1214843596'),
('374', '35', '1214841542'),
('50', '57', '1214842015'),
('376', '2', '1214842428'),
('390', '69', '1214866951'),
('195', '2', '1214843374'),
('204', '2', '1214843358'),
('380', '1', '1214843760'),
('50', '52', '1214845234'),
('335', '46', '1214847921'),
('386', '1', '1214852195'),
('385', '1', '1214851480'),
('384', '1', '1214851050'),
('374', '52', '1214850513'),
('395', '69', '1214866947'),
('382', '1', '1214849267'),
('377', '24', '1214854600'),
('274', '69', '1214867006'),
('394', '1', '1214863062'),
('393', '1', '1214862937'),
('191', '1', '1214269606'),
('338', '69', '1214868830'),
('193', '1', '1214346950'),
('397', '1', '1214868162'),
('107', '69', '1214868482'),
('219', '69', '1214868479'),
('398', '1', '1214868818'),
('198', '1', '1214337493'),
('199', '1', '1214318935'),
('197', '19', '1214272549'),
('40', '19', '1214272598'),
('199', '19', '1214273583'),
('198', '19', '1214272743'),
('196', '19', '1214272732'),
('161', '19', '1214273247'),
('195', '19', '1214273235'),
('190', '19', '1214273275'),
('121', '19', '1214273720'),
('107', '19', '1214273768'),
('199', '20', '1214275234'),
('167', '20', '1214275318'),
('121', '20', '1214275407'),
('68', '20', '1214275489'),
('62', '20', '1214275500'),
('130', '20', '1214275750'),
('126', '20', '1214275755'),
('86', '20', '1214275759'),
('124', '20', '1214275760'),
('70', '20', '1214275843'),
('199', '2', '1214281421'),
('38', '21', '1214289503'),
('46', '22', '1214321537'),
('198', '22', '1214307533'),
('3', '22', '1214300775'),
('4', '22', '1214300790'),
('11', '22', '1214300801'),
('13', '22', '1214301185'),
('14', '22', '1214302007'),
('15', '22', '1214302017'),
('18', '22', '1214302025'),
('16', '22', '1214302037'),
('22', '22', '1214302046'),
('65', '22', '1214302069'),
('57', '22', '1214302087'),
('43', '22', '1214319688'),
('107', '22', '1214302150'),
('53', '22', '1214302160'),
('20', '22', '1214302174'),
('50', '22', '1214302184'),
('181', '22', '1214306689'),
('182', '22', '1214306707'),
('188', '22', '1214307074'),
('189', '22', '1214307148'),
('190', '22', '1214307202'),
('191', '22', '1214307427'),
('200', '1', '1214314079'),
('24', '22', '1214315663'),
('25', '22', '1214315672'),
('201', '1', '1214315844'),
('201', '23', '1214315981'),
('200', '23', '1214316020'),
('26', '22', '1214316028'),
('27', '22', '1214316039'),
('28', '22', '1214316049'),
('29', '22', '1214316062'),
('30', '22', '1214316072'),
('31', '22', '1214316112'),
('202', '1', '1214424942'),
('203', '1', '1214316500'),
('32', '22', '1214316892'),
('204', '1', '1214316944'),
('33', '22', '1214317177'),
('34', '22', '1214317185'),
('205', '1', '1214317714'),
('35', '22', '1214318315'),
('36', '22', '1214318777'),
('37', '22', '1214318826'),
('39', '22', '1214318889'),
('40', '22', '1214318983'),
('41', '22', '1214319188'),
('205', '2', '1214319581'),
('200', '2', '1214319663'),
('210', '1', '1214328320'),
('211', '1', '1214328259'),
('211', '23', '1214329181'),
('206', '23', '1214329211'),
('204', '23', '1214329223'),
('203', '23', '1214329238'),
('212', '1', '1214329716'),
('213', '1', '1214424850'),
('214', '1', '1214493969'),
('215', '1', '1214331319'),
('213', '16', '1214331836'),
('216', '16', '1214331882'),
('215', '16', '1214331900'),
('214', '16', '1214331919'),
('201', '16', '1214331989'),
('216', '25', '1214334313'),
('215', '25', '1214334355'),
('130', '25', '1214334410'),
('206', '25', '1214334750'),
('124', '25', '1214334820'),
('126', '25', '1214334853'),
('42', '25', '1214334967'),
('7', '25', '1214334968'),
('107', '25', '1214335052'),
('81', '25', '1214335148'),
('51', '25', '1214335257'),
('38', '25', '1214335306'),
('217', '1', '1214336944'),
('218', '1', '1214337254'),
('219', '1', '1214338170'),
('220', '1', '1214338312'),
('221', '1', '1214338915'),
('222', '1', '1214339311'),
('223', '1', '1214340147'),
('211', '26', '1214341236'),
('183', '26', '1214341283'),
('204', '26', '1214341292'),
('223', '25', '1214343502'),
('224', '1', '1214403512'),
('224', '25', '1214343640'),
('222', '25', '1214343681'),
('221', '25', '1214343711'),
('218', '25', '1214343758'),
('225', '1', '1214344573'),
('217', '25', '1214343796'),
('209', '25', '1214343827'),
('205', '25', '1214343872'),
('211', '25', '1214344041'),
('210', '25', '1214344076'),
('204', '25', '1214344249'),
('203', '25', '1214344345'),
('202', '25', '1214344400'),
('197', '25', '1214344451'),
('196', '25', '1214344494'),
('195', '25', '1214344519'),
('194', '25', '1214344645'),
('171', '25', '1214344716'),
('164', '25', '1214344925'),
('226', '1', '1214345457'),
('227', '1', '1214409826'),
('228', '1', '1214347208'),
('229', '1', '1214353440'),
('229', '28', '1214359019'),
('227', '28', '1214359047'),
('226', '28', '1214359053'),
('211', '28', '1214359063'),
('232', '1', '1214359072'),
('210', '28', '1214359073'),
('213', '28', '1214359119'),
('233', '1', '1214359346'),
('234', '1', '1214359706'),
('235', '1', '1214360046'),
('229', '29', '1214368081'),
('225', '29', '1214368095'),
('199', '29', '1214368118'),
('213', '29', '1214368214'),
('204', '29', '1214368270'),
('198', '29', '1214369060'),
('221', '29', '1214370937'),
('214', '31', '1214407461'),
('242', '1', '1214424078'),
('243', '1', '1214409739'),
('244', '1', '1214410219'),
('245', '1', '1214410907'),
('246', '1', '1214411456'),
('248', '1', '1214412851'),
('236', '23', '1214414140'),
('249', '34', '1214421468'),
('250', '34', '1214421494'),
('242', '34', '1214421530'),
('223', '34', '1214421562'),
('205', '34', '1214421649'),
('183', '32', '1214422445'),
('74', '32', '1214422459'),
('12', '32', '1214422480'),
('222', '32', '1214422607'),
('217', '32', '1214422753'),
('225', '32', '1214422849'),
('200', '32', '1214423036'),
('249', '32', '1214423064'),
('228', '32', '1214423160'),
('251', '1', '1214423220'),
('203', '32', '1214423313'),
('202', '32', '1214423324'),
('252', '1', '1214423534'),
('253', '1', '1214423896'),
('254', '1', '1214424285'),
('255', '1', '1214487251'),
('256', '1', '1214427243'),
('247', '28', '1214432040'),
('177', '28', '1214432091'),
('257', '1', '1214432710'),
('256', '35', '1214433867'),
('247', '35', '1214433906'),
('258', '1', '1214447077'),
('259', '1', '1214437689'),
('260', '1', '1214438675'),
('261', '1', '1214444403'),
('262', '1', '1214444458'),
('263', '1', '1214444709'),
('264', '1', '1214444911'),
('271', '1', '1214483205'),
('236', '38', '1214485972'),
('271', '38', '1214486080'),
('276', '1', '1214487888'),
('258', '35', '1214488119'),
('274', '38', '1214488448'),
('277', '1', '1214488442'),
('258', '23', '1214500380'),
('273', '40', '1214489954'),
('258', '38', '1214492003'),
('278', '31', '1214492516'),
('275', '31', '1214492527'),
('274', '31', '1214492540'),
('257', '31', '1214492545'),
('279', '1', '1214493760'),
('258', '24', '1214493693'),
('280', '1', '1214696100'),
('279', '40', '1214495797'),
('280', '40', '1214495800'),
('278', '40', '1214495804'),
('281', '1', '1214496096'),
('282', '1', '1214496784'),
('236', '41', '1214496966'),
('283', '1', '1214497077'),
('278', '21', '1214497170'),
('280', '21', '1214497264'),
('284', '1', '1214497696'),
('280', '42', '1214609718'),
('280', '35', '1214500691');
Caused the error:

Unknown column 'logTime' in 'field list'

SleePy

Open the .sql file.

Find:
SELECT tid AS ID_TOPIC, uid AS ID_MEMBER, dateline AS logTime
FROM {$from_prefix}threadsread;


Replace:
SELECT tid AS ID_TOPIC, uid AS ID_MEMBER
FROM {$from_prefix}threadsread;

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Limer

#162
THANKS everything is perfect now...

BUT I have a BIG problem... all my old urls are broken I though it would still work from the database...is there a fix for this?

old urls:      showthread.php?tid=390
New URL:    index.php/topic,390.0.html

OMG...I can't have all those links now broken....

how do I fix this?

Thanks again


ThorstenE

check out this post, might be helpful:
http://www.simplemachines.org/community/index.php?topic=99500.msg644890#msg644890
it's an example for phpBB but the myBB URLs look similar..

Limer

I can't get it to work...I modded it to this and it doesn't work... Anyone can fix this?

RewriteCond %{QUERY_STRING} ^(.*&)?tid=([0-9]+)(&.*)?$ [NC]
RewriteRule ^forum/showthread\.php$ /forum/index.php?topic=%2.0 [R=301,L]
RewriteCond %{QUERY_STRING} ^(.*&)?fid=([0-9]+)(&.*)?$ [NC]
RewriteRule ^forum/forumdisplay\.php$ /forum/index.php?board=%2.0 [R=301,L]

ThorstenE

This one shoud work (tested localy)
Code (.htaccess) Select

RewriteEngine on

RewriteCond %{QUERY_STRING} ^(.*&)?tid=([0-9]+)(&.*)?$ [NC]
RewriteRule ^showthread\.php$ /forum/index.php?topic=%2.0
RewriteCond %{QUERY_STRING} ^(.*&)?fid=([0-9]+)(&.*)?$ [NC]
RewriteRule ^forumdisplay\.php$ /forum/index.php?board=%2.0


/forum/index.php in above .htaccess must be the part after the root-url.

Example:
www.yourdomain.com/community/forum is path to your SMF, then you have to change this to /community/forum/index.php

Limer

It's still not working...

Forum.mysite.com is where my forum is located...

could this be the issue?

I placed the .htaccess in the root folder of miysite. Should it be in the forum folder?

Thanks for all you help!

ThorstenE

Quote from: Limer on July 01, 2008, 10:39:20 AM
I placed the .htaccess in the root folder of miysite. Should it be in the forum folder?
is forum.yoursite.com the path for old and new forum? then you have to put it in the forum-folder and remove the /forum/ from the condition.

Limer

#168
IT WORKED !!!!! Thanks!!!


ThorstenE

Try this (put htaccess in smf-directory)
Code (.htaccess) Select
RewriteEngine on

RewriteCond %{QUERY_STRING} ^(.*&)?tid=([0-9]+)(&.*)?$ [NC]
RewriteRule ^showthread\.php$ /index.php?topic=%2.0
RewriteCond %{QUERY_STRING} ^(.*&)?fid=([0-9]+)(&.*)?$ [NC]
RewriteRule ^forumdisplay\.php$ /index.php?board=%2.0


SleePy

It may be more simple to just create a showthread.php file that handles the topic redirecting. As well for forum displaying.

The result rewrite rules though if you do them and get them working, you should force it as a 301 redirect so search engines know to update their links.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Limer

IT WORKED !!!!!

Another question... I had my old forum up yesterday.... is the a way to sync the changes since I converted it?

If I ran the convertion tool again will it have problems ? or should I just do a fresh convertion...

What about all the stuff already added to the database from the first convertion?

basically, What's the best way to add the data from the last 24 hours?

Thanks!!!


ThorstenE

Quote from: Limer on July 01, 2008, 02:09:24 PM
If I ran the convertion tool again will it have problems ?
you can reconvert it without problems.. and it's the easiest way ..

SleePy is right, try:
Code (.htaccess) Select
RewriteEngine on

RewriteCond %{QUERY_STRING} ^(.*&)?tid=([0-9]+)(&.*)?$ [NC]
RewriteRule ^showthread\.php$ /index.php?topic=%2.0  [R=301,L]
RewriteCond %{QUERY_STRING} ^(.*&)?fid=([0-9]+)(&.*)?$ [NC]
RewriteRule ^forumdisplay\.php$ /index.php?board=%2.0  [R=301,L]



Limer

Thanks guys ...everything is 100% The support here on SMF has been amazing!!!

mutevekkil

QuoteConverting members... Unsuccessful!
This query:
SELECT
uid AS ID_MEMBER, SUBSTRING(username, 1, 255) AS memberName,
SUBSTRING(username, 1, 255) AS realName,
SUBSTRING(password, 1, 64) AS passwd, email AS emailAddress,
postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
lastvisit AS lastLogin, IF(usergroup = 4, 1, 0) AS ID_GROUP,
regdate AS dateRegistered, SUBSTRING(website, 1, 255) AS websiteUrl,
SUBSTRING(website, 1, 255) AS websiteTitle,
SUBSTRING(icq, 1, 255) AS ICQ, SUBSTRING(aim, 1, 16) AS AIM,
SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,
SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hideEmail,
SUBSTRING(buddylist, 1, 255) AS buddy_list,
SUBSTRING(regip, 1, 255) AS memberIP, SUBSTRING(regip, 1, 255) AS memberIP2,
SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
timeonline AS totalTimeLoggedIn,
IF(birthday = '', '0001-01-01', CONCAT_WS('-', RIGHT(birthday, 4), SUBSTRING(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), LEFT(birthday, LOCATE('-', birthday) - 1))) AS birthdate
FROM `yansima_portal`.mybb_users
LIMIT 0, 500;
Caused the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS MSN, 1, 255) AS MSN,
SUBSTRING(signature, 1, 65534) AS signature, hideemail ' at line 10
please help me !!

SleePy

Quote from: SleePy on June 27, 2008, 01:20:00 PM
Find:
SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,

Replace:
    SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn, 1, 255) AS MSN,
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

blackbiLL

Hi.
I have got a problem.

QuoteConverting poll votes... Unsuccessful!
This query:

    INSERT INTO `ps3kille_smfklrs`.smf15klrs_log_polls
    (ID_POLL, ID_MEMBER, ID_CHOICE)
    VALUES ('1', '2', '7'),
    ('1', '5', '5'),
    ('1', '10', '7'),
    ('1', '12', '5'),
    ('1', '14', '4'),
    ('1', '6', '5'),
    ('1', '4', '5'),
    ('1', '15', '4'),
    ('1', '16', '5'),
    ('1', '13', '5'),
    ('1', '0', '4'),
    ('1', '20', '5'),
    ('2', '2', '2'),
    ('2', '12', '2'),
    ('2', '4', '2'),
    ('2', '10', '2'),
    ('2', '14', '2'),
    ('1', '9', '5'),
    ('2', '6', '2'),
    ('3', '2', '5'),
    ('3', '2', '4'),
    ('3', '53', '11'),
    ('3', '14', '14'),
    ('9', '4', '5'),
    ('3', '13', '3'),
    ('3', '13', '10'),
    ('3', '13', '15'),
    ('3', '13', '16'),
    ('3', '20', '10'),
    ('3', '20', '19'),
    ('3', '22', '5'),
    ('3', '12', '8'),
    ('3', '12', '10'),
    ('3', '4', '5'),
    ('3', '4', '10'),
    ('3', '4', '11'),
    ('4', '53', '6'),
    ('1', '11', '7'),
    ('3', '10', '11'),
    ('3', '2', '10'),
    ('3', '2', '11'),
    ('1', '22', '4'),
    ('2', '26', '1'),
    ('1', '26', '4'),
    ('2', '5', '2'),
    ('3', '8', '13'),
    ('3', '8', '11'),
    ('3', '8', '15'),
    ('2', '11', '2'),
    ('3', '11', '3'),
    ('3', '11', '4'),
    ('3', '11', '11'),
    ('3', '12', '4'),
    ('4', '2', '5'),
    ('4', '12', '4'),
    ('4', '22', '4'),
    ('4', '4', '6'),
    ('4', '11', '5'),
    ('4', '10', '6'),
    ('3', '26', '11'),
    ('4', '8', '6'),
    ('5', '2', '7'),
    ('5', '14', '2'),
    ('5', '10', '7'),
    ('5', '12', '7'),
    ('3', '5', '8'),
    ('3', '5', '11'),
    ('3', '5', '15'),
    ('0', '15', '3'),
    ('0', '13', '1'),
    ('0', '31', '4'),
    ('3', '31', '10'),
    ('0', '10', '1'),
    ('0', '10', '7'),
    ('0', '4', '1'),
    ('0', '4', '5'),
    ('0', '26', '1'),
    ('0', '26', '5'),
    ('3', '23', '1'),
    ('3', '23', '3'),
    ('3', '23', '6'),
    ('8', '13', '4'),
    ('8', '13', '8'),
    ('8', '13', '9'),
    ('8', '4', '5'),
    ('4', '13', '5'),
    ('4', '14', '6'),
    ('8', '22', '3'),
    ('8', '22', '5'),
    ('8', '22', '10'),
    ('0', '8', '1'),
    ('0', '8', '5'),
    ('3', '47', '18'),
    ('8', '39', '2'),
    ('8', '23', '2'),
    ('8', '23', '5'),
    ('8', '23', '11'),
    ('5', '22', '7'),
    ('5', '0', '6'),
    ('4', '5', '3'),
    ('8', '2', '2'),
    ('8', '2', '4'),
    ('8', '2', '14'),
    ('0', '15', '2'),
    ('0', '15', '4'),
    ('4', '33', '4'),
    ('3', '33', '3'),
    ('3', '33', '5'),
    ('3', '33', '11'),
    ('4', '26', '6'),
    ('9', '2', '5'),
    ('9', '10', '3'),
    ('9', '14', '3'),
    ('9', '12', '5'),
    ('8', '8', '4'),
    ('8', '8', '10'),
    ('8', '8', '12'),
    ('9', '13', '5'),
    ('8', '14', '9'),
    ('3', '13', '4'),
    ('8', '15', '1'),
    ('8', '15', '3'),
    ('8', '15', '5'),
    ('4', '15', '4'),
    ('0', '13', '3'),
    ('3', '47', '17'),
    ('11', '2', '1'),
    ('11', '10', '1'),
    ('11', '12', '1'),
    ('3', '42', '3'),
    ('0', '0', '1'),
    ('11', '13', '1'),
    ('11', '6', '1'),
    ('0', '0', '6'),
    ('0', '0', '7'),
    ('0', '23', '2'),
    ('0', '23', '4'),
    ('0', '39', '3'),
    ('0', '15', '2'),
    ('0', '16', '2'),
    ('11', '20', '1'),
    ('12', '2', '3'),
    ('12', '10', '2'),
    ('12', '4', '1'),
    ('12', '17', '3'),
    ('12', '12', '1'),
    ('4', '20', '4'),
    ('11', '35', '2'),
    ('1', '51', '5'),
    ('8', '43', '9'),
    ('11', '4', '1'),
    ('12', '15', '1'),
    ('9', '15', '3'),
    ('3', '35', '1'),
    ('3', '35', '2'),
    ('3', '35', '5'),
    ('3', '35', '20'),
    ('4', '43', '6'),
    ('11', '16', '1'),
    ('0', '14', '1'),
    ('4', '35', '5'),
    ('3', '40', '8'),
    ('12', '13', '3'),
    ('11', '33', '1'),
    ('8', '19', '4'),
    ('8', '19', '5'),
    ('8', '19', '12'),
    ('3', '19', '1'),
    ('3', '19', '15'),
    ('3', '19', '18'),
    ('11', '19', '1'),
    ('9', '20', '4'),
    ('3', '43', '4'),
    ('3', '43', '5'),
    ('3', '43', '6'),
    ('12', '5', '3'),
    ('12', '49', '3'),
    ('3', '30', '1'),
    ('3', '30', '5'),
    ('3', '30', '11'),
    ('11', '15', '1'),
    ('11', '14', '3'),
    ('11', '32', '1'),
    ('11', '0', '1'),
    ('11', '5', '1'),
    ('3', '40', '1'),
    ('3', '40', '15'),
    ('4', '40', '1'),
    ('8', '47', '14'),
    ('4', '47', '6'),
    ('3', '47', '5'),
    ('3', '47', '11'),
    ('3', '31', '11'),
    ('3', '31', '22'),
    ('0', '31', '2'),
    ('3', '0', '3'),
    ('4', '19', '4'),
    ('3', '51', '3'),
    ('3', '51', '4'),
    ('3', '51', '8'),
    ('3', '51', '21'),
    ('3', '67', '10'),
    ('3', '67', '14'),
    ('13', '47', '2'),
    ('13', '47', '14'),
    ('3', '14', '10'),
    ('13', '12', '3'),
    ('13', '12', '11'),
    ('13', '12', '14'),
    ('13', '4', '1'),
    ('13', '4', '9'),
    ('13', '11', '1'),
    ('13', '38', '1'),
    ('13', '38', '3'),
    ('13', '38', '5'),
    ('13', '6', '1'),
    ('13', '6', '5'),
    ('13', '6', '7'),
    ('13', '32', '11'),
    ('13', '32', '14'),
    ('13', '26', '4'),
    ('13', '8', '1'),
    ('13', '8', '9'),
    ('13', '35', '1'),
    ('13', '8', '15'),
    ('13', '35', '14'),
    ('13', '2', '1'),
    ('13', '5', '1'),
    ('13', '5', '5'),
    ('13', '5', '14'),
    ('13', '10', '1'),
    ('13', '10', '14'),
    ('13', '10', '15'),
    ('13', '66', '2'),
    ('13', '66', '4'),
    ('13', '19', '2'),
    ('13', '19', '4'),
    ('13', '19', '6'),
    ('13', '31', '3'),
    ('13', '31', '7'),
    ('13', '31', '9'),
    ('13', '14', '4'),
    ('13', '14', '2'),
    ('13', '67', '3'),
    ('13', '67', '4'),
    ('13', '67', '7'),
    ('13', '7', '1'),
    ('13', '7', '3'),
    ('13', '7', '5'),
    ('13', '47', '1'),
    ('3', '53', '12'),
    ('3', '53', '13'),
    ('3', '53', '14'),
    ('3', '53', '15'),
    ('3', '53', '16'),
    ('3', '53', '17'),
    ('3', '53', '18'),
    ('3', '53', '19'),
    ('3', '53', '20'),
    ('3', '53', '21'),
    ('3', '53', '22'),
    ('13', '53', '2'),
    ('13', '53', '4'),
    ('13', '53', '6'),
    ('13', '63', '3'),
    ('13', '63', '9'),
    ('13', '63', '12'),
    ('13', '4', '2'),
    ('13', '11', '2'),
    ('13', '11', '3'),
    ('13', '65', '4'),
    ('13', '65', '6'),
    ('13', '65', '8'),
    ('13', '46', '13'),
    ('13', '23', '3'),
    ('13', '23', '7'),
    ('13', '23', '15'),
    ('3', '4', '8'),
    ('13', '43', '11'),
    ('3', '61', '3'),
    ('3', '61', '5'),
    ('3', '61', '11'),
    ('3', '61', '14'),
    ('13', '20', '13'),
    ('8', '6', '3'),
    ('14', '14', '4'),
    ('14', '33', '4'),
    ('14', '31', '4'),
    ('14', '6', '4'),
    ('14', '20', '1'),
    ('3', '59', '20'),
    ('4', '59', '6'),
    ('14', '43', '2'),
    ('14', '5', '3'),
    ('14', '13', '4'),
    ('15', '4', '1'),
    ('15', '10', '2'),
    ('15', '23', '1'),
    ('14', '2', '4'),
    ('15', '12', '1'),
    ('14', '15', '4'),
    ('3', '54', '18'),
    ('3', '54', '1'),
    ('3', '54', '22'),
    ('14', '39', '1'),
    ('15', '11', '1'),
    ('4', '29', '5'),
    ('13', '15', '6'),
    ('13', '15', '4'),
    ('13', '15', '2'),
    ('3', '9', '19'),
    ('3', '9', '15'),
    ('3', '9', '10'),
    ('17', '32', '1'),
    ('17', '10', '1'),
    ('16', '13', '6'),
    ('17', '4', '1'),
    ('17', '2', '1'),
    ('16', '14', '5'),
    ('16', '20', '2'),
    ('16', '6', '2'),
    ('16', '31', '3'),
    ('3', '29', '1'),
    ('3', '29', '2'),
    ('16', '5', '6'),
    ('15', '22', '1'),
    ('15', '35', '1'),
    ('3', '68', '20'),
    ('3', '68', '13'),
    ('3', '68', '8'),
    ('3', '68', '1'),
    ('16', '2', '3'),
    ('15', '26', '11'),
    ('8', '29', '14'),
    ('15', '19', '7'),
    ('3', '14', '11'),
    ('13', '2', '3'),
    ('13', '2', '5'),
    ('18', '59', '4'),
    ('18', '32', '4'),
    ('18', '2', '5'),
    ('18', '4', '4'),
    ('18', '10', '5'),
    ('19', '2', '1'),
    ('19', '32', '1'),
    ('19', '68', '1'),
    ('19', '68', '2'),
    ('19', '10', '1'),
    ('19', '10', '2'),
    ('19', '2', '3'),
    ('19', '32', '2'),
    ('19', '13', '1'),
    ('19', '13', '2'),
    ('19', '4', '1'),
    ('19', '4', '3'),
    ('19', '35', '1'),
    ('19', '39', '1'),
    ('8', '59', '5'),
    ('19', '6', '1'),
    ('19', '6', '5'),
    ('19', '14', '1'),
    ('19', '14', '3'),
    ('19', '51', '1'),
    ('19', '70', '1'),
    ('19', '70', '3'),
    ('13', '68', '1'),
    ('19', '47', '14'),
    ('19', '47', '1');

Caused the error:

    Duplicate entry '1-2-7' for key 1

Can anyone help me?

P.S.: Sorry for my English, I'm Italian. ;)

SleePy

open the .sql file

Find:
---* {$to_prefix}log_polls
SELECT pid AS ID_POLL, uid AS ID_MEMBER, voteoption AS ID_CHOICE
FROM {$from_prefix}pollvotes;
---*


Replace:
---* {$to_prefix}log_polls
---{
$ignore = true;
---}
SELECT pid AS ID_POLL, uid AS ID_MEMBER, voteoption AS ID_CHOICE
FROM {$from_prefix}pollvotes;
---*


Thank you. I made the change as well in my sources since I didn't see if changed :)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

blackbiLL

Very well. Thanks a lot!  ;)

I converted phpbb3 in myBB and myBB in SMF!

THANKS! ;)

mutevekkil

Quote from: SleePy on July 04, 2008, 04:45:20 PM
Quote from: SleePy on June 27, 2008, 01:20:00 PM
Find:
SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,

Replace:
    SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn, 1, 255) AS MSN,

i converted mybb 1.2.12 to smf, successful !
thanks so very much SleePy !

Advertisement: