Advertisement:

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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] MyBB 1.2.x
« Reply #20 on: February 26, 2007, 07:14:38 PM »
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

Offline mark25

  • Semi-Newbie
  • *
  • Posts: 53
    • RoCkRuLZ OnLiNe
Re: [SMF Converter] MyBB 1.2.x
« Reply #21 on: March 24, 2007, 08:15:34 AM »
i need some help..

Field 'lngfile' doesn't have a default value

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] MyBB 1.2.x
« Reply #22 on: March 26, 2007, 10:32:43 AM »
What table is this column in?
Follow me on Twitter

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

Offline ChaosZero112

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] MyBB 1.2.x
« Reply #23 on: May 07, 2007, 07:32:53 PM »
I keep getting the same error:

Duplicate entry '16777215' for key 1

Liski

  • Guest
Re: [SMF Converter] MyBB 1.2.x
« Reply #24 on: May 15, 2007, 06:51:50 AM »
I'm getting

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

Offline a_mulia

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] MyBB 1.2.x
« Reply #25 on: May 24, 2007, 03:52:41 AM »
Hi Jay,

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

Thanks in advance

Abi

Offline CSpili

  • Newbie
  • *
  • Posts: 5
  • Gender: Male
Re: [SMF Converter] MyBB 1.2.x
« Reply #26 on: June 04, 2007, 05:10:56 AM »
Jay, I'm getting this error:

Converting members... Unsuccessful!
This query:

    SELECT
    uid AS ID_MEMBER, SUBSTRING(username, 1, 255) AS memberName,
    SUBSTRING(username, 1, 255) AS realName,
    SUBSTRING(password, 1, 64) AS passwd, email AS emailAddress,
    postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
    lastvisit AS lastLogin, IF(usergroup = 4, 1, 0) AS ID_GROUP,
    regdate AS dateRegistered, SUBSTRING(website, 1, 255) AS websiteUrl,
    SUBSTRING(website, 1, 255) AS websiteTitle,
    SUBSTRING(icq, 1, 255) AS ICQ, SUBSTRING(aim, 1, 16) AS AIM,
    SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hideEmail,
    SUBSTRING(buddylist, 1, 255) AS buddy_list,
    SUBSTRING(regip, 1, 255) AS memberIP, SUBSTRING(regip, 1, 255) AS memberIP2,
    SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
    timeonline AS totalTimeLoggedIn,
    IF(birthday = '', '0001-01-01', CONCAT_WS('-', RIGHT(birthday, 4), SUBSTRING(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), LEFT(birthday, LOCATE('-', birthday) - 1))) AS birthdate
    FROM `test_mybb`.mybb_users
    LIMIT 0, 500;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS MSN, 1, 255) AS MSN,
    SUBSTRING(signature, 1, 65534) AS signa

After I try to convert from MyBB 1.2.7 to SMF 1.1.2 using latest convert.php and db

Offline EximTrak

  • Semi-Newbie
  • *
  • Posts: 33
  • Gender: Male
    • ForumExi
Re: [SMF Converter] MyBB 1.2.x
« Reply #27 on: June 15, 2007, 04:18:19 PM »
I write both of the forum directories and error in second step :( The page cannot be shown. I am waiting more and see this error.

How can I fix this?
www.forumexi.com
admin@forumexi.com

Offline suye

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] MyBB 1.2.x
« Reply #28 on: June 21, 2007, 08:48:43 AM »
I have the same problem as CSpili, anybody could help us?

Liski

  • Guest
Re: [SMF Converter] MyBB 1.2.x
« Reply #29 on: June 24, 2007, 12:01:43 AM »
Converting members... Unsuccessful!
This query:

    SELECT
    uid AS ID_MEMBER, SUBSTRING(username, 1, 255) AS memberName,
    SUBSTRING(username, 1, 255) AS realName,
    SUBSTRING(password, 1, 64) AS passwd, email AS emailAddress,
    postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
    lastvisit AS lastLogin, IF(usergroup = 4, 1, 0) AS ID_GROUP,
    regdate AS dateRegistered, SUBSTRING(website, 1, 255) AS websiteUrl,
    SUBSTRING(website, 1, 255) AS websiteTitle,
    SUBSTRING(icq, 1, 255) AS ICQ, SUBSTRING(aim, 1, 16) AS AIM,
    SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hideEmail,
    SUBSTRING(buddylist, 1, 255) AS buddy_list,
    SUBSTRING(regip, 1, 255) AS memberIP, SUBSTRING(regip, 1, 255) AS memberIP2,
    SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
    timeonline AS totalTimeLoggedIn,
    IF(birthday = '', '0001-01-01', CONCAT_WS('-', RIGHT(birthday, 4), SUBSTRING(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), LEFT(birthday, LOCATE('-', birthday) - 1))) AS birthdate
    FROM `liskico_liski`.mybb_users
    LIMIT 0, 500;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS MSN, 1, 255) AS MSN,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail ' at line 10

Offline spit

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] MyBB 1.2.x
« Reply #30 on: July 09, 2007, 06:53:48 PM »
From 1.2.8:

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Converting topic view logs... Successful.
Converting attachments... Successful.
Recalculating forum statistics... Unsuccessful!
This query:

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

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LENGTH(code) DESC' at line 2

Offline EximTrak

  • Semi-Newbie
  • *
  • Posts: 33
  • Gender: Male
    • ForumExi
Re: [SMF Converter] MyBB 1.2.x
« Reply #31 on: July 21, 2007, 01:49:30 AM »
I can't convert topics. Everything is ok but while converting topics the server doesn't answer :S
« Last Edit: July 21, 2007, 08:44:52 AM by EximTrak »
www.forumexi.com
admin@forumexi.com

Offline EximTrak

  • Semi-Newbie
  • *
  • Posts: 33
  • Gender: Male
    • ForumExi
Re: [SMF Converter] MyBB 1.2.x
« Reply #32 on: July 21, 2007, 11:59:18 AM »
Topics can not be converted. Can anyone check the codes please?
www.forumexi.com
admin@forumexi.com

Offline Obi-Wahn

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] MyBB 1.2.x
« Reply #33 on: July 22, 2007, 12:47:53 PM »
one more ;)

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


Offline EximTrak

  • Semi-Newbie
  • *
  • Posts: 33
  • Gender: Male
    • ForumExi
Re: [SMF Converter] MyBB 1.2.x
« Reply #34 on: July 22, 2007, 01:38:54 PM »
one more ;)

Code: [Select]
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 ;)
www.forumexi.com
admin@forumexi.com

Offline Obi-Wahn

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] MyBB 1.2.x
« Reply #35 on: July 23, 2007, 04:43:34 AM »
Hi!

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

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

I wonder, because the converter talks about "MyBulletinBoard 1.0", ....


Offline Obi-Wahn

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] MyBB 1.2.x
« Reply #37 on: July 23, 2007, 03:35:39 PM »
Thanks, it works.

Offline marines

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] MyBB 1.2.x
« Reply #38 on: July 28, 2007, 04:03:46 PM »
there is still sth wrong. i got:
Quote
Recalculating 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 "ż"
« Last Edit: July 28, 2007, 04:13:59 PM by marines »

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,928
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #39 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.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub