Upgrade failed, please give advice

Support & Bugs
1

Hi, I run piwik on multiple sites, but on one the upgrade failed and I couldn’t find anything in the log files.

It failed during db update and I’m looking for ways to do the upgrade manually. I see that the db contains some data from 2010, but everything from 2011 is gone.

On the upgrade screen there were some SQL that could be run, but I can’t find it on this site. There should be something about this in the upgrade documentation I think.

When I run the update command manually from command line I only get a redirect.

php index.php – “module=CoreUpdater”

Status: 302 Moved Temporarily
X-Powered-By: PHP/5.2.13
Location: index.php?module=CoreHome&action=
Content-type: text/html

Can someone please advice me on how I can restore the data? Would it be easiest to do a db rollback or is this upgrade savable.

Thank you!

2

You can tell piwik that it’s running the old schema, by doing: UPDATE piwik_option SET option_value = “1.3.1” WHERE option_name = “version_core”

then it will try to run the upgrade again, which might fail as some of the queries maybe hav been processed, So run manually all the ones that haven’t been yet processed