How do I fix this "ALTER TABLE smf_smileys ORDER BY LENGTH" error I am getting?
Quote
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
There are two solutions to resolve this error.
The first solution will fix both the issue with upgrading, as well as an issue with editing smileys in the Smileys and Message Icons section of your admin panel.
All you need to do is update your MySQL version. To update MySQL yourself, you will have to have server access. Otherwise, and more commonly the case, you will have to ask your host to upgrade MySQL on the server for you. It is unknown at the time if the MySQL AB Team is supporting this uasge or not.
There may be other versions of MySQL that have this issue as well, but upgrading MySQL to the latest version for the MySQL branch you are using may resolve the issue.
The second way to resolve this for upgrading is to open "upgrade_1-1.sql" with a text editor and find the following:
Code: [Select]
ALTER TABLE {$db_prefix}smileys
ORDER BY LENGTH(code) DESC;
Replacing this with:
Code: [Select]
ALTER TABLE {$db_prefix}smileys
ORDER BY code DESC;
For editing smileys in the Smileys and Message Icons section of your admin panel, open "/Sources/ManageSmileys.php" with a text editor and find the following code:
Code: [Select]
// Sort all smiley codes for more accurate parsing (longest code first).
db_query("
ALTER TABLE {$db_prefix}smileys
ORDER BY LENGTH(code) DESC", __FILE__, __LINE__);Replacing this with:
Code: [Select]
// Sort all smiley codes for more accurate parsing (longest code first).
db_query("
ALTER TABLE {$db_prefix}smileys
ORDER BY code DESC", __FILE__, __LINE__);This section of code will appear twice in "/Sources/ManageSmileys.php", You will find this approximatively on lines 654 and 990.
.
hawt... thanks for this fix. I ran into this error today while applying the upgrade.
I'd read the guide and following the step by step instructions while paying attention to server side requirements etc...
My host (hostmonster.com) is using MySQL version 5.0.45 and php version 5.2.6
I was using the small update on the downloads page to upgrade from 1.1.4 to 1.1.5 and encountered this error.
A search in the forum lead to a user with the same issue and the first response was a link to this post. Unfortunately 5.1 is in alpha phase atm and not actually released by sun microsystems, so there is nothing my host can do as of yet since we are using the latest version.
The second solution offered took less than 10 seconds and worked flawlessly. Thanks a ton.
Upgrade was successfully applied to autismwf.com/forum