Known Issues and Workarounds


(vipsoft) #1
  1. 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
  1. 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
  1. 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.

  1. 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
  1. 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,
  1. 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/',
  1. 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".

(eveshock) #2

[quote=vipsoft @ Aug 5 2009, 02:51 PM]1. 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
  1. 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
  1. 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.

  1. 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
  1. 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,
  1. 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/',
  1. 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".
[/quote]

Hey, thanks for the info, i learned a lot from these. there’s just one concern, Is there a missing character in #6 coz it does not work?