upgrade failed at smiley's

[confuzzed]

I had 1.1.9, I could nit even see the upgrade to 1.1.10 in packages, even though I have updated that way before.  So finally I got the big upgrade pack and FTP'd it in place and run the upgrade.php and it failed (see below)  I couldn't get it out of maintain mode either, so I ended up nuking the folder and installed 1.1.9 again.

then tried the upgrade again and failed again.  While I can get it to a running state, I have no idea how/if the data is damaged..

as much as I prefer SMF, for now, I was successfully able to covert to phpbb and have that running in a new database.
I still have the original database sitting there..
Any suggestion what to do?  i'm on Godaddy hosting if that matters.

Should I just run it as is? it does seem to work, but I'm concerned the database error might cause a security risk.


Upgrading...
Updating Settings.php... Successful.
Updating and creating indexes...
    Updating indexes on "messages"... done.
    Updating table indexes... done.
    Reordering boards and categories... done.
    Updating indexes and data on "smileys"... 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

[H]

Welcome to SMF.
Please see: http://docs.simplemachines.org/index.php?topic=1079.0

[confuzzed]

thanks.. I did search for ideas, and never seen that..  i'll work on it in a bit

since my site is on godaddy (shared hosting) updating mysql probably isn't an option..

[confuzzed]

Just did the changes in the post you pointed me at.. SMF is back up and running 

[H]

Glad that sorted it for you