Text only | Text with Images

Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Topic started by: mpMS on July 03, 2007, 08:25:51 PM

Title: Error in SQL: ALTER TABLE smf_smileys ORDER BY LENGTH(code) DESC;
Post by: mpMS on July 03, 2007, 08:25:51 PM
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 (http://www.simplemachines.org/community/index.php?topic=180391.0)

Hope you might help.
Title: Re: Error in SQL: ALTER TABLE smf_smileys ORDER BY LENGTH(code) DESC;
Post by: redone on July 04, 2007, 09:52:37 AM
You already have on thread started on this support topic. Hopefully someone will merge it! ;)

Did you follow what was suggested?
Title: Re: Error in SQL: ALTER TABLE smf_smileys ORDER BY LENGTH(code) DESC;
Post by: mpMS on July 04, 2007, 08:08:40 PM
Quote from: redone on July 04, 2007, 09:52:37 AM
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
Title: Re: Error in SQL: ALTER TABLE smf_smileys ORDER BY LENGTH(code) DESC;
Post by: redone on July 04, 2007, 08:20:41 PM
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?

Title: Re: Error in SQL: ALTER TABLE smf_smileys ORDER BY LENGTH(code) DESC;
Post by: mpMS on July 04, 2007, 10:07:23 PM
Quotemysql  Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i486) using readline 5.2
Using linux Ubuntu Server 7.04
Title: Re: Error in SQL: ALTER TABLE smf_smileys ORDER BY LENGTH(code) DESC;
Post by: SleePy on July 11, 2007, 03:12:20 PM
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 :P

Quote
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
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
// 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__);
Title: Re: Error in SQL: ALTER TABLE smf_smileys ORDER BY LENGTH(code) DESC;
Post by: mpMS on July 11, 2007, 08:43:15 PM
I have resolved this problem as indicated on my other thread as included on the first post.  I will take note of this documentation.
Title: Re: Error in SQL: ALTER TABLE smf_smileys ORDER BY LENGTH(code) DESC;
Post by: Bojeunx on August 03, 2007, 10:44:51 PM
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...
Text only | Text with Images