upgrade test failed from 1.1.10 to 1.1.11

[Bazar6]

when upgrading from 1.1.10 to .11, the test says it failed one file, the ./Sources/Packages.php... What is in this file and what can go wrong if I upgrade without doing anything to this file? I'm not great with code, but I can find something thats wrong if I know what I'm looking for.

The packages I have installed include:
• updates since 1.0.13
• Admin Notepad
• Email validator
• AjaxChat Integration
• Custom Profile Field
• Registration Read for 1.1.10
• reCAPTCHA for SMF

Some of these mods are not applied. And some of those that are not applied I physically deleted from the server, before deleting them from the packages list (they were never applied to the forum). So I think thats what is making the upgrade not work with that file. But, since the mods that I deleted don't exist, will the new file just omit the mods that dont exist and keep the ones that do exist and are applied? Thanks a ton to anyone who can help!

[Nick Whetstone]

Try overwriting your Packages.php file with the one I attached.

As always, when messing with Source files, make sure to have a recent backup in case anything goes screwy.

[Bazar6]

overwrite, then install the upgrade?

[Nick Whetstone]

Overwrite, then see if the upgrade tests still fail. If they don't fail, go ahead and upgrade. If they do, please post back saying so.

[Bazar6]

Ha²... Thank you very much... test passed, upgrade successful... thanks a ton!

[wgn_white]

Hello.

Please help.

I am also upgrading from 1.1.10 to 1.1.11

It failed and here is the report.

Upgrading...
Updating Settings.php... Successful.
Backing up old table data...
   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 cmssmf_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