Project / Support Center
Welcome, %1$s. Please login or register. February 28, 2024, 09:57: AM
Web Global Net Web Application & Web Development Project Center  |  Technical Issues  |  Open Source Topics  |  SMF related  |  : Upgrade error 1.1.8 - ALTER TABLE smf_smileys ORDER BY LENGTH" error 0 and 1 Guest are viewing this topic. « previous next »
: [1]
: Upgrade error 1.1.8 - ALTER TABLE smf_smileys ORDER BY LENGTH" error  ( 11221 )
admin
« : April 09, 2009, 02:13: AM »

How do I fix this "ALTER TABLE smf_smileys ORDER BY LENGTH" error I am getting?
While upgrading and possibly editing smileys in the Smileys section of your Administration Panel, you may get an error similar to this:

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.
 
: [1]  
Web Global Net Web Application & Web Development Project Center  |  Technical Issues  |  Open Source Topics  |  SMF related  |  : Upgrade error 1.1.8 - ALTER TABLE smf_smileys ORDER BY LENGTH" error « previous next »
:  


Powered by MySQL Powered by PHP Valid XHTML 1.0! Valid CSS!
Sorry, the copyright must be in the template.
Please notify this forum's administrator that this site is missing the copyright message for SMF so they can rectify the situation. Display of copyright is a legal requirement. For more information on this please visit the Simple Machines website.