Advertisement:

Author Topic: [SMF Converter] MyBB 1.2.x  (Read 235998 times)

Offline Limer

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] MyBB 1.2.x
« Reply #160 on: June 30, 2008, 09:07:56 PM »
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.

Code: [Select]
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'

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #161 on: June 30, 2008, 10:29:55 PM »
Open the .sql file.

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

Replace:
Code: [Select]
SELECT tid AS ID_TOPIC, uid AS ID_MEMBER
FROM {$from_prefix}threadsread;
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Limer

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] MyBB 1.2.x
« Reply #162 on: June 30, 2008, 10:38:24 PM »
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

« Last Edit: June 30, 2008, 11:00:38 PM by Limer »

ThorstenE

  • Guest
Re: [SMF Converter] MyBB 1.2.x
« Reply #163 on: July 01, 2008, 01:19:09 AM »
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..

Offline Limer

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] MyBB 1.2.x
« Reply #164 on: July 01, 2008, 02:18:57 AM »
I can't get it to work...I modded it to this and it doesn't work... Anyone can fix this?

Code: [Select]
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

  • Guest
Re: [SMF Converter] MyBB 1.2.x
« Reply #165 on: July 01, 2008, 04:28:21 AM »
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

Offline Limer

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] MyBB 1.2.x
« Reply #166 on: July 01, 2008, 10:39:20 AM »
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

  • Guest
Re: [SMF Converter] MyBB 1.2.x
« Reply #167 on: July 01, 2008, 10:45:51 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.

Offline Limer

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] MyBB 1.2.x
« Reply #168 on: July 01, 2008, 01:55:00 PM »
IT WORKED !!!!! Thanks!!!

« Last Edit: July 01, 2008, 02:04:18 PM by Limer »

ThorstenE

  • Guest
Re: [SMF Converter] MyBB 1.2.x
« Reply #169 on: July 01, 2008, 02:01:39 PM »
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

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #170 on: July 01, 2008, 02:04:25 PM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline Limer

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] MyBB 1.2.x
« Reply #171 on: July 01, 2008, 02:09:24 PM »
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

  • Guest
Re: [SMF Converter] MyBB 1.2.x
« Reply #172 on: July 01, 2008, 02:20:20 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]


Offline Limer

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] MyBB 1.2.x
« Reply #173 on: July 01, 2008, 02:41:30 PM »
Thanks guys ...everything is 100% The support here on SMF has been amazing!!!

Offline mutevekkil

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] MyBB 1.2.x
« Reply #174 on: July 04, 2008, 04:14:46 PM »
Quote
Converting 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 !!

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #175 on: July 04, 2008, 04:45:20 PM »
Find:
Code: [Select]
SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,
Replace:
Code: [Select]
    SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn, 1, 255) AS MSN,
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline blackbiLL

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] MyBB 1.2.x
« Reply #176 on: July 05, 2008, 06:26:04 AM »
Hi.
I have got a problem.

Quote
Converting 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. ;)

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #177 on: July 05, 2008, 01:59:13 PM »
open the .sql file

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

Replace:
Code: [Select]
---* {$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
Support the SMF Support team!
Profiles:
GitHub

Offline blackbiLL

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] MyBB 1.2.x
« Reply #178 on: July 06, 2008, 04:46:21 AM »
Very well. Thanks a lot!  ;)

I converted phpbb3 in myBB and myBB in SMF!

THANKS! ;)

Offline mutevekkil

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] MyBB 1.2.x
« Reply #179 on: August 04, 2008, 10:35:25 AM »
Find:
Code: [Select]
SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,
Replace:
Code: [Select]
    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 !