json_encode error on event widget

dobie_gillis · September 25, 2014, 9:20pm

Hi, I got this error on an event widget after clicked “Pivot by Event Action”.
This is on PHP 5.3.2, Piwik 2.7.0.


Warning: json_encode() [function.json-encode]: Invalid UTF-8 sequence in argument in /local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Visualization.php on line 626 

Backtrace -->

#0 Piwik\Error::errorHandler(...) called at [:]
#1 json_encode(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Visualization.php:626]
#2 Piwik\Plugin\Visualization->makeSureArrayContainsOnlyStrings(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Visualization.php:590]
#3 Piwik\Plugin\Visualization->logMessageIfRequestPropertiesHaveChanged(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Visualization.php:175]
#4 Piwik\Plugin\Visualization->buildView(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/ViewDataTable.php:414]
#5 Piwik\Plugin\ViewDataTable->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Report.php:298]
#6 Piwik\Plugin\Report->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/CoreHome/Controller.php:78]
#7 Piwik\Plugins\CoreHome\Controller->renderReportWidget(...) called at [:]
#8 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#9 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#10 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/dispatch.php:34]
#11 require_once(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/index.php:46]



#0 Piwik\Error::errorHandler(...) called at [:]
#1 json_encode(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Extension/Core.php:645]
#2 twig_jsonencode_filter(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/e5/b3/762f387d60e463f5ff91402d788147e813a6b1517fcc1f38237f72ce4cf7.php:60]
#3 __TwigTemplate_e5b3762f387d60e463f5ff91402d788147e813a6b1517fcc1f38237f72ce4cf7->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#4 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#5 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:264]
#6 Twig_Template->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Environment.php:292]
#7 Twig_Environment->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View.php:263]
#8 Piwik\View->renderTwigTemplate(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View.php:257]
#9 Piwik\View->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/ViewDataTable.php:415]
#10 Piwik\Plugin\ViewDataTable->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Report.php:298]
#11 Piwik\Plugin\Report->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/CoreHome/Controller.php:78]
#12 Piwik\Plugins\CoreHome\Controller->renderReportWidget(...) called at [:]
#13 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#14 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#15 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/dispatch.php:34]
#16 require_once(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/index.php:46]


{"date":"2014-09-25","module":"Events","action":"getName","secondaryDimension":"eventAction","widget":"1","idSite":"1","period":"week","filter_limit":"10","filter_sort_order":"desc","viewDataTable":"table","pivotBy":"Events.EventAction","pivotByColumn":"nb_events","filter_offset":0,"filter_sort_column":null,"totalRows":3}">
EVENT NAME

#0 PIWIK\ERROR::ERRORHANDLER(...) CALLED AT [:]
#1 HTMLSPECIALCHARS(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/EXTENSION/CORE.PHP:970]
#2 TWIG_ESCAPE_FILTER(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/TMP/TEMPLATES_C/C2/22/40CEF23DCBBD06133024477AEEB474D1F49C5A50CE75D014648540340FB8.PHP:51]
#3 __TWIGTEMPLATE_C22240CEF23DCBBD06133024477AEEB474D1F49C5A50CE75D014648540340FB8->DODISPLAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:279]
#4 TWIG_TEMPLATE->DISPLAYWITHERRORHANDLING(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:253]
#5 TWIG_TEMPLATE->DISPLAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/TMP/TEMPLATES_C/5D/32/BD9AA0EBE47F85E313DD430CA13ED0BE0460E631D9E02D59911BE52C4CF8.PHP:36]
#6 __TWIGTEMPLATE_5D32BD9AA0EBE47F85E313DD430CA13ED0BE0460E631D9E02D59911BE52C4CF8->DODISPLAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:279]
#7 TWIG_TEMPLATE->DISPLAYWITHERRORHANDLING(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:253]
#8 TWIG_TEMPLATE->DISPLAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/TMP/TEMPLATES_C/E5/B3/762F387D60E463F5FF91402D788147E813A6B1517FCC1F38237F72CE4CF7.PHP:117]
#9 __TWIGTEMPLATE_E5B3762F387D60E463F5FF91402D788147E813A6B1517FCC1F38237F72CE4CF7->DODISPLAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:279]
#10 TWIG_TEMPLATE->DISPLAYWITHERRORHANDLING(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:253]
#11 TWIG_TEMPLATE->DISPLAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:264]
#12 TWIG_TEMPLATE->RENDER(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/ENVIRONMENT.PHP:292]
#13 TWIG_ENVIRONMENT->RENDER(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/VIEW.PHP:263]
#14 PIWIK\VIEW->RENDERTWIGTEMPLATE(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/VIEW.PHP:257]
#15 PIWIK\VIEW->RENDER(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/PLUGIN/VIEWDATATABLE.PHP:415]
#16 PIWIK\PLUGIN\VIEWDATATABLE->RENDER(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/PLUGIN/REPORT.PHP:298]
#17 PIWIK\PLUGIN\REPORT->RENDER(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/PLUGINS/COREHOME/CONTROLLER.PHP:78]
#18 PIWIK\PLUGINS\COREHOME\CONTROLLER->RENDERREPORTWIDGET(...) CALLED AT [:]
#19 CALL_USER_FUNC_ARRAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/FRONTCONTROLLER.PHP:577]
#20 PIWIK\FRONTCONTROLLER->DODISPATCH(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/FRONTCONTROLLER.PHP:86]
#21 PIWIK\FRONTCONTROLLER->DISPATCH(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/DISPATCH.PHP:34]
#22 REQUIRE_ONCE(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/INDEX.PHP:46]


">
1.�PAGE LOAD

#0 PIWIK\ERROR::ERRORHANDLER(...) CALLED AT [:]
#1 HTMLSPECIALCHARS(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/EXTENSION/CORE.PHP:970]
#2 TWIG_ESCAPE_FILTER(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/TMP/TEMPLATES_C/C2/22/40CEF23DCBBD06133024477AEEB474D1F49C5A50CE75D014648540340FB8.PHP:51]
#3 __TWIGTEMPLATE_C22240CEF23DCBBD06133024477AEEB474D1F49C5A50CE75D014648540340FB8->DODISPLAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:279]
#4 TWIG_TEMPLATE->DISPLAYWITHERRORHANDLING(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:253]
#5 TWIG_TEMPLATE->DISPLAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/TMP/TEMPLATES_C/5D/32/BD9AA0EBE47F85E313DD430CA13ED0BE0460E631D9E02D59911BE52C4CF8.PHP:36]
#6 __TWIGTEMPLATE_5D32BD9AA0EBE47F85E313DD430CA13ED0BE0460E631D9E02D59911BE52C4CF8->DODISPLAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:279]
#7 TWIG_TEMPLATE->DISPLAYWITHERRORHANDLING(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:253]
#8 TWIG_TEMPLATE->DISPLAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/TMP/TEMPLATES_C/E5/B3/762F387D60E463F5FF91402D788147E813A6B1517FCC1F38237F72CE4CF7.PHP:117]
#9 __TWIGTEMPLATE_E5B3762F387D60E463F5FF91402D788147E813A6B1517FCC1F38237F72CE4CF7->DODISPLAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:279]
#10 TWIG_TEMPLATE->DISPLAYWITHERRORHANDLING(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:253]
#11 TWIG_TEMPLATE->DISPLAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/TEMPLATE.PHP:264]
#12 TWIG_TEMPLATE->RENDER(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/VENDOR/TWIG/TWIG/LIB/TWIG/ENVIRONMENT.PHP:292]
#13 TWIG_ENVIRONMENT->RENDER(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/VIEW.PHP:263]
#14 PIWIK\VIEW->RENDERTWIGTEMPLATE(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/VIEW.PHP:257]
#15 PIWIK\VIEW->RENDER(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/PLUGIN/VIEWDATATABLE.PHP:415]
#16 PIWIK\PLUGIN\VIEWDATATABLE->RENDER(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/PLUGIN/REPORT.PHP:298]
#17 PIWIK\PLUGIN\REPORT->RENDER(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/PLUGINS/COREHOME/CONTROLLER.PHP:78]
#18 PIWIK\PLUGINS\COREHOME\CONTROLLER->RENDERREPORTWIDGET(...) CALLED AT [:]
#19 CALL_USER_FUNC_ARRAY(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/FRONTCONTROLLER.PHP:577]
#20 PIWIK\FRONTCONTROLLER->DODISPATCH(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/FRONTCONTROLLER.PHP:86]
#21 PIWIK\FRONTCONTROLLER->DISPATCH(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/CORE/DISPATCH.PHP:34]
#22 REQUIRE_ONCE(...) CALLED AT [/LOCAL/CCNMTL/VAR-WWW-CCNMTL/WWW/PIWIK/INDEX.PHP:46]


">
2.�STUDENT.PDF

capedfuzz · September 26, 2014, 3:31am

Can you post a screenshot of the event action table before you try to pivot it? And in the screenshot, can you make sure some of the subtables are loaded and displayed?

Also, if you export the un-pivoted table, add &expanded=1 to the table and reload, does it work?

dobie_gillis · October 1, 2014, 6:51pm

I don’t have that widget still around to screenshot, but a similar error just happened to me on the widget at the Action -> Event page. I can’t undo the pivot because the widget won’t respond to any mouse clicks, or delete this widget since I didn’t create it in the first place. I’ll have to revert the database from a backup.

Here’s the log:

http://dpaste.com/0MMY7AX


Warning: json_encode() [function.json-encode]: Invalid UTF-8 sequence in argument in /local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Visualization.php on line 626

Backtrace -->

#0 Piwik\Error::errorHandler(...) called at [:]
#1 json_encode(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Visualization.php:626]
#2 Piwik\Plugin\Visualization->makeSureArrayContainsOnlyStrings(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Visualization.php:590]
#3 Piwik\Plugin\Visualization->logMessageIfRequestPropertiesHaveChanged(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Visualization.php:175]
#4 Piwik\Plugin\Visualization->buildView(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/ViewDataTable.php:414]
#5 Piwik\Plugin\ViewDataTable->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Report.php:298]
#6 Piwik\Plugin\Report->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Controller.php:327]
#7 Piwik\Plugin\Controller->renderReport(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:96]
#8 Piwik\Plugins\Events\Controller->indexEvent(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:43]
#9 Piwik\Plugins\Events\Controller->indexCategory(...) called at [:]
#10 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#11 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#12 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:197]
#13 Piwik\FrontController->fetchDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View/ReportsByDimension.php:121]
#14 Piwik\View\ReportsByDimension->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:38]
#15 Piwik\Plugins\Events\Controller->getLeftMenuReports(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:22]
#16 Piwik\Plugins\Events\Controller->index(...) called at [:]
#17 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#18 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#19 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/dispatch.php:34]
#20 require_once(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/index.php:46]



    Event Names

Event Categories

#0 Piwik\Error::errorHandler(...) called at [:]
#1 json_encode(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Extension/Core.php:645]
#2 twig_jsonencode_filter(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/e5/b3/762f387d60e463f5ff91402d788147e813a6b1517fcc1f38237f72ce4cf7.php:60]
#3 __TwigTemplate_e5b3762f387d60e463f5ff91402d788147e813a6b1517fcc1f38237f72ce4cf7->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#4 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#5 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:264]
#6 Twig_Template->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Environment.php:292]
#7 Twig_Environment->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View.php:263]
#8 Piwik\View->renderTwigTemplate(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View.php:257]
#9 Piwik\View->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/ViewDataTable.php:415]
#10 Piwik\Plugin\ViewDataTable->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Report.php:298]
#11 Piwik\Plugin\Report->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Controller.php:327]
#12 Piwik\Plugin\Controller->renderReport(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:96]
#13 Piwik\Plugins\Events\Controller->indexEvent(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:43]
#14 Piwik\Plugins\Events\Controller->indexCategory(...) called at [:]
#15 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#16 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#17 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:197]
#18 Piwik\FrontController->fetchDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View/ReportsByDimension.php:121]
#19 Piwik\View\ReportsByDimension->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:38]
#20 Piwik\Plugins\Events\Controller->getLeftMenuReports(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:22]
#21 Piwik\Plugins\Events\Controller->index(...) called at [:]
#22 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#23 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#24 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/dispatch.php:34]
#25 require_once(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/index.php:46]


{"isFooterExpandedInDashboard":true,"viewDataTable":"table","date":"2014-09-05","module":"Events","action":"getCategory","idSite":"1","period":"month","secondaryDimension":"eventAction","filter_offset":0,"flat":0,"pivotBy":"Events.EventAction","filter_limit":10,"filter_sort_column":null,"filter_sort_order":"desc","totalRows":3}">
Event Category
	
#0 Piwik\Error::errorHandler(...) called at [:]
#1 htmlspecialchars(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Extension/Core.php:970]
#2 twig_escape_filter(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/c2/22/40cef23dcbbd06133024477aeeb474d1f49c5a50ce75d014648540340fb8.php:51]
#3 __TwigTemplate_c22240cef23dcbbd06133024477aeeb474d1f49c5a50ce75d014648540340fb8->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#4 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#5 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/5d/32/bd9aa0ebe47f85e313dd430ca13ed0be0460e631d9e02d59911be52c4cf8.php:36]
#6 __TwigTemplate_5d32bd9aa0ebe47f85e313dd430ca13ed0be0460e631d9e02d59911be52c4cf8->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#7 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#8 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/e5/b3/762f387d60e463f5ff91402d788147e813a6b1517fcc1f38237f72ce4cf7.php:117]
#9 __TwigTemplate_e5b3762f387d60e463f5ff91402d788147e813a6b1517fcc1f38237f72ce4cf7->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#10 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#11 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:264]
#12 Twig_Template->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Environment.php:292]
#13 Twig_Environment->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View.php:263]
#14 Piwik\View->renderTwigTemplate(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View.php:257]
#15 Piwik\View->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/ViewDataTable.php:415]
#16 Piwik\Plugin\ViewDataTable->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Report.php:298]
#17 Piwik\Plugin\Report->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Controller.php:327]
#18 Piwik\Plugin\Controller->renderReport(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:96]
#19 Piwik\Plugins\Events\Controller->indexEvent(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:43]
#20 Piwik\Plugins\Events\Controller->indexCategory(...) called at [:]
#21 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#22 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#23 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:197]
#24 Piwik\FrontController->fetchDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View/ReportsByDimension.php:121]
#25 Piwik\View\ReportsByDimension->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:38]
#26 Piwik\Plugins\Events\Controller->getLeftMenuReports(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:22]
#27 Piwik\Plugins\Events\Controller->index(...) called at [:]
#28 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#29 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#30 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/dispatch.php:34]
#31 require_once(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/index.php:46]


">
1.�Page Load
	
#0 Piwik\Error::errorHandler(...) called at [:]
#1 htmlspecialchars(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Extension/Core.php:970]
#2 twig_escape_filter(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/c2/22/40cef23dcbbd06133024477aeeb474d1f49c5a50ce75d014648540340fb8.php:51]
#3 __TwigTemplate_c22240cef23dcbbd06133024477aeeb474d1f49c5a50ce75d014648540340fb8->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#4 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#5 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/5d/32/bd9aa0ebe47f85e313dd430ca13ed0be0460e631d9e02d59911be52c4cf8.php:36]
#6 __TwigTemplate_5d32bd9aa0ebe47f85e313dd430ca13ed0be0460e631d9e02d59911be52c4cf8->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#7 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#8 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/e5/b3/762f387d60e463f5ff91402d788147e813a6b1517fcc1f38237f72ce4cf7.php:117]
#9 __TwigTemplate_e5b3762f387d60e463f5ff91402d788147e813a6b1517fcc1f38237f72ce4cf7->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#10 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#11 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:264]
#12 Twig_Template->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Environment.php:292]
#13 Twig_Environment->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View.php:263]
#14 Piwik\View->renderTwigTemplate(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View.php:257]
#15 Piwik\View->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/ViewDataTable.php:415]
#16 Piwik\Plugin\ViewDataTable->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Report.php:298]
#17 Piwik\Plugin\Report->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Controller.php:327]
#18 Piwik\Plugin\Controller->renderReport(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:96]
#19 Piwik\Plugins\Events\Controller->indexEvent(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:43]
#20 Piwik\Plugins\Events\Controller->indexCategory(...) called at [:]
#21 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#22 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#23 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:197]
#24 Piwik\FrontController->fetchDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View/ReportsByDimension.php:121]
#25 Piwik\View\ReportsByDimension->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:38]
#26 Piwik\Plugins\Events\Controller->getLeftMenuReports(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:22]
#27 Piwik\Plugins\Events\Controller->index(...) called at [:]
#28 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#29 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#30 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/dispatch.php:34]
#31 require_once(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/index.php:46]


">
2.�Download
	
#0 Piwik\Error::errorHandler(...) called at [:]
#1 htmlspecialchars(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Extension/Core.php:970]
#2 twig_escape_filter(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/c2/22/40cef23dcbbd06133024477aeeb474d1f49c5a50ce75d014648540340fb8.php:51]
#3 __TwigTemplate_c22240cef23dcbbd06133024477aeeb474d1f49c5a50ce75d014648540340fb8->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#4 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#5 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/5d/32/bd9aa0ebe47f85e313dd430ca13ed0be0460e631d9e02d59911be52c4cf8.php:36]
#6 __TwigTemplate_5d32bd9aa0ebe47f85e313dd430ca13ed0be0460e631d9e02d59911be52c4cf8->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#7 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#8 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/e5/b3/762f387d60e463f5ff91402d788147e813a6b1517fcc1f38237f72ce4cf7.php:117]
#9 __TwigTemplate_e5b3762f387d60e463f5ff91402d788147e813a6b1517fcc1f38237f72ce4cf7->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#10 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#11 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:264]
#12 Twig_Template->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Environment.php:292]
#13 Twig_Environment->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View.php:263]
#14 Piwik\View->renderTwigTemplate(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View.php:257]
#15 Piwik\View->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/ViewDataTable.php:415]
#16 Piwik\Plugin\ViewDataTable->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Report.php:298]
#17 Piwik\Plugin\Report->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Controller.php:327]
#18 Piwik\Plugin\Controller->renderReport(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:96]
#19 Piwik\Plugins\Events\Controller->indexEvent(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:43]
#20 Piwik\Plugins\Events\Controller->indexCategory(...) called at [:]
#21 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#22 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#23 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:197]
#24 Piwik\FrontController->fetchDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View/ReportsByDimension.php:121]
#25 Piwik\View\ReportsByDimension->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:38]
#26 Piwik\Plugins\Events\Controller->getLeftMenuReports(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:22]
#27 Piwik\Plugins\Events\Controller->index(...) called at [:]
#28 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#29 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#30 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/dispatch.php:34]
#31 require_once(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/index.php:46]


">
3.�student.pdf
	
#0 Piwik\Error::errorHandler(...) called at [:]
#1 htmlspecialchars(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Extension/Core.php:970]
#2 twig_escape_filter(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/c2/22/40cef23dcbbd06133024477aeeb474d1f49c5a50ce75d014648540340fb8.php:51]
#3 __TwigTemplate_c22240cef23dcbbd06133024477aeeb474d1f49c5a50ce75d014648540340fb8->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#4 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#5 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/5d/32/bd9aa0ebe47f85e313dd430ca13ed0be0460e631d9e02d59911be52c4cf8.php:36]
#6 __TwigTemplate_5d32bd9aa0ebe47f85e313dd430ca13ed0be0460e631d9e02d59911be52c4cf8->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#7 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#8 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/tmp/templates_c/e5/b3/762f387d60e463f5ff91402d788147e813a6b1517fcc1f38237f72ce4cf7.php:117]
#9 __TwigTemplate_e5b3762f387d60e463f5ff91402d788147e813a6b1517fcc1f38237f72ce4cf7->doDisplay(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#10 Twig_Template->displayWithErrorHandling(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#11 Twig_Template->display(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Template.php:264]
#12 Twig_Template->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/vendor/twig/twig/lib/Twig/Environment.php:292]
#13 Twig_Environment->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View.php:263]
#14 Piwik\View->renderTwigTemplate(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View.php:257]
#15 Piwik\View->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/ViewDataTable.php:415]
#16 Piwik\Plugin\ViewDataTable->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Report.php:298]
#17 Piwik\Plugin\Report->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/Plugin/Controller.php:327]
#18 Piwik\Plugin\Controller->renderReport(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:96]
#19 Piwik\Plugins\Events\Controller->indexEvent(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:43]
#20 Piwik\Plugins\Events\Controller->indexCategory(...) called at [:]
#21 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#22 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#23 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:197]
#24 Piwik\FrontController->fetchDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/View/ReportsByDimension.php:121]
#25 Piwik\View\ReportsByDimension->render(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:38]
#26 Piwik\Plugins\Events\Controller->getLeftMenuReports(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/plugins/Events/Controller.php:22]
#27 Piwik\Plugins\Events\Controller->index(...) called at [:]
#28 call_user_func_array(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:577]
#29 Piwik\FrontController->doDispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/FrontController.php:86]
#30 Piwik\FrontController->dispatch(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/core/dispatch.php:34]
#31 require_once(...) called at [/local/ccnmtl/var-www-ccnmtl/www/piwik/index.php:46]


">
4.�teacher pdf.pdf

dobie_gillis · October 1, 2014, 9:16pm

I was able to fix this error by running this query:


DELETE FROM piwik_option WHERE option_name LIKE 'viewData%';

nkuehn · October 1, 2014, 9:50pm

I can confirm this bug in the events UI in Piwik 2.7.0.

After requesting a Pivot view for the first time the events view is not usable any more.

The error messages match the ones dobie_gillis posted above.

Unfortunately I cannot get back to the View before the switch to pivot view because the error breaks the control to switch back to non-pivoted

I have manually removed all the error messages from the page state with error to get back to a “screenshottable” size and have pasted that as an attachment here.

Every

Table header of the table contained the following error (which I removed to be able to make a screenshot):


#0  Piwik\Error::errorHandler(...) called at [:]<br>
#1  htmlspecialchars(...) called at [/srv/www/piwik.excentos.com/piwik/vendor/twig/twig/lib/Twig/Extension/Core.php:970]<br>
#2  twig_escape_filter(...) called at [/srv/www/piwik.excentos.com/piwik/tmp/templates_c/11/fd/ee0e33e3fd0848c70c9845f1915ac80a2649b997ee025ece6695f0b8dea3.php:51]<br>
#3  __TwigTemplate_11fdee0e33e3fd0848c70c9845f1915ac80a2649b997ee025ece6695f0b8dea3->doDisplay(...) called at [/srv/www/piwik.excentos.com/piwik/vendor/twig/twig/lib/Twig/Template.php:279]<br>
#4  Twig_Template->displayWithErrorHandling(...) called at [/srv/www/piwik.excentos.com/piwik/vendor/twig/twig/lib/Twig/Template.php:253]<br>
#5  Twig_Template->display(...) called at [/srv/www/piwik.excentos.com/piwik/tmp/templates_c/96/55/d6e0c9a9fb73934a6d33fdcd2f0f4ca9221e3ea2822f21d18c42946e2b1b.php:36]<br>
#6  __TwigTemplate_9655d6e0c9a9fb73934a6d33fdcd2f0f4ca9221e3ea2822f21d18c42946e2b1b->doDisplay(...) called at [/srv/www/piwik.excentos.com/piwik/vendor/twig/twig/lib/Twig/Template.php:279]<br>
#7  Twig_Template->displayWithErrorHandling(...) called at [/srv/www/piwik.excentos.com/piwik/vendor/twig/twig/lib/Twig/Template.php:253]<br>
#8  Twig_Template->display(...) called at [/srv/www/piwik.excentos.com/piwik/tmp/templates_c/7f/19/548220fd5c9b601e7795dd5739790ca447faa270af9a4d9634a3e67050a1.php:117]<br>
#9  __TwigTemplate_7f19548220fd5c9b601e7795dd5739790ca447faa270af9a4d9634a3e67050a1->doDisplay(...) called at [/srv/www/piwik.excentos.com/piwik/vendor/twig/twig/lib/Twig/Template.php:279]<br>
#10  Twig_Template->displayWithErrorHandling(...) called at [/srv/www/piwik.excentos.com/piwik/vendor/twig/twig/lib/Twig/Template.php:253]<br>
#11  Twig_Template->display(...) called at [/srv/www/piwik.excentos.com/piwik/vendor/twig/twig/lib/Twig/Template.php:264]<br>
#12  Twig_Template->render(...) called at [/srv/www/piwik.excentos.com/piwik/vendor/twig/twig/lib/Twig/Environment.php:292]<br>
#13  Twig_Environment->render(...) called at [/srv/www/piwik.excentos.com/piwik/core/View.php:263]<br>
#14  Piwik\View->renderTwigTemplate(...) called at [/srv/www/piwik.excentos.com/piwik/core/View.php:257]<br>
#15  Piwik\View->render(...) called at [/srv/www/piwik.excentos.com/piwik/core/Plugin/ViewDataTable.php:415]<br>
#16  Piwik\Plugin\ViewDataTable->render(...) called at [/srv/www/piwik.excentos.com/piwik/core/Plugin/Report.php:298]<br>
#17  Piwik\Plugin\Report->render(...) called at [/srv/www/piwik.excentos.com/piwik/core/Plugin/Controller.php:327]<br>
#18  Piwik\Plugin\Controller->renderReport(...) called at [/srv/www/piwik.excentos.com/piwik/plugins/Events/Controller.php:96]<br>
#19  Piwik\Plugins\Events\Controller->indexEvent(...) called at [/srv/www/piwik.excentos.com/piwik/plugins/Events/Controller.php:43]<br>
#20  Piwik\Plugins\Events\Controller->indexCategory(...) called at [:]<br>
#21  call_user_func_array(...) called at [/srv/www/piwik.excentos.com/piwik/core/FrontController.php:577]<br>
#22  Piwik\FrontController->doDispatch(...) called at [/srv/www/piwik.excentos.com/piwik/core/FrontController.php:86]<br>
#23  Piwik\FrontController->dispatch(...) called at [/srv/www/piwik.excentos.com/piwik/core/FrontController.php:197]<br>
#24  Piwik\FrontController->fetchDispatch(...) called at [/srv/www/piwik.excentos.com/piwik/core/View/ReportsByDimension.php:121]<br>
#25  Piwik\View\ReportsByDimension->render(...) called at [/srv/www/piwik.excentos.com/piwik/plugins/Events/Controller.php:38]<br>
#26  Piwik\Plugins\Events\Controller->getLeftMenuReports(...) called at [/srv/www/piwik.excentos.com/piwik/plugins/Events/Controller.php:22]<br>
#27  Piwik\Plugins\Events\Controller->index(...) called at [:]<br>
#28  call_user_func_array(...) called at [/srv/www/piwik.excentos.com/piwik/core/FrontController.php:577]<br>
#29  Piwik\FrontController->doDispatch(...) called at [/srv/www/piwik.excentos.com/piwik/core/FrontController.php:86]<br>
#30  Piwik\FrontController->dispatch(...) called at [/srv/www/piwik.excentos.com/piwik/core/dispatch.php:34]<br>
#31  require_once(...) called at [/srv/www/piwik.excentos.com/piwik/index.php:46]<br>

Report that to the Github Issue tracker, too?

nkuehn · October 1, 2014, 9:53pm

Hi, I just saw that dobie_gills posted a preliminary per-installation fix (SQL above). Can anyone confirm that the Query doesn’t break other stuff? It looks quite far-reaching to me on first glance.

dobie_gillis · October 1, 2014, 9:55pm

nkuehn, It removes any customizations you have on the events widget.

I just opened a Github issue here: json_encode error when pivoting event widget · Issue #6364 · matomo-org/matomo · GitHub