Urgent - SQL Syntax error upgrading from 1.1.7 to 1.1.8. Auto update fails.

[TITSSN]

Hi all,

I just tried updating automatically from within the forum board and it fails. No matter which of the upgrade/update options I choose they all fail.

Here's what I get when I try to do it manually.

Upgrading...
Updating Settings.php... Successful.
Backing up old table data...
   Backing up "settings"... done.
   Backing up "smileys"... done.
   Backing up "themes"... done.
   Backing up "topics"... done.
Successful.
Updating and creating indexes...
    Updating indexes on "messages"... done.
    Updating table indexes... done.
    Reordering boards and categories... done.
    Updating indexes and data on "smileys"... 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


Now when I try to access the board i'm seeing this.

Upgrading the forum...
Don't worry, we will be back shortly with an updated forum. It will only be a minute .

Can anyone help me please even if it means going back to 1.1.7.

Thank you and have a great day,

~TITSSN~

[JimM]

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

If you are still stuck in maintenance mode, in your Settings.php file

Code (find) Select Expand

$maintenance = 2;      # Set to 1 to enable Maintenance Mode, 2 to make the forum untouchable. (you'll have to make it 0 again manually!)

Code (replace) Select Expand

$maintenance = 0;      # Set to 1 to enable Maintenance Mode, 2 to make the forum untouchable. (you'll have to make it 0 again manually!)

[TITSSN]

Hi JimM,

Thank you for the quick response and fix info.

Would taking it out of maintenance mode (even though the upgrade of the smiley section is not complete) cause any problems?

Please advise.

Thank you,

~TITSSN~

[JimM]

My suggestion would be to fix the smiley problem, run the upgrade again and if it completes properly you may not have to worry about the maintenance mode.

[TITSSN]

Hi JimM,

That worked and i'm good to go for now. Thank you.

I wonder why the upgrade from within the board isn't working, hmm. That's another issue by itself.

Thanks again.

[JimM]

Glad it worked out for you.  I'll mark the topic as solved.