Board order after aborted database upgrade

[HunterP]

Recently I've encountered this error :

Code Select Expand

[b]Note:[/b] It appears that your database <em>may</em> require an upgrade. Your forum's files are currently at version 1.1.4, while your database is at version 1.1.12. The above error might possibly go away if you execute the latest version of upgrade.php.

So I downloaded the 1.1.2 ugrade package and uploaded upgrade.php, upgrade_1-0.sql and upgrade_1-1.sql and executed upgrade.php which immediately showed this error :

Code Select Expand

The upgrader found some old or outdated language files.
Please make certain you uploaded the new versions of all the files included in the package, even the theme and language files for the default theme.
Click here to try again.

At that moment I didn't have the time to sort it out, so I aborted the upgrade.

The forum seemed to be running normally, but suddenly I noticed the board order was messed up. After some Googling I found :

Code Select Expand

4. In BoardIndex.php (in Sources dir)

find:
Code:
         AND b.childLevel <= 1" : ''), __FILE__, __LINE__);

replace with:
         AND b.childLevel <= 1" : '') . " ORDER BY c.catOrder, b.boardOrder ASC" , __FILE__, __LINE__);

This seemed to fix the problem. Partially, because I noticed another mess-up, the board order in the drop down box when a moderator wants to move a topic.

Any suggestions? It seems as if the upgrader did change some things, but not correctly?

[Kindred]

did you take and save a backup before you started your upgrade?
(always do that)

If you aborted the upgrade, it is completely possible that your board will be in a bad state....   once the upgrade starts, it really needs to finish or you need ot re-load your backup.

[HunterP]

If you aborted the upgrade, it is completely possible that your board will be in a bad state....   once the upgrade starts, it really needs to finish or you need ot re-load your backup.

Yes, I backed it up But I didn't really abort it, there was no progress bar or whatsoever, directy a warning that the language files needed to be updated. So it really looked like nothing happened 

[JimM]

The error you posted says your forum's files are at 1.1.4.  Your database is at 1.1.12.  To fix that you would need to upload all the files from the large upgrade package.  If it was me, I would display the detailed version information in the Admincp to see what files are not updated.

[HunterP]

The error you posted says your forum's files are at 1.1.4.  Your database is at 1.1.12.  To fix that you would need to upload all the files from the large upgrade package.  If it was me, I would display the detailed version information in the Admincp to see what files are not updated.

This is not an issue anymore. Everything is up to date now. I just wanted to point out that something weird happened when I *tried* to upgrade, but was aborted due to out-of-date language files.