[abfan1127]

I recently inherited a forum running 1.0.10. I want to upgrade it to 1.1.10, or if the 2.x line releases soon, to it. I tried using the upgrade version of the download, but it complains about an SQL statement

Upgrading...
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

Any ideas on this?
PHP Version: 5.2.6
MySQL Version: 5.0.81-community

Thanks in advance.

[Antechinus]

Yep. We get that all the time. How do I fix this "ALTER TABLE smf_smileys ORDER BY LENGTH" error I am getting?

[DavidCT]

I wonder why SMF doesn't detect that error and make the change automatically???  Not possible?  Either use a different upgrade.sql file when it errors or at least tell the person in the error statement how to fix it themselves

[abfan1127]

That worked. Thanks for the link. Does this really require MySQL 5.1? Or is it dependent on something else?

[abfan1127]

The upgrade went well, except now I am getting this copyright notice.
Sorry, the copyright must be in the template.
Please notify this forum's administrator that this site is missing the copyright message for SMF so they can rectify the situation. Display of copyright is a legal requirement. For more information on this please visit the Simple Machines website.
I am using the default theme. I moved all the theme files into a backup directory and copied all the theme files over again, and I still get it.

[abfan1127]

I looked into the template, and it looks good. It looks like some file is not executing properly. I CHMOD'ed everything to 755 and it didn't do anything. I CHMOD'ed everything to 777 and it threw a Server Error. I CHMOD'ed everything to 755 and it executes, but still the copyright error.

[JimM]

Any changes made to the forum after the upgrade before the copyright notice started appearing?

[Arantor]

Your 1.0.10 theme may not be compatible with 1.1.10 which could be causing the problem.