Logs in BD is ok but no stats


(rafffel) #1

Hi your tools are looks very great but i’ve little problem.

i can access to Web analystics report bug nothing apears .

if i look on DB with php my admin table piwik_log_visit have 9 record

i have checked the Mysql / php timezones with SELECT @@global.time_zone

he return SYSTEM

i have activated plugin DBstats

he return this error : Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘?’ at line 1

the server have :
PHP version: 5.2.10
MySQL version: 5.0.84


(vipsoft) #2

SYSTEM means the MySQL server is using the system environment timezone. For example:

echo $TZ

PHP has its own setting:

<?php
echo ini_get("date.timezone");
?>

(rafffel) #3

hi thanks i have set timezone of php with the .htaccess because host is in safe mode i use php_value date.timezone Europe/Paris in .htaccess