News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

[SMF Converter] MyBB 1.2.x

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

Previous topic - Next topic

JayBachatero

Updated converter to convert password salts.
Follow me on Twitter

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

mark25

i need some help..

Field 'lngfile' doesn't have a default value

JayBachatero

Follow me on Twitter

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

ChaosZero112

I keep getting the same error:

Duplicate entry '16777215' for key 1

Liski

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

a_mulia

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

CSpili

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

EximTrak

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?

suye

I have the same problem as CSpili, anybody could help us?

Liski

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

spit

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

EximTrak

#31
I can't convert topics. Everything is ok but while converting topics the server doesn't answer :S

EximTrak

Topics can not be converted. Can anyone check the codes please?

Obi-Wahn

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


EximTrak

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 ;)

Obi-Wahn

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", ....


Obi-Wahn


marines

#38
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 "ż"

SleePy

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

Advertisement: