Error in SQL: ALTER TABLE smf_smileys ORDER BY LENGTH(code) DESC;

[mpMS]

SMF Version: SMF 1.0.9
I am upgrading to SMF 1.1.3 as seen on my previous post:

http://www.simplemachines.org/community/index.php?topic=180391.0

Hope you might help.

[redone]

You already have on thread started on this support topic. Hopefully someone will merge it!

Did you follow what was suggested?

[mpMS]

You already have on thread started on this support topic. Hopefully someone will merge it!

Did you follow what was suggested?

yes but I am not familiar with MySQL. I need to learn that first or if someone can help me I would really appreciate it. thanks for the reply

[redone]

Someone needs to merge your threads. You were pointed to a potential solution that requires some action on behalf of your webhost.

Can you confirm that your host carried out what was suggested and your still having issues. For the most part your MySQL issues can only really be fixed by your host. What version of MySQL does your server have?

[mpMS]

mysql  Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i486) using readline 5.2

Using linux Ubuntu Server 7.04

[SleePy]

This is part of an unapproved doc at the doc site. Akabugeyes has shown this before and I wrote the doc so I can show parts of it

The first solution will fix the upgrade and a smiley edit error.
All you need to do is update Your MySQL version. Some older versions of MySQL have this issue. More may have this problem at this time though it is unknown. But upgrading to the latest version in 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" and find, then remove the following code:

Code Select Expand

ALTER TABLE {$db_prefix}smileys
ORDER BY LENGTH(code) DESC;


For Editing Smileys, open "ManageSmileys.php" and find, then remove the following code:

Code Select Expand

// 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__);

[mpMS]

I have resolved this problem as indicated on my other thread as included on the first post.  I will take note of this documentation.

[Bojeunx]

http://www.simplemachines.org/community/index.php?topic=180391.0
The solution in this pages works %100 the solution that want you to substitude a code...
It works. Just want to report for guyz who may have this problem
Thanx...