Upgrade Error|Site Down! urgent!|

[indra00]

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

thats the error.... please plz help as soon as u can!

[JimM]

This fix was available even before you asked the question

How do I fix this "ALTER TABLE smf_smileys ORDER BY LENGTH" error I am getting?

[indra00]

Sorry for not searching..i was very tensed... but that prob solved but new error came now 

SELECT ID_HOLIDAY
FROM smf_calendar_holidays
WHERE YEAR(eventDate) > 2010
LIMIT 1;

I hv searched this
got this topic---

Code Select Expand

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

but dint get a right answer what should i do... please solve this issue..my site down for  hours 

what should i edit in upgrade_1-1.sql ?--
this i found in  upgrade_1-1.sql

Code Select Expand

/******************************************************************************/
--- Updating holidays and calendar...
/******************************************************************************/

---# Adding new holidays...
---{
$result = upgrade_query("
SELECT ID_HOLIDAY
FROM {$db_prefix}calendar_holidays
WHERE YEAR(eventDate) > 2010
LIMIT 1");
$do_it = mysql_num_rows($result) == 0;
mysql_free_result($result);

[indra00]

please anyone out there .. help me out... its an emergency as i tried it on my real site not demo one.. and site down for 12 hrs now!!!!

[sherpa サイバー侍]

You might like to see this link
http://www.simplemachines.org/community/index.php?topic=278294.msg1827593#msg1827593

[JimM]

indra00 - did the solution that sherpa　サイバー侍 linked to work for you?