[solved] Upgrade from 1.2 to 1.4.1 problem: upgrade not completed

[monchito]

Hi, I have a problem upgrading my 1.2 'barbados' site to 1.4.1. It seems that the upgrade starts, but does not finish, leaving an ugly site behind

What i did so far:
- backupped all files and the database
- emptied the cache
- downloaded 1.4.1 full and uploaded it to ftp, overwriting existing files
- opened /install/upgrade.php
- tested it on a development site, where it worked flawlessly

See an empty page with the message: 'site down for maintenance'

I looked elsewhere in the forum and usually people say I should empty the cache, which I did

What i can see:
- the database is changed: from 71 tables to 74
- in the admin panel, i still see however the notification that i should update he database (from version 29 to 31)
- if i update it, i get an error 404 not found message, while the upgrade.php file definitely resides in my ftp folder


I don't know what's wrong, maybe:
- something to do with chmod settings for config.php?

anxious for an answer... thnx!

[update: added some additional clarification and removed some remarks that didn't make sense]

[Pierre M.]

Hello,

BTW : you should clear the cache first, before the backup.

- tested it on a development site, where it worked flawlessly

Interesting : may be the culprit is the live context (monitor you http logS) or the transfer to it (monitor your upload log).

See an empty page with the message: 'site down for maintenance'

Search these forums (with Google) for SITEDOWN.

Pierre M.

[monchito]

I found nothing in my logs and cleared the cache many times, but still to no avail...

The installation breaks when i try to update the database. Could it be i should be upgrading from version 29 to 30 first, before i can move on to version 31?

p.s.: it also seems that the update did something with the stylesheets: all content is shown, but the {stylesheet} thingies in the templates are not shown on the client side. The page itself shows only html and no css

but then why did it work perfectly on a test environment (another server btw)

[alby]

The installation breaks when i try to update the database.

If you can, look your server mysql logs or apply manualy the queries

Alby

[Pierre M.]

Could it be i should be upgrading from version 29 to 30 first, before i can move on to version 31?

Once you have backups 1.2->1.3 and 1.3->1.4 is an option to try.

BTW, by "found nothing in my logs", you mean the error log, don't you ?

Pierre M.

[monchito]

Well, i haven't 'solved' it, but used a workaround to make it work anyway.

I simply copied the whole site to the staging environment and upgraded there. Worked like a charm. Then i simply copied the database and all files, modified settings in .htaccess, config.php en checked the db and everything worked fine...

no solution but a workaround, but hey, it works

[alby]

no solution but a workaround, but hey, it works

You have not permission of ALTER in your mysql

Alby