Simple Machines Community Forum

SMF Support => Converting to SMF => MyBB => Topic started by: JayBachatero on January 24, 2007, 11:57:28 AM

Title: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on January 24, 2007, 11:57:28 AM
Software: MyBB
Version: 1.2.x

This is the official support topic for MyBB converter.  Use this topic to ask for support for this converter.

Changelog
! When converting users also convert the passwordSalt. (mybb12_to_smf.sql)
! Typo
! logTime is no longer used (mybb12_to_smf.sql)
! When converting polls make sure that questions column has an alias. (mybb12_to_smf.sql)
! Updated converter to convert attachments. (mybb12_to_smf.sql)
! When converting attachments and it's an image add the width and height for it. (mybb12_to_smf.sql)
! Cast $width and $height as a string or else it wont return a value if the file is not an image. (mybb12_to_smf.sql)

convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Clint_ on January 24, 2007, 04:24:11 PM
I'm getting an error of:

Converting topic view logs... Unsuccessful!
This query:

    INSERT IGNORE INTO `tom151_forum`.smf_log_topics
    (ID_TOPIC, ID_MEMBER, logTime)
    VALUES ('79', '1', '1169497241'),
    ('81', '6', '1169411140'),
    ('80', '6', '1169346269'),
    ('79', '3', '1169509016'),
    ('36', '3', '1169425880'),
    ('79', '6', '1169492893'),
    ('79', '2', '1169498321'),
    ('78', '2', '1169393279'),
    ('71', '2', '1169404516'),
    ('30', '17', '1169512058'),
    ('81', '2', '1169508577'),
    ('65', '2', '1169351641'),
    ('78', '1', '1169352161'),
    ('1', '17', '1169362206'),
    ('30', '1', '1169404615'),
    ('60', '1', '1169352691'),
    ('9', '1', '1169352795'),
    ('77', '1', '1169352818'),
    ('75', '1', '1169352835'),
    ('64', '1', '1169352837'),
    ('63', '1', '1169352838'),
    ('61', '1', '1169352839'),
    ('52', '1', '1169352840'),
    ('47', '1', '1169352841'),
    ('23', '1', '1169352842'),
    ('20', '1', '1169352843'),
    ('30', '6', '1169538285'),
    ('18', '3', '1169355176'),
    ('36', '1', '1169497198'),
    ('82', '3', '1169366310'),
    ('30', '3', '1169366546'),
    ('81', '17', '1169366961'),
    ('81', '3', '1169375431'),
    ('82', '2', '1169425452'),
    ('73', '2', '1169387923'),
    ('32', '1', '1169399772'),
    ('28', '1', '1169399788'),
    ('8', '1', '1169399820'),
    ('79', '11', '1169506094'),
    ('80', '11', '1169402865'),
    ('82', '11', '1169402904'),
    ('48', '11', '1169403168'),
    ('36', '14', '1169415494'),
    ('74', '14', '1169415644'),
    ('18', '14', '1169406473'),
    ('41', '14', '1169406599'),
    ('68', '14', '1169407006'),
    ('7', '2', '1169406882'),
    ('67', '14', '1169406924'),
    ('36', '2', '1169406955'),
    ('74', '2', '1169512971'),
    ('27', '14', '1169407054'),
    ('83', '14', '1169420476'),
    ('60', '2', '1169429361'),
    ('44', '14', '1169407474'),
    ('83', '2', '1169430365'),
    ('33', '14', '1169407489'),
    ('84', '2', '1169494161'),
    ('44', '2', '1169408118'),
    ('65', '11', '1169408226'),
    ('84', '11', '1169420272'),
    ('44', '11', '1169408299'),
    ('68', '11', '1169408433'),
    ('85', '11', '1169513631'),
    ('30', '11', '1169513688'),
    ('36', '11', '1169408704'),
    ('85', '2', '1169522494'),
    ('85', '6', '1169669703'),
    ('74', '6', '1169538268'),
    ('84', '6', '1169493725'),
    ('36', '6', '1169435433'),
    ('85', '7', '1169411649'),
    ('71', '7', '1169489822'),
    ('62', '7', '1169412630'),
    ('8', '7', '1169650988'),
    ('84', '14', '1169496581'),
    ('79', '14', '1169497012'),
    ('85', '14', '1169415783'),
    ('8', '6', '1169417396'),
    ('57', '11', '1169418125'),
    ('62', '11', '1169418181'),
    ('8', '11', '1169418220'),
    ('11', '11', '1169418408'),
    ('8', '14', '1169420544'),
    ('44', '3', '1169425888'),
    ('65', '3', '1169425933'),
    ('85', '3', '1169521903'),
    ('8', '3', '1169425963'),
    ('74', '3', '1169425991'),
    ('84', '3', '1169425995'),
    ('8', '2', '1169429974'),
    ('85', '12', '1169434181'),
    ('84', '12', '1169431713'),
    ('85', '17', '1169512466'),
    ('86', '7', '1169659424'),
    ('84', '7', '1169495148'),
    ('36', '7', '1169475597'),
    ('79', '7', '1169650951'),
    ('81', '7', '1169477011'),
    ('76', '7', '1169477034'),
    ('74', '7', '1169477047'),
    ('86', '2', '1169660188'),
    ('74', '18', '1169477777'),
    ('32', '18', '1169477929'),
    ('79', '18', '1169481077'),
    ('30', '7', '1169507681'),
    ('43', '7', '1169489784'),
    ('77', '7', '1169482296'),
    ('64', '7', '1169482358'),
    ('61', '7', '1169482529'),
    ('43', '11', '1169483047'),
    ('77', '11', '1169483080'),
    ('61', '2', '1169486523'),
    ('44', '7', '1169489802'),
    ('62', '2', '1169489837'),
    ('77', '6', '1169493349'),
    ('86', '6', '1169669610'),
    ('86', '11', '1169514204'),
    ('30', '14', '1169497138'),
    ('25', '11', '1169507500'),
    ('87', '2', '1169650293'),
    ('69', '2', '1169508797'),
    ('50', '2', '1169508808'),
    ('87', '3', '1169632336'),
    ('66', '3', '1169508932'),
    ('86', '3', '1169521844'),
    ('77', '3', '1169509000'),
    ('43', '22', '1169510503'),
    ('88', '22', '1169510589'),
    ('88', '2', '1169522337'),
    ('88', '7', '1169510770'),
    ('87', '7', '1169645180'),
    ('74', '17', '1169512667'),
    ('43', '12', '1169513605'),
    ('61', '12', '1169513640'),
    ('82', '12', '1169513657'),
    ('86', '12', '1169513705'),
    ('88', '12', '1169513768'),
    ('74', '12', '1169513795'),
    ('88', '11', '1169514175'),
    ('87', '11', '1169514223'),
    ('89', '12', '1169555650'),
    ('89', '2', '1169522851'),
    ('65', '12', '1169518291'),
    ('89', '14', '1169519053'),
    ('89', '3', '1169521798'),
    ('88', '3', '1169521863'),
    ('88', '6', '1169538242'),
    ('87', '6', '1169538410'),
    ('87', '12', '1169555716'),
    ('60', '7', '1169651192');

Caused the error:

    Unknown column 'logTime' in 'field list'



Clint

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: lunzet on January 25, 2007, 02:07:27 AM
my topics went fine but polls are an issue:

QuoteConverting...
Converting polls... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_polls
    (ID_POLL, SUBSTRING(p.question, 1, 255), votingLocked, ID_MEMBER, expireTime, posterName)
    VALUES ('1', 'Wer soll unser Mage sein', 'no', '4', '0', 'Jo'),
    ('3', 'Bock auf PvP (Warsong/Alterac) mit gleichzeitigem harten Levelcap bei 39', 'no', '4', '157903847585', 'Jo'),
    ('4', 'Wann sollen wir das Level-Cap < 40 aufheben:', 'no', '3', '0', 'TurboPala'),
    ('6', 'Wer soll nächsten Dienstag als Stammgast aufgenommen werden', 'no', '4', '0', 'Jo'),
    ('9', 'Hast du Lust auf ein solches Event und kommst?', 'no', '3', '1153925496', 'TurboPala'),
    ('11', 'Wann gehen wir DM West für Pala Epic', 'no', '3', '0', 'TurboPala'),
    ('15', 'An welchen Teilen des Abendprogramms bin ich dabei? (Mehrfachnennung möglich)', 'no', '4', '0', 'Jo'),
    ('18', 'Ich möchte am Proberun MC am Dienstag teilnehmen', 'no', '4', '0', 'Jo'),
    ('19', 'Ja ich komme zum MC Vorbereitungsrun', 'no', '4', '0', 'Jo'),
    ('20', 'Besteht Interesse an ZG/AQ20', 'no', '8', '0', 'Doikatei'),
    ('21', 'Ich will eine PArtnerschaft mit den MM\'s und mag sie auch zum Braukeller als Gäste zulassen', 'no', '4', '0', 'Jo'),
    ('22', 'Ich kann an EINEM der folgenden Tage eher regelmässig an unserem gemeinsamen 20er Run mit den BM+MM teilnehmen', 'no', '4', '0', 'Jo'),
    ('23', 'Wie geht es mit der Gildenleitung/Wirten weiter', 'no', '4', '0', 'Jo'),
    ('24', 'Wer ist heute Abend mit dabei?', 'no', '39', '0', 'Uerige'),
    ('25', 'Di. 26.09. TS Brewmasters', 'no', '8', '0', 'Doikatei'),
    ('26', 'Wer hat welche Quest', 'no', '21', '0', 'Thorald'),
    ('27', 'Was haltet ihr von den Ideen?', 'no', '66', '1162773759', 'Edhilchîr'),
    ('28', 'Was haltet ihr davon', 'no', '66', '0', 'Edhilchîr'),
    ('29', 'Was möchtet Ihr am Dienstag machen', 'no', '21', '1162309899', 'Thorald'),
    ('30', 'Teilnahme am Gildenevent', 'no', '21', '1163546023', 'Thorald'),
    ('31', 'PVP Stammgruppe', 'no', '21', '1165755754', 'Thorald'),
    ('32', 'PVP Gildenevent', 'no', '21', '1164319342', 'Thorald'),
    ('33', 'Ich finde folgende Raidinhalte klasse und würd die gerne mal intern spielen', 'no', '4', '1164988174', 'Jo'),
    ('34', 'Wo soll das Glühweintrinken stattfinden', 'no', '8', '0', 'Doikatei'),
    ('35', 'Den Teamspeak Server Status im Forum (oben) finde ich...', 'no', '3', '1166729563', 'TurboPala'),
    ('36', 'Zum Glühweintrinken kann ich', 'no', '3', '1167058157', 'TurboPala'),
    ('37', 'Besteht Interesse an dem Angebot?', 'no', '37', '0', 'Mannipoc'),
    ('38', 'PVP-Interesse', 'no', '6', '1166022644', 'Dariel'),
    ('39', 'Welche Instanzen sollen wir bis zur ersten BC Raidinstanz wie spielen ?', 'no', '4', '0', 'Jo'),
    ('40', 'Gildentag, Donnerstags', 'no', '21', '0', 'Thorald');

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 'SUBSTRING(p.question, 1, 255), votingLocked, ID_MEMBER, expireT

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on January 25, 2007, 09:50:11 AM
Ok updated the converter.  It now converts attachments as well.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: lunzet on January 25, 2007, 11:11:11 AM
Thanks for all your support. We are getting closer and closer.

next error:
Converting...
Converting topic notifications... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_log_notify
    (ID_MEMBER, ID_TOPIC)
    VALUES ('3', '7'),
    ('3', '8'),
    ('3', '9'),
    ('3', '10'),
    ('3', '11'),
    ('3', '12'),
    ('3', '14'),
    ('4', '14'),
    ('8', '413'),
    ('3', '27'),
    ('3', '28'),
    ('11', '387'),
    ('3', '29'),
    ('3', '32'),
    ('3', '34'),
    ('3', '37'),
    ('3', '40'),
    ('3', '42'),
    ('3', '43'),
    ('3', '44'),
    ('3', '45'),
    ('4', '47'),
    ('3', '47'),
    ('8', '542'),
    ('4', '126'),
    ('3', '51'),
    ('3', '52'),
    ('4', '53'),
    ('4', '54'),
    ('4', '55'),
    ('3', '56'),
    ('3', '58'),
    ('4', '58'),
    ('4', '62'),
    ('3', '62'),
    ('8', '62'),
    ('8', '64'),
    ('3', '65'),
    ('4', '69'),
    ('3', '69'),
    ('8', '69'),
    ('3', '70'),
    ('4', '74'),
    ('4', '76'),
    ('8', '77'),
    ('8', '78'),
    ('9', '122'),
    ('3', '84'),
    ('4', '85'),
    ('3', '86'),
    ('4', '86'),
    ('3', '88'),
    ('3', '89'),
    ('4', '88'),
    ('4', '90'),
    ('9', '69'),
    ('4', '91'),
    ('9', '93'),
    ('3', '91'),
    ('3', '90'),
    ('3', '96'),
    ('7', '90'),
    ('11', '90'),
    ('11', '96'),
    ('9', '90'),
    ('4', '96'),
    ('9', '96'),
    ('3', '99'),
    ('4', '99'),
    ('8', '98'),
    ('4', '98'),
    ('7', '98'),
    ('7', '96'),
    ('7', '99'),
    ('11', '98'),
    ('8', '122'),
    ('8', '96'),
    ('8', '101'),
    ('11', '122'),
    ('3', '101'),
    ('11', '99'),
    ('4', '104'),
    ('7', '104'),
    ('4', '106'),
    ('9', '106'),
    ('8', '108'),
    ('3', '108'),
    ('4', '108'),
    ('8', '110'),
    ('4', '110'),
    ('4', '112'),
    ('3', '110'),
    ('8', '112'),
    ('3', '118'),
    ('4', '119'),
    ('4', '120'),
    ('9', '121'),
    ('3', '121'),
    ('4', '121'),
    ('3', '112'),
    ('4', '122'),
    ('4', '128'),
    ('3', '129'),
    ('7', '319'),
    ('4', '131'),
    ('7', '131'),
    ('4', '133'),
    ('3', '133'),
    ('3', '135'),
    ('3', '137'),
    ('3', '138'),
    ('9', '138'),
    ('7', '138'),
    ('4', '144'),
    ('8', '128'),
    ('7', '128'),
    ('4', '140'),
    ('8', '141'),
    ('10', '141'),
    ('10', '128'),
    ('4', '141'),
    ('4', '142'),
    ('3', '144'),
    ('4', '146'),
    ('4', '147'),
    ('3', '176'),
    ('8', '146'),
    ('3', '149'),
    ('11', '131'),
    ('8', '155'),
    ('3', '155'),
    ('9', '155'),
    ('11', '392'),
    ('11', '391'),
    ('4', '160'),
    ('4', '161'),
    ('4', '162'),
    ('11', '161'),
    ('8', '162'),
    ('3', '162'),
    ('3', '179'),
    ('9', '161'),
    ('8', '160'),
    ('3', '177'),
    ('4', '163'),
    ('7', '156'),
    ('7', '164'),
    ('4', '164'),
    ('11', '164'),
    ('11', '163'),
    ('11', '162'),
    ('7', '122'),
    ('8', '161'),
    ('3', '161'),
    ('3', '164'),
    ('3', '165'),
    ('3', '166'),
    ('4', '171'),
    ('7', '165'),
    ('8', '172'),
    ('3', '172'),
    ('8', '165'),
    ('4', '179'),
    ('4', '170'),
    ('4', '169'),
    ('4', '177'),
    ('11', '170'),
    ('4', '181'),
    ('8', '179'),
    ('8', '181'),
    ('4', '182'),
    ('3', '182'),
    ('4', '183'),
    ('4', '184'),
    ('11', '184'),
    ('7', '182'),
    ('8', '212'),
    ('8', '189'),
    ('4', '188'),
    ('8', '182'),
    ('7', '212'),
    ('7', '210'),
    ('8', '210'),
    ('8', '65'),
    ('3', '191'),
    ('8', '191'),
    ('7', '191'),
    ('4', '191'),
    ('4', '192'),
    ('3', '192'),
    ('7', '193'),
    ('4', '193'),
    ('4', '189'),
    ('11', '193'),
    ('8', '193'),
    ('4', '198'),
    ('4', '199'),
    ('4', '200'),
    ('4', '202'),
    ('4', '203'),
    ('8', '203'),
    ('3', '333'),
    ('4', '208'),
    ('11', '160'),
    ('3', '160'),
    ('7', '160'),
    ('11', '210'),
    ('4', '210'),
    ('4', '27'),
    ('11', '214'),
    ('4', '214'),
    ('7', '214'),
    ('7', '112'),
    ('8', '215'),
    ('4', '215'),
    ('3', '215'),
    ('7', '215'),
    ('7', '192'),
    ('4', '217'),
    ('8', '192'),
    ('8', '217'),
    ('3', '593'),
    ('8', '184'),
    ('11', '217'),
    ('3', '217'),
    ('7', '217'),
    ('7', '141'),
    ('3', '141'),
    ('11', '202'),
    ('11', '219'),
    ('3', '219'),
    ('7', '299'),
    ('7', '222'),
    ('11', '390'),
    ('8', '222'),
    ('4', '222'),
    ('11', '223'),
    ('8', '223'),
    ('8', '224'),
    ('8', '225'),
    ('11', '224'),
    ('3', '202'),
    ('8', '202'),
    ('3', '227'),
    ('8', '228'),
    ('8', '229'),
    ('4', '228'),
    ('4', '229'),
    ('8', '231'),
    ('7', '231'),
    ('11', '228'),
    ('4', '231'),
    ('8', '233'),
    ('8', '144'),
    ('8', '235'),
    ('4', '235'),
    ('8', '236'),
    ('3', '235'),
    ('11', '235'),
    ('4', '237'),
    ('3', '238'),
    ('11', '239'),
    ('4', '240'),
    ('8', '237'),
    ('11', '479'),
    ('3', '471'),
    ('4', '243'),
    ('8', '243'),
    ('11', '243'),
    ('4', '244'),
    ('11', '244'),
    ('8', '244'),
    ('3', '244'),
    ('3', '243'),
    ('7', '243'),
    ('8', '245'),
    ('3', '245'),
    ('4', '246'),
    ('7', '244'),
    ('7', '221'),
    ('7', '228'),
    ('4', '221'),
    ('11', '221'),
    ('11', '251'),
    ('7', '251'),
    ('8', '250'),
    ('8', '221'),
    ('8', '252'),
    ('7', '250'),
    ('8', '253'),
    ('11', '250'),
    ('8', '286'),
    ('3', '252'),
    ('8', '723'),
    ('8', '262'),
    ('3', '263'),
    ('8', '263'),
    ('7', '263'),
    ('11', '264'),
    ('11', '266'),
    ('11', '389'),
    ('8', '270'),
    ('7', '266'),
    ('11', '270'),
    ('7', '270'),
    ('11', '260'),
    ('8', '277'),
    ('3', '489'),
    ('11', '288'),
    ('8', '288'),
    ('8', '291'),
    ('8', '292'),
    ('8', '295'),
    ('7', '294'),
    ('3', '322'),
    ('7', '297'),
    ('8', '297'),
    ('3', '299'),
    ('8', '299'),
    ('3', '292'),
    ('10', '299'),
    ('11', '304'),
    ('8', '304'),
    ('8', '305'),
    ('3', '306'),
    ('8', '310'),
    ('11', '310'),
    ('3', '310'),
    ('3', '315'),
    ('8', '317'),
    ('7', '318'),
    ('7', '310'),
    ('8', '318'),
    ('3', '318'),
    ('3', '320'),
    ('8', '319'),
    ('11', '319'),
    ('7', '320'),
    ('9', '319'),
    ('11', '377'),
    ('8', '322'),
    ('9', '323'),
    ('3', '324'),
    ('8', '324'),
    ('11', '324'),
    ('3', '319'),
    ('8', '331'),
    ('8', '335'),
    ('8', '336'),
    ('11', '338'),
    ('8', '338'),
    ('8', '339'),
    ('8', '340'),
    ('11', '340'),
    ('11', '342'),
    ('8', '341'),
    ('8', '345'),
    ('8', '346'),
    ('8', '353'),
    ('11', '346'),
    ('11', '350'),
    ('31', '351'),
    ('3', '337'),
    ('11', '353'),
    ('8', '343'),
    ('3', '351'),
    ('8', '355'),
    ('8', '351'),
    ('8', '357'),
    ('3', '358'),
    ('3', '358'),
    ('3', '348'),
    ('8', '348'),
    ('11', '361'),
    ('8', '361'),
    ('3', '361'),
    ('8', '362'),
    ('7', '361'),
    ('8', '364'),
    ('11', '357'),
    ('9', '382'),
    ('3', '364'),
    ('3', '366'),
    ('8', '368'),
    ('7', '367'),
    ('3', '367'),
    ('11', '369'),
    ('8', '370'),
    ('8', '369'),
    ('8', '371'),
    ('3', '371'),
    ('8', '376'),
    ('8', '377'),
    ('8', '380'),
    ('3', '377'),
    ('7', '377'),
    ('8', '385'),
    ('8', '387'),
    ('7', '387'),
    ('3', '388'),
    ('3', '387'),
    ('11', '393'),
    ('11', '394'),
    ('11', '395'),
    ('8', '396'),
    ('8', '397'),
    ('8', '400'),
    ('11', '401'),
    ('8', '401'),
    ('8', '404'),
    ('8', '405'),
    ('11', '405'),
    ('3', '404'),
    ('8', '407'),
    ('8', '366'),
    ('8', '412'),
    ('3', '412'),
    ('3', '414'),
    ('8', '414'),
    ('11', '415'),
    ('3', '415'),
    ('8', '415'),
    ('10', '415'),
    ('10', '366'),
    ('10', '407'),
    ('3', '417'),
    ('7', '417'),
    ('8', '418'),
    ('3', '419'),
    ('7', '420'),
    ('8', '420'),
    ('8', '421'),
    ('3', '420'),
    ('11', '420'),
    ('8', '422'),
    ('3', '428'),
    ('8', '427'),
    ('3', '431'),
    ('7', '431'),
    ('7', '432'),
    ('3', '433'),
    ('8', '432'),
    ('3', '434'),
    ('3', '436'),
    ('7', '437'),
    ('8', '436'),
    ('8', '443'),
    ('8', '444'),
    ('3', '445'),
    ('7', '447'),
    ('3', '447'),
    ('8', '445'),
    ('8', '447'),
    ('8', '446'),
    ('3', '448'),
    ('8', '448'),
    ('7', '366'),
    ('11', '366'),
    ('10', '447'),
    ('10', '434'),
    ('3', '449'),
    ('11', '331'),
    ('8', '449'),
    ('11', '449'),
    ('7', '331'),
    ('7', '450'),
    ('10', '449'),
    ('3', '451'),
    ('3', '453'),
    ('8', '454'),
    ('10', '454'),
    ('8', '459'),
    ('3', '459'),
    ('11', '461'),
    ('8', '462'),
    ('8', '463'),
    ('8', '461'),
    ('8', '464'),
    ('8', '465'),
    ('11', '465'),
    ('8', '466'),
    ('3', '304'),
    ('3', '461'),
    ('3', '331'),
    ('3', '465'),
    ('11', '508'),
    ('10', '465'),
    ('9', '470'),
    ('11', '485'),
    ('3', '470'),
    ('8', '481'),
    ('8', '484'),
    ('3', '479'),
    ('8', '477'),
    ('8', '479'),
    ('3', '484'),
    ('39', '182'),
    ('39', '477'),
    ('11', '455'),
    ('8', '485');

Caused the error:

    Duplicate entry '3-7-0' for key 1
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on January 25, 2007, 11:34:31 AM
Updated it.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: lunzet on January 26, 2007, 04:01:59 AM
Thanks...unfortunately next error.

Converting...
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... Successful.
Converting attachments...
Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17

Parse error: parse error in /data/www/htdocs/smf/convert.php(829) : eval()'d code on line 17
Unsuccessful!
This query:

    INSERT IGNORE INTO `smf`.smf_attachments
    (ID_MSG, downloads, filename, filesize, attachname)
    VALUES ('270', '6', 'gildensucheV10900_mit.zip', '25502', 'post_4_1141044239.attach'),
    ('524', '19', 'nacktbaden.jpg', '310867', 'post_4_1143993345.attach'),
    ('524', '21', 'zeppi.jpg', '250920', 'post_4_1143993541.attach'),
    ('566', '15', 'oliaufgreif.jpg', '13428', 'post_13_1144425297.attach'),
    ('667', '5', 'tabelle.htm', '5481', 'post_3_1144957243.attach'),
    ('678', '2', 'mod_table_tag1.2.zip', '5101', 'post_4_1145016270.attach'),
    ('682', '0', 'CT_RaidTracker_v125.10_modded.zip', '45459', 'post_4_1145026667.attach'),
    ('682', '0', 'EQdkp_CTRaidTracker_Import_v111.zip', '15946', 'post_4_1145026688.attach'),
    ('697', '7', 'iview398(1).zip', '899626', 'post_4_1145227093.attach'),
    ('699', '73', 'Jo_if.jpg', '242966', 'post_4_1145229778.attach'),
    ('698', '72', 'WoWScrnShot_041706_001644.jpg', '262795', 'post_15_1145229605.attach'),
    ('701', '37', 'WoWScrnShot_032906_190242.jpg', '112842', 'post_15_1145279585.attach'),
    ('701', '39', 'WoWScrnShot_032906_230157.jpg', '148098', 'post_15_1145279684.attach'),
    ('721', '21', 'WoWScrnShot_041806_222951.jpg', '38649', 'post_13_1145397466.attach'),
    ('881', '15', 'wow error Kopie.jpg', '249134', 'post_8_1146081950.attach'),
    ('920', '36', 'WoWScrnShot_042606_032042.jpg', '57083', 'post_15_1146135580.attach'),
    ('921', '37', 'WoWScrnShot_042406_212842.jpg', '104752', 'post_15_1146135684.attach'),
    ('922', '35', 'WoWScrnShot_042406_202911.jpg', '137141', 'post_15_1146135789.attach'),
    ('923', '37', 'WoWScrnShot_042306_020918.jpg', '145159', 'post_15_1146135941.attach'),
    ('924', '27', 'WoWScrnShot_041806_223022.jpg', '196605', 'post_15_1146135998.attach'),
    ('928', '45', 'ein bisschen versaut.jpg', '20099', 'post_13_1146136493.attach'),
    ('928', '47', 'oliduschweinxD.jpg', '9883', 'post_13_1146136567.attach'),
    ('928', '41', 'hyal2.jpg', '562029', 'post_13_1146136656.attach'),
    ('930', '30', 'einstolzerjägermitseinerbeute.jpg', '405907', 'post_13_1146136824.attach'),
    ('929', '39', 'difficulty15bx9iw.jpg', '516458', 'post_8_1146136898.attach'),
    ('930', '36', 'hordepartyinalterac.jpg', '579306', 'post_13_1146136935.attach'),
    ('930', '35', 'gelabere in tanaris.jpg', '600772', 'post_13_1146137070.attach'),
    ('931', '22', 'ausicht.jpg', '179577', 'post_4_1146137180.attach'),
    ('931', '24', 'garderobenkontrolle.jpg', '120938', 'post_4_1146137198.attach'),
    ('931', '19', 'tempel.jpg', '79817', 'post_4_1146137217.attach'),
    ('931', '19', 'alte_eier.jpg', '261692', 'post_4_1146137229.attach'),
    ('931', '22', 'Isa&Freund.jpg', '173678', 'post_4_1146137244.attach'),
    ('933', '18', 'rally1.jpg', '171826', 'post_4_1146137646.attach'),
    ('933', '19', 'rally2.jpg', '154825', 'post_4_1146137656.attach'),
    ('933', '17', 'rally3.jpg', '280439', 'post_4_1146137666.attach'),
    ('934', '42', 'pervers.jpg', '505511', 'post_13_1146137675.attach'),
    ('937', '22', 'gn8.jpg', '114020', 'post_13_1146137854.attach'),
    ('937', '30', 'uldaman.jpg', '370227', 'post_13_1146137921.attach'),
    ('965', '12', 'olli.jpg', '2300', 'post_3_1146236056.attach'),
    ('965', '9', 'ingo.jpg', '2192', 'post_3_1146236157.attach'),
    ('1011', '11', 'Geschafft.jpg', '616750', 'post_11_1146660386.attach'),
    ('1139', '9', 'addon.jpg', '331076', 'post_8_1147419271.attach'),
    ('1152', '16', 'WoWScrnShot_051306_204442.jpg', '263597', 'post_15_1147549231.attach'),
    ('1155', '10', 'PHOT0008.JPG', '77242', 'post_13_1147618287.attach'),
    ('1188', '12', 'oli.jpg', '312445', 'post_15_1147763077.attach'),
    ('1257', '19', 'Lilok_Mount.jpg', '118242', 'post_16_1148134779.attach'),
    ('1259', '14', 'unsichtbarerknoten.jpg', '11306', 'post_13_1148149477.attach'),
    ('1259', '12', 'mamaskelettundbabyskelett.jpg', '222952', 'post_13_1148149542.attach'),
    ('1259', '14', 'aQwithjuLe.jpg', '576775', 'post_13_1148149617.attach'),
    ('1261', '12', 'teufelssaurier.jpg', '459509', 'post_13_1148150050.attach'),
    ('1261', '15', 'bärenblokade.jpg', '89475', 'post_13_1148150126.attach'),
    ('1289', '11', 'acc_elektro.jpg', '117427', 'post_8_1148366112.attach'),
    ('1327', '14', 'WoWScrnShot_042706_171518.jpg', '140692', 'post_8_1148459352.attach'),
    ('1328', '18', 'WoWScrnShot_042806_215214.jpg', '114433', 'post_8_1148459471.attach'),
    ('1329', '12', 'WoWScrnShot_050306_223636.jpg', '280756', 'post_8_1148459578.attach'),
    ('1330', '29', 'WoWScrnShot_052406_152302.jpg', '127226', 'post_8_1148459655.attach'),
    ('1331', '13', 'Robe.jpg', '97853', 'post_15_1148461510.attach'),
    ('1356', '11', 'handschuhe.jpg', '290828', 'post_15_1148913037.attach'),
    ('1490', '11', 'oliisa.jpg', '105272', 'post_15_1149683701.attach'),
    ('1498', '3', 'dm.jpg', '146220', 'post_6_1149698086.attach'),
    ('1599', '16', 'zugangmc.jpg', '150190', 'post_15_1150704358.attach'),
    ('1599', '14', 'kloster.jpg', '137115', 'post_15_1150704414.attach'),
    ('1599', '14', 'mm brd.jpg', '101015', 'post_15_1150704889.attach'),
    ('1600', '22', 'mana.jpg', '281474', 'post_15_1150704984.attach'),
    ('1601', '20', 'aq20.jpg', '229159', 'post_15_1150705038.attach'),
    ('1616', '1', 'olirosen.jpg', '124672', 'post_15_1150847487.attach'),
    ('1617', '19', 'ubrs.jpg', '125579', 'post_15_1150847559.attach'),
    ('1727', '77', 'garten001[1].jpg', '12729', 'post_31_1151658575.attach'),
    ('1738', '7', 'amylee.jpg', '177270', 'post_15_1151846382.attach'),
    ('1804', '11', 'Bild1.jpg', '34104', 'post_15_1152245705.attach'),
    ('1804', '11', 'Bild2.jpg', '44888', 'post_15_1152245771.attach'),
    ('1804', '11', 'Bild3.jpg', '52208', 'post_15_1152245830.attach'),
    ('1805', '10', 'Yulina_Schurkenset.jpg', '263445', 'post_11_1152287856.attach'),
    ('1871', '15', 'gemischt064[1].jpg', '18142', 'post_31_1152704349.attach'),
    ('1871', '13', 'meinestutetara[2].jpg', '27948', 'post_31_1152704464.attach'),
    ('1873', '69', 'einkleinerausritt[1].jpg', '11286', 'post_31_1152704982.attach'),
    ('1992', '12', 'WoWScrnShot_072006_201159.jpg', '311425', 'post_8_1153333178.attach'),
    ('1999', '12', 'w2.JPG', '216689', 'post_6_1153394012.attach'),
    ('1999', '13', 'w3.JPG', '216768', 'post_6_1153394025.attach'),
    ('2000', '15', 'olipc.jpg', '245677', 'post_15_1153397114.attach'),
    ('2003', '16', 'MOV00005.3gp', '93901', 'post_6_1153408522.attach'),
    ('2003', '7', 'MOV00006.3gp', '128907', 'post_6_1153408533.attach'),
    ('2068', '9', 'ragi.jpg', '393111', 'post_8_1153583927.attach'),
    ('2068', '7', 'ragi_2.jpg', '309971', 'post_8_1153584023.attach'),
    ('2257', '5', 'ony1.jpg', '241463', 'post_8_1154532276.attach'),
    ('2636', '19', 'Angeln.jpg', '89159', 'post_37_1156024452.attach'),
    ('2333', '105', 'tanja_056_800x600.jpg', '188704', 'post_33_1155033654.attach'),
    ('2333', '51', 'tanja_061_800x1067.jpg', '103948', 'post_33_1155034003.attach'),
    ('2360', '14', 'säbler.jpg', '159559', 'post_15_1155127747.attach'),
    ('2403', '15', 'cooler würstchengriller.jpg', '159704', 'post_15_1155299625.attach'),
    ('2578', '14', 'WoWScrnShot_081406_225252.jpg', '122777', 'post_37_1155645718.attach'),
    ('2636', '19', 'Support.jpg', '86721', 'post_37_1156024472.attach'),
    ('2678', '13', 'WoWScrnShot_082206_000840.jpg', '217163', 'post_37_1156202117.attach'),
    ('3175', '9', 'wipe.jpg', '414857', 'post_8_1157657017.attach'),
    ('3175', '6', 'razel.jpg', '448259', 'post_8_1157657048.attach'),
    ('3175', '11', 'drache.jpg', '441599', 'post_8_1157657092.attach'),
    ('3240', '3', 'stischisa.jpg', '236981', 'post_15_1158126855.attach'),
    ('3276', '28', 'IMG_0288.jpg', '497380', 'post_37_1158578719.attach'),
    ('3294', '10', 'IMG_2109.JPG', '698390', 'post_6_1158606844.attach'),
    ('3280', '8', 'Wein.JPG', '75565', 'post_37_1158579871.attach'),
    ('3294', '8', 'IMG_3951.JPG', '193244', 'post_6_1158607438.attach'),
    ('3294', '7', 'IMG_4004.JPG', '257016', 'post_6_1158607555.attach'),
    ('3294', '8', 'IMG_4039.JPG', '161912', 'post_6_1158607609.attach'),
    ('3294', '7', 'IMG_4116.JPG', '139309', 'post_6_1158607619.attach'),
    ('3465', '12', 'ony20.jpg', '309441', 'post_8_1159814422.attach'),
    ('3465', '12', 'down_ony20.jpg', '215291', 'post_8_1159814458.attach'),
    ('3638', '1', 'images1.jpg', '3115', 'post_33_1161625188.attach'),
    ('3639', '0', 'images1.jpg', '3115', 'post_33_1161625365.attach'),
    ('3891', '11', 'siegeldeslichts.jpg', '18846', 'post_3_1162995068.attach'),
    ('3891', '13', 'tabelle_siegeldeslichts.jpg', '47152', 'post_3_1162995587.attach'),
    ('3968', '59', 'tanja 0091.jpg', '607260', 'post_21_1163166106.attach'),
    ('3992', '12', 'hyjal4.jpg', '337169', 'post_21_1163295441.attach'),
    ('3992', '12', 'hyjal6.jpg', '247584', 'post_21_1163295479.attach'),
    ('3992', '14', 'hyjal2.jpg', '191635', 'post_21_1163295580.attach'),
    ('4009', '2', 'palamathe_sdw.jpg', '96051', 'post_3_1163422339.attach'),
    ('4259', '2', 'bier_logos.zip', '157874', 'post_80_1164108608.attach'),
    ('4258', '1', 'downloader.jpg', '65379', 'post_3_1164111117.attach'),
    ('4363', '7', 'Gesperrte_Benutzer.jpg', '53814', 'post_3_1164275112.attach'),
    ('4366', '1', 'patch_201_teil2.jpg', '65547', 'post_3_1164276003.attach'),
    ('4412', '12', '002 049.jpg', '223716', 'post_90_1164361899.attach'),
    ('4412', '16', '002 057.jpg', '205479', 'post_90_1164362064.attach'),
    ('4443', '17', 'teamspeak_users.xls', '24576', 'post_3_1164385368.attach'),
    ('4485', '11', 'car.jpg', '176271', 'post_74_1164499549.attach'),
    ('4485', '17', 'hund.jpg', '27352', 'post_74_1164499562.attach'),
    ('4485', '32', 'workplace.jpg', '156800', 'post_74_1164499575.attach'),
    ('4485', '28', 'ich.jpg', '22857', 'post_74_1164500066.attach'),
    ('4539', '2', 'patch_201_teil2.jpg', '65547', 'post_3_1164707093.attach'),
    ('4539', '7', 'patchfiles.jpg', '9201', 'post_3_1164707237.attach'),
    ('4546', '0', '3.gif', '13437', 'post_21_1164734496.attach'),
    ('4546', '0', 'Barenbrau_r_1_n.jpg', '15525', 'post_21_1164734508.attach'),
    ('4546', '0', 'Bierborse_2006_n.jpg', '44675', 'post_21_1164734541.attach'),
    ('4546', '2', 'Eisgrub_1_Getranke_hellblauerRand_n.jpg', '43262', 'post_21_1164734556.attach'),
    ('4546', '18', 'intro3a.gif', '8277', 'post_21_1164734575.attach'),
    ('4547', '0', 'krbemblem.png', '23318', 'post_21_1164734628.attach'),
    ('4547', '0', 'MAB_r_Biersteuer_hinten_n.jpg', '38875', 'post_21_1164734643.attach'),
    ('4547', '17', 'MAB_r_Biersteuer_vorne_t.jpg', '3848', 'post_21_1164734657.attach'),
    ('4761', '2', 'PallyPower-2-0-23.zip', '148182', 'post_7_1165571857.attach'),
    ('4764', '1', '47-21134-pallypower-2-0-26.zip', '148205', 'post_7_1165574962.attach'),
    ('4783', '2', '47-21241-pallypower-2-00-30-1.zip', '148626', 'post_3_1165605385.attach'),
    ('4784', '44', 'PhotekUIX6Normal.jpg', '216219', 'post_74_1165610186.attach'),
    ('4795', '3', 'HealBot_v2.0b22_20061208.zip', '133134', 'post_3_1165656503.attach'),
    ('4798', '31', 'interface.jpg', '140899', 'post_37_1165669633.attach'),
    ('4801', '1', '47-21441-pallypower-2-00-32.zip', '148901', 'post_3_1165677231.attach'),
    ('4878', '28', 'WoWScrnShot_121906_070455.jpg', '422636', 'post_8_1166423090.attach'),
    ('4948', '15', 'new_laptop.jpg', '261398', 'post_3_1166549742.attach'),
    ('5005', '7', '23-16363-SmartBuff_SmartDebuff01.png', '119151', 'post_3_1166726986.attach'),
    ('5006', '2', 'healbot.png', '51448', 'post_3_1166728389.attach'),
    ('5045', '16', 'IMG_5012.JPG', '741172', 'post_6_1167126228.attach'),
    ('5089', '17', 'BM_Forum_Benutzergruppen.xls', '84480', 'post_3_1167387469.attach'),
    ('5093', '2', 'eqdkpraid.zip', '5280', 'post_4_1167401043.attach'),
    ('5094', '1', 'dkp.zip', '230', 'post_4_1167403800.attach'),
    ('5124', '6', 'Mappe1.xls', '14336', 'post_6_1167573329.attach'),
    ('5152', '11', 'WoWScrnShot_122806_235016.jpg', '280787', 'post_37_1167748186.attach'),
    ('5169', '6', 'eqdkpraid.xls', '29184', 'post_6_1167776171.attach'),
    ('5234', '1', '350 - eventsonindex.zip', '3073', 'post_4_1168173881.attach'),
    ('5355', '2', 'eqdkpraid.xls', '45056', 'post_6_1168552432.attach'),
    ('5383', '0', 'settings.zip', '837', 'post_3_1168636427.attach'),
    ('5385', '2', 'UniUploader_v2.5.0_Installer.exe', '255638', 'post_3_1168639810.attach'),
    ('5398', '54', 'MWSnap001.jpg', '907', 'post_3_1168704781.attach'),
    ('5398', '4', 'MWSnap008.jpg', '49687', 'post_3_1168704792.attach'),
    ('5398', '4', 'MWSnap010.jpg', '66313', 'post_3_1168704856.attach'),
    ('5398', '3', 'MWSnap011.jpg', '62548', 'post_3_1168704863.attach'),
    ('5398', '2', 'BM_UniUploader_v2.5.0_Installer.exe', '255638', 'post_3_1168705215.attach'),
    ('5398', '50', 'MWSnap009.jpg', '2074', 'post_3_1168705813.attach'),
    ('5406', '3', 'CT_RaidAssist - Update 12.zip', '145173', 'post_8_1168730697.attach'),
    ('5409', '16', 'MWSnap011.jpg', '62548', 'post_3_1168768969.attach'),
    ('5409', '14', 'MWSnap119.jpg', '33444', 'post_3_1168769235.attach'),
    ('5409', '10', 'BM_UniUploader_v2.5.0_Installer.exe', '255638', 'post_3_1168769402.attach'),
    ('5422', '17', 'Anleitung Gildenroster Characterprofiler Signatur 1.0.doc', '734208', 'post_3_1168783861.attach'),
    ('5458', '12', 'mitternachtsverkauf_Koeln.jpg', '63293', 'post_3_1168878778.attach'),
    ('5471', '5', 'IMAGE_006.jpg', '187238', 'post_78_1168940068.attach'),
    ('5502', '11', 'Roster.png', '274096', 'post_37_1168992111.attach'),
    ('5502', '11', 'Forum.png', '273486', 'post_37_1168992194.attach'),
    ('5468', '9', 'Anleitung Uniloader addons.doc', '150016', 'post_3_1169129350.attach'),
    ('5543', '3', 'MWSnap0019.jpg', '28682', 'post_3_1169252486.attach'),
    ('5577', '5', 'TS_userliste.pdf', '52838', 'post_3_1169504562.attach'),
    ('5595', '6', 'TS-Regs.xls', '18944', 'post_4_1169551657.attach');

Caused the error:

    Unknown column 'filesize' in 'field list'
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on January 26, 2007, 09:20:29 AM
Weird.  It's missing a few columns from the insert.  It should have the width and height column.  I'm going to reupload the file again.  Get it from the first post.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: lunzet on January 26, 2007, 10:02:26 AM
still the same error
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on January 26, 2007, 12:04:36 PM
Can you please give me FTP info so that I can debug the error?

Ok I found the parse error.  I reuploaded the attachment in first post.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: alexro on February 01, 2007, 01:23:49 PM
Hello,

trying to convert from MyBB 1.2.2 to SMF 1.1.1 I get the following error:

Converting attachments... Unsuccessful!
This query:

    INSERT IGNORE INTO `cutrrnet_smf1`.smf_attachments
    (ID_ATTACH, size, filename, ID_MSG, downloads, width, height)
    VALUES (1, 187469, 'INFOFH476.jpg', 2129, 2, 944, 1105),
    (2, 76726, 'INFOFH476.zoom.jpg', 2129, 1, 734, 827),
    (3, 37881, '1505.gif', 2179, 2, 505, 496),
    (4, 5190, '28.gif', 2214, 9, 64, 64),
    (5, 147902, 'harta1.jpg', 2226, 37, 800, 600),
    (6, 109246, 'case2.gif', 2374, 25, 440, 1017),
    (7, 71571, 'case1.gif', 2374, 27, 464, 1009),
    (8, 86312, 'IMG0003.jpg', 2239, 35, 512, 768),
    (9, 305853, '1.jpg', 2239, 24, 1273, 899),
    (10, 89388, 'IMG0011.jpg', 2240, 23, 512, 768),
    (11, 42475, 'Continental.jpg', 2240, 26, 300, 272),
    (12, 25671, 'img_18497.jpg', 2241, 18, 250, 250),
    (13, 82733, 'IMG0052.jpg', 2241, 23, 512, 768),
    (14, 83335, 'modernisme architecture 014.jpg', 2242, 18, 768, 1024),
    (15, 224507, 'modernisme architecture 011.jpg', 2242, 19, 1024, 768),
    (16, 107109, 'cutremur40a.jpg', 2243, 19, 556, 360),
    (17, 77187, 'biserica.jpg', 2244, 30, 482, 476),
    (18, 9266, 'Untitled-4%7E157.jpg', 2244, 29, 267, 200),
    (19, 48392, 'Bucuresti1941.jpg', 2245, 42, 594, 396),
    (20, 32011, '11.jpg', 2245, 29, 400, 338),
    (21, 5263, 'Untitled-5%7E138.jpg', 2246, 23, 147, 200),
    (22, 34971, '59371959806_0_ALB.jpg', 2246, 28, 448, 343),
    (23, 52976, '3300-80.jpg', 2247, 34, 436, 276),
    (24, 94503, 'argeles aout 2004 179.jpg', 2247, 24, 1024, 768),
    (25, 28220, 'ADO-BUC-BUL-BRATIANU1937.jpg', 2249, 23, 353, 222),
    (26, 33585, '08.jpg', 2249, 26, 400, 335),
    (27, 272032, '6.jpg', 2250, 31, 1273, 899),
    (28, 78467, 'argeles aout 2004 170.jpg', 2250, 35, 1024, 768),
    (29, 81788, 'IMG0030.jpg', 2252, 22, 512, 768),
    (30, 63817, 'Bloc1977.jpg', 2252, 27, 465, 322),
    (31, 61149, 'bratianu.jpg', 2254, 16, 754, 491),
    (32, 68371, 'IMG0045.jpg', 2257, 19, 512, 768),
    (33, 57817, 'IMG0046.jpg', 2257, 18, 512, 768),
    (34, 65083, 'IMG0006.jpg', 2258, 14, 512, 768),
    (35, 48687, 'IMG0005.jpg', 2258, 16, 512, 768),
    (36, 96979, 'IMG0053.jpg', 2259, 19, 512, 768),
    (37, 73037, 'IMG0009.jpg', 2259, 17, 512, 768),
    (38, 35754, 'Untitled-1%7E965.jpg', 2260, 21, 350, 546),
    (39, 28218, 'new-6.jpg', 2260, 24, 350, 417),
    (40, 31400, '14.jpg', 2261, 16, 400, 338),
    (41, 317999, '9[1]....JPG', 2261, 18, 1273, 899),
    (42, 62980, '4 mars 008.jpg', 2262, 21, 640, 480),
    (43, 61480, '4 mars 006.jpg', 2262, 19, 640, 480),
    (44, 78275, 'argeles aout 2004 171.jpg', 2263, 26, 1024, 768),
    (45, 166002, 'bucuresti 023.jpg', 2263, 27, 1024, 768),
    (46, 146105, 'harta_tectonica.gif', 2329, 5, 800, 400),
    (47, 161174, 'Paci_tectonice.jpg', 2329, 5, 799, 545),
    (48, 70584, 'case3.gif', 2374, 17, 464, 1009),
    (49, 157630, 'INFOGZ461.jpg', 2383, 3, 855, 1037),
    (50, 599734, 'foggia.JPG', 3293, 109, 1024, 768),
    (51, 104499, '7.jpg', 2428, 3, 640, 480),
    (52, 64041, 'Mozambic.jpg', 2480, 3, 300, 300),
    (53, 100321, 'azi.jpg', 2797, 5, 487, 370),
    (54, 3137, 'avatar_1.jpg', 3012, 0, 127, 128),
    (55, 3065, 'avt_sorinsov_medium.jpg', 3013, 13, 48, 48),
    (56, 3065, 'avt_sorinsov_medium.jpg', 3101, 71, 48, 48),
    (57, 28621, 'vrancea_13dec_05.pdf', 3397, 9, , ),
    (58, 14099, 'tungurah.jpg', 4796, 4, 500, 327),
    (59, 457824, '1.jpg', 5001, 12, 1024, 768),
    (60, 436223, '2.jpg', 5001, 4, 1024, 768),
    (61, 444795, '3.jpg', 5001, 7, 1024, 768),
    (62, 465482, '4.jpg', 5001, 6, 1024, 768),
    (63, 238565, '5.jpg', 5002, 9, 1024, 768),
    (64, 126275, 'luna.jpg', 5016, 3, 1593, 1195),
    (65, 138179, '1052 audi Q7.jpg', 5089, 1, 800, 600),
    (66, 45858, 'portiaderas378.jpg', 5107, 4, 449, 438),
    (67, 190191, 'Strut2.gif', 5108, 9, 315, 288),
    (68, 26010, 'ca111.gif', 5109, 5, 160, 120),
    (69, 27724, 'ca118.gif', 5109, 49, 120, 120),
    (70, 31281, 'bassethound.gif', 5110, 10, 156, 156),
    (71, 146214, 'untitled resize.bmp', 5111, 4, 270, 180),
    (72, 27724, 'ca118 catel.gif', 5114, 40, 120, 120),
    (73, 65778, 'Slide38.jpg', 5262, 9, 720, 540),
    (74, 15805, 'tort1.jpg', 5393, 2, 150, 142),
    (75, 78549, 'TIRR.20060923.gif', 5632, 50, 1024, 780),
    (76, 31737, 'PSZ.20060923.gif', 5633, 24, 1024, 780),
    (77, 16629, '060923.png', 5639, 28, 800, 472),
    (78, 5693, '060923_05.png', 5639, 21, 800, 290),
    (79, 426382, 'harta_seismica.jpg', 5686, 251, 1000, 1000),
    (80, 49697, 'Conceptii structurale.PDF', 5810, 0, , ),
    (81, 31037, 'Declaratii Radulian.pdf', 5810, 1, , ),
    (82, 33062, 'Pagini de istorie contemporana Cutremurul din 1977.pdf', 5810, 1, , ),
    (83, 3058, 'carlton.pdf', 5836, 44, 60, 60),
    (84, 3058, 'brat_1.jpg', 5844, 5, 60, 60),
    (85, 3058, 'Magheru.jpg', 5844, 1, 60, 60),
    (86, 3058, 'modernisme%20architecture%20014.jpg', 5844, 9, 60, 60),
    (87, 196664, 'rev 580.jpg', 0, 0, 1600, 1200),
    (88, 15004, 'Dodo_bird.jpg', 5905, 3, 342, 321),
    (89, 239000, 'zonare.jpg', 6149, 12, 435, 365),
    (90, 752122, 'Picture1.png', 6200, 17, 1132, 845),
    (91, 333891, 'Photo-00072.jpg', 6235, 8, 1024, 768),
    (92, 11559, 'ExtinctDodoBird.jpg', 6348, 2, 225, 244),
    (93, 209862, 'Picture2.png', 6391, 6, 1004, 775),
    (94, 396746, 'Picture1.png', 6395, 4, 551, 381),
    (95, 280702, 'Picture1.png', 6404, 7, 908, 621),
    (96, 41984, 'Intrebari.doc', 6440, 6, , ),
    (97, 9873, 'EMSCmon.rar.bmp', 6540, 8, , ),
    (98, 81735, 'h_euromed.jpg', 6563, 10, 600, 478),
    (99, 33766, 'poza 2.1.bmp', 6725, 7, 130, 86),
    (100, 10531, 'EMSCmon.zip', 6623, 2, , ),
    (101, 35741, 'statiaKalwariaPolonia.gif', 6791, 4, 1024, 780),
    (102, 44081, 'statiaMorawskyCehia.gif', 6791, 4, 1024, 780),
    (103, 42626, 'statiaPiszkesUngaria.gif', 6792, 5, 1024, 780),
    (104, 32167, 'statiaSuwalkiPolonia.gif', 6792, 4, 1024, 780),
    (105, 12420, 'imgst.jpeg', 6839, 10, 250, 319),
    (106, 22733, 'etajeadancime.JPG', 6982, 7, 319, 419),
    (107, 20421, 'hipocentre.JPG', 7004, 4, 319, 463),
    (108, 43299, 'sectiuneVrancea.JPG', 7005, 2, 737, 421),
    (109, 71115, 'tectonica.JPG', 7006, 12, 789, 587),
    (110, 82859, 'izseiste.JPG', 7008, 10, 630, 672),
    (111, 99988, 'efecte1977.JPG', 7009, 9, 827, 662),
    (112, 125960, 'hartaepicentre.JPG', 7010, 10, 596, 667),
    (113, 86325, 'cutremur.jpg', 7120, 6, 641, 508),
    (114, 144921, '9.jpg', 7131, 4, 457, 600),
    (115, 179806, '10.jpg', 7131, 5, 589, 600),
    (116, 248452, '1.jpg', 7132, 4, 531, 600),
    (117, 194240, '2.jpg', 7132, 3, 542, 600),
    (118, 226461, '7.jpg', 7133, 1, 523, 600),
    (119, 213594, '6.jpg', 7133, 2, 563, 600),
    (120, 171143, '3.jpg', 7134, 3, 400, 600),
    (121, 160552, '4.jpg', 7134, 3, 421, 600),
    (122, 74184, 'epicentre.JPG', 7190, 8, 615, 455),
    (123, 59084, 'Foto3.jpg', 7231, 8, 640, 480),
    (124, 53516, 'Foto4.jpg', 7231, 6, 640, 480),
    (125, 43600, 'Foto5.jpg', 7231, 3, 640, 480),
    (126, 51116, 'Foto8.jpg', 7232, 7, 640, 480),
    (127, 67196, 'Foto9.jpg', 7232, 6, 640, 480),
    (128, 61668, 'Foto10.jpg', 7232, 4, 640, 480),
    (129, 57296, 'Foto11.jpg', 7233, 8, 640, 480),
    (130, 12430, '200px-ExtinctDodoBird.jpg', 7246, 2, 200, 217),
    (131, 470811, 'incerc2.jpg', 7288, 6, 1024, 959),
    (132, 278250, 'incerc1.jpg', 7288, 3, 1024, 585),
    (133, 196781, 'vrancioaia.jpg', 7288, 4, 1024, 557),
    (134, 92429, 'poza.jpg', 7340, 12, 600, 478),
    (135, 54442, 'Asia3.gif', 7417, 3, 574, 409),
    (136, 87758, 'tectonic plates.gif', 7422, 8, 663, 401),
    (137, 55494, 'azi1hungary.gif', 7469, 83, 1024, 780),
    (138, 52562, 'azi2targusor.gif', 7469, 180, 1024, 780),
    (139, 97490, 'Targusor - 13.01.2007.gif', 7523, 25, 1024, 780),
    (140, 159612, 'seismogram.jpg', 7531, 40, 1174, 741),
    (141, 87697, 'a4.jpg', 7572, 4, 500, 384),
    (142, 139879, 'a6.jpg', 7572, 4, 640, 480),
    (143, 52365, 'a8.jpg', 7572, 3, 500, 294),
    (144, 81648, 'b1.jpg', 7572, 3, 640, 480),
    (145, 467557, 'complet.jpg', 7595, 6, 1202, 679);

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 ' ),
    (58, 14099, 'tungurah.jpg', 4796, 4, 500, 327),
    (59, 45782' at line 59
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on February 01, 2007, 10:58:41 PM
Ok updated it.  Should work now.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Shahryar_NEO on February 11, 2007, 02:10:01 PM
Hi...

Thanks For Your Posts...

I Have Forum Has Been Created By Mybb 1.2.2 And I want To Convert It To SMF . Can You Learn Me Step By Step And How To Convert IT ? Please Say Step By Step ... Please Help Me Quickly ...

Thanks A Lot
Shahryar
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on February 12, 2007, 01:50:18 AM
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: lunzet on February 12, 2007, 06:17:15 AM
everything is working like a charm to me now. Thx
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Shahryar_NEO on February 12, 2007, 08:10:29 AM
Thanks My Friend But I Have An Eror While I'm Converting :

http://shahrsakhtafzar.persiangig.com/www.gif

What's My problem? And How Can I Solve This problem

Thanks
Shahrayr
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Shahryar_NEO on February 12, 2007, 01:40:26 PM
Thanks You JayBachatero For Your Update . But My Last Eror Is :

Converting topic notifications... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_log_notify
    (ID_MEMBER, ID_TOPIC)
    VALUES ('2', '6'),
    ('2', '6');

Caused the error:

    Duplicate entry '2-6-0' for key 1




What Can I Do For Solve This Problem ?

Thanks
Shahryar
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Shahryar_NEO on February 14, 2007, 05:40:17 AM
Is There Any Body Here!?!?!

Please Help Me!!!

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on February 17, 2007, 01:06:40 AM
Are you using the most recent convert.php file?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: wonton1017 on February 25, 2007, 06:07:53 PM
Thank you! I've been looking for this for more than 2 months now!
I started to hate myBB and started to love SMF :)

FYI, i was using myBB v1.2.3 and successfully converted to SMF v1.1.2!!!!!
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on February 26, 2007, 07:14:38 PM
Updated converter to convert password salts.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: mark25 on March 24, 2007, 08:15:34 AM
i need some help..

Field 'lngfile' doesn't have a default value
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on March 26, 2007, 10:32:43 AM
What table is this column in?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: ChaosZero112 on May 07, 2007, 07:32:53 PM
I keep getting the same error:

Duplicate entry '16777215' for key 1
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Liski on May 15, 2007, 06:51:50 AM
I'm getting

Notice: Undefined index: convert_script in /home/liskico/public_html/sneakyunity/forum/convert.php on line 586

Warning: Invalid argument supplied for foreach() in /home/liskico/public_html/sneakyunity/forum/convert.php on line 589

Notice: Undefined index: convert_script in /home/liskico/public_html/sneakyunity/forum/convert.php on line 594
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 939

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 949

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 957

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 967

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 980

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 993

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1039

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1041

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1047

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1053

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1064

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1065

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1073

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1075

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1081

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1082

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1088

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1089

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1113

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1115

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1121

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1133

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1158

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1160

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1197

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1198

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1235

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1240

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1301

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1303

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1339

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1358

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1845

Notice: Undefined variable: result in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1381

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/liskico/public_html/sneakyunity/forum/convert.php on line 1382
Successful.
Conversion Complete
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: a_mulia on May 24, 2007, 03:52:41 AM
Hi Jay,

I Had convert mybb 1.2.6 to SMF 1.1.2 using the latest convert.php and mybb12_to_smf.sql , all the content are converted to SMF but unfortunately there some strange character appear. mybb database was using latin_1 as character set.
Is there somewhere I can set the char_set to latin_1 in convert.php file?

Thanks in advance

Abi
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: CSpili on June 04, 2007, 05:10:56 AM
Jay, I'm getting this error:

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 `test_mybb`.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 signa

After I try to convert from MyBB 1.2.7 to SMF 1.1.2 using latest convert.php and db
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: EximTrak on June 15, 2007, 04:18:19 PM
I write both of the forum directories and error in second step :( The page cannot be shown. I am waiting more and see this error.

How can I fix this?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: suye on June 21, 2007, 08:48:43 AM
I have the same problem as CSpili, anybody could help us?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Liski on June 24, 2007, 12:01:43 AM
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 `liskico_liski`.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
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: spit on July 09, 2007, 06:53:48 PM
From 1.2.8:

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... Successful.
Converting attachments... Successful.
Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `smf`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: EximTrak on July 21, 2007, 01:49:30 AM
I can't convert topics. Everything is ok but while converting topics the server doesn't answer :S
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: EximTrak on July 21, 2007, 11:59:18 AM
Topics can not be converted. Can anyone check the codes please?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Obi-Wahn on July 22, 2007, 12:47:53 PM
one more ;)

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 `nlt-forum`.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

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: EximTrak on July 22, 2007, 01:38:54 PM
Quote from: Obi-Wahn on July 22, 2007, 12:47:53 PM
one more ;)

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 `nlt-forum`.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



Try to use the last converter in the first post ;)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Obi-Wahn on July 23, 2007, 04:43:34 AM
Hi!

You are talking about this convert.php, aren't you?

http://www.simplemachines.org/community/index.php?topic=140741.0

I wonder, because the converter talks about "MyBulletinBoard 1.0", ....
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: EximTrak on July 23, 2007, 08:56:24 AM
No ;)

I'm talking about

http://www.simplemachines.org/community/index.php?action=dlattach;topic=140741.0;attach=30178

and

http://www.simplemachines.org/community/index.php?action=dlattach;topic=145191.0;attach=28148

Try yo use these ;)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Obi-Wahn on July 23, 2007, 03:35:39 PM
Thanks, it works.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: marines on July 28, 2007, 04:03:46 PM
there is still sth wrong. i got:
QuoteRecalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `marines_cms_forum`.smf_smileys

    ORDER BY LENGTH(code) DESC;

Caused the error:

    Something is wrong in your syntax obok 'LENGTH(code) DESC' w linii 3

BTW there is no utf8 encoding? i got bad chars like "ż"
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on July 29, 2007, 01:49:19 PM
The SMF converters do not have UTF-8 support yet. But hopefully they will in the future.
The query error is an issue with mysql. You should ask your host to upgrade.
You can also remove that query from the sql file and it will work just fine without it.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on August 08, 2007, 01:43:57 AM
Quote from: SleePy on July 29, 2007, 01:49:19 PM
The SMF converters do not have UTF-8 support yet. But hopefully they will in the future.
The query error is an issue with mysql. You should ask your host to upgrade.
You can also remove that query from the sql file and it will work just fine without it.
I guess you missed the UTF-8 Conversion (http://www.simplemachines.org/community/index.php?topic=140917.0) topic. ::)

Also are you guys still having problems with this converter?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: CSpili on August 08, 2007, 10:02:49 AM
Hey Jay!

Just tested the latest one you got here and had alien symbols.  I'm now checking the UTF-8 Conversion Topic and will let you know.  Thanks for the great work Jay!

Cheers,
Constantinos
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: EximTrak on August 25, 2007, 06:28:41 PM
Can we convert banned members?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on August 26, 2007, 08:43:06 PM
You mean set the banned status for those members that are banned?  If so I'll look and see how MyBB handles it.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: EximTrak on August 27, 2007, 11:41:44 AM
Quote from: JayBachatero on August 26, 2007, 08:43:06 PM
You mean set the banned status for those members that are banned?  If so I'll look and see how MyBB handles it.

Yeah i mean this ;) I have lots of banned members and to set their status to banned will take long time :(

Also can we convert the locked topics?

Thanks..
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on August 28, 2007, 10:40:55 PM
Ok added to the todo list.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Minare on August 31, 2007, 05:06:59 AM
I got this error :

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 `ea2_`.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 signa
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Minare on August 31, 2007, 05:01:22 PM
What can I  do, any ideas ?  :(
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: EximTrak on September 03, 2007, 01:36:05 AM
Try to use the latest convert.php and mybb12_to_smf.sql ;)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Minare on September 03, 2007, 03:08:04 AM
Quote from: EximTrak on September 03, 2007, 01:36:05 AM
Try to use the latest convert.php and mybb12_to_smf.sql ;)

I thought that I did as u said. Can u pls give me the links to those sources for guarentee ?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on September 03, 2007, 03:09:52 AM
http://www.simplemachines.org/community/index.php?action=dlattach;topic=145191.0;attach=28148
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: xScopex on September 18, 2007, 10:19:49 PM
When I tried this I got 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 `clanfall_mybb`.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 sign
I am running on MyBB1.2.9 would this be the problem>

NVM: I got it to work.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: dudeness3 on October 03, 2007, 01:42:16 AM
I got this error

Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `dude`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on October 03, 2007, 01:50:04 AM
Don't worry about that error.  Just run Find and Repair errors in Admin > Forum Maintenance then do a stats recount and you should be fine.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: dudeness3 on October 03, 2007, 02:08:27 AM
Quote from: JayBachatero on October 03, 2007, 01:50:04 AM
Don't worry about that error.  Just run Find and Repair errors in Admin > Forum Maintenance then do a stats recount and you should be fine.
Thanks, it worked out fine :)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: marc25v on October 08, 2007, 08:17:48 PM
Hello,  I am trying to convert my MyBB forum to SMF.  I used the script located in this thread and the convert.php in the one that links to this one (has all the forum choices) . 

Step 1 never loads, it loads a white page in firefox and a Connection Error in IE.  If I change the step1 in the URL to step2, the page loads with the following error.  Everything seems imported other than the posts and threads.  Also, these are the only errors I get.  These are all seen on the step2 page where it says Conversion Successful...

Recalculating forum statistics...
Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 930

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 939

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 949

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 957

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 967

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 972

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 980

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 993

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1032

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1039

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1041

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1047

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1053

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1058

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1064

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1065

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1073

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1075

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1081

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1082

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1088

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1089

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1105

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1113

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1115

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1121

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1133

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1151

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1158

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1160

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1192

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1197

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1198

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1227

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1235

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1240

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1301

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1303

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1329

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1339

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1358

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1363

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1376

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1381

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1382
Successful.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Clarky on October 13, 2007, 06:52:39 AM
Im getting the below error. Please help!

Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `rcforum_smf`.smf_boards
SET ID_LAST_MSG = 1053, lastUpdated = 1190815870
WHERE ID_BOARD = 4
LIMIT 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Clarky on October 15, 2007, 03:07:55 AM
Successfully converted :D

I wasnt using the latest convert.php :) :D

www.rc-forums.co.uk
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on October 16, 2007, 06:05:44 PM
marc25v what permission is the file set to?  Also who is your host?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: marc25v on October 16, 2007, 07:44:31 PM
Hello, my permissions are all set to 777 and I own my own server.  It is a dedicated server which costs me a lot.

Waiting for your reply.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on October 16, 2007, 10:16:43 PM
Actually now that I look at the errors they are because you went to step 2 but didn't have any of the session variables set that are defined in step 1.  If you want I can take a look at this for you.  Just send me FTP info.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: marc25v on October 17, 2007, 11:04:49 AM
Actually I took action before you replied.  I decided to manually import and export and rename all my threads tables and posts.  The members got imported oddly using the converter.  It looks ok now except a couple of things such as the IP only shows 2 numbers.  Here I could send you a link to the forums.   http://forums.zendurl.com/smf

Thansk a lot.. Although it was a lot of trouble :S
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on October 19, 2007, 01:13:04 AM
First time I see that IP issue.  But if that's the only remaining issue then you don't have to worry.  The IP's get updated for the users.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: curiousgeo on November 19, 2007, 02:02:23 AM
I get stopped immediately with the following error, which I have seen a lot in previous posts but no resolution:

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 `gdogforum`.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 sign
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on November 19, 2007, 02:34:25 AM
Are you using the converter in this topic?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: curiousgeo on November 19, 2007, 10:55:35 AM
Yes, of course I am.  I have gone through this entire thread and used every one that is mentioned.  Still same exact error.

But if you'd like to link me to the exact one I'm supposed to use, maybe I'll have better luck.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: curiousgeo on November 23, 2007, 11:01:12 AM
Hmmm...well, I guess I won't be converting to smf.

By the way, that is really irritating to be thrown to the index after you post instead of being able to view the post you just made (without having to look for it).
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on November 23, 2007, 04:19:01 PM
curiousgeo,

Please remember we are all volunteers here and do not get paid for what we do.

Can you verify in your conversion .sql file that on line 30 you have exactly this:
SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn, 1, 255) AS MSN,

If you can't find the line or want me to look. Just post everything from "Converting members" to "Converting categories".

As for the post, Just go to your Look and Layout and Check "Return to topics after posting by default."

You can make this a default option for all new users and/or your current users in these places
Admin -> Current Theme -> Reset Options -> Reset all members' current options for this theme
Admin -> Current Theme -> Reset Options -> Reset default (guest) options for this theme

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on December 09, 2007, 11:38:07 PM
Quote from: curiousgeo on November 23, 2007, 11:01:12 AM
Hmmm...well, I guess I won't be converting to smf.

By the way, that is really irritating to be thrown to the index after you post instead of being able to view the post you just made (without having to look for it).
Can you give me FTP access so that I can give this a try and debug it?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: f0g on December 15, 2007, 05:41:29 PM
The converter in the topic has an error on line 28. AS MSN is repeated twice, incorrectly the first time through.


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

should be

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


Also, I'm trying to do a convert of a very large forum.  When I do a show full processlist on mysql, I see that the same query is executing simultaneously... and obviously, it takes a while. Right now it's still running, but...

Id      User    Host    db      Command Time    State   Info
69      smf     localhost       NULL    Query   1231    Copying to tmp table    SELECT\n\tt.tid AS ID_TOPIC, t.fid AS ID_BOARD, t.sticky AS isSticky,\n\tt.poll AS ID_POLL, t.views AS numViews, t.uid AS ID_MEMBER_STARTED,\n\tul.uid AS ID_MEMBER_UPDATED, t.replies AS numReplies, t.closed AS locked,\n\tMIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG\nFROM (`fur`.mybb_threads AS t, `fur`.mybb_posts AS p)\n\tLEFT JOIN `fur`.mybb_users AS ul ON (BINARY ul.username = t.lastposter)\nWHERE p.tid = t.tid\nGROUP BY t.tid\nHAVING ID_FIRST_MSG != 0\n\tAND ID_LAST_MSG != 0\nLIMIT 0, 500
72      smf     localhost       NULL    Query   842     Copying to tmp table    SELECT\n\tt.tid AS ID_TOPIC, t.fid AS ID_BOARD, t.sticky AS isSticky,\n\tt.poll AS ID_POLL, t.views AS numViews, t.uid AS ID_MEMBER_STARTED,\n\tul.uid AS ID_MEMBER_UPDATED, t.replies AS numReplies, t.closed AS locked,\n\tMIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG\nFROM (`fur`.mybb_threads AS t, `fur`.mybb_posts AS p)\n\tLEFT JOIN `fur`.mybb_users AS ul ON (BINARY ul.username = t.lastposter)\nWHERE p.tid = t.tid\nGROUP BY t.tid\nHAVING ID_FIRST_MSG != 0\n\tAND ID_LAST_MSG != 0\nLIMIT 0, 500



Edit #2:
Well, the web page timed out (I reset the timeout to one hour, but it's been running longer).

But those same queries are still running. 6119 seconds and counting...

Edit #3:
Over 8000. I'm killing it because I haven't seen mysql chewing up any CPU the entire time...

what's going on?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on December 15, 2007, 11:58:44 PM
Do an explain on the queries and post the results here.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: f0g on December 16, 2007, 03:27:02 PM
1       SIMPLE  p       ALL     NULL    NULL    NULL    NULL    253021  Using temporary; Using filesort
1       SIMPLE  t       eq_ref  PRIMARY PRIMARY 4       fur.p.tid       1
1       SIMPLE  ul      ALL     NULL    NULL    NULL    NULL    9485
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: f0g on December 18, 2007, 07:15:15 AM
I hope that means more to you than it does to me. :)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: f0g on December 19, 2007, 09:32:45 PM
Is there more information I can get you?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on December 20, 2007, 11:19:04 PM
Seems like it's not using any keys.  Can you PM me access to phpMyAdmin?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: f0g on December 22, 2007, 11:45:59 PM
Sent you a PM.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on December 22, 2007, 11:47:05 PM
Alright I'll take a look at it in a bit.  What version of MyBB are you exactly using?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: el canadiano on January 28, 2008, 08:27:03 PM
I'm getting this error.

QuoteConverting members... Unsuccessful!
This query:

    INSERT INTO `stone_smfdb`.smf_members
    (ID_MEMBER, memberName, realName, passwd, emailAddress, posts, usertitle, lastLogin, ID_GROUP, dateRegistered, websiteUrl, websiteTitle, ICQ, AIM, YIM, MSN, signature, hideEmail, buddy_list, memberIP, memberIP2, pm_ignore_list, totalTimeLoggedIn, birthdate)
    VALUES ('2001', 'dascmaniac', 'dascmaniac', '', '[email protected]', '0', '', '1171923355', '0', '1171923295', '', '', '0', '', '', '', '', 'yes', '', '132.73.80.129', '132.73.80.129', '', '0', '----'),
    ('2002', 'Morbo', 'Morbo', '', '[email protected]', '4', '', '1172045585', '0', '1171932555', '', '', '0', '', '', '', '', 'yes', '', '207.41.34.50', '207.41.34.50', '', '0', '----'),
    ('2003', 'profumi', 'profumi', '', '[email protected]', '0', '', '1172048762', '0', '1172048741', '', '', '0', '', '', '', '', 'yes', '', '84.197.12.108', '84.197.12.108', '', '0', '----'),
    ('2004', 'homer 408', 'homer 408', '', '[email protected]', '1', '', '1172124458', '0', '1172124427', '', '', '0', '', '', '', '', 'yes', '', '69.228.199.195', '69.228.199.195', '', '0', '----'),
    ('2005', 'Taktloss', 'Taktloss', '', '[email protected]', '0', '', '1172096354', '0', '1172096311', '', '', '0', '', '', '', '', 'yes', '', '84.61.4.135', '84.61.4.135', '', '0', '----'),
    ('2006', 'Stranger', 'Stranger', '', '[email protected]', '1', '', '1172157377', '0', '1172157359', '', '', '0', '', '', '', '', 'yes', '', '82.32.48.236', '82.32.48.236', '', '0', '----'),
    ('2007', 'poupounousse', 'poupounousse', '', '[email protected]', '0', '', '1172238290', '0', '1172157350', '', '', '0', '', '', '', '', 'yes', '', '194.4.232.242', '194.4.232.242', '', '0', '----'),
    ('2008', 'msimplay', 'msimplay', '', '[email protected]', '0', '', '1172165708', '0', '1172165649', '', '', '0', '', '', '', '', 'yes', '', '62.30.74.65', '62.30.74.65', '', '0', '----'),
    ('2009', 'gupouoit7uy', 'gupouoit7uy', '', '[email protected]', '0', '', '1172167620', '0', '1172166018', '', '', '0', '', '', '', '', 'yes', '', '80.41.181.188', '80.41.181.188', '', '0', '----'),
    ('2010', 'markrenton', 'markrenton', '', '[email protected]', '0', '', '1172166689', '0', '1172166559', '', '', '0', '', '', '', '', 'yes', '', '217.86.77.190', '217.86.77.190', '', '0', '----'),
    ('2011', 'gillym8', 'gillym8', '', '[email protected]', '0', '', '1172196745', '0', '1172196720', '', '', '0', '', '', '', '', 'yes', '', '210.49.196.17', '210.49.196.17', '', '0', '----'),
    ('2012', 'sbbfooks', 'sbbfooks', '', '[email protected]', '0', '', '1180187815', '0', '1172198681', '', '', '0', '', '', '', '', 'yes', '', '65.93.146.45', '65.93.146.45', '', '0', '----'),
    ('2013', 'cesarix', 'cesarix', '', '[email protected]', '0', '', '1180044591', '0', '1172253987', '', '', '0', '', '', '', '', 'yes', '', '89.152.172.204', '89.152.172.204', '', '0', '----'),
    ('2014', 'bdbucky', 'bdbucky', '', '[email protected]', '80', '', '1177517826', '0', '1172258190', 'http://', 'http://', '0', '', '', '', '(http://i4.photobucket.com/albums/y144/Quxmax/5c4ee917b19f8ab93fee1e05e6c5b8d5.gif)

    [size=11]<span style=\"color:#FF0000\">Don't mess with the Sess<!--sizec-->[/size]<!--/sizec--><!--fontc--><!--/fontc-->', 'yes', '', '192.138.205.144', '192.138.205.144', '', '0', '1988-4-22'),
    ('2015', 'GGP_ipb2_import2024', 'GGP_ipb2_import2024', '', '[email protected]', '30', '', '1180640025', '0', '1172344729', '', '', '0', '', '', '', '', 'yes', '', '66.31.75.235', '66.31.75.235', '', '0', '----'),
    ('2016', 'Evil1', 'Evil1', '', '[email protected]', '0', '', '1172308853', '0', '1172308331', '', '', '0', '', '', '', '', 'yes', '', '138.217.217.219', '138.217.217.219', '', '0', '----'),
    ('2017', 'IRISHDUDE27', 'IRISHDUDE27', '', '[email protected]', '0', '', '0', '0', '1172378056', '', '', '0', '', '', '', '', 'yes', '', '68.98.39.208', '68.98.39.208', '', '0', '----'),
    ('2018', 'Kyle', 'Kyle', '', '[email protected]', '0', '', '1172387209', '0', '1172383631', '', '', '0', '', '', '', '', 'yes', '', '124.177.150.106', '124.177.150.106', '', '0', '----'),
    ('2019', 'jaygray94', 'jaygray94', '', '[email protected]', '0', '', '1172431836', '0', '1172431796', '', '', '0', '', '', '', '', 'yes', '', '81.151.206.169', '81.151.206.169', '', '0', '----'),
    ('2020', 'theonemaster', 'theonemaster', '', '[email protected]', '0', '', '1172433320', '0', '1172433263', '', '', '0', '', '', '', '', 'yes', '', '72.160.185.108', '72.160.185.108', '', '0', '----'),
    ('2021', 'simpsongampl', 'simpsongampl', '', '[email protected]', '0', '', '1172492641', '0', '1172492608', '', '', '0', '', '', '', '', 'yes', '', '217.173.20.106', '217.173.20.106', '', '0', '----'),
    ('2022', 'TravisG', 'TravisG', '', '[email protected]', '1', '', '1172524445', '0', '1172449101', '', '', '0', '', '', '', '', 'yes', '', '62.253.32.5', '62.253.32.5', '', '0', '----'),
    ('2023', 'dodabartmanx4', 'dodabartmanx4', '', '[email protected]', '0', '', '0', '0', '1172455944', '', '', '0', '', '', '', '', 'yes', '', '12.217.128.82', '12.217.128.82', '', '0', '----'),
    ('2024', 'snocker', 'snocker', '', '[email protected]', '0', '', '1172548748', '0', '1172548716', '', '', '0', '', '', '', '', 'yes', '', '137.226.181.106', '137.226.181.106', '', '0', '----'),
    ('2025', 'dmc2005', 'dmc2005', '', '[email protected]', '0', '', '1173919807', '0', '1172499601', '', '', '0', '', '', '', '', 'yes', '', '82.141.146.20', '82.141.146.20', '', '0', '----'),
    ('2026', 'borikong', 'borikong', '', '[email protected]', '0', '', '1172572766', '0', '1172572749', '', '', '0', '', '', '', '', 'yes', '', '122.2.30.213', '122.2.30.213', '', '0', '----'),
    ('2027', 'dadflea', 'dadflea', '', '[email protected]', '0', '', '1172517739', '0', '1172517710', '', '', '0', '', '', '', '', 'yes', '', '71.53.35.214', '71.53.35.214', '', '0', '----'),
    ('2028', 'Alexander86', 'Alexander86', '', '[email protected]', '0', '', '1172524052', '0', '1172518617', '', '', '0', '', '', '', '', 'yes', '', '80.217.128.54', '80.217.128.54', '', '0', '----'),
    ('2029', 'tintinza', 'tintinza', '', '[email protected]', '0', '', '1172519930', '0', '1172519906', '', '', '0', '', '', '', '', 'yes', '', '90.194.198.75', '90.194.198.75', '', '0', '----'),
    ('2030', 'damhomersfunny', 'damhomersfunny', '', '[email protected]', '0', '', '1172629118', '0', '1172629082', '', '', '0', '', '', '', '', 'yes', '', '74.96.106.227', '74.96.106.227', '', '0', '----'),
    ('2031', 'Shogg', 'Shogg', '', '[email protected]', '3', '', '1174866790', '0', '1174779433', '', '', '0', '', '', '', '', 'yes', '', '68.197.6.182', '68.197.6.182', '', '0', '----'),
    ('2032', 'jeffbaldwin', 'jeffbaldwin', '', '[email protected]', '0', '', '1172648331', '0', '1172648297', '', '', '0', '', '', '', '', 'yes', '', '64.17.80.155', '64.17.80.155', '', '0', '----'),
    ('2033', 'Sirz', 'Sirz', '', '[email protected]', '0', '', '1172648415', '0', '1172648373', '', '', '0', '', '', '', '', 'yes', '', '91.121.13.44', '91.121.13.44', '', '0', '----'),
    ('2034', 'Kikkerkont', 'Kikkerkont', '', '[email protected]', '30', '', '1180780585', '0', '1172648966', '', '', '0', '', '', '', 'South Park Source - The ultimate source for everything about South Park! (http://spsource.net)
    South Park Source Forums (http://forum.spsource.net)', 'yes', '', '145.53.234.161', '145.53.234.161', '', '0', '----'),
    ('2035', 'The_Black_Smoke_Monster', 'The_Black_Smoke_Monster', '', '[email protected]', '26', '', '1176932591', '0', '1172678462', 'http://www.futuramaff.com', 'http://www.futuramaff.com', '0', '', '', '', 'Nearly 700 members
    Over 45,000 posts
    5 and a half months old
    FUTURAMA FANS
    www.futuramaff.com (http://www.futuramaff.com)
    ', 'yes', '', '84.64.255.89', '84.64.255.89', '', '0', '1989-6-29'),
    ('2036', 'izhan_ipb2_import2036', 'izhan_ipb2_import2036', '', '[email protected]', '0', '', '1172681694', '0', '1172681678', '', '', '0', '', '', '', '', 'yes', '', '80.7.241.116', '80.7.241.116', '', '0', '----'),
    ('2037', 'frostie', 'frostie', '', '[email protected]', '0', '', '1172683900', '0', '1172683879', '', '', '0', '', '', '', '', 'yes', '', '89.216.147.195', '89.216.147.195', '', '0', '----'),
    ('2038', 'leprechaun27', 'leprechaun27', '', '[email protected]', '1', '', '1175316983', '0', '1172692238', '', '', '0', '', '', '', '', 'yes', '', '68.98.39.208', '68.98.39.208', '', '0', '----'),
    ('2039', 'tardistraveller15', 'tardistraveller15', '', '[email protected]', '0', '', '1177516217', '0', '1172696159', '', '', '0', '', '', '', '', 'yes', '', '80.192.164.6', '80.192.164.6', '', '0', '----'),
    ('2040', 'malcolm333', 'malcolm333', '', '[email protected]', '1', '', '1172700975', '0', '1172700954', '', '', '0', '', '', '', '', 'yes', '', '74.15.81.141', '74.15.81.141', '', '0', '----'),
    ('2041', 'hardtodie0', 'hardtodie0', '', '[email protected]', '0', '', '1172729343', '0', '1172711498', '', '', '0', '', '', '', '', 'yes', '', '63.252.66.201', '63.252.66.201', '', '0', '----'),
    ('2042', 'hassanrca', 'hassanrca', '', '[email protected]', '0', '', '1173305253', '0', '1172714989', '', '', '0', '', '', '', '', 'yes', '', '82.231.152.210', '82.231.152.210', '', '0', '----'),
    ('2043', 'baxter316', 'baxter316', '', '[email protected]', '0', '', '1172927423', '0', '1172927399', '', '', '0', '', '', '', '', 'yes', '', '195.93.21.39', '195.93.21.39', '', '0', '----'),
    ('2044', 'ratsco', 'ratsco', '', '[email protected]', '0', '', '1175773383', '0', '1172832497', '', '', '0', '', '', '', '', 'yes', '', '203.59.159.130', '203.59.159.130', '', '0', '----'),
    ('2045', 'LazyPeanut', 'LazyPeanut', '', '[email protected]', '6', '', '1173364317', '0', '1172763102', '', '', '0', '', '', '', '', 'yes', '', '81.243.142.239', '81.243.142.239', '', '0', '----'),
    ('2046', 'huggies', 'huggies', '', '[email protected]', '0', '', '1173466808', '0', '1172769489', '', '', '0', '', '', '', '', 'yes', '', '204.8.198.2', '204.8.198.2', '', '0', '----'),
    ('2047', 'eastfifearabman', 'eastfifearabman', '', '[email protected]', '0', '', '1172783784', '0', '1172783324', '', '', '0', '', '', '', '', 'yes', '', '82.41.124.189', '82.41.124.189', '', '0', '----'),
    ('2048', 'Ghost_Rider_666', 'Ghost_Rider_666', '', '[email protected]', '0', '', '1172860385', '0', '1172859584', '', '', '0', '', '', '', '', 'yes', '', '80.192.163.139', '80.192.163.139', '', '0', '----'),
    ('2049', 'kagakaga1', 'kagakaga1', '', '[email protected]', '0', '', '1172868706', '0', '1172868685', '', '', '0', '', '', '', '', 'yes', '', '172.142.109.64', '172.142.109.64', '', '0', '----'),
    ('2050', 'wentworth2006', 'wentworth2006', '', '[email protected]', '0', '', '1177177644', '0', '1172871972', '', '', '0', '', '', '', '', 'yes', '', '86.133.124.17', '86.133.124.17', '', '0', '----'),
    ('2051', 'Jamesisfun93', 'Jamesisfun93', '', '[email protected]', '0', '', '1172873144', '0', '1172872500', '', '', '0', '', '', '', '', 'yes', '', '211.27.246.184', '211.27.246.184', '', '0', '----'),
    ('2052', 'aussie2000', 'aussie2000', '', '[email protected]', '0', '', '1172902607', '0', '1172902539', '', '', '0', '', '', '', '', 'yes', '', '58.178.226.251', '58.178.226.251', '', '0', '----'),
    ('2053', 'kkojot', 'kkojot', '', '[email protected]', '0', '', '1172955587', '0', '1172955542', '', '', '0', '', '', '', '', 'yes', '', '91.143.221.169', '91.143.221.169', '', '0', '----'),
    ('2054', 'jokern102', 'jokern102', '', '[email protected]', '0', '', '1172959847', '0', '1172959828', '', '', '0', '', '', '', '', 'yes', '', '217.209.9.33', '217.209.9.33', '', '0', '----'),
    ('2055', 'shady45', 'shady45', '', '[email protected]', '0', '', '1172977975', '0', '1172977954', '', '', '0', '', '', '', '', 'yes', '', '69.116.131.71', '69.116.131.71', '', '0', '----'),
    ('2056', 'olexinski', 'olexinski', '', '[email protected]', '0', '', '1173192857', '0', '1173192770', '', '', '0', '', '', '', '', 'yes', '', '83.27.92.102', '83.27.92.102', '', '0', '----'),
    ('2057', 'deathman', 'deathman', '', '[email protected]', '0', '', '1173010282', '0', '1172995673', '', '', '0', '', '', '', '', 'yes', '', '217.194.149.227', '217.194.149.227', '', '0', '----'),
    ('2058', 'saj72', 'saj72', '', '[email protected]', '0', '', '1173576654', '0', '1172996474', '', '', '0', '', '', '', '', 'yes', '', '211.30.200.190', '211.30.200.190', '', '0', '----'),
    ('2059', 'kerry24', 'kerry24', '', '[email protected]', '0', '', '1173108502', '0', '1173100544', 'http://', 'http://', '0', '', '', '[email protected]', 'I love Simon 4 eva and eva.', 'yes', '', '144.137.249.153', '144.137.249.153', '', '0', '1983-2-19'),
    ('2060', 'Replay', 'Replay', '', '[email protected]', '26', '', '1180202088', '0', '1173300416', '', '', '0', 'Da Finest of NY', '[email protected]', '[email protected]', 'My One Click Movie Downloads (http://krustylustudios.com/index.php?showtopic=889)', 'yes', '', '70.23.85.179', '70.23.85.179', '', '0', '1990-4-4'),
    ('2061', 'banderas', 'banderas', '', '[email protected]', '0', '', '1173819165', '0', '1173218804', '', '', '0', '', '', '', '', 'yes', '', '84.71.26.103', '84.71.26.103', '', '0', '----'),
    ('2062', 'Jibaro', 'Jibaro', '', '[email protected]', '0', '', '1173221496', '0', '1173221451', '', '', '0', '', '', '', '', 'yes', '', '75.21.67.136', '75.21.67.136', '', '0', '----'),
    ('2063', 'sureshisgreat', 'sureshisgreat', '', '[email protected]', '0', '', '1176763601', '0', '1173221638', '', '', '0', '', '', '', '', 'yes', '', '91.4.86.117', '91.4.86.117', '', '0', '----'),
    ('2064', 'Luminux', 'Luminux', '', '[email protected]', '0', '', '1173756259', '0', '1173224779', '', '', '0', '', '', '', '', 'yes', '', '74.13.110.19', '74.13.110.19', '', '0', '----'),
    ('2065', 'lyrical_headspin', 'lyrical_headspin', '', '[email protected]', '1', '', '1173333634', '0', '1173333607', '', '', '0', '', '', '', '', 'yes', '', '158.136.163.110', '158.136.163.110', '', '0', '----'),
    ('2066', 'webspinner', 'webspinner', '', '[email protected]', '0', '', '1173367632', '0', '1173367595', '', '', '0', '', '', '', '', 'yes', '', '72.1.206.12', '72.1.206.12', '', '0', '----'),
    ('2067', 'hollathina', 'hollathina', '', '[email protected]', '0', '', '1173385799', '0', '1173385765', '', '', '0', '', '', '', '', 'yes', '', '82.152.204.39', '82.152.204.39', '', '0', '----'),
    ('2068', 'stokesg', 'stokesg', '', '[email protected]', '0', '', '1173388551', '0', '1173388157', '', '', '0', '', '', '', '', 'yes', '', '62.253.128.12', '62.253.128.12', '', '0', '----'),
    ('2069', 'Brillig', 'Brillig', '', '[email protected]', '3', '', '1174336859', '0', '1173388839', '', '', '0', '', '', '', '', 'yes', '', '72.54.129.226', '72.54.129.226', '', '0', '----'),
    ('2070', 'miki', 'miki', '', '[email protected]', '0', '', '1173451748', '0', '1173451661', '', '', '0', '', '', '', '', 'yes', '', '84.2.150.192', '84.2.150.192', '', '0', '----'),
    ('2071', 'bartinjapan', 'bartinjapan', '', '[email protected]', '0', '', '1176988532', '0', '1173492760', '', '', '0', '', '', '', '', 'yes', '', '124.26.164.2', '124.26.164.2', '', '0', '----'),
    ('2072', 'forget.regret', 'forget.regret', '', '[email protected]', '0', '', '1173518483', '0', '1173518458', '', '', '0', '', '', '', '', 'yes', '', '75.71.244.177', '75.71.244.177', '', '0', '----'),
    ('2073', 'oliversam123', 'oliversam123', '', '[email protected]', '0', '', '1173466610', '0', '1173466584', '', '', '0', '', '', '', '', 'yes', '', '82.36.105.112', '82.36.105.112', '', '0', '----'),
    ('2074', 'simpsonsfan102', 'simpsonsfan102', '', '[email protected]', '0', '', '1173665982', '0', '1173665967', '', '', '0', '', '', '', '', 'yes', '', '209.162.47.60', '209.162.47.60', '', '0', '----'),
    ('2075', 'cooltown', 'cooltown', '', '[email protected]', '0', '', '1173561667', '0', '1173561603', '', '', '0', '', '', '', '', 'yes', '', '59.92.130.181', '59.92.130.181', '', '0', '----'),
    ('2076', 'K3vin', 'K3vin', '', '[email protected]', '0', '', '1175696514', '0', '1175696494', '', '', '0', '', '', '', '', 'yes', '', '84.99.7.210', '84.99.7.210', '', '0', '----'),
    ('2077', 'twingats54', 'twingats54', '', '[email protected]', '0', '', '1173669452', '0', '1173669418', '', '', '0', '', '', '', '', 'yes', '', '67.37.190.23', '67.37.190.23', '', '0', '----'),
    ('2078', 'flavinoska', 'flavinoska', '', '[email protected]', '0', '', '1173783192', '0', '1173674380', '', '', '0', '', '', '', '', 'yes', '', '82.240.203.4', '82.240.203.4', '', '0', '----'),
    ('2079', 'poiuytre', 'poiuytre', '', '[email protected]', '0', '', '1173815740', '0', '1173748700', '', '', '0', '', '', '', '', 'yes', '', '84.196.242.33', '84.196.242.33', '', '0', '----'),
    ('2080', 'someone', 'someone', '', '[email protected]', '0', '', '1177011811', '0', '1173693009', '', '', '0', '', '', '', '', 'yes', '', '88.105.54.217', '88.105.54.217', '', '0', '----'),
    ('2081', 'simpson boy', 'simpson boy', '', '[email protected]', '0', '', '1174070735', '0', '1174070700', '', '', '0', '', '', '', '', 'yes', '', '81.77.104.151', '81.77.104.151', '', '0', '----'),
    ('2082', 'Vaibhav007', 'Vaibhav007', '', '[email protected]', '0', '', '1173793410', '0', '1173793373', '', '', '0', '', '', '', '', 'yes', '', '59.178.83.202', '59.178.83.202', '', '0', '----'),
    ('2083', 'stappo', 'stappo', '', '[email protected]', '0', '', '1173819908', '0', '1173819883', '', '', '0', '', '', '', '', 'yes', '', '84.197.50.31', '84.197.50.31', '', '0', '----'),
    ('2084', 'nix', 'nix', '', '[email protected]', '0', '', '1173835362', '0', '1173835329', '', '', '0', '', '', '', '', 'yes', '', '200.116.173.103', '200.116.173.103', '', '0', '----'),
    ('2085', 'jn1978', 'jn1978', '', '[email protected]', '0', '', '1173876389', '0', '1173876366', '', '', '0', '', '', '', '', 'yes', '', '82.233.53.142', '82.233.53.142', '', '0', '----'),
    ('2086', 'Jimbob2110', 'Jimbob2110', '', '[email protected]', '0', '', '1173890450', '0', '1173889655', '', '', '0', '', '', '', '', 'yes', '', '86.7.64.178', '86.7.64.178', '', '0', '----'),
    ('2087', 'pyro666', 'pyro666', '', '[email protected]', '0', '', '1174209491', '0', '1173899947', '', '', '0', '', '', '', '', 'yes', '', '221.135.251.166', '221.135.251.166', '', '0', '----'),
    ('2088', 'BadCase', 'BadCase', '', '[email protected]', '0', '', '1173979335', '0', '1173979315', '', '', '0', '', '', '', '', 'yes', '', '70.190.147.10', '70.190.147.10', '', '0', '----'),
    ('2089', 'benj_au', 'benj_au', '', '[email protected]', '0', '', '1174110501', '0', '1174110469', '', '', '0', '', '', '', '', 'yes', '', '203.214.147.224', '203.214.147.224', '', '0', '----'),
    ('2090', 'mcilroga', 'mcilroga', '', '[email protected]', '0', '', '1174016583', '0', '1174016571', '', '', '0', '', '', '', '', 'yes', '', '74.114.67.102', '74.114.67.102', '', '0', '----'),
    ('2091', 'NightTerrors', 'NightTerrors', '', '[email protected]', '0', '', '0', '0', '1174083639', '', '', '0', '', '', '', '', 'yes', '', '124.183.225.246', '124.183.225.246', '', '0', '----'),
    ('2092', 'ronroms', 'ronroms', '', '[email protected]', '0', '', '1174088319', '0', '1174088308', '', '', '0', '', '', '', '', 'yes', '', '201.143.81.254', '201.143.81.254', '', '0', '----'),
    ('2093', 'Shen', 'Shen', '', '[email protected]', '0', '', '1174112043', '0', '1174111989', '', '', '0', '', '', '', '', 'yes', '', '74.241.165.226', '74.241.165.226', '', '0', '----'),
    ('2094', 'Version1', 'Version1', '', '[email protected]', '0', '', '1174145129', '0', '1174145102', '', '', '0', '', '', '', '', 'yes', '', '124.189.66.15', '124.189.66.15', '', '0', '----'),
    ('2095', 'maame_masr', 'maame_masr', '', '[email protected]', '0', '', '1174156441', '0', '1174156422', '', '', '0', '', '', '', '', 'yes', '', '67.41.132.94', '67.41.132.94', '', '0', '----'),
    ('2096', 'doodster', 'doodster', '', '[email protected]', '0', '', '1174211082', '0', '1174211062', '', '', '0', '', '', '', '', 'yes', '', '194.42.116.11', '194.42.116.11', '', '0', '----'),
    ('2097', 'mekeskispas', 'mekeskispas', '', '[email protected]', '0', '', '1174248771', '0', '1174248746', '', '', '0', '', '', '', '', 'yes', '', '193.51.16.187', '193.51.16.187', '', '0', '----'),
    ('2098', 'HomerSimpson76-07', 'HomerSimpson76-07', '', '[email protected]', '0', '', '1175805473', '0', '1174268339', '', '', '0', '', '', '', '', 'yes', '', '70.143.58.203', '70.143.58.203', '', '0', '----'),
    ('2099', 'KarinaLG06_ipb2_import2103', 'KarinaLG06_ipb2_import2103', '', '[email protected]', '0', '', '0', '0', '1174279363', '', '', '0', '', '', '', '', 'yes', '', '198.202.25.212', '198.202.25.212', '', '0', '----'),
    ('2100', 'homer_rulz', 'homer_rulz', '', '[email protected]', '0', '', '1174283419', '0', '1174283396', '', '', '0', '', '', '', '', 'yes', '', '124.187.149.74', '124.187.149.74', '', '0', '----'),
    ('2101', 'huricane85_ipb2_import2105', 'huricane85_ipb2_import2105', '', '[email protected]', '0', '', '1174669795', '0', '1174319832', '', '', '0', '', '', '', '', 'yes', '', '193.54.215.253', '193.54.215.253', '', '0', '----'),
    ('2102', 'Drama Queen 1', 'Drama Queen 1', '', '[email protected]', '0', '', '1174335780', '0', '1174333563', '', '', '0', '', '', '', '', 'yes', '', '86.137.87.113', '86.137.87.113', '', '0', '1996-5-14'),
    ('2103', 'Aussie_pridez', 'Aussie_pridez', '', '[email protected]', '0', '', '1174374814', '0', '1174374779', '', '', '0', '', '', '', '', 'yes', '', '124.184.58.89', '124.184.58.89', '', '0', '1992-4-27'),
    ('2104', 'Pakaveli', 'Pakaveli', '', '[email protected]', '0', '', '1175555225', '0', '1175555204', '', '', '0', '', '', '', '', 'yes', '', '82.36.219.76', '82.36.219.76', '', '0', '----'),
    ('2105', 'kamoku', 'kamoku', '', '[email protected]', '0', '', '1175353692', '0', '1174426488', '', '', '0', '', '', '', '', 'yes', '', '213.22.156.150', '213.22.156.150', '', '0', '----'),
    ('2106', 'turlach', 'turlach', '', '[email protected]', '0', '', '1174446966', '0', '1174446938', '', '', '0', '', '', '', '', 'yes', '', '87.192.246.215', '87.192.246.215', '', '0', '----'),
    ('2107', 'lisine', 'lisine', '', '[email protected]', '3', '', '1175697917', '0', '1174481724', '', '', '0', '', '', '', '', 'yes', '', '147.91.173.31', '147.91.173.31', '', '0', '----'),
    ('2108', 'thesimpsonsmanic141', 'thesimpsonsmanic141', '', '[email protected]', '16', '', '1176254205', '0', '1174816318', '', '', '0', '', '', '', '', 'yes', '', '58.110.136.156', '58.110.136.156', '', '0', '----'),
    ('2109', 'aruku', 'aruku', '', '[email protected]', '0', '', '1174827518', '0', '1174827494', '', '', '0', '', '', '', '', 'yes', '', '155.232.128.10', '155.232.128.10', '', '0', '----'),
    ('2110', 'Alexness', 'Alexness', '', '[email protected]', '0', '', '1175346281', '0', '1174860004', '', '', '0', '', '', '', '', 'yes', '', '81.164.5.63', '81.164.5.63', '', '0', '----'),
    ('2111', 'dayday_ipb2_import2116', 'dayday_ipb2_import2116', '', '[email protected]', '0', '', '1177325392', '0', '1174903453', '', '', '0', '', '', '', '', 'yes', '', '88.106.186.212', '88.106.186.212', '', '0', '----'),
    ('2112', 'majora', 'majora', '', '[email protected]', '0', '', '1174954977', '0', '1174954961', '', '', '0', '', '', '', '', 'yes', '', '80.47.114.36', '80.47.114.36', '', '0', '----'),
    ('2113', 'Craig', 'Craig', '', '[email protected]', '1', '', '1175023640', '0', '1174937965', '', '', '0', '', '', '', '', 'yes', '', '24.187.130.93', '24.187.130.93', '', '0', '----'),
    ('2114', 'ravensedge', 'ravensedge', '', '[email protected]', '0', '', '1174950389', '0', '1174950368', '', '', '0', '', '', '', '', 'yes', '', '204.209.17.254', '204.209.17.254', '', '0', '1985-10-4'),
    ('2115', 'KarinaLG87', 'KarinaLG87', '', '[email protected]', '0', '', '1175037117', '0', '1174956892', 'http://', 'http://', '0', '', '', '', '', 'yes', '', '198.202.25.212', '198.202.25.212', '', '0', '1987-4-29'),
    ('2116', 'Xmell', 'Xmell', '', '[email protected]', '0', '', '1175084217', '0', '1175080786', '', '', '0', '', '', '', '', 'yes', '', '213.141.159.112', '213.141.159.112', '', '0', '----'),
    ('2117', 'juniorpassa', 'juniorpassa', '', '[email protected]', '0', '', '1175730084', '0', '1175018555', '', '', '0', '', '', '', '', 'yes', '', '68.36.83.193', '68.36.83.193', '', '0', '----'),
    ('2118', 'Craig_no27', 'Craig_no27', '', '[email protected]', '0', '', '1175220311', '0', '1175215976', '', '', '0', '', '', '', '', 'yes', '', '218.214.141.73', '218.214.141.73', '', '0', '----'),
    ('2119', 'harrymorrison', 'harrymorrison', '', '[email protected]', '0', '', '1175042015', '0', '1175041958', '', '', '0', '', '', '', '', 'yes', '', '62.252.0.7', '62.252.0.7', '', '0', '----'),
    ('2120', 'doroti', 'doroti', '', '[email protected]', '0', '', '1175173045', '0', '1175091112', '', '', '0', '', '', '', '', 'yes', '', '195.56.186.198', '195.56.186.198', '', '0', '----'),
    ('2121', 'fantabulacious', 'fantabulacious', '', '[email protected]', '0', '', '1175116115', '0', '1175116091', '', '', '0', '', '', '', '', 'yes', '', '12.193.224.21', '12.193.224.21', '', '0', '----'),
    ('2122', 'saldejums', 'saldejums', '', '[email protected]', '0', '', '1175194807', '0', '1175194789', '', '', '0', '', '', '', '', 'yes', '', '132.183.13.1', '132.183.13.1', '', '0', '----'),
    ('2123', 'absolon', 'absolon', '', '[email protected]', '0', '', '1175421667', '0', '1175271737', '', '', '0', '', '', '', '', 'yes', '', '218.186.10.11', '218.186.10.11', '', '0', '----'),
    ('2124', 'thatguywhoposts', 'thatguywhoposts', '', '[email protected]', '0', '', '1175276738', '0', '1175276376', '', '', '0', '', '', '', '', 'yes', '', '82.34.247.156', '82.34.247.156', '', '0', '----'),
    ('2125', 'Daniel_ipb2_import2125', 'Daniel_ipb2_import2125', '', '[email protected]', '0', '', '1175314238', '0', '1175314154', '', '', '0', '', '', '', '', 'yes', '', '125.237.40.98', '125.237.40.98', '', '0', '----'),
    ('2126', 'SpambotVersion2', 'SpambotVersion2', '', '[email protected]', '8', '', '1175406258', '0', '1175401351', '', '', '0', '', '', '', '', 'yes', '', '208.68.99.185', '208.68.99.185', '', '0', '----'),
    ('2127', 'chu_ri_su', 'chu_ri_su', '', '[email protected]', '0', '', '1175334042', '0', '1175333818', '', '', '0', '', '', '', '', 'yes', '', '60.52.178.218', '60.52.178.218', '', '0', '----'),
    ('2128', 'xxvikkixx', 'xxvikkixx', '', '[email protected]', '0', '', '1175354883', '0', '1175354703', '', '', '0', '', '', '', '', 'yes', '', '88.109.235.165', '88.109.235.165', '', '0', '----'),
    ('2129', 'ImwithInvaderButters', 'ImwithInvaderButters', '', '[email protected]', '13', '', '1175402035', '0', '1175402010', '', '', '0', '', '', '', '', 'yes', '', '68.205.64.97', '68.205.64.97', '', '0', '----'),
    ('2130', 'thaihung', 'thaihung', '', '[email protected]', '0', '', '1175414886', '0', '1175414792', '', '', '0', '', '', '', '', 'yes', '', '125.214.63.35', '125.214.63.35', '', '0', '----'),
    ('2131', 'MrBitter805', 'MrBitter805', '', '[email protected]', '0', '', '1175481616', '0', '1175481453', '', '', '0', '', '', '', '', 'yes', '', '207.200.116.70', '207.200.116.70', '', '0', '----'),
    ('2132', 'erikyates', 'erikyates', '', '[email protected]', '0', '', '1175455058', '0', '1175455030', '', '', '0', '', '', '', '', 'yes', '', '70.146.6.36', '70.146.6.36', '', '0', '----'),
    ('2133', 'KrustyBurgerLad', 'KrustyBurgerLad', '', '[email protected]', '0', '', '1175457727', '0', '1175457664', '', '', '0', '', '', '', '', 'yes', '', '74.235.213.164', '74.235.213.164', '', '0', '----'),
    ('2134', 'Phil K_ipb2_import2134', 'Phil K_ipb2_import2134', '', '[email protected]', '3', '', '1180008349', '0', '1175470040', 'http://', 'http://', '0', '', '', '', '', 'yes', '', '82.39.227.248', '82.39.227.248', '', '0', '1908-4-13'),
    ('2135', 'vvthanh', 'vvthanh', '', '[email protected]', '0', '', '1177325006', '0', '1175577820', '', '', '0', '', '', '', '', 'yes', '', '74.116.34.153', '74.116.34.153', '', '0', '----'),
    ('2136', 'tester', 'tester', '', '[email protected]', '2', '', '1175553114', '0', '1175485879', '', '', '0', '', '', '', '', 'yes', '', '24.195.161.215', '24.195.161.215', '', '0', '----'),
    ('2137', 'tulpa', 'tulpa', '', '[email protected]', '0', '', '1175595019', '0', '1175594994', '', '', '0', '', '', '', '', 'yes', '', '64.59.144.85', '64.59.144.85', '', '0', '----'),
    ('2138', 'theoneh', 'theoneh', '', '[email protected]', '0', '', '1175607798', '0', '1175607782', '', '', '0', '', '', '', '', 'yes', '', '194.112.196.135', '194.112.196.135', '', '0', '----'),
    ('2139', 'overlord13', 'overlord13', '', '[email protected]', '1', '', '1175634272', '0', '1175634244', '', '', '0', '', '', '', '', 'yes', '', '195.166.203.156', '195.166.203.156', '', '0', '----'),
    ('2140', 'theresalwaysanotherway', 'theresalwaysanotherway', '&
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on January 28, 2008, 08:36:51 PM
Are you using the converter in this topic?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: el canadiano on January 28, 2008, 08:42:04 PM
Of course. I was also getting Curiousgeo's error too, but took Fog's advice and that error was fixed.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on January 28, 2008, 09:34:56 PM
What is the exact error that you get?  Seems like it got cut off from the post. Just post the last part to the error.

What version of MyBB are you running?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: el canadiano on January 29, 2008, 09:49:45 AM
MyBB 1.2.10
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on January 29, 2008, 09:59:00 AM
Quote from: -AW- on January 28, 2008, 08:42:04 PM
Of course. I was also getting Curiousgeo's error too, but took Fog's advice and that error was fixed.
The converter in the first post should not give you that error.  I just downloaded it to double check and that line is not in the file.

I noticed that the password field is empty for the users that you posted.  What is the error that you are getting now?  I don't see the error since it got cut off.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: el canadiano on January 29, 2008, 10:32:44 AM
It was something about member 2001. Let me retry and see what's happening

EDIT: nvm, I got it fixed, thanks for SMF. Top free forum Software (though MyBB comes a close second)
EDIT: I have to do it again, cus it isn't working.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: el canadiano on January 30, 2008, 05:23:02 PM
BTW, the error was
Quote
INSERT INTO `stone_smf`.smf_members
(ID_MEMBER, memberName, realName, emailAddress, passwd, passwordSalt, posts, usertitle, lastLogin, ID_GROUP, dateRegistered, websiteUrl, websiteTitle, ICQ, AIM, YIM, MSN, signature, hideEmail, buddy_list, memberIP, memberIP2, pm_ignore_list, totalTimeLoggedIn, birthdate)
VALUES ('2062', 'Jibaro', 'Jibaro', '[email protected]', '', '[jR9m', '0', '', '1173221496', '0', '1173221451', '', '', '0', '', '', '', '', 'yes', '', '75.21.67.136', '75.21.67.136', '', '0', '----'),
('2063', 'sureshisgreat', 'sureshisgreat', '[email protected]', '', '7AfPD', '0', '', '1176763601', '0', '1173221638', '', '', '0', '', '', '', '', 'yes', '', '91.4.86.117', '91.4.86.117', '', '0', '----'),
('2064', 'Luminux', 'Luminux', '[email protected]', '', 'Ziv`o', '0', '', '1173756259', '0', '1173224779', '', '', '0', '', '', '', '', 'yes', '', '74.13.110.19', '74.13.110.19', '', '0', '----'),
('2065', 'lyrical_headspin', 'lyrical_headspin', '[email protected]', '', 'KIc\"d', '1', '', '1173333634', '0', '1173333607', '', '', '0', '', '', '', '', 'yes', '', '158.136.163.110', '158.136.163.110', '', '0', '----'),
('2066', 'webspinner', 'webspinner', '[email protected]', '', 'xGk*5', '0', '', '1173367632', '0', '1173367595', '', '', '0', '', '', '', '', 'yes', '', '72.1.206.12', '72.1.206.12', '', '0', '----'),
('2067', 'hollathina', 'hollathina', '[email protected]', '', 'cQZ>?', '0', '', '1173385799', '0', '1173385765', '', '', '0', '', '', '', '', 'yes', '', '82.152.204.39', '82.152.204.39', '', '0', '----'),
('2068', 'stokesg', 'stokesg', '[email protected]', '', ']d_xK', '0', '', '1173388551', '0', '1173388157', '', '', '0', '', '', '', '', 'yes', '', '62.253.128.12', '62.253.128.12', '', '0', '----'),
('2069', 'Brillig', 'Brillig', '[email protected]', '', 't*gwx', '3', '', '1174336859', '0', '1173388839', '', '', '0', '', '', '', '', 'yes', '', '72.54.129.226', '72.54.129.226', '', '0', '----'),
('2070', 'miki', 'miki', '[email protected]', '', '_mruR', '0', '', '1173451748', '0', '1173451661', '', '', '0', '', '', '', '', 'yes', '', '84.2.150.192', '84.2.150.192', '', '0', '----'),
('2071', 'bartinjapan', 'bartinjapan', '[email protected]', '', 'Tc-p8', '0', '', '1176988532', '0', '1173492760', '', '', '0', '', '', '', '', 'yes', '', '124.26.164.2', '124.26.164.2', '', '0', '----'),
('2072', 'forget.regret', 'forget.regret', '[email protected]', '', 'O&B\"R', '0', '', '1173518483', '0', '1173518458', '', '', '0', '', '', '', '', 'yes', '', '75.71.244.177', '75.71.244.177', '', '0', '----'),
('2073', 'oliversam123', 'oliversam123', '[email protected]', '', '-%}\'4', '0', '', '1173466610', '0', '1173466584', '', '', '0', '', '', '', '', 'yes', '', '82.36.105.112', '82.36.105.112', '', '0', '----'),
('2074', 'simpsonsfan102', 'simpsonsfan102', '[email protected]', '', '/^ynC', '0', '', '1173665982', '0', '1173665967', '', '', '0', '', '', '', '', 'yes', '', '209.162.47.60', '209.162.47.60', '', '0', '----'),
('2075', 'cooltown', 'cooltown', '[email protected]', '', 'cnt|K', '0', '', '1173561667', '0', '1173561603', '', '', '0', '', '', '', '', 'yes', '', '59.92.130.181', '59.92.130.181', '', '0', '----'),
('2076', 'K3vin', 'K3vin', '[email protected]', '', 'j2gWG', '0', '', '1175696514', '0', '1175696494', '', '', '0', '', '', '', '', 'yes', '', '84.99.7.210', '84.99.7.210', '', '0', '----'),
('2077', 'twingats54', 'twingats54', '[email protected]', '', ')jHJZ', '0', '', '1173669452', '0', '1173669418', '', '', '0', '', '', '', '', 'yes', '', '67.37.190.23', '67.37.190.23', '', '0', '----'),
('2078', 'flavinoska', 'flavinoska', '[email protected]', '', 'RA;9O', '0', '', '1173783192', '0', '1173674380', '', '', '0', '', '', '', '', 'yes', '', '82.240.203.4', '82.240.203.4', '', '0', '----'),
('2079', 'poiuytre', 'poiuytre', '[email protected]', '', '(ju6`', '0', '', '1173815740', '0', '1173748700', '', '', '0', '', '', '', '', 'yes', '', '84.196.242.33', '84.196.242.33', '', '0', '----'),
('2080', 'someone', 'someone', '[email protected]', '', '+nb9j', '0', '', '1177011811', '0', '1173693009', '', '', '0', '', '', '', '', 'yes', '', '88.105.54.217', '88.105.54.217', '', '0', '----'),
('2081', 'simpson boy', 'simpson boy', '[email protected]', '', ';ne\"H', '0', '', '1174070735', '0', '1174070700', '', '', '0', '', '', '', '', 'yes', '', '81.77.104.151', '81.77.104.151', '', '0', '----'),
('2082', 'Vaibhav007', 'Vaibhav007', '[email protected]', '', 'xhnFE', '0', '', '1173793410', '0', '1173793373', '', '', '0', '', '', '', '', 'yes', '', '59.178.83.202', '59.178.83.202', '', '0', '----'),
('2083', 'stappo', 'stappo', '[email protected]', '', 'UyyYh', '0', '', '1173819908', '0', '1173819883', '', '', '0', '', '', '', '', 'yes', '', '84.197.50.31', '84.197.50.31', '', '0', '----'),
('2084', 'nix', 'nix', '[email protected]', '', '`5ze^', '0', '', '1173835362', '0', '1173835329', '', '', '0', '', '', '', '', 'yes', '', '200.116.173.103', '200.116.173.103', '', '0', '----'),
('2085', 'jn1978', 'jn1978', '[email protected]', '', 'AeX7G', '0', '', '1173876389', '0', '1173876366', '', '', '0', '', '', '', '', 'yes', '', '82.233.53.142', '82.233.53.142', '', '0', '----'),
('2086', 'Jimbob2110', 'Jimbob2110', '[email protected]', '', '|VIVz', '0', '', '1173890450', '0', '1173889655', '', '', '0', '', '', '', '', 'yes', '', '86.7.64.178', '86.7.64.178', '', '0', '----'),
('2087', 'pyro666', 'pyro666', '[email protected]', '', '-\"S|(', '0', '', '1174209491', '0', '1173899947', '', '', '0', '', '', '', '', 'yes', '', '221.135.251.166', '221.135.251.166', '', '0', '----'),
('2088', 'BadCase', 'BadCase', '[email protected]', '', 'FS<|b', '0', '', '1173979335', '0', '1173979315', '', '', '0', '', '', '', '', 'yes', '', '70.190.147.10', '70.190.147.10', '', '0', '----'),
('2089', 'benj_au', 'benj_au', '[email protected]', '', '/!^^?', '0', '', '1174110501', '0', '1174110469', '', '', '0', '', '', '', '', 'yes', '', '203.214.147.224', '203.214.147.224', '', '0', '----'),
('2090', 'mcilroga', 'mcilroga', '[email protected]', '', '8-|^Y', '0', '', '1174016583', '0', '1174016571', '', '', '0', '', '', '', '', 'yes', '', '74.114.67.102', '74.114.67.102', '', '0', '----'),
('2091', 'NightTerrors', 'NightTerrors', '[email protected]', '', 'X-E2V', '0', '', '0', '0', '1174083639', '', '', '0', '', '', '', '', 'yes', '', '124.183.225.246', '124.183.225.246', '', '0', '----'),
('2092', 'ronroms', 'ronroms', '[email protected]', '', 'snv2G', '0', '', '1174088319', '0', '1174088308', '', '', '0', '', '', '', '', 'yes', '', '201.143.81.254', '201.143.81.254', '', '0', '----'),
('2093', 'Shen', 'Shen', '[email protected]', '', 'GL*rm', '0', '', '1174112043', '0', '1174111989', '', '', '0', '', '', '', '', 'yes', '', '74.241.165.226', '74.241.165.226', '', '0', '----'),
('2094', 'Version1', 'Version1', '[email protected]', '', 'IQ^Vv', '0', '', '1174145129', '0', '1174145102', '', '', '0', '', '', '', '', 'yes', '', '124.189.66.15', '124.189.66.15', '', '0', '----'),
('2095', 'maame_masr', 'maame_masr', '[email protected]', '', 'Q_jkS', '0', '', '1174156441', '0', '1174156422', '', '', '0', '', '', '', '', 'yes', '', '67.41.132.94', '67.41.132.94', '', '0', '----'),
('2096', 'doodster', 'doodster', '[email protected]', '', 'r(-&8', '0', '', '1174211082', '0', '1174211062', '', '', '0', '', '', '', '', 'yes', '', '194.42.116.11', '194.42.116.11', '', '0', '----'),
('2097', 'mekeskispas', 'mekeskispas', '[email protected]', '', 'sDZjI', '0', '', '1174248771', '0', '1174248746', '', '', '0', '', '', '', '', 'yes', '', '193.51.16.187', '193.51.16.187', '', '0', '----'),
('2098', 'HomerSimpson76-07', 'HomerSimpson76-07', '[email protected]', '', '1p#pV', '0', '', '1175805473', '0', '1174268339', '', '', '0', '', '', '', '', 'yes', '', '70.143.58.203', '70.143.58.203', '', '0', '----'),
('2100', 'homer_rulz', 'homer_rulz', '[email protected]', '', '^$%%<', '0', '', '1174283419', '0', '1174283396', '', '', '0', '', '', '', '', 'yes', '', '124.187.149.74', '124.187.149.74', '', '0', '----'),
('2102', 'Drama Queen 1', 'Drama Queen 1', '[email protected]', '', '!+)>[', '0', '', '1174335780', '0', '1174333563', '', '', '0', '', '', '', '', 'yes', '', '86.137.87.113', '86.137.87.113', '', '0', '1996-5-14'),
('2103', 'Aussie_pridez', 'Aussie_pridez', '[email protected]', '', 'mVBW/', '0', '', '1174374814', '0', '1174374779', '', '', '0', '', '', '', '', 'yes', '', '124.184.58.89', '124.184.58.89', '', '0', '1992-4-27'),
('2104', 'Pakaveli', 'Pakaveli', '[email protected]', '', 'osxU}', '0', '', '1175555225', '0', '1175555204', '', '', '0', '', '', '', '', 'yes', '', '82.36.219.76', '82.36.219.76', '', '0', '----'),
('2105', 'kamoku', 'kamoku', '[email protected]', '', '4br*e', '1', '', '1175353692', '0', '1174426488', '', '', '0', '', '', '', '', 'yes', '', '213.22.156.150', '213.22.156.150', '', '0', '----'),
('2106', 'turlach', 'turlach', '[email protected]', '', 'FZ;9M', '0', '', '1174446966', '0', '1174446938', '', '', '0', '', '', '', '', 'yes', '', '87.192.246.215', '87.192.246.215', '', '0', '----'),
('2107', 'lisine', 'lisine', '[email protected]', '', '{OE}E', '3', '', '1175697917', '0', '1174481724', '', '', '0', '', '', '', '', 'yes', '', '147.91.173.31', '147.91.173.31', '', '0', '----'),
('2108', 'thesimpsonsmanic141', 'thesimpsonsmanic141', '[email protected]', '', 'r{@Nm', '19', '', '1176254205', '0', '1174816318', '', '', '0', '', '', '', '', 'yes', '', '58.110.136.156', '58.110.136.156', '', '0', '----'),
('2109', 'aruku', 'aruku', '[email protected]', '', '*}qDL', '0', '', '1174827518', '0', '1174827494', '', '', '0', '', '', '', '', 'yes', '', '155.232.128.10', '155.232.128.10', '', '0', '----'),
('2110', 'Alexness', 'Alexness', '[email protected]', '', '0|<@P', '0', '', '1175346281', '0', '1174860004', '', '', '0', '', '', '', '', 'yes', '', '81.164.5.63', '81.164.5.63', '', '0', '----'),
('2112', 'majora', 'majora', '[email protected]', '', 'Xi`\"&', '0', '', '1174954977', '0', '1174954961', '', '', '0', '', '', '', '', 'yes', '', '80.47.114.36', '80.47.114.36', '', '0', '----'),
('2113', 'Craig', 'Craig', '[email protected]', '', 'lQ<TS', '1', '', '1175023640', '0', '1174937965', '', '', '0', '', '', '', '', 'yes', '', '24.187.130.93', '24.187.130.93', '', '0', '----'),
('2114', 'ravensedge', 'ravensedge', '[email protected]', '', '~EWl{', '0', '', '1174950389', '0', '1174950368', '', '', '0', '', '', '', '', 'yes', '', '204.209.17.254', '204.209.17.254', '', '0', '1985-10-4'),
('2115', 'KarinaLG87', 'KarinaLG87', '[email protected]', '', 'vVU?9', '1', '', '1175037117', '0', '1174956892', 'http://', 'http://', '0', '', '', '', '', 'yes', '', '198.202.25.212', '198.202.25.212', '', '0', '1987-4-29'),
('2116', 'Xmell', 'Xmell', '[email protected]', '', 'kr=UJ', '0', '', '1175084217', '0', '1175080786', '', '', '0', '', '', '', '', 'yes', '', '213.141.159.112', '213.141.159.112', '', '0', '----'),
('2117', 'juniorpassa', 'juniorpassa', '[email protected]', '', 'mn.F1', '0', '', '1175730084', '0', '1175018555', '', '', '0', '', '', '', '', 'yes', '', '68.36.83.193', '68.36.83.193', '', '0', '----'),
('2118', 'Craig_no27', 'Craig_no27', '[email protected]', '', '#Hr6\"', '0', '', '1175220311', '0', '1175215976', '', '', '0', '', '', '', '', 'yes', '', '218.214.141.73', '218.214.141.73', '', '0', '----'),
('2119', 'harrymorrison', 'harrymorrison', '[email protected]', '', 'J#>tx', '0', '', '1175042015', '0', '1175041958', '', '', '0', '', '', '', '', 'yes', '', '62.252.0.7', '62.252.0.7', '', '0', '----'),
('2120', 'doroti', 'doroti', '[email protected]', '', 'FWngJ', '0', '', '1175173045', '0', '1175091112', '', '', '0', '', '', '', '', 'yes', '', '195.56.186.198', '195.56.186.198', '', '0', '----'),
('2121', 'fantabulacious', 'fantabulacious', '[email protected]', '', 'Z4Liq', '0', '', '1175116115', '0', '1175116091', '', '', '0', '', '', '', '', 'yes', '', '12.193.224.21', '12.193.224.21', '', '0', '----'),
('2122', 'saldejums', 'saldejums', '[email protected]', '', '}+9ke', '0', '', '1175194807', '0', '1175194789', '', '', '0', '', '', '', '', 'yes', '', '132.183.13.1', '132.183.13.1', '', '0', '----'),
('2123', 'absolon', 'absolon', '[email protected]', '', '5d;!j', '0', '', '1175421667', '0', '1175271737', '', '', '0', '', '', '', '', 'yes', '', '218.186.10.11', '218.186.10.11', '', '0', '----'),
('2124', 'thatguywhoposts', 'thatguywhoposts', '[email protected]', '', '_Tk\'z', '0', '', '1175276738', '0', '1175276376', '', '', '0', '', '', '', '', 'yes', '', '82.34.247.156', '82.34.247.156', '', '0', '----'),
('2126', 'SpambotVersion2', 'SpambotVersion2', '[email protected]', '', 'a3O[>', '8', '', '1175406258', '0', '1175401351', '', '', '0', '', '', '', '', 'yes', '', '208.68.99.185', '208.68.99.185', '', '0', '----'),
('2127', 'chu_ri_su', 'chu_ri_su', '[email protected]', '', 'f]1b=', '0', '', '1175334042', '0', '1175333818', '', '', '0', '', '', '', '', 'yes', '', '60.52.178.218', '60.52.178.218', '', '0', '----'),
('2128', 'xxvikkixx', 'xxvikkixx', '[email protected]', '', 'k)ycS', '0', '', '1175354883', '0', '1175354703', '', '', '0', '', '', '', '', 'yes', '', '88.109.235.165', '88.109.235.165', '', '0', '----'),
('2129', 'ImwithInvaderButters', 'ImwithInvaderButters', '[email protected]', '', 'e!dO;', '13', '', '1175402035', '0', '1175402010', '', '', '0', '', '', '', '', 'yes', '', '68.205.64.97', '68.205.64.97', '', '0', '----'),
('2130', 'thaihung', 'thaihung', '[email protected]', '', '7S3Lq', '0', '', '1175414886', '0', '1175414792', '', '', '0', '', '', '', '', 'yes', '', '125.214.63.35', '125.214.63.35', '', '0', '----'),
('2131', 'MrBitter805', 'MrBitter805', '[email protected]', '', 'WO>`x', '0', '', '1175481616', '0', '1175481453', '', '', '0', '', '', '', '', 'yes', '', '207.200.116.70', '207.200.116.70', '', '0', '----'),
('2132', 'erikyates', 'erikyates', '[email protected]', '', 'K}IIy', '0', '', '1175455058', '0', '1175455030', '', '', '0', '', '', '', '', 'yes', '', '70.146.6.36', '70.146.6.36', '', '0', '----'),
('2133', 'KrustyBurgerLad', 'KrustyBurgerLad', '[email protected]', '', '#Ys.S', '0', '', '1175457727', '0', '1175457664', '', '', '0', '', '', '', '', 'yes', '', '74.235.213.164', '74.235.213.164', '', '0', '----'),
('2135', 'vvthanh', 'vvthanh', '[email protected]', '', '?\"h<;', '0', '', '1177325006', '0', '1175577820', '', '', '0', '', '', '', '', 'yes', '', '74.116.34.153', '74.116.34.153', '', '0', '----'),
('2136', 'tester', 'tester', '[email protected]', '', 'J}O]m', '2', '', '1175553114', '0', '1175485879', '', '', '0', '', '', '', '', 'yes', '', '24.195.161.215', '24.195.161.215', '', '0', '----'),
('2137', 'tulpa', 'tulpa', '[email protected]', '', 'VZ5y-', '0', '', '1175595019', '0', '1175594994', '', '', '0', '', '', '', '', 'yes', '', '64.59.144.85', '64.59.144.85', '', '0', '----'),
('2138', 'theoneh', 'theoneh', '[email protected]', '', '|ku:\"', '0', '', '1175607798', '0', '1175607782', '', '', '0', '', '', '', '', 'yes', '', '194.112.196.135', '194.112.196.135', '', '0', '----'),
('2139', 'overlord13', 'overlord13', '[email protected]', '', 'a6^9p', '1', '', '1175634272', '0', '1175634244', '', '', '0', '', '', '', '', 'yes', '', '195.166.203.156', '195.166.203.156', '', '0', '----'),
('2140', 'theresalwaysanotherway', 'theresalwaysanotherway', '[email protected]', '', 'am\'!z', '2', '', '1176244450', '0', '1175636046', '', '', '0', '', '', '', '', 'yes', '', '209.149.16.47', '209.149.16.47', '', '0', '----'),
('2141', 'xviper2k', 'xviper2k', '[email protected]', '', 'u{lYE', '0', '', '1175652063', '0', '1175652013', '', '', '0', '', '', '', '', 'yes', '', '68.202.139.212', '68.202.139.212', '', '0', '----'),
('2142', 'pansy', 'pansy', '******[email protected]', '', '=Icn~', '0', '', '1175679838', '0', '1175679827', '', '', '0', '', '', '', '', 'yes', '', '86.0.247.34', '86.0.247.34', '', '0', '----'),
('2143', 'Caesar', 'Caesar', '[email protected]', '', 'f|>?x', '0', '', '1175697202', '0', '1175697187', '', '', '0', '', '', '', '', 'yes', '', '84.151.235.74', '84.151.235.74', '', '0', '----'),
('2144', 'homerdies', 'homerdies', '[email protected]', '', ':l]xH', '0', '', '1175705453', '0', '1175705428', '', '', '0', '', '', '', '', 'yes', '', '81.84.12.15', '81.84.12.15', '', '0', '----'),
('2145', 'simpsonsmad', 'simpsonsmad', '[email protected]', '', 'UPQWH', '0', '', '1175711073', '0', '1175711047', '', '', '0', '', '', '', '', 'yes', '', '172.189.179.156', '172.189.179.156', '', '0', '----'),
('2146', 'quackspanner', 'quackspanner', '[email protected]', '', 'JU]$u', '0', '', '1175724229', '0', '1175724205', '', '', '0', '', '', '', '', 'yes', '', '217.44.215.248', '217.44.215.248', '', '0', '----'),
('2147', 'niall_23', 'niall_23', '[email protected]', '', '.Fb=j', '0', '', '1175758300', '0', '1175758263', '', '', '0', '', '', '', '', 'yes', '', '58.178.60.70', '58.178.60.70', '', '0', '----'),
('2148', 'Jadams805', 'Jadams805', '[email protected]', '', '[l4&p', '0', '', '1176437703', '0', '1175759665', '', '', '0', '', '', '', '', 'yes', '', '69.231.48.237', '69.231.48.237', '', '0', '----'),
('2149', 'The_Gambler', 'The_Gambler', '[email protected]', '', 'tdJV}', '0', '', '1180128593', '0', '1175770073', '', '', '0', '', '', '', '', 'yes', '', '80.186.125.93', '80.186.125.93', '', '0', '1989-3-23'),
('2150', 'lordrayden11', 'lordrayden11', '[email protected]', '', '?_kRJ', '1', '', '1175814218', '0', '1175773229', '', '', '0', '', '', '', '', 'yes', '', '220.239.159.193', '220.239.159.193', '', '0', '----'),
('2151', 'bloodygutsmurphy', 'bloodygutsmurphy', '[email protected]', '', 'v;m_2', '0', '', '1175777098', '0', '1175776048', '', '', '0', '', '', '', '', 'yes', '', '194.80.238.40', '194.80.238.40', '', '0', '----'),
('2152', 'tokyoknights', 'tokyoknights', '[email protected]', '', 'iVwWE', '0', '', '1175786294', '0', '1175786262', '', '', '0', '', '', '', '', 'yes', '', '60.229.61.151', '60.229.61.151', '', '0', '----'),
('2153', 'manchester united', 'manchester united', '[email protected]', '', 'u{$e\'', '0', '', '1176202759', '0', '1175787108', '', '', '0', '', '', '', '', 'yes', '', '168.213.1.134', '168.213.1.134', '', '0', '----'),
('2154', 'FatalRemedy', 'FatalRemedy', '[email protected]', '', 'kz+hB', '0', '', '1175790845', '0', '1175790229', '', '', '0', '', '', '', '', 'yes', '', '74.103.85.181', '74.103.85.181', '', '0', '----'),
('2155', 'rocari09', 'rocari09', '[email protected]', '', '7k3j|', '0', '', '1175830510', '0', '1175830340', '', '', '0', '', '', '', '', 'yes', '', '200.21.65.154', '200.21.65.154', '', '0', '----'),
('2156', 'jiws88', 'jiws88', '[email protected]', '', '#7VKG', '0', '', '1175992274', '0', '1175962122', '', '', '0', '', '', '', '', 'yes', '', '203.79.252.193', '203.79.252.193', '', '0', '----'),
('2157', 'jerm', 'jerm', '[email protected]', '', 'u[o60', '0', '', '1175843012', '0', '1175842928', '', '', '0', '', '', '', '', 'yes', '', '211.31.87.180', '211.31.87.180', '', '0', '----'),
('2158', 'ASSMAN', 'ASSMAN', '[email protected]', '', 'aeZl/', '0', '', '1175851907', '0', '1175851869', '', '', '0', '', '', '', '', 'yes', '', '58.178.3.132', '58.178.3.132', '', '0', '----'),
('2159', 'cao9317', 'cao9317', '[email protected]', '', 'fO]du', '0', '', '1175906447', '0', '1175905777', '', '', '0', '', '', '', '', 'yes', '', '200.120.147.133', '200.120.147.133', '', '0', '----'),
('2160', 'superman', 'superman', '[email protected]', '', '10YEO', '0', '', '1180115196', '0', '1175880602', '', '', '0', '', '', '', '', 'yes', '', '202.133.71.55', '202.133.71.55', '', '0', '----'),
('2161', 'bigkris', 'bigkris', '[email protected]', '', '0{LI]', '0', '', '1176247864', '0', '1175911247', '', '', '0', '', '', '', '', 'yes', '', '24.96.111.163', '24.96.111.163', '', '0', '----'),
('2162', 'CARLOS', 'CARLOS', '[email protected]', '', '_{qU]', '0', '', '1176015212', '0', '1176015194', '', '', '0', '', '', '', '', 'yes', '', '189.174.64.30', '189.174.64.30', '', '0', '----'),
('2163', 'simpsonstube', 'simpsonstube', '[email protected]', '', 'fmRr`', '2', '', '1179903863', '0', '1175943078', '', '', '0', '', '', '', '', 'yes', '', '144.137.46.185', '144.137.46.185', '', '0', '1993-4-14'),
('2164', 'best member', 'best member', '[email protected]', '', 'Br/:L', '3', '', '1180135735', '0', '1176083655', '', '', '0', '', '', '', '', 'yes', '', '71.139.42.142', '71.139.42.142', '', '0', '----'),
('2165', 'fluffynut racoontree', 'fluffynut racoontree', '[email protected]', '', ']&d^9', '7', '', '1176234001', '0', '1176047367', '', '', '0', '', '', '', 'oo ya (http://www.fetopia.net/signature/simpsons.jpg)', 'yes', '', '24.62.146.153', '24.62.146.153', '', '0', '----'),
('2166', 'Tobias', 'Tobias', '[email protected]', '', 'e}W|W', '12', '', '1180671628', '0', '1176055867', '', '', '0', '', '', '[email protected]', '', 'yes', '', '80.217.81.121', '80.217.81.121', '', '0', '1994-5-7'),
('2167', 'rossrobinson1987', 'rossrobinson1987', '[email protected]', '', 'D?9mx', '0', '', '1177512200', '0', '1176056365', '', '', '0', '', '', '', '', 'yes', '', '82.19.27.32', '82.19.27.32', '', '0', '----'),
('2168', 'Smilis', 'Smilis', '[email protected]', '', '+A[H6', '0', '', '1176062454', '0', '1176062448', '', '', '0', '', '', '', '', 'yes', '', '84.217.74.203', '84.217.74.203', '', '0', '----'),
('2169', 'clandestine_chick', 'clandestine_chick', '[email protected]', '', 'q1j.|', '0', '', '1176189643', '0', '1176179636', '', '', '0', '', '', '', '<span style=\"font-family:Impact\">I love I love I love BlessTheFall (http://www.myspace.com/blessthefall)!!!!<!--fontc--><!--/fontc--><!--sizec--></span><!--/sizec-->', 'yes', '', '71.139.200.129', '71.139.200.129', '', '0', '----'),
('2170', 'daexorcist', 'daexorcist', '[email protected]', '', 'z9R-j', '0', '', '1176137182', '0', '1176137163', '', '', '0', '', '', '', '', 'yes', '', '128.239.155.187', '128.239.155.187', '', '0', '----'),
('2171', 'Bartoman22', 'Bartoman22', '[email protected]', '', '|he<\'', '1', '', '1180456977', '0', '1176147405', '', '', '0', '', '', '', '', 'yes', '', '88.107.218.76', '88.107.218.76', '', '0', '----'),
('2172', 'deadbadger', 'deadbadger', '[email protected]', '', 'wNY-}', '0', '', '1176152183', '0', '1176152148', '', '', '0', '', '', '', '', 'yes', '', '217.44.215.248', '217.44.215.248', '', '0', '----'),
('2173', 'giffy', 'giffy', '[email protected]', '', 'c];U3', '1', '', '1176154073', '0', '1176154060', '', '', '0', '', '', '', '', 'yes', '', '69.156.1.78', '69.156.1.78', '', '0', '----'),
('2174', 'meghansfriend', 'meghansfriend', '[email protected]', '', 'bRZoi', '0', '', '1176163776', '0', '1176163582', '', '', '0', '', '', '', '', 'yes', '', '72.226.71.31', '72.226.71.31', '', '0', '----'),
('2175', 'marceloln', 'marceloln', '[email protected]', '', ']rCt2', '0', '', '0', '0', '1176339658', '', '', '0', '', '', '', '', 'yes', '', '201.17.39.201', '201.17.39.201', '', '0', '----'),
('2176', 'qdqqqq', 'qdqqqq', '[email protected]', '', '&fqrU', '0', '', '1176205323', '0', '1176205289', '', '', '0', '', '', '', '', 'yes', '', '221.0.142.62', '221.0.142.62', '', '0', '----'),
('2177', 'Homer94', 'Homer94', '[email protected]', '', '+PA2J', '0', '', '1176248268', '0', '1176246940', '', '', '0', '', '', '', '', 'yes', '', '74.103.234.117', '74.103.234.117', '', '0', '----'),
('2178', 'Dan_Yankees', 'Dan_Yankees', '[email protected]', '', 'jKt]U', '0', '', '1176258312', '0', '1176257688', '', '', '0', '', '', '', '', 'yes', '', '24.161.110.100', '24.161.110.100', '', '0', '----'),
('2179', 'bob_141', 'bob_141', '[email protected]', '', 'CWX41', '0', '', '1176261581', '0', '1176261546', '', '', '0', '', '', '', '', 'yes', '', '58.110.136.156', '58.110.136.156', '', '0', '----'),
('2180', 'piloto-43', 'piloto-43', '[email protected]', '', 'G]|$-', '2', '', '1176445437', '0', '1176304458', '', '', '0', '', '', '', '', 'yes', '', '190.40.42.13', '190.40.42.13', '', '0', '----'),
('2181', 'fulltimecasual', 'fulltimecasual', '[email protected]', '', '\"b(l6', '0', '', '1176387499', '0', '1176385013', '', '', '0', '', '', '', '', 'yes', '', '220.233.9.164', '220.233.9.164', '', '0', '----'),
('2182', 'deepak.stoic', 'deepak.stoic', '[email protected]', '', ']L2|7', '0', '', '1176387853', '0', '1176387530', '', '', '0', '', '', '', '', 'yes', '', '202.141.145.38', '202.141.145.38', '', '0', '----'),
('2183', 'KIM', 'KIM', '[email protected]', '', '$Fh`F', '0', '', '1176415550', '0', '1176414749', '', '', '0', '', '', '', '', 'yes', '', '81.106.22.99', '81.106.22.99', '', '0', '----'),
('2184', 'shortguy', 'shortguy', '[email protected]', '', 'g*g0;', '0', '', '1176416432', '0', '1176416401', '', '', '0', '', '', '', '', 'yes', '', '81.79.194.253', '81.79.194.253', '', '0', '----'),
('2185', 'James 2007', 'James 2007', '[email protected]', '', '~-kuI', '0', '', '1176460126', '0', '1176460080', '', '', '0', '', '', '', '', 'yes', '', '58.178.73.231', '58.178.73.231', '', '0', '----'),
('2187', 'kian2112', 'kian2112', '[email protected]', '', '$DOco', '0', '', '1176485689', '0', '1176485654', '', '', '0', '', '', '', '', 'yes', '', '155.69.5.236', '155.69.5.236', '', '0', '----'),
('2188', 'coolguy111', 'coolguy111', '[email protected]', '', 'tC-[!', '16', '', '1177893536', '0', '1176835801', '', '', '0', '', '', '', '', 'yes', '', '64.30.77.179', '64.30.77.179', '', '0', '----'),
('2189', 'hugz', 'hugz', '[email protected]', '', 'zAHp?', '0', '', '1176494613', '0', '1176494277', '', '', '0', '', '', '', '', 'yes', '', '67.82.133.130', '67.82.133.130', '', '0', '----'),
('2190', 'HpseoJ', 'HpseoJ', '[email protected]', '', 'Mr>}m', '0', '', '1176504106', '0', '1176498654', '', '', '0', '', '', '', '', 'yes', '', '80.177.167.71', '80.177.167.71', '', '0', '----'),
('2191', 'Mr Smee', 'Mr Smee', '[email protected]', '', '&xmL~', '0', '', '1176886524', '0', '1176552195', 'http://www.google.co.uk', 'http://www.google.co.uk', '0', '???', '???', '???', '(http://lnx.ginevra2000.it/Disney/peterpan1/smee.gif)
<span style=\"color:#000000\">Reggae Reggae Sauce!(tastes so nice I had to name it twice)
', 'yes', '', '62.253.48.108', '62.253.48.108', '', '0', '1994-1-1'),
('2192', 'adam', 'adam', '[email protected]', '', '=<+[+', '6', '', '1177780190', '0', '1176552244', '', '', '0', '', '', '', '(http://users.on.net/~abwolf/turds/nohomers.gif) (http://www.lardlad.com)', 'yes', '', '121.44.68.31', '121.44.68.31', '', '0', '----'),
('2193', 'CyPhUr', 'CyPhUr', '[email protected]', '', ']hPH_', '0', '', '0', '0', '1176580457', '', '', '0', '', '', '', '', 'yes', '', '74.111.152.101', '74.111.152.101', '', '0', '----'),
('2195', 'mmm_aggressive', 'mmm_aggressive', '[email protected]', '', '4q_%b', '0', '', '1176843107', '0', '1176724501', '', '', '0', '', '', '', '', 'yes', '', '217.228.91.151', '217.228.91.151', '', '0', '----'),
('2196', 'Derflanner', 'Derflanner', '[email protected]', '', 'EsFl}', '0', '', '1176736752', '0', '1176734934', '', '', '0', '', '', '', '', 'yes', '', '81.157.193.214', '81.157.193.214', '', '0', '----'),
('2197', 'superkirby', 'superkirby', '[email protected]', '', 'PYF\';', '0', '', '1176770738', '0', '1176770703', '', '', '0', '', '', '', '', 'yes', '', '75.6.231.205', '75.6.231.205', '', '0', '----'),
('2198', 'untouchable', 'untouchable', '[email protected]', '', '_m3uJ', '0', '', '1176737203', '0', '1176737194', '', '', '0', '', '', '', '', 'yes', '', '68.39.78.61', '68.39.78.61', '', '0', '----'),
('2199', 'Punkgal', 'Punkgal', '[email protected]', '', 'K|1nO', '0', '', '1176771123', '0', '1176771092', '', '', '0', '', '', '', '', 'yes', '', '203.26.16.66', '203.26.16.66', '', '0', '----'),
('2201', 'zoltain73', 'zoltain73', '[email protected]', '', 'lK[l/', '0', '', '1176810480', '0', '1176810453', '', '', '0', '', '', '', '', 'yes', '', '196.25.255.194', '196.25.255.194', '', '0', '----'),
('2202', 'digitus', 'digitus', '[email protected]', '', ']_X1W', '0', '', '1176914707', '0', '1176914693', '', '', '0', '', '', '', '', 'yes', '', '200.155.38.1', '200.155.38.1', '', '0', '----'),
('2203', 'Trae', 'Trae', '[email protected]', '', 'ghG~6', '1', '', '1176930250', '0', '1176930235', '', '', '0', '', '', '', '', 'yes', '', '75.58.152.198', '75.58.152.198', '', '0', '----'),
('2204', 'pank', 'pank', '[email protected]', '', '?t3!R', '0', '', '1176937962', '0', '1176937950', '', '', '0', '', '', '', '', 'yes', '', '24.1.49.167', '24.1.49.167', '', '0', '----'),
('2205', 'eh3', 'eh3', '[email protected]', '', 'e6rx4', '8', '', '1177030456', '0', '1177023694', '', '', '0', '', '', '', '', 'yes', '', '66.90.73.41', '66.90.73.41', '', '0', '----'),
('2206', 'Elbarto', 'Elbarto', '[email protected]', '', '\'*JAi', '0', '', '1177047115', '0', '1177047075', '', '', '0', '', '', '', '', 'yes', '', '202.67.67.45', '202.67.67.45', '', '0', '----'),
('2207', 'The Homega Man', 'The Homega Man', '[email protected]', '', 'Mq\'ry', '0', '', '1177063921', '0', '1177063457', '', '', '0', '', '', '', '', 'yes', '', '58.69.54.51', '58.69.54.51', '', '0', '----'),
('2208', 'x03x', 'x03x', '[email protected]', '', 'p5Fg|', '0', '', '1177166790', '0', '1177087175', '', '', '0', '', '', '', '', 'yes', '', '208.109.89.43', 
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on January 30, 2008, 05:52:29 PM
Still cutting off the actual error.  Just post the LAST part of the error.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: el canadiano on January 30, 2008, 05:53:57 PM
It's long :S
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Gary on January 30, 2008, 09:37:56 PM
AW, don't post the whole thing, as Jay, just the end will do (there should be some more inserts and a query that it's trying to run).

That or put the code into a txt and attach it. :P
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Faisal Shah on February 04, 2008, 02:15:48 PM
Quote from: JayBachatero on January 24, 2007, 11:57:28 AM
Software: MyBB
Version: 1.2.x

This is the official support topic for MyBB converter.  Use this topic to ask for support for this converter.

Changelog
! When converting users also convert the passwordSalt. (mybb12_to_smf.sql)
! Typo
! logTime is no longer used (mybb12_to_smf.sql)
! When converting polls make sure that questions column has an alias. (mybb12_to_smf.sql)
! Updated converter to convert attachments. (mybb12_to_smf.sql)
! When converting attachments and it's an image add the width and height for it. (mybb12_to_smf.sql)
! Cast $width and $height as a string or else it wont return a value if the file is not an image. (mybb12_to_smf.sql)

convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.

Well. I WAN\T to use the converter!
Please tell me what what things i need to use this stuff??
I mean this convert.php and that sql file thats it?
Or i have to install a SMF and MyBB before running conversion??

I AM waiting for answer!

THANKS
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on February 04, 2008, 02:42:14 PM
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: roguevalleyforums on February 10, 2008, 01:00:38 AM
Thanks for the great program, I have converted all successfully, however the passwords don't convert for some reason.  In looking at the user tables for SMF, it has carried the password hash over, but if I try to log in, it won't let me. 

I am using Mybb 1.2.12.   With the most recent converters posted through this thread and the sql table converter file as well.

EDIT: Funny thing - if I paste the password hash into the password box, it lets me in. 

Any ideas?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: roguevalleyforums on February 12, 2008, 12:54:45 AM
Any answers to my above post?  It has been a couple of days.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on February 12, 2008, 01:27:39 AM
Is the salt field blank for SMF?  If not try emptying it.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: roguevalleyforums on February 12, 2008, 10:04:39 AM
It is empty for everyone else but mine.  I had logged in with the original password hash in the table and it let me in so literally "4fd79e0e2bca4755757ecfd3a2e13aec"  (test account no worries on exposure) let me in when logging in, instead of usual password.  So, after I got in under my account, I changed it in the control panel through SMF to a regular password.  So, mine has a Salt entry. 

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: roguevalleyforums on February 14, 2008, 07:53:57 PM
BUMP
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on February 15, 2008, 12:54:13 AM
Umm I wonder if they changed their password encryption method.  I'll take a look at it and see if they did.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: alwa7eed on February 23, 2008, 05:45:38 PM
after convert all topic like ?????????????

http://www.bloo2th.info/smf/
what this error
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on February 26, 2008, 04:02:05 AM
Means that the database connection info is incorrect.  Use repair_settings.php and put in the correct info.
What is repair_settings.php? (http://www.simplemachines.org/community/index.php?topic=18096.0)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: jinji55 on March 16, 2008, 10:26:17 AM
When I'm trying to convert the mybb forum it apears me:
"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 `zmelcu1`.myf_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"
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on March 16, 2008, 10:03:06 PM
Use the file in the first post.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: adil09 on March 21, 2008, 04:35:55 PM
When I try to convert I get this:

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...Duplicate entry '11-0-1' for key 1

Even if I untick all that poll stuff I still get the same message. And when I go to the forum, the members are converted but there are no categories, boards and topics. Any suggestions?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on March 24, 2008, 01:24:18 AM
Did you use the .sql file from this topic?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: kgt400 on March 27, 2008, 02:13:07 PM
I'm using the latest converter.php and sql file but still getting this error:
Please help me!



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 `d60476576`.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
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on April 01, 2008, 03:01:44 PM
http://www.simplemachines.org/community/index.php?action=dlattach;topic=145191.0;attach=28148
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: kgt400 on April 04, 2008, 11:45:45 AM
Now it gives this error:


Converting topics... Unsuccessful!
This query:

    SELECT
    t.tid AS ID_TOPIC, t.fid AS ID_BOARD, t.sticky AS isSticky,
    t.poll AS ID_POLL, t.views AS numViews, t.uid AS ID_MEMBER_STARTED,
    ul.uid AS ID_MEMBER_UPDATED, t.replies AS numReplies, t.closed AS locked,
    MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG
    FROM (`d60476576`.mybb_threads AS t, `d60476576`.mybb_posts AS p)
    LEFT JOIN `d60476576`.mybb_users AS ul ON (BINARY ul.username = t.lastposter)
    WHERE p.tid = t.tid
    GROUP BY t.tid
    HAVING ID_FIRST_MSG != 0
    AND ID_LAST_MSG != 0
    LIMIT 500, 500;

Caused the error:

    The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on April 04, 2008, 11:51:24 AM
Open the .sql file and change this line.

Code (find) Select
LEFT JOIN {$from_prefix}users AS ul ON (BINARY ul.username = t.lastposter)
Code (replace) Select
LEFT JOIN {$from_prefix}users AS ul ON (ul.username = t.lastposter)

Give it a shot and see.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: kgt400 on April 04, 2008, 03:04:12 PM
Quote from: JayBachatero on April 04, 2008, 11:51:24 AM
Open the .sql file and change this line.

Code (find) Select
LEFT JOIN {$from_prefix}users AS ul ON (BINARY ul.username = t.lastposter)
Code (replace) Select
LEFT JOIN {$from_prefix}users AS ul ON (ul.username = t.lastposter)

Give it a shot and see.

it worked...
thanks.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on April 05, 2008, 08:13:22 PM
I noticed that doing a BINARY check on it doesn't use indexes correctly and slowing thing down miserably.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: roguevalleyforums on April 05, 2008, 10:03:41 PM
I am getting this error:

Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `rogueval_mybb`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2



Any ideas?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: roguevalleyforums on April 05, 2008, 10:24:33 PM
OK,

Got it to work.

I had to go into the convert.php file and look for step 9 and then follow the directions in the below link. :)

http://docs.simplemachines.org/index.php?topic=1079.0;wap

converted fine and all, user avatars didn't nor did their permissions, but that is a small price to pay.  Great work on the script.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: nghiemhuy on April 13, 2008, 08:24:19 AM
I've got this error:

QuoteNotice: Undefined index: charsets in /home/****/public_html/****/convert.php on line 378

then:

QuoteConverting...
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes...Duplicate entry '2-30-1' for key 1


then the script stopped

Can you please let me know how can I solve this problem?

Thank you so much
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on April 13, 2008, 02:54:38 PM
nghiemhuy,

Are you using the convert.php in the first post of this topic?
http://www.simplemachines.org/community/index.php?topic=140741.0

The poll votes is saying that some member has voted twice in a poll
If I remember right the index goes (poll id, member id, choice). So it would seem your second poll and member of id of 30 voiced for choice 1 two times.
You can fix this by going into your phpbb database and removing the duplicate vote option.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: ninhanh on April 20, 2008, 07:33:46 AM
I'm getting an error of:

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... Successful.
Converting attachments...
Notice: getimagesize() [function.getimagesize]: Read error! in D:\xampp\htdocs\smf\convert.php(827) : eval()'d code on line 27

Notice: getimagesize() [function.getimagesize]: Read error! in D:\xampp\htdocs\smf\convert.php(827) : eval()'d code on line 27

Notice: getimagesize() [function.getimagesize]: Read error! in D:\xampp\htdocs\smf\convert.php(827) : eval()'d code on line 27

Notice: getimagesize() [function.getimagesize]: Read error! in D:\xampp\htdocs\smf\convert.php(827) : eval()'d code on line 27

Notice: getimagesize() [function.getimagesize]: Read error! in D:\xampp\htdocs\smf\convert.php(827) : eval()'d code on line 27

Notice: getimagesize() [function.getimagesize]: Read error! in D:\xampp\htdocs\smf\convert.php(827) : eval()'d code on line 27
Successful.
Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `teen`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2



help me !!
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on April 20, 2008, 12:41:43 PM
The first error is saying that it can't read the images to correctly size them.
We can ignore that one for now and try this script after we complete the conversion:
http://www.simplemachines.org/community/index.php?topic=187532.0

For the other one:
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: ninhanh on April 20, 2008, 01:55:53 PM
i use mybb 1.2.12; i convert to SMF 1.1.4
I'm getting an error of:

Converting topics... Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:

    INSERT INTO `kem`.smf_messages
    (ID_MSG, ID_TOPIC, ID_BOARD, ID_MEMBER, posterName, posterTime, posterIP, subject, posterEmail, smileysEnabled, modifiedName, modifiedTime, body, icon)
    VALUES ('9922', '472', '41', '833', 'ngaybinhyen', '1204028096', '203.160.1.45', 'Chiến Dịch Ä'iện Biên Phủ', '[email protected]', '1', '', '0', 'Trận Điện Biên Phủ là trận Ä'ánh lá»›n nhất [3] trong Chiến tranh Đông DÆ°Æ¡ng lần thứ nhất diá»...n ra tại lòng chảo Mường Thanh, châu Điện Biên (nay là thà nh phá»' Điện Biên Phủ), tỉnh Lai Châu (nay tách thà nh tỉnh Điện Biên) giữa quân Ä'á»™i Pháp và Quân Ä'á»™i Nhân dân Việt Nam. Đây là chiến thắng quân sá»± lá»›n nhất trong cuá»™c kháng chiến chá»'ng Pháp 1945 â€" 1954 của Việt Nam.

    Trên phÆ°Æ¡ng diện quá»'c tế, trận nà y có má»™t ý nghÄ©a rất lá»›n: lần Ä'ầu tiên quân Ä'á»™i của má»™t nÆ°á»›c thuá»™c Ä'ịa châu Á Ä'ánh thắng bằng quân sá»± má»™t quân Ä'á»™i của má»™t cường quá»'c châu Ã,u. Trận Điện Biên Phủ Ä'ã Ä'ánh bại ý chí duy trì thuá»™c Ä'ịa Đông DÆ°Æ¡ng của Pháp và buá»™c nÆ°á»›c nà y ra khỏi Đông DÆ°Æ¡ng.

    Các kế hoạch của hai bên dẫn Ä'ến trận Điện Biên Phủ
    Đến cuá»'i năm 1953, Chiến tranh Đông DÆ°Æ¡ng Ä'ã kéo dà i 8 năm, Pháp Ä'ã mệt mỏi và muá»'n tìm má»™t giải pháp hòa bình có thể chấp nhận Ä'ược Ä'ể chấm dứt cuá»™c chiến nhÆ°ng mặt khác họ muá»'n duy trì quyền lợi tại Đông DÆ°Æ¡ng. Pháp bổ nhiệm tổng chỉ huy Henri Navarre sang Đông DÆ°Æ¡ng tìm kiếm má»™t chiến thắng quân sá»± quyết Ä'ịnh Ä'ể là m cÆ¡ sở cho má»™t cuá»™c thảo luận hòa bình trên thế mạnh. Kế hoạch của bá»™ chỉ huy Pháp tại Đông DÆ°Æ¡ng gá»"m hai bÆ°á»›c:

    BÆ°á»›c thứ nhất: Thu Ä'ông 1953 và xuân 1954 giữ thế phòng ngá»± ở miền Bắc và thá»±c hiện tấn công chiến lược tại miền Trung và miền Nam.
    BÆ°á»›c thứ hai: Chuyển từ phòng ngá»± sang tấn công chiến lược ở phía Bắc Ä'ể tiêu diệt chủ lá»±c của Việt Minh.
    Để thá»±c hiện kế hoạch nà y Pháp cho tiến hà nh xây dá»±ng và tập trung lá»±c lượng cÆ¡ Ä'á»™ng lá»›n, mở rá»™ng quân Ä'á»™i bản Ä'ịa, cà n quét bình Ä'ịnh vùng kiểm soát. Thá»±c hà nh tấn công chiến lược ở vùng Khu V., Navarre Ä'ược nhà nÆ°á»›c Pháp cấp thêm cho 9 tiểu Ä'oà n tinh nhuệ. Viện trợ Mỹ tăng vọt, chiếm Ä'ại Ä'a sá»' chi phí chiến tranh.
    Thôi mệt quá rá»"i anh Ä'à nh phanh bút ở Ä'ây. Chà o em và yêu em nhiều, chúc em gặp nhiều ác má»™ng, anh sẽ hiện ra Ä'ể cùng em chạy trá»'n.', 'xx'),
    ('9771', '516', '51', '82', 'pe_vjp_9x', '1203986410', '203.160.1.45', 'Bức thÆ° hoà nh tráng wa\' ^^^', '[email protected]', '1', '', '0', '[img]http://i93.photobucket.com/albums/l55/tuandinh_haiduong2/Thuguiem.jpg[/img]
    po\' tay vá»›i Anh chà ng nà y ^
    [url=http://i93.photobucket.com/albums/l55/tuandinh_haiduong2/Thuguiem.jpg][/url]', 'xx'),
    ('9913', '516', '51', '82', 'pe_vjp_9x', '1204026127', '203.160.1.45', 'Bức thÆ° hoà nh tráng wa\' ^^^', '[email protected]', '1', '', '0', '[quote=anhchang_dethuong]hê.hình nhÆ° Ä'ây là bức thÆ° anh viết cho em mà Oanh.sao lai pót lên diá»...n dà n thế kia :D:D:D[/quote]
    ạc
    ji` thế Anh long ^?
    phét ko biết Ä'ường mà phét ?
    ........
    nói ji` mà ^??...?? ác zu~ ?', 'xx'),
    ('9777', '516', '51', '787', 'anhchang_dethuong', '1203992878', '203.160.1.45', 'Bức thÆ° hoà nh tráng wa\' ^^^', '[email protected]', '1', '', '0', 'hê.hình nhÆ° Ä'ây là bức thÆ° anh viết cho em mà Oanh.sao lai pót lên diá»...n dà n thế kia :D:D:D', 'xx'),
    ('9929', '516', '51', '787', 'anhchang_dethuong', '1204028648', '203.160.1.45', 'Bức thÆ° hoà nh tráng wa\' ^^^', '[email protected]', '1', '', '0', 'hê.không nhá»› sao em.hay sợ mọi người trêu lên không dám nhận ah:D:D', 'xx'),
    ('9780', '516', '51', '790', 'vip_hoang_k_ninh', '1203996282', '203.162.3.148', 'Bức thÆ° hoà nh tráng wa\' ^^^', '[email protected]', '1', '', '0', 'chà ng nà o viet thÆ° ngá»™ thế nhỉ
    hà i wa
    viet thÆ° theo kiểm muá»'n ăn Ä'ấm Ä'ây mà haaaaaaaaaaa', 'xx'),
    ('9772', '516', '51', '838', 'ßaßyGhost', '1203989220', '203.160.1.45', 'Bức thÆ° hoà nh tráng wa\' ^^^', '[email protected]', '1', '', '0', 'hà i wa\' búc thÆ° kiểu ???? mà lại thế nhỉ', 'xx'),
    ('10324', '517', '62', '92', 'Anh_Duy8x', '1204418930', '203.160.1.45', 'ai là SV thì nhà o vô', '[email protected]', '1', '', '0', 'Rau muá»'ng 15.000 Ä'á»"ng/má»›, bắp cải 8.000 Ä'á»"ng/kg, cải ngọt 13-15.000 Ä'á»"ng/kg, su hà o 4.000/củ
    Bắp cải 12.000 Ä'á»"ng/kg má»›i lên giá rùi.
    Cứ Ä'à nà y thì lấy Ä'âu ra tiền tiêu vặt', 'xx'),
    ('10320', '517', '62', '124', 'zoro_bka', '1204412339', '58.187.132.207', 'ai là SV thì nhà o vô', '[email protected]', '1', '', '0', 'hic , Ä'úng rá»"i , rau Ä'ắt lắm , ở nhà là 2k / 3 củ su hà o , trên nay là 3k.../1 củ , 12k 1 cái bắp cải , hic , Ä'ắt gần bằng tiền thức ăn rá»"i', 'xx');

Caused the error:

    MySQL server has gone away


Please help me ! Big Thanks !! :)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on April 21, 2008, 01:46:59 PM
Contact your host and ask them about this issue.  Also use the UTF-8 converter in the sticky on this board.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: ninhanh on April 24, 2008, 07:51:25 AM
thanks Jaybachatero , but i use XAMPP in localhost. i use UTF8 - converter but I've got this error;

     MySQL server has gone away

Thanks !!
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Oldiesmann on April 24, 2008, 02:54:30 PM
It could be that the "wait_timeout" setting is too low. This setting tells MySQL how many seconds it should wait for a response from the server before killing the connection.

Open up your my.ini file (refer to the XAMPP documentation to find the location of this file) and add this to it:

wait_timeout = 300

Save the changes and restart MySQL (again, refer to XAMPP docs for info on how to do this), then try the conversion again.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: ninhanh on April 25, 2008, 08:35:11 AM
please view image in post; i can't covert ... please help me !
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: JayBachatero on April 25, 2008, 10:26:21 AM
Copy and paste the output from the conversion.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: ninhanh on April 30, 2008, 09:30:44 AM
thanks JayBachatero, no error !! :D
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: osgeld on May 12, 2008, 01:10:25 AM
all i get is a 500 server error

any ideas?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on May 12, 2008, 12:23:40 PM
Are you trying to access the convert.php?
Are you sure the permissions for the files are correct?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: osgeld on May 12, 2008, 07:04:21 PM
i have no trouble accessing the convert.php script, i put in all the correct info and let it run, after about 5 min on step one it comes back with a 500

i also thought it might be permissions so i changed EVERYTHING to 777 (its ok this is not the production site)

now last time i attempted this it was about 3 months ago, and it worked for the most part just loosing user avatars, 3 months later, same server, same setup, even the same silly board, i get a 500
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on May 12, 2008, 10:16:37 PM
Well the error 500 is a error generated by the server saying something went wrong internally.

Do you have access to the apache error logs or is your host able to see what information is being logged when you get this error 500
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: osgeld on May 12, 2008, 11:23:50 PM
well i have access to some logs from my hosting company, nothing worth while tho, just some link errors from outside sites

only other thought is turning off fast cgi and going back to php4, any effect?

if its the worst case and i have to pull this down to my local computer (which sucks cause my upload speed has been useless this week yay 4kb instead of 30) what would be the most optimal server environment for these scripts to perform best? (not smf i have that covered, but these 2 scripts convert.php and *.sql)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on May 12, 2008, 11:37:33 PM
That may work. It is a server error so tweaking with the server settings might get it going.

I am guessing you have cpanel and are looking at the error log area? This wouldn't have the error.
The php error log might have it if those are logged. Such as:
[10-Feb-2008 14:37:20] PHP Fatal error:  Function name must be a string in /Functions.php on line 63

The key word is the fatal error or similar that makes it sound really bad :P
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: osgeld on May 13, 2008, 12:16:29 AM
no nothing fatal, and i have this instance pulled outside of the cloud (its not public) and i see nothing pointing to my "work" directory

it would be quite obvious url/forum vs url/me_working/smf/

im going to monkey with the php settings to see if it makes a difference in conversion (it takes a huge hit on the production site but at this time noone is around)

~and~

im going to call up my host in the morning and see if i cant get a log dump of my server, they are pretty nice and willing over the phone heh

btw thank you very much for trying to help me on this problem
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on May 13, 2008, 12:28:10 AM
You are welcome.
Without seeing the error I can only shoot in the dark and guess what might be wrong :(

Hopefully you can figure it out or get an error log message that tells why it happened.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: osgeld on May 16, 2008, 12:30:14 AM
ok fast cgi was the cause of the 500 error (i was not able to get the exact log)
but now, after a few min i get

Quote from: mysite
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Server shutdown in progress

it doesnt go from there (nor does it shut down the server as the error states)

but atleast im making progress heh
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on May 16, 2008, 01:54:31 PM
wow, server shutting down.
Everything I found in search is pointing to mysql.

Do you have a way you can try this conversion locally?
This would put you more in control of the conversion and would hopefully pt the host out of the problem area.

You can simply make backups and import them between your live site and local site during the conversion and that would work.

If you can't we could try to reduce the number of topics it is converting at once and see if that helps.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: osgeld on May 17, 2008, 07:08:50 PM
ok so tried locally, same thing, except it didnt say it was shutting down

i thought maby its smf1.1.5 so i downloaded and installed smf 1.1.4 same results

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on May 17, 2008, 09:11:54 PM
You received the error 500 this time as well?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: osgeld on May 17, 2008, 10:20:37 PM
sorry no

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...

and dies
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on May 18, 2008, 01:16:16 AM
Try this one out and see if it provides better luck.
I turned it down to only do 200 topics at a time.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: osgeld on May 19, 2008, 12:16:34 AM
same thing, even acts the same way

im going to try on a php 4 system, thats about the only thing left
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on May 19, 2008, 01:17:43 AM
If that fails are you willing to let me take a try at it? It would be nice to have some ftp access at least to see what I can do with the script to try and make it work. If your ok with it, please pm the details, we don't want that info public :P
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: osgeld on May 19, 2008, 10:49:40 PM
under php 4 i get this error

Quote
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

    SELECT
    t.tid AS ID_TOPIC, t.fid AS ID_BOARD, t.sticky AS isSticky,
    t.poll AS ID_POLL, t.views AS numViews, t.uid AS ID_MEMBER_STARTED,
    ul.uid AS ID_MEMBER_UPDATED, t.replies AS numReplies, t.closed AS locked,
    MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG
    FROM (`cheesefa_irs`.mybb_threads AS t, `cheesefa_irs`.mybb_posts AS p)
    LEFT JOIN `cheesefa_irs`.mybb_users AS ul ON (BINARY ul.username = t.lastposter)
    WHERE p.tid = t.tid
    GROUP BY t.tid
    HAVING ID_FIRST_MSG != 0
    AND ID_LAST_MSG != 0
    LIMIT 0, 500;

Caused the error:

    Server shutdown in progress

but hey at least its an error!
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on May 19, 2008, 11:07:23 PM
If you copy that query and try to run it via the SQL tab in phpMyAdmin, does it give the same error?

If you open the .sql file and find:
---* {$to_prefix}topics
Does replacing it with the below code and trying the conversion again help?
---* {$to_prefix}topics 100


Edit, the above find code might have a 200 after it if you used the one I linked to in the download.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: osgeld on May 19, 2008, 11:58:34 PM
using your sql file the server cuts off much quicker with

Quote
Converting topics... Unsuccessful!
This query:

    SELECT
    t.tid AS ID_TOPIC, t.fid AS ID_BOARD, t.sticky AS isSticky,
    t.poll AS ID_POLL, t.views AS numViews, t.uid AS ID_MEMBER_STARTED,
    ul.uid AS ID_MEMBER_UPDATED, t.replies AS numReplies, t.closed AS locked,
    MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG
    FROM (`cheesefa_irs`.mybb_threads AS t, `cheesefa_irs`.mybb_posts AS p)
    LEFT JOIN `cheesefa_irs`.mybb_users AS ul ON (BINARY ul.username = t.lastposter)
    WHERE p.tid = t.tid
    GROUP BY t.tid
    HAVING ID_FIRST_MSG != 0
    AND ID_LAST_MSG != 0
    LIMIT 200, 200;

Caused the error:

    Server shutdown in progress

using the sql file at the top of the thread goes for quite a while (it actually told me "incomplete" and to press the button before it died)
Quote
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

    SELECT
    t.tid AS ID_TOPIC, t.fid AS ID_BOARD, t.sticky AS isSticky,
    t.poll AS ID_POLL, t.views AS numViews, t.uid AS ID_MEMBER_STARTED,
    ul.uid AS ID_MEMBER_UPDATED, t.replies AS numReplies, t.closed AS locked,
    MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG
    FROM (`cheesefa_irs`.mybb_threads AS t, `cheesefa_irs`.mybb_posts AS p)
    LEFT JOIN `cheesefa_irs`.mybb_users AS ul ON (BINARY ul.username = t.lastposter)
    WHERE p.tid = t.tid
    GROUP BY t.tid
    HAVING ID_FIRST_MSG != 0
    AND ID_LAST_MSG != 0
    LIMIT 1500, 500;

Caused the error:

    The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

just incase you were wondering
Quote
Our members have made a total of 12,021 posts in 1,583 threads.
We currently have 10,498 members registered.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on May 20, 2008, 02:08:16 AM
Can you change the mysql settings?
You could set the max_join_size to something bigger and have it allow this

I haven't dug into it, but I am wanting to make the convert.php in the future try to allow big selects by setting it at the start of the conversion and when it detects the error.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: osgeld on May 20, 2008, 02:30:03 AM
the max_join_size is already reporting as 100,000,000
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on May 20, 2008, 05:44:28 PM
Am I able to give this a try and see what i can come up with to get it to convert?

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: osgeld on May 20, 2008, 08:25:53 PM
yea ill set you up on my test server
the production site isnt mine, and only has php 5 which this does not seem to like at all, besides all these errors have been with my site anyway, using php 4(again the production site just dies with no error message on php 5)

again i consider getting an error a step forward

anywho keep an eye out for a PM
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: saab on June 08, 2008, 10:10:56 AM
Hello,
I am trying to convert from mybb 1.2.13 to SMF 1.1.5,
Thanks to your big help I could convert members but I got following error in second tap of converting process:


Converting members... Successful.
Converting categories... Unsuccessful!
This query:

    INSERT INTO `xxxx_smfxxx`.smf_categories
    (ID_CAT, name, catOrder)
    VALUES ('1', '????? ?? ???????', '1'),
    ('5', ' ????? ????? ???????', '2'),
    ('9', '????? ????? ? ????? ??????', '3'),
    ('12', '????? ?????', '4'),
    ('27', '????? ???? dvb', '5'),
    ('33', '????? ????????', '6'),
    ('39', '????? ??????', '28'),
    ('43', '????? ???', '29'),
    ('50', '????? ??????', '35'),
    ('59', '????? ? ??????? ?????????', '7'),
    ('291', ' ????? ??????? ????? ??????? ??', '8'),
    ('307', '????? ??????? ????? ?????????', '9'),
    ('314', '????? ?????(?????)', '30');

Caused the error:

    Duplicate entry '255' for key 1

May you help me please continuing convertion and come to Great SMF Community?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: saab on June 08, 2008, 10:14:29 AM
Hello,
I am trying to convert from mybb 1.2.13 to SMF 1.1.5,
Thanks to your big help I could convert members but I got following error in second tap of converting process:

Converting members... Successful.
Converting categories... Unsuccessful!
This query:

    INSERT INTO `xxxx_smfxxx`.smf_categories
    (ID_CAT, name, catOrder)
    VALUES ('1', '????? ?? ???????', '1'),
    ('5', ' ????? ????? ???????', '2'),
    ('9', '????? ????? ? ????? ??????', '3'),
    ('12', '????? ?????', '4'),
    ('27', '????? ???? dvb', '5'),
    ('33', '????? ????????', '6'),
    ('39', '????? ??????', '28'),
    ('43', '????? ???', '29'),
    ('50', '????? ??????', '35'),
    ('59', '????? ? ??????? ?????????', '7'),
    ('291', ' ????? ??????? ????? ??????? ??', '8'),
    ('307', '????? ??????? ????? ?????????', '9'),
    ('314', '????? ?????(?????)', '30');

Caused the error:

    Duplicate entry '255' for key 1


May you help me please continuing convertion and come to Great SMF Community?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on June 08, 2008, 01:18:07 PM
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)

I added it to the common conversion errors page.
I am going to work on writing up a script to also fix the categories ids to prevent possible future upgrade issues. Which would basically recount them using lower values.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: scan06disk on June 10, 2008, 09:05:24 AM
Hi,

I am getting this error what must i do...? Thank You ! :)
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user '[s]asudgausdg[/s]'@'localhost' for table 'mybb_users'


Regards,
Scanny 8)


Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on June 10, 2008, 12:20:06 PM
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: scan06disk on June 11, 2008, 07:36:19 AM
Thank You ! All fixed :D You Guys ROCK ! :D
If you have time check out my website ;)

http://www.jatsim.com

Regards,
Scanny
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: juliocqw on June 27, 2008, 12:49:36 PM
Hello Im getting the following error while trying to convert MyBB to SMF:

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 `nextgrul_meg`.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


Can anyone help to solve this problem?

Thanks!
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: 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,
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: juliocqw on June 27, 2008, 01:53:02 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,

Thanks a lot, SleePy. I made the change and ran the converter again. The initial problem was solved but now I get the following error:

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Unsuccessful!
This query:
INSERT INTO `nextgrul_meg`.smf_polls
(ID_POLL, SUBSTRING(p.question, 1, 255), votingLocked, ID_MEMBER, expireTime, posterName)
VALUES ('1', 'Do you find handy the proposed file\'s nomenclature?', 'no', '5', '0', 'karol');
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 'SUBSTRING(p.question, 1, 255), votingLocked, ID_MEMBER, expireTime, posterName)
' at line 2


I wonder if you or someone else could give me a hand to fix that.
Thanks again!
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on June 27, 2008, 01:55:20 PM
Give this file a try:
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: juliocqw on June 27, 2008, 02:28:15 PM
Quote from: SleePy on June 27, 2008, 01:55:20 PM
Give this file a try:

I used the other .sql file and I still got some errors, but I was able to make the SMF work with the MyBB data.

I think I will leave it like that!

Thanks again!
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Gene Steinberg on June 27, 2008, 08:16:24 PM
One down, one to go:

Got one working, but another MyBB board presents:

Notice: Undefined index: table_prefix in /home/rockoids/public_html/forum/convert.php(398) : eval()'d code on line 1

Can I get some direct help on this? Maybe someone can send me a PM on this subject -- the board has about 80-90 messages.

Peace,
Gene
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on June 28, 2008, 01:08:34 AM
Gene,

Did you specify the correct path the the mybb board?
the table_prefix is a variable from the configuration file in mybb that tells us the prefix of the tables.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Hime on June 28, 2008, 08:31:29 AM
Converting members... Unsuccessful!
This query:

    ALTER TABLE `dotnxtc_dbmybb`.smf_members
    CHANGE COLUMN passwordSalt passwordSalt varchar(8) NOT NULL default '';

Caused the error:

    Unknown column 'passwordSalt' in 'smf_members'


Any help please!
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on June 28, 2008, 01:32:37 PM
What version of SMF are you using?

It is telling me that the column is missing, which it shouldn't be if you are using SMF 1.1.
SMF 2.0 converters are not out yet.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Hime on June 28, 2008, 03:10:28 PM
Quote from: SleePy on June 28, 2008, 01:32:37 PM
What version of SMF are you using?

It is telling me that the column is missing, which it shouldn't be if you are using SMF 1.1.
SMF 2.0 converters are not out yet.

that explains everything....I have to roll back...

thanks.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Limer 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.

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'
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on June 30, 2008, 10:29:55 PM
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;

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Limer 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

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: ThorstenE 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..
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Limer 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?

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]
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: ThorstenE 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
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Limer 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!
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: ThorstenE on July 01, 2008, 10:45:51 AM
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.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Limer on July 01, 2008, 01:55:00 PM
IT WORKED !!!!! Thanks!!!

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: ThorstenE 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

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy 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.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Limer 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!!!

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: ThorstenE on July 01, 2008, 02:20:20 PM
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]


Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Limer on July 01, 2008, 02:41:30 PM
Thanks guys ...everything is 100% The support here on SMF has been amazing!!!
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: mutevekkil on July 04, 2008, 04:14:46 PM
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 !!
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: 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,
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: blackbiLL on July 05, 2008, 06:26:04 AM
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. ;)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on July 05, 2008, 01:59:13 PM
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 :)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: blackbiLL on July 06, 2008, 04:46:21 AM
Very well. Thanks a lot!  ;)

I converted phpbb3 in myBB and myBB in SMF!

THANKS! ;)
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: mutevekkil on August 04, 2008, 10:35:25 AM
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 !
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: maritimesbob on August 31, 2008, 05:28:06 PM
I`m test converting a mybb 1.2 board to smf 1.1.5, however the topic conversion is failing with the following error:

Duplicate entry '1015' for key 1
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: ThorstenE on September 01, 2008, 01:24:53 AM
maybe you are using the version from the download-page (outdated version)? try the one attached in the first post of this topic.. if this doesn't solve your problem you can edit the mybb12_to_smf.sql and place

---* {$to_prefix}topics

with


---* {$to_prefix}topics
---{
$ignore = true;
---}



after changing restart conversion.

Title: Re: [SMF Converter] MyBB 1.2.x
Post by: fgtec on March 20, 2009, 07:53:19 AM
Hi,

iam getting error
Converting posts (this may take some time)... Unsuccessful!
This query:

(long text)

Duplicate entry '10129' for key 1
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: SleePy on March 20, 2009, 06:13:03 PM
You have a duplicate message in your MyBB database. This is throwing errors for SMF when it tries to insert it into its database (As it doesn't like duplicate ids).

If you go into your MyBB database, Then the posts table. Do a search on pid equaling "10129".

You will come up with more than 1 result. You will need to decide which one you want to keep, and what other one you want to delete.
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Techdomain on April 03, 2009, 05:47:07 PM
is there a way to go from mybb 1.4 to smf?
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Gary on April 03, 2009, 05:53:53 PM
By using the MyBB 1.4 Converter from the download page: http://download.simplemachines.org/?converters
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Techdomain on April 03, 2009, 07:19:42 PM
thanks!
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: mosmankoc on January 03, 2010, 03:00:03 PM
Valla arkadaşlar ben sizin anlattıklarınızdan birşey anlamış değilim SMF nin bu destek hiç hoşuma Gitmiyor işte.Ben mybb 1.4.11 kullanıyorum smf ye geçmek istiyorum doğru dürüst bir anlatım bulamadım bu konuda bana yardımcı olabilecek varmı acaba.Konuları geziyorumda rahat geçtim bilmem ne ya bunlara gerek yokki geçmiş Isen izah et şöyle yaptım böyle yaptım anlatta hiç olmazsa ihtiyacı olan uygulasın değilmi.
Valla ben SMF ye geçmek istiyorum ve desteklerinizi bekliyorum
Title: Re: [SMF Converter] MyBB 1.2.x
Post by: Gary on January 03, 2010, 03:30:42 PM
Please use English when outside of the language boards. If English is not your first language, post in English as best you can, or consult with the Turkish language mods for help in translating.