Error occured

[wisherman]

Hi! Sorry for my english, i'm from Russia ))

I try to upgrade my forum engine from 1.1.2 version to 1.1.4 version but upgrade.php find the error in sintax of SQL-querry.

Text of the error:
Upgrading...
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

Version of MySQL used on server is 5.0.45

Help please with this question. I'm not understand what to do..

Thanks for help!

[Douglas]

You've got the same issue I do on my own boxes.

Open up BOTH of your .sql files in your installation/upgrade packages and search for

ALTER TABLE smf_smileys
ORDER BY LENGTH(code) DESC

Change to read as follows:

ALTER TABLE smf_smileys
ORDER BY code DESC

And then re-run your upgrade/installation script again.

[H]

For more information on this search the mod site for smiley