Since updating to 2.7.0, no more data was added to statistics. I can see realtime dashboard visitors and the visitors log. But no new ecommerce statistics actions or even statistics of any type. These seem to be frozen at update time. I then deleted the piwik_archive_* tables for September as recommended in the faq. Now all September statistics are empty (0) and they do not fill up again.
Then I tried to call the cron job manually (it is no real cron, but called externally as an url.)
It echoed:
INFO [2014-09-29 12:19:13] [bdad2] --------------------------- INFO [2014-09-29 12:19:13] [bdad2] INIT INFO [2014-09-29 12:19:13] [bdad2] Piwik is installed at: http://blabla.mydomain.net/piwik/index.php INFO [2014-09-29 12:19:13] [bdad2] Running Piwik 2.7.0 as Super User ERROR [2014-09-29 12:19:13] [bdad2] The Piwik URL http://blabla.mydomain.net/piwik/index.php does not seem to be pointing to a Piwik server. Response was '
And exactly here it ends. No more output follows.
index.php exists in that piwik subdirectory, and does not look broken. But something must be broken, however.
I wonder what can be done now. Will I have to install Piwik again by hand? What will happen to the already collected statistics data?
I don’t have enough background to do this level of debugging. If you or someone cares to walk me through it cheers, otherwise I guess I can try to uninstall/reinstall…? The data prior to September is all in place. But nothing from September on…
Visitor-log table shows entries for today, but nothing shows in the dashboard.
if you have data in visitor log then data is collected. can you try to setup auto archiving? http://piwik.org/docs/setup-auto-archiving/
@P|w|k
can you set [Tracker]
debug=1 in your config and then PM me a link to this post a a website where the piwik js code?
sh-4.2$ php /home/***/domains/piwik.***.ua/public_html/console core:archive --url=http://piwik.***.ua/
INFO CoreConsole[2014-10-01 06:49:52] [f3901] ---------------------------
INFO CoreConsole[2014-10-01 06:49:52] [f3901] INIT
INFO CoreConsole[2014-10-01 06:49:52] [f3901] Piwik is installed at: http://piwik.***.ua/index.php
INFO CoreConsole[2014-10-01 06:49:52] [f3901] Running Piwik 2.7.0 as Super User
INFO CoreConsole[2014-10-01 06:49:54] [f3901] ---------------------------
INFO CoreConsole[2014-10-01 06:49:54] [f3901] NOTES
INFO CoreConsole[2014-10-01 06:49:54] [f3901] - Reports for today will be processed at most every 10 seconds. You can change this value in Piwik UI > Settings > General Settings.
INFO CoreConsole[2014-10-01 06:49:54] [f3901] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
INFO CoreConsole[2014-10-01 06:49:54] [f3901] - Archiving was last executed without error 1 years 265 days ago
INFO CoreConsole[2014-10-01 06:49:54] [f3901] - Will process 1 websites with new visits since 1 years 265 days , IDs: 1
INFO CoreConsole[2014-10-01 06:49:54] [f3901] ---------------------------
INFO CoreConsole[2014-10-01 06:49:54] [f3901] START
INFO CoreConsole[2014-10-01 06:49:54] [f3901] Starting Piwik reports archiving...
ERROR CoreConsole[2014-10-01 06:49:55] [f3901] Got invalid response from API request: http://piwik.***.ua/index.php?module=API&method=API.get&idSite=1&period=day&date=last52&format=php&token_auth=8fe51c14dbd914eb1f38e8a4ddf1c52b&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:118:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_link_visit_action.idaction_content_name' in 'where clause'";}'
ERROR CoreConsole[2014-10-01 06:49:55] [f3901] Got invalid response from API request: http://piwik.***.ua/index.php?module=API&method=API.get&idSite=1&period=day&date=last52&format=php&token_auth=8fe51c14dbd914eb1f38e8a4ddf1c52b&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:118:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_link_visit_action.idaction_content_name' in 'where clause'";}'
ERROR CoreConsole[2014-10-01 06:49:56] [f3901] Empty or invalid response '' for website id 1, Time elapsed: 1.683s, skipping
ERROR CoreConsole[2014-10-01 06:49:56] [f3901] Empty or invalid response '' for website id 1, Time elapsed: 1.683s, skipping
INFO CoreConsole[2014-10-01 06:49:56] [f3901] Done archiving!
INFO CoreConsole[2014-10-01 06:49:56] [f3901] ---------------------------
INFO CoreConsole[2014-10-01 06:49:56] [f3901] SUMMARY
INFO CoreConsole[2014-10-01 06:49:56] [f3901] Total visits for today across archived websites: 0
INFO CoreConsole[2014-10-01 06:49:56] [f3901] Archived today's reports for 0 websites
INFO CoreConsole[2014-10-01 06:49:56] [f3901] Archived week/month/year for 0 websites
INFO CoreConsole[2014-10-01 06:49:56] [f3901] Skipped 1 websites: no new visit since the last script execution
INFO CoreConsole[2014-10-01 06:49:56] [f3901] Skipped 0 websites day archiving: existing daily reports are less than 10 seconds old
INFO CoreConsole[2014-10-01 06:49:56] [f3901] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
INFO CoreConsole[2014-10-01 06:49:56] [f3901] Total API requests: 0
INFO CoreConsole[2014-10-01 06:49:56] [f3901] done: 0/1 0%, 0 vtoday, 0 wtoday, 0 wperiods, 0 req, 1897 ms, 2 errors.
INFO CoreConsole[2014-10-01 06:49:56] [f3901] Time elapsed: 1.897s
INFO CoreConsole[2014-10-01 06:49:56] [f3901] ---------------------------
INFO CoreConsole[2014-10-01 06:49:56] [f3901] SCHEDULED TASKS
INFO CoreConsole[2014-10-01 06:49:56] [f3901] Starting Scheduled tasks...
INFO CoreConsole[2014-10-01 06:49:57] [f3901] No task to run
INFO CoreConsole[2014-10-01 06:49:57] [f3901] done
INFO CoreConsole[2014-10-01 06:49:57] [f3901] ---------------------------
INFO CoreConsole[2014-10-01 06:49:57] [f3901] ---------------------------
INFO CoreConsole[2014-10-01 06:49:57] [f3901] SUMMARY OF ERRORS
INFO CoreConsole[2014-10-01 06:49:57] [f3901] Error: Got invalid response from API request: http://piwik.***.ua/index.php?module=API&method=API.get&idSite=1&period=day&date=last52&format=php&token_auth=8fe51c14dbd914eb1f38e8a4ddf1c52b&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:118:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_link_visit_action.idaction_content_name' in 'where clause'";}'
INFO CoreConsole[2014-10-01 06:49:57] [f3901] Error: Empty or invalid response '' for website id 1, Time elapsed: 1.683s, skipping
ERROR CoreConsole[2014-10-01 06:49:57] [f3901] 2 total errors during this script execution, please investigate and try and fix these errors.
ERROR CoreConsole[2014-10-01 06:49:57] [f3901] 2 total errors during this script execution, please investigate and try and fix these errors.
Unfortunately I have no access to the php error log.
This is where the archive.php call stops:
ERROR [2014-10-01 20:20:21] [4d6f6] The Piwik URL
http://my.domain.net/piwik/index.php does not seem to be pointing to
a Piwik server. Response was '
[Zend_Db_Adapter_Exception]
SQLSTATE[HY000] [2002] No such file or directory
[PDOException]
SQLSTATE[HY000] [2002] No such file or directory
climulti:request [url-query] '.
This problem occurs since upgrading to 2.70. No more statistics since then.
How can it be fixed?