Upgrade from 1.1.2 to 1.1.3

[ZgaR]

SMF Version: SMF 1.1.2
Hello,

I wanted to upgrade my SMF 1.1.2 with the 1.1.3
But I have this error :

Code Select Expand

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

Can someone help me to solve this problem ?

[Celestial Lord]

I attempted to upgrade my SMF 1.1.2 board to 1.1.3 using the large upgrade file, and received the exact same error.  Any help would be greatly appreciated.

[Celestial Lord]

I found the solution.

Edit Sources/ManageSmileys.php

Change Line 654:
ORDER BY LENGTH(code) DESC", __FILE__, __LINE__);
To:
ORDER BY code DESC", __FILE__, __LINE__);

Change Line 990:
ORDER BY LENGTH(code) DESC", __FILE__, __LINE__);
To:
ORDER BY code DESC", __FILE__, __LINE__);

Edit upgrade_1-1.sql

Change Line 181:
ORDER BY LENGTH(code) DESC;
To:
ORDER BY code DESC;

[ZgaR]

Nice, it works fine, thank you a lot for your help

[santanu]

I want to upgrade my smf to 1.1.3 but my smf have many mods installed and some by the package parser. how do i upgrade without disturbing the mods form giving error.

Please help