@tsteur opened this Issue on February 14th 2022 Member

Happened with PHP 8.

#0 plugins\/Live\/Model.php(636): date('Y-m-d H:i:s', '0 WAITFOR DELA...')\n#1 plugins\/Live\/Model.php(495): Piwik\Plugins\Live\Model->getWhereClauseAndBind('log_visit.idsit...', Array, Object(Piwik\Date), NULL, false, '0 WAITFOR DELA...')\n#2 plugins\/Live\/Model.php(78): Piwik\Plugins\Live\Model->makeLogVisitsQueryString('4', Object(Piwik\Date), NULL, false, 0, 101, false, '0 WAITFOR DELA...', '')\n#3 plugins\/Live\/API.php(363): Piwik\Plugins\Live\Model->queryLogVisits('4', 'range', 'last3', false, 0, 101, false, '0 WAITFOR DELA...', '', true)\n#4 plugins\/Live\/API.php(174): Piwik\Plugins\Live\API->loadLastVisitsDetailsFromDatabase('4', 'range', 'last3', false, 0, 100, '0 WAITFOR DELA...', '', false)\n#5 [internal function]: Piwik\Plugins\Live\API->getLastVisitsDetails('4', 'range', 'last3', false, false, '0 WAITFOR DELA...', false, false, false)\n#6 core\/API\/Proxy.php(244): call_user_func_array(Array, Array)\n#7 core\/Context.php(28): Piwik\API\Proxy->Piwik\API\{closure}()\n#8 core\/API\/Proxy.php(335): Piwik\Context::executeWithQueryParameters(Array, Object(Closure))\n#9 core\/API\/Request.php(266): Piwik\API\Proxy->call('\\Piwik\\Plugins\\...', 'getLastVisitsDe...', Array)\n#10 plugins\/API\/Controller.php(46): Piwik\API\Request->process()\n#11 [internal function]: Piwik\Plugins\API\Controller->index()\n#12

URL: index.php

Referrer: index.php?module=CoreHome&action=index&idSite=4&period=day&date=yesterday

GET: {"filter_limit":"100"}

POST: {"token_auth":"XYZANONYMIZED","force_api_session":"1","period":"range","idSite":"4","segment":"","date":"last3","format":"json","showRawMetrics":"1","module":"API","method":"Live.getLastVisitsDetails","filter_limit":"100","showColumns":"latitude,longitude,actions,lastActionTimestamp,visitLocalTime,city,country,countryCode,referrerType,referrerName,referrerTypeName,browserIcon,operatingSystemIcon,deviceType,deviceModel,countryFlag,idVisit,actionDetails,continentCode,actions,searches,goalConversions,visitorId,userId","minTimestamp":"0 WAITFOR DELAY '0:0:5'"}

seems the issue is caused by ,"minTimestamp":"0 WAITFOR DELAY '0:0:5'"}

This Issue was closed on February 15th 2022
Powered by GitHub Issue Mirror