Hi! Sorry for my english, i'm from Russia 8)))
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! 8)
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
LainaaALTER TABLE smf_smileys
ORDER BY LENGTH(code) DESC
Change to read as follows:
LainaaALTER TABLE smf_smileys
ORDER BY code DESC
And then re-run your upgrade/installation script again.
For more information on this search the mod site for smiley :)