News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

[SMF Converter] MyBB 1.2.x

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

Previous topic - Next topic

adil09

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?

JayBachatero

Did you use the .sql file from this topic?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

kgt400

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

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

kgt400

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

JayBachatero

Open the .sql file and change this line.

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

Give it a shot and see.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

kgt400

Quote from: JayBachatero on April 04, 2008, 11:51:24 AM
Open the .sql file and change this line.

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

Give it a shot and see.

it worked...
thanks.

JayBachatero

I noticed that doing a BINARY check on it doesn't use indexes correctly and slowing thing down miserably.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

roguevalleyforums

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?

roguevalleyforums

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.

nghiemhuy

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

SleePy

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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

ninhanh

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 !!

SleePy

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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

ninhanh

#114
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 !! :)

JayBachatero

Contact your host and ask them about this issue.  Also use the UTF-8 converter in the sticky on this board.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

ninhanh

thanks Jaybachatero , but i use XAMPP in localhost. i use UTF8 - converter but I've got this error;

     MySQL server has gone away

Thanks !!

Oldiesmann

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.
Michael Eshom
Christian Metal Fans

ninhanh

please view image in post; i can't covert ... please help me !

JayBachatero

Copy and paste the output from the conversion.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Advertisement: