- session has already been started by session.auto-start or session_start()
Turn session.auto_start Off in php.ini, or create a .htaccess file containing:php_flag session.auto_start off
- Browser (e.g., Firefox) reports “Content Encoding Error”
Apache's compression conflicts with PHP's output handler compression. The default is usually Off. Turn zlib.output_compression Off in php.ini, or create a .htaccess file containing:php_flag zlib.output_compression off
- SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘xxxxx’ doesn’t exist
In general, this indicates that a database update didn't complete successfully because you have a lot of data and the browser timed out. With Piwik 0.4.4, you can upgrade the database from the shell, e.g.,php piwik/index.php
In the special case of user_language, you may have to go to Settings | Plugins, and deactivate/re-activate the LanguagesManager plugin.
- SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘xxxxx’ in ‘field list’
In general, this indicates that a database update didn't complete successfully because you have a lot of data and the browser timed out. With Piwik 0.4.4, you can upgrade the database from the shell, e.g.,php piwik/index.php
- SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘’ for column ‘visit_goal_converted’
Your MySQL server is in 'strict' mode. Please add the IGNORE keyword, i.e.,'ALTER IGNORE TABLE `'. Piwik::prefixTable('log_visit') .'` CHANGE `visit_goal_converted` `visit_goal_converted` TINYINT(1) NOT NULL' => false,
- SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user ‘myUserID’@‘SomeIP’ for table ‘piwik_log_action’
Ask your sysadmin to GRANT your database user INDEX privilege. In the meantime (note this will come up again in Piwik 0.5), assuming your table prefix is "piwik_", run:SHOW CREATE piwik_log_visit;
If the table doesn’t have an index named
index_idaction
, then you can safely comment out this line in core/Updates/0.4.3.php.//'DROP INDEX index_idaction ON '. Piwik::prefixTable('log_action') => '/1091/',
- Other error after auto-updating
If your tmp/latest folder contains a piwik folder, it's an indicator that the auto-update did not complete successfully. Please check your max_execution_time in php.ini. Either copy tmp/latest/piwik to your root piwik folder, or download latest.zip. If you re-run the installer, select "reuse existing tables".