After upgrading from 1.9 to 1.12 (which appeared to complete without any errors using the php updater), the “All Websites” link in the admin area is now causing an error that re-directs with a link to the login page:
Mysqli prepare error: Unknown column 'custom_float' in 'field list'
Im guessing this means something might have gone wrong with the update, but no errors were reported. Can the upgrade process be re-invoked or this fixed by other means? Thank you in advance for any suggestions or assistance!
Run this query :
piwik_option SET option_value = “1.12-b2” WHERE option_name = “version_core”;
which should fix it
Thanks for the suggestion, but unfortunately the error persists - not only with the “All Websites” link but the “misc/cron/archive.php” script as well. I’m thinking it might be time to start with a clean database and look into importing the old data over into that. Thanks again though!
After running the SQL query, if you visit the admin, you should see the “update screen”.
It should work…
This does invoke the update process, but even after updating (which reports having completed successfully), the "Mysqli prepare error: Unknown column ‘custom_float’ in ‘field list’ " error still persists. Looking at the SQL statements for the updater, this field isnt even mentioned. Thanks though…
I gave up and looked to a clean installation to see where this column should be and added this column to the end of the piwik_log_link_visit_action table to solve the problem. THanks again for the suggestions!