I’m having the same problem as above, here are some logs.
ERROR: Failed to get data from API: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_action_event_category.type’ in ‘field list’ #0 /home2/USER/public_html/analytics.domain.tld/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /home2/USER/public_html/analytics.domain.tld/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home2/USER/public_html/analytics.domain.tld/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’\n\t\t\t\tSELECT\n\t\t\t…’, Array) #3 /home2/USER/public_html/analytics.domain.tld/core/Db/Adapter/Pdo/Mysql.php(256): Zend_Db_Adapter_Pdo_Abstract->query(’\n\t\t\t\tSELECT\n\t\t\t…’, Array) #4 /home2/USER/public_html/analytics.domain.tld/libs/Zend/Db/Adapter/Abstract.php(736): Piwik\Db\Adapter\Pdo\Mysql->query(’\n\t\t\t\tSELECT\n\t\t\t…’, Array) #5 /home2/USER/public_html/analytics.domain.tld/core/Db.php(217): Zend_Db_Adapter_Abstract->fetchAll(’\n\t\t\t\tSELECT\n\t\t\t…’, Array) #6 /home2/USER/public_html/analytics.domain.tld/plugins/Actions/VisitorDetails.php(239): Piwik\Db::fetchAll(’\n\t\t\t\tSELECT\n\t\t\t…’) #7 /home2/USER/public_html/analytics.domain.tld/plugins/Actions/VisitorDetails.php(36): Piwik\Plugins\Actions\VisitorDetails->queryActionsForVisits(Array) #8 /home2/USER/public_html/analytics.domain.tld/plugins/Live/API.php(332): Piwik\Plugins\Actions\VisitorDetails->provideActionsForVisitIds(Array, Array) #9 [internal function]: Piwik\Plugins\Live\API->Piwik\Plugins\Live{closure}(Object(Piwik\DataTable)) #10 /home2/USER/public_html/analytics.domain.tld/core/DataTable.php(475): call_user_func_array(Object(Closure), Array) #11 /home2/USER/public_html/analytics.domain.tld/core/DataTable.php(581): Piwik\DataTable->filter(Object(Closure), Array) #12 /home2/USER/public_html/analytics.domain.tld/core/API/DataTablePostProcessor.php(283): Piwik\DataTable->applyQueuedFilters() #13 /home2/USER/public_html/analytics.domain.tld/core/API/DataTablePostProcessor.php(129): Piwik\API\DataTablePostProcessor->applyQueuedFilters(Object(Piwik\DataTable)) #14 /home2/USER/public_html/analytics.domain.tld/core/Plugin/Visualization.php(449): Piwik\API\DataTablePostProcessor->process(Object(Piwik\DataTable)) #15 /home2/USER/public_html/analytics.domain.tld/core/Plugin/Visualization.php(186): Piwik\Plugin\Visualization->applyFilters() #16 /home2/USER/public_html/analytics.domain.tld/core/Plugin/Report.php(317): Piwik\Plugin\Visualization->render() #17 /home2/USER/public_html/analytics.domain.tld/plugins/CoreHome/Controller.php(58): Piwik\Plugin\Report->render() #18 [internal function]: Piwik\Plugins\CoreHome\Controller->renderReportWidget(Object(Piwik\Plugins\Live\Reports\GetLastVisitsDetails)) #19 /home2/USER/public_html/analytics.domain.tld/core/FrontController.php(544): call_user_func_array(Array, Array) #20 /home2/USER/public_html/analytics.domain.tld/core/FrontController.php(137): Piwik\FrontController->doDispatch(‘Live’, ‘getLastVisitsDe…’, Array) #21 /home2/USER/public_html/analytics.domain.tld/core/dispatch.php(34): Piwik\FrontController->dispatch() #22 /home2/USER/public_html/analytics.domain.tld/index.php(27): require_once(’/home2/USER/pub…’) #23 {main}
[Mon Sep 11 20:04:56.704154 2017] [cgid:error] [pid 31641:tid 140158690981632] [client 123.456.789.1011:60109] End of script output before headers: nk.pl.png, referer: domain/index.php?module=ReferrersManager&actio
n=index&date=last30&period=range&idSite=1&activated=
[Mon Sep 11 20:04:57.388635 2017] [cgid:error] [pid 31641:tid 140158816872192] [client 123.456.789.1011:60109] End of script output before headers: www.google.interia.pl.png, referer: domain/index.php?module=Referr
ersManager&action=index&date=last30&period=range&idSite=1&activated=
[Mon Sep 11 20:04:57.537184 2017] [cgid:error] [pid 31641:tid 140158942762752] [client 123.456.789.1011:60109] End of script output before headers: szukaj.onet.pl.png, referer: domain/index.php?module=ReferrersMana
ger&action=index&date=last30&period=range&idSite=1&activated=
[Mon Sep 11 20:04:59.490973 2017] [cgid:error] [pid 31641:tid 140158867228416] [client 123.456.789.1011:60109] End of script output before headers: szukaj.wp.pl.png, referer: domain/index.php?module=ReferrersManage
r&action=index&date=last30&period=range&idSite=1&activated=
[Mon Sep 11 20:10:21.420480 2017] [cgid:error] [pid 31946:tid 140158884013824] [client 123.456.789.1011:60163] End of script output before headers: nk.pl.png, referer: domain/index.php?module=ReferrersManager&actio
n=index&widget=undefined&idSite=1&period=range&date=last30&showtitle=1&random=4693&activated=
[Mon Sep 11 20:10:21.872320 2017] [cgid:error] [pid 31946:tid 140158884013824] [client 123.456.789.1011:60163] End of script output before headers: www.google.interia.pl.png, referer: domain/index.php?module=Referr
ersManager&action=index&widget=undefined&idSite=1&period=range&date=last30&showtitle=1&random=4693&activated=
[Mon Sep 11 20:10:21.947679 2017] [cgid:error] [pid 31946:tid 140158884013824] [client 123.456.789.1011:60163] End of script output before headers: szukaj.onet.pl.png, referer: domain/index.php?module=ReferrersMana
ger&action=index&widget=undefined&idSite=1&period=range&date=last30&showtitle=1&random=4693&activated=
[Mon Sep 11 20:10:22.094529 2017] [cgid:error] [pid 31946:tid 140158884013824] [client 123.456.789.1011:60163] End of script output before headers: szukaj.wp.pl.png, referer: domain/index.php?module=ReferrersManage
r&action=index&widget=undefined&idSite=1&period=range&date=last30&showtitle=1&random=4693&activated=
php -v
ea-php-cli Copyright 2017 cPanel, Inc.
PHP 7.0.23 (cli) (built: Sep 6 2017 03:11:01) ( NTS )
Copyright © 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright © 1998-2017 Zend Technologies
with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v6.1.0 (), Copyright © 2002-2017, by ionCube Ltd.
with Zend OPcache v7.0.23, Copyright © 1999-2017, by Zend Technologies
apachectl -v
Server version: Apache/2.4.27 (cPanel)
Server built: Sep 1 2017 13:16:26
apachectl -M
Loaded Modules:
core_module (static)
so_module (static)
http_module (static)
mpm_worker_module (shared)
cgid_module (shared)
access_compat_module (shared)
actions_module (shared)
alias_module (shared)
auth_basic_module (shared)
authn_core_module (shared)
authn_file_module (shared)
authz_core_module (shared)
authz_groupfile_module (shared)
authz_host_module (shared)
authz_user_module (shared)
autoindex_module (shared)
dav_module (shared)
dav_fs_module (shared)
dav_lock_module (shared)
deflate_module (shared)
dir_module (shared)
env_module (shared)
expires_module (shared)
filter_module (shared)
headers_module (shared)
include_module (shared)
log_config_module (shared)
logio_module (shared)
macro_module (shared)
mime_module (shared)
negotiation_module (shared)
proxy_module (shared)
proxy_fcgi_module (shared)
proxy_http_module (shared)
proxy_wstunnel_module (shared)
rewrite_module (shared)
setenvif_module (shared)
slotmem_shm_module (shared)
socache_dbm_module (shared)
socache_shmcb_module (shared)
status_module (shared)
suexec_module (shared)
unique_id_module (shared)
unixd_module (shared)
userdir_module (shared)
version_module (shared)
ssl_module (shared)
http2_module (shared)
bwlimited_module (shared)
security2_module (shared)
suphp_module (shared)