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.
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
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
Ok updated the converter. It now converts attachments as well.
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
Updated it.
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'
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.
still the same error
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.
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
Ok updated it. Should work now.
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
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
everything is working like a charm to me now. Thx
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
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
Is There Any Body Here!?!?!
Please Help Me!!!
Are you using the most recent convert.php file?
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!!!!!
Updated converter to convert password salts.
i need some help..
Field 'lngfile' doesn't have a default value
What table is this column in?
I keep getting the same error:
Duplicate entry '16777215' for key 1
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
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
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
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?
I have the same problem as CSpili, anybody could help us?
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
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
I can't convert topics. Everything is ok but while converting topics the server doesn't answer :S
Topics can not be converted. Can anyone check the codes please?
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
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 ;)
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", ....
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 ;)
Thanks, it works.
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 "ż"
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.
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?
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
Can we convert banned members?
You mean set the banned status for those members that are banned? If so I'll look and see how MyBB handles it.
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..
Ok added to the todo list.
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
What can I do, any ideas ? :(
Try to use the latest convert.php and mybb12_to_smf.sql ;)
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 ?
http://www.simplemachines.org/community/index.php?action=dlattach;topic=145191.0;attach=28148
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.
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
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.
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 :)
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.
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'
Successfully converted :D
I wasnt using the latest convert.php :) :D
www.rc-forums.co.uk
marc25v what permission is the file set to? Also who is your host?
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.
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.
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
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.
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
Are you using the converter in this topic?
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.
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).
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
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?
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?
Do an explain on the queries and post the results here.
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
I hope that means more to you than it does to me. :)
Is there more information I can get you?
Seems like it's not using any keys. Can you PM me access to phpMyAdmin?
Sent you a PM.
Alright I'll take a look at it in a bit. What version of MyBB are you exactly using?
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', '&
Are you using the converter in this topic?
Of course. I was also getting Curiousgeo's error too, but took Fog's advice and that error was fixed.
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?
MyBB 1.2.10
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.
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.
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',
Still cutting off the actual error. Just post the LAST part of the error.
It's long :S
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
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
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
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?
Any answers to my above post? It has been a couple of days.
Is the salt field blank for SMF? If not try emptying it.
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.
BUMP
Umm I wonder if they changed their password encryption method. I'll take a look at it and see if they did.
after convert all topic like ?????????????
http://www.bloo2th.info/smf/
what this error
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)
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"
Use the file in the first post.
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?
Did you use the .sql file from this topic?
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
http://www.simplemachines.org/community/index.php?action=dlattach;topic=145191.0;attach=28148
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
Open the .sql file and change this line.
LEFT JOIN {$from_prefix}users AS ul ON (BINARY ul.username = t.lastposter)
LEFT JOIN {$from_prefix}users AS ul ON (ul.username = t.lastposter)
Give it a shot and see.
Quote from: JayBachatero on April 04, 2008, 11:51:24 AM
Open the .sql file and change this line.
LEFT JOIN {$from_prefix}users AS ul ON (BINARY ul.username = t.lastposter)
LEFT JOIN {$from_prefix}users AS ul ON (ul.username = t.lastposter)
Give it a shot and see.
it worked...
thanks.
I noticed that doing a BINARY check on it doesn't use indexes correctly and slowing thing down miserably.
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?
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.
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
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.
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 !!
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)
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 !! :)
Contact your host and ask them about this issue. Also use the UTF-8 converter in the sticky on this board.
thanks Jaybachatero , but i use XAMPP in localhost. i use UTF8 - converter but I've got this error;
MySQL server has gone away
Thanks !!
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.
please view image in post; i can't covert ... please help me !
Copy and paste the output from the conversion.
thanks JayBachatero, no error !! :D
all i get is a 500 server error
any ideas?
Are you trying to access the convert.php?
Are you sure the permissions for the files are correct?
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
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
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)
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
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
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.
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
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.
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
You received the error 500 this time as well?
sorry no
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...
and dies
Try this one out and see if it provides better luck.
I turned it down to only do 200 topics at a time.
same thing, even acts the same way
im going to try on a php 4 system, thats about the only thing left
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
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!
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.
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.
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.
the max_join_size is already reporting as 100,000,000
Am I able to give this a try and see what i can come up with to get it to convert?
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
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?
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?
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.
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)
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Thank You ! All fixed :D You Guys ROCK ! :D
If you have time check out my website ;)
http://www.jatsim.com
Regards,
Scanny
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!
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,
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 2I wonder if you or someone else could give me a hand to fix that.
Thanks again!
Give this file a try:
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!
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
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.
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!
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.
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.
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'
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;
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
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..
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]
This one shoud work (tested localy)
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
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!
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.
IT WORKED !!!!! Thanks!!!
Try this (put htaccess in smf-directory)
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
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.
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!!!
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:
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]
Thanks guys ...everything is 100% The support here on SMF has been amazing!!!
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 !!
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,
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. ;)
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 :)
Very well. Thanks a lot! ;)
I converted phpbb3 in myBB and myBB in SMF!
THANKS! ;)
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 !
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
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.
Hi,
iam getting error
Converting posts (this may take some time)... Unsuccessful!
This query:
(long text)
Duplicate entry '10129' for key 1
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.
is there a way to go from mybb 1.4 to smf?
By using the MyBB 1.4 Converter from the download page: http://download.simplemachines.org/?converters
thanks!
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
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.