Upgrade MySQL Error

[alebeard]

Tried to upgrade and got this message, I am knda lost as what to do next and the forum seems crashed until I fix it
Please help!


Updating and creating indexes...
Unsuccessful!
This query:

    ALTER TABLE 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

[metallica48423]

http://www.simplemachines.org/community/index.php?topic=195424.msg1244444#msg1244444

[babjusi]

I think I already answered you at this topic. Please, don''t start duplicate topics for the same thing

http://www.simplemachines.org/community/index.php?topic=198512.msg1262196#msg1262196