LainaaUpdating 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!
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? (http://docs.simplemachines.org/index.php?topic=1079.0)
Sorry for not searching..i was very tensed... but that prob solved but new error came now :-X
Lainaa
SELECT ID_HOLIDAY
FROM smf_calendar_holidays
WHERE YEAR(eventDate) > 2010
LIMIT 1;
I hv searched this
got this topic---
http://www.simplemachines.org/community/index.php?topic=256828.0but 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
/******************************************************************************/
--- 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);
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!!!!
You might like to see this link
http://www.simplemachines.org/community/index.php?topic=278294.msg1827593#msg1827593
indra00 - did the solution that sherpa サイバー侍 linked to work for you?