upgrade.php yi çalıştırıyorum devem deyinece bu hata başka gitmiyor varmı bşıan gelen yada çözen

Upgrading...
Updating Settings.php... Successful.
Updating and creating indexes... Unsuccessful!

This query:
ALTER TABLE `..._joom1`.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