piwik error while request data in a daterange -
i have problem getting reports in piwik date range 30 days on dashboard , visitors , actions tabs. when want this error occures :
oops… there problem during request. maybe server had temporary issue, or maybe requested report data. please try again. if error occurs repeatedly please contact piwik administrator assistance.
i did archiving below command :
/usr/bin/php /var/www/html/piwik/console core:archive --url=http://myip/piwik/ , resolved issue on dashboard , , still show error when want reports date range 30 days on visitors , actions tabs. when set date range smaller ranges example 15 days ok , not shows error. have installed piwik on rhel php 5.3.3 , mysql 5.1 . can me how fix problem. thanks
i have fixed issue. related data format. after changing date format, able load page out issue. have added error.log reference.
hope seeking help.
you can change particular table column "date format" using below query:
update table_name
set field_name
= replace(same_field_name, 'unwanted_text', 'wanted_text')
[sat sep 12 12:03:37.124105 2015] [:error] [pid 21414] [client 192.168.1.22:50006] error in piwik: date format must be: yyyy-mm-dd, or 'today' or 'yesterday' or keyword supported strtotime function (see http://php.net/strtotime more information): -62169984000, referer: http://192.168.1.20/ap_enterprise/index.php?module=multisites&action=index&idsite=1&period=day&date=yesterday
Comments
Post a Comment