I’m encountering problem with my piwik setup after upgrading to 1.10.1.
I got the “Notice: Undefined index: sitesearch in …core/Site.php on line 265” and followed the FAQ with the manual “UPDATE piwik_option” to reset the core version, and run the update again from CLI, but it remains the same… same notice everywhere.
I also get a mysqli error upon login: "Mysqli prepare error: Unknown column ‘name’ in ‘field list’ "
I’ve restored my previous piwik folder to gain access to piwik, and everything seems fine but still running and old version.
ok then what i would do is try to upgrade in stages. There was a substantial database upgrade at version 1.8.4. I would try to get 1.8.4 working then try to go to 1.10.1
I found what was causing my upgrade problem… piwik had no ALTER privileges in mysql, so all its ALTER statements were not executed, but as no error was reported during the upgrade process it was not easy to find out !
Some error message in such case would be really useful…