Upgrade gone HORRIBLY wrong.

Permalink
Was upgrading a site from 5.5.2.1 to 5.6.3.1. I backed up all the files on the site, but not the database(Mistake 1). When the upgrade finished, only the home page would show, the other pages were blank. I panicked and reuploaded the backup files to the FTP over the existing ones(Mistake 2). Now I get the "An unexpected error... mysql error: [1054: Unknown column 'cPendingAction' in 'field list'] in EXECUTE" for every page.

Dashboard is non functional, but can access /index.php/tools/required/upgrade. it says "Upgrade to 5.5.2.1 complete!" after I have replaced everything.

So, my question is, how screwed am I?

hdcdesign
 
WebcentricLtd replied on at Permalink Reply
hi,
first thing I'd do is check if my host has a backup from the previous night.

Did the initial upgrade say it had run correctly?

In your website inside the /config/site.php is there a line that starts:

define('DIRNAME_APP_UPDATED', '
hdcdesign replied on at Permalink Reply
hdcdesign
I saw no error messages when I updated.

That line is in my site.php. But I believe it is the file I reuploaded in my panic. I still have the 5.6.3.1 folder in my updates folder. Would changing this line to point to the 5.6.3.1 folder get it back to it "updated" state. At least I could see the home page then, and something was working. I think it would be easier to troubleshoot from there.
WebcentricLtd replied on at Permalink Best Answer Reply
Hi,
that's exactly what I was going to suggest.
If you are lucky the upgrade worked ok but there was some other issue afterwards that you need to track down (incompatible override code or something like that).

If that is the case then pointing back to the correct code should get you back to the upgraded state and then you can troubleshoot whatever the issues are.

It depends is the upgrade was successful and if anything else has accidentally gone wrong but I'd give that a go.

Post back once you've done this and see if you can at least get the homepage back and work from there.
hdcdesign replied on at Permalink Reply
hdcdesign
AndyJ, Thank you. I pointed that line in the config file to the 5.6.3.1 directory, and forced the update again. I got the page saying you have 5.5.2.1, would you like to upgrade to 5.6.3.1. I did upgrade. And now EVERYTHING is working. even the pages that were broken according to the last update.

Thanks for pointing me in the right direction.
WebcentricLtd replied on at Permalink Reply
that went better than I expected :) - congrats!