My forum is down.

[madagascar]

Hi all,

I tried to upgrade to SMF 1.1.3 but i encountered this error:

Updating Settings.php... Successful.
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

How to fix this error?

thanks

[IchBin]

You should really ask/search at SMF for problems with SMF.

[madagascar]

You should really ask/search at SMF for problems with SMF.

thanks inchbin. the magic word is always "search" I got the answer.