I’ve searched to the best of my abilities and see no other posts regarding this specific error. Apologies if it’s a different form of something common that I just missed.
I’m not sure what it means that the table is “in use.” Does this mean the database has a lock? I’ve tried running the console core:update command, but it says I’m up to date. I haven’t rolled back or reinstalled anything yet, since I can’t tell exactly what’s happening.
Any pointers would be appreciated. If it matters, I’m running Apache 2.2.22, MySql 5.5.35, and PHP 5.3.10
From which Piwik version did you update?
Are you using any opcache (apart from APC) that needs to be invalidated?
Sounds like there went something wrong during the update. Maybe some files were not copied correct. Can you download Piwik again and copy over all the files except the config folder?
It looks like replacing the Goals.php file corrects the error. However, that also seems to remove all my goal and ecommerce tracking. I’d rather not have to rebuild the dozens of goals and variables from scratch. Is there an easy way to copy those portions of the old Goals.php over, or will that cause further issues?
I am pretty sure those Goals are still there but simply not displayed. I’d recommend to download Piwik manually and copy it to your server (except the config folder).
Looks like the update didn’t work properly for you.