Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

json_encode error when pivoting event widget #6364

Closed
nikolas opened this issue Oct 1, 2014 · 22 comments
Closed

json_encode error when pivoting event widget #6364

nikolas opened this issue Oct 1, 2014 · 22 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.

Comments

@nikolas
Copy link

nikolas commented Oct 1, 2014

It was suggested on the Piwik forum that I open this issue here as well. http://forum.piwik.org/read.php?2,120372,120568

I get an error when I pivot 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. This is on Piwik 2.7.0., PHP 5.3.2.

If you run into this issue, the only way to get out of this state is to revert the database to a previous version, or run this SQL query: DELETE FROM piwik_option WHERE option_name LIKE 'viewData%';

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
@nikolas nikolas changed the title json_encode error on event widget json_encode error when pivoting event widget Oct 1, 2014
@mattab
Copy link
Member

mattab commented Oct 2, 2014

Thanks for the report!

What version of PHP are you using?

@mattab mattab added Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. labels Oct 2, 2014
@mattab mattab added this to the Short term milestone Oct 2, 2014
@nikolas
Copy link
Author

nikolas commented Oct 2, 2014

@mattab PHP 5.3.2, it's mentioned in the forum post.

@mattab
Copy link
Member

mattab commented Oct 2, 2014

@nikolas can you upgrade to more recent PHP ? I expect this bug is due to a bug in PHP 5.3.2. Thanks

@mattab mattab closed this as completed Oct 2, 2014
@mattab mattab added the wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it. label Oct 2, 2014
@nikolas
Copy link
Author

nikolas commented Oct 2, 2014

@mattab no I can't, I don't control the servers that run this version of PHP.

@nikolas
Copy link
Author

nikolas commented Oct 2, 2014

@mattab If you're closing this as "wontfix", please change the requirements on the README, currently they say piwik supports "PHP 5.3.2 or greater"

@mattab
Copy link
Member

mattab commented Oct 2, 2014

hundreds of users run it with 5.3.2 and it mostly works. just some features like this may be broken because of bugs in PHP... we can't really increase requirements and block piwik from used by user because of this bug that is triggered in very particular use case. though I agree it's annoying and frustrating for you and i'm sorry about that. Maybe ask your host as often they are able to upgrade php

@sgiehl
Copy link
Member

sgiehl commented Oct 2, 2014

I'm not sure if that is really a 5.3.2 failure. Might be possible that the data given to json_decode in that case just is invalid. Could you maybe try to log the data given to json_decode?

@mattab mattab reopened this Oct 2, 2014
@diosmosis
Copy link
Member

@sgiehl It appears to be the decoded ' ' character (though w/o a screenshot I can't tell for sure). I've been trying to get PHP 5.3.2 to test, but the source code doesn't seem to be available on http://museum.php.net...

@sgiehl
Copy link
Member

sgiehl commented Oct 2, 2014

@diosmosis
Copy link
Member

@sgiehl Thanks! I'll do some testing just as soon as I'm done building 5.6

@tsteur
Copy link
Member

tsteur commented Oct 4, 2014

I know it's off topic but +1 for mentioning PHP 5.3.3 requirement (and also checking for it in update-check) in case we do not fully support it as this is very annoying otherwise

@mattab
Copy link
Member

mattab commented Oct 6, 2014

@nikolas Could you maybe temporarily try it on PHP > 5.3.2 ? it would be nice to double check that this bug is indeed a bug in 5.3.2 implementation of JSON.

@diosmosis
Copy link
Member

I created an ec2 instance using ubuntu 10.04 and can confirm the issue is w/ the code json_encode(html_entity_decode(' ')). We can fix it by replacing such strings w/ ' ' in JSON renderers (API + DataTable).

@mattab mattab removed the wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it. label Oct 6, 2014
@mattab
Copy link
Member

mattab commented Oct 6, 2014

OK we will increase Piwik PHP requirement to PHP 5.3.3: #6390

@mattab mattab closed this as completed Oct 6, 2014
@mattab mattab added the wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it. label Oct 14, 2014
@nkuehn
Copy link

nkuehn commented Oct 16, 2014

Hi, sorry for not catching up on time (I posted my report in the forum thread above, too).
I am sure this is not PHP 5.3.2<. related as our server is running PHP 5.3.10-1ubuntu3.14 and shows the error, too.
My gut says the suspect is the json_encode(html_entity_decode('&nbsp;')) issue mentioned by @diosmosis above.
The issue is still prevalent on 2.8.0 in my installation, even after resetting the view Data via the SQL statement mentioned above.

FIRST error i get is: (maybe unrelated)

WARN CoreHome[2014-10-16 08:29:18] [4b534] Failed to get data from API: The date '2014-10-09' is not a correct date range. It should have the following format:  'lastN', 'previousN', 'YYYY-MM-DD,YYYY-MM-DD'.
#0 /srv/www/piwik.excentos.com/piwik/core/Period.php(102): Piwik\Period\Range->generate()
#1 /srv/www/piwik.excentos.com/piwik/core/Period/Range.php(96): Piwik\Period->getDateStart()
#2 /srv/www/piwik.excentos.com/piwik/core/Period.php(272): Piwik\Period\Range->getDateStart()
#3 /srv/www/piwik.excentos.com/piwik/core/Archive/DataCollection.php(120): Piwik\Period->getRangeString()
#4 /srv/www/piwik.excentos.com/piwik/core/Archive.php(506): Piwik\Archive\DataCollection->__construct(Array, 'blob', Array, Array, NULL)
#5 /srv/www/piwik.excentos.com/piwik/core/Archive.php(375): Piwik\Archive->get('Events_name_cat...', 'blob', '2')
#6 /srv/www/piwik.excentos.com/piwik/core/Archive.php(470): Piwik\Archive->getDataTable('Events_name_cat...', '2')
#7 /srv/www/piwik.excentos.com/piwik/plugins/Events/API.php(156): Piwik\Archive::getDataTableFromArchive('Events_name_cat...', '1', 'range', '2014-10-09', false, false, '2')
#8 /srv/www/piwik.excentos.com/piwik/plugins/Events/API.php(203): Piwik\Plugins\Events\API->getDataTable('getCategoryFrom...', '1', 'range', '2014-10-09', false, false, '2')
#9 [internal function]: Piwik\Plugins\Events\API->getCategoryFromNameId('1', 'range', '2014-10-09', '2', false)
#10 /srv/www/piwik.excentos.com/piwik/core/API/Proxy.php(209): call_user_func_array(Array, Array)
#11 /srv/www/piwik.excentos.com/piwik/core/API/Request.php(216): Piwik\API\Proxy->call('\Piwik\Plugins\...', 'getCategoryFrom...', Array)
#12 /srv/www/piwik.excentos.com/piwik/core/API/Request.php(304): Piwik\API\Request->process()
#13 /srv/www/piwik.excentos.com/piwik/core/Plugin/Report.php(646): Piwik\API\Request::processRequest('Events.getCateg...', Array)
#14 /srv/www/piwik.excentos.com/piwik/core/DataTable/Filter/PivotByDimension.php(290): Piwik\Plugin\Report->fetchSubtable(2, Array)
#15 /srv/www/piwik.excentos.com/piwik/core/DataTable/Filter/PivotByDimension.php(263): Piwik\DataTable\Filter\PivotByDimension->loadSubtable(Object(Piwik\DataTable), Object(Piwik\DataTable\Row))
#16 /srv/www/piwik.excentos.com/piwik/core/DataTable/Filter/PivotByDimension.php(192): Piwik\DataTable\Filter\PivotByDimension->getIntersectedTable(Object(Piwik\DataTable), Object(Piwik\DataTable\Row))
#17 /srv/www/piwik.excentos.com/piwik/core/DataTable.php(425): Piwik\DataTable\Filter\PivotByDimension->filter(Object(Piwik\DataTable))
#18 /srv/www/piwik.excentos.com/piwik/core/API/ResponseBuilder.php(172): Piwik\DataTable->filter('PivotByDimensio...', Array)
#19 /srv/www/piwik.excentos.com/piwik/core/API/ResponseBuilder.php(91): Piwik\API\ResponseBuilder->handleDataTable(Object(Piwik\DataTable))
#20 /srv/www/piwik.excentos.com/piwik/core/API/Request.php(218): Piwik\API\ResponseBuilder->getResponse(Object(Piwik\DataTable), 'Events', 'getAction')
#21 /srv/www/piwik.excentos.com/piwik/core/ViewDataTable/Request.php(48): Piwik\API\Request->process()
#22 /srv/www/piwik.excentos.com/piwik/core/Plugin/ViewDataTable.php(327): Piwik\ViewDataTable\Request->loadDataTableFromAPI(Array)
#23 /srv/www/piwik.excentos.com/piwik/core/Plugin/Visualization.php(166): Piwik\Plugin\ViewDataTable->loadDataTableFromAPI(Array)
#24 /srv/www/piwik.excentos.com/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView()
#25 /srv/www/piwik.excentos.com/piwik/core/Plugin/Report.php(304): Piwik\Plugin\ViewDataTable->render()
#26 /srv/www/piwik.excentos.com/piwik/plugins/CoreHome/Controller.php(78): Piwik\Plugin\Report->render()
#27 [internal function]: Piwik\Plugins\CoreHome\Controller->renderReportWidget('Events', 'getAction')
#28 /srv/www/piwik.excentos.com/piwik/core/FrontController.php(579): call_user_func_array(Array, Array)
#29 /srv/www/piwik.excentos.com/piwik/core/FrontController.php(87): Piwik\FrontController->doDispatch(NULL, NULL, NULL)
#30 /srv/www/piwik.excentos.com/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch()
#31 /srv/www/piwik.excentos.com/piwik/index.php(46): require_once('/srv/www/piwik....')
#32 {main}

The date '2014-10-09' is not a correct date range. It should have the following format: 'lastN', 'previousN', 'YYYY-MM-DD,YYYY-MM-DD'.

After changing the date range to anything else via the date range widget, the actual pivot error is back again:

 There is an error. Please report the message (Piwik 2.8.0) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Warning: json_encode(): Invalid UTF-8 sequence in argument in /srv/www/piwik.excentos.com/piwik/core/Plugin/Visualization.php on line 627

Backtrace -->

#0 Piwik\Error::errorHandler(...) called at [:]
#1 json_encode(...) called at [/srv/www/piwik.excentos.com/piwik/core/Plugin/Visualization.php:627]
#2 Piwik\Plugin\Visualization->makeSureArrayContainsOnlyStrings(...) called at [/srv/www/piwik.excentos.com/piwik/core/Plugin/Visualization.php:591]
#3 Piwik\Plugin\Visualization->logMessageIfRequestPropertiesHaveChanged(...) called at [/srv/www/piwik.excentos.com/piwik/core/Plugin/Visualization.php:175]
#4 Piwik\Plugin\Visualization->buildView(...) called at [/srv/www/piwik.excentos.com/piwik/core/Plugin/ViewDataTable.php:414]
#5 Piwik\Plugin\ViewDataTable->render(...) called at [/srv/www/piwik.excentos.com/piwik/core/Plugin/Report.php:304]
#6 Piwik\Plugin\Report->render(...) called at [/srv/www/piwik.excentos.com/piwik/plugins/CoreHome/Controller.php:78]
#7 Piwik\Plugins\CoreHome\Controller->renderReportWidget(...) called at [:]
#8 call_user_func_array(...) called at [/srv/www/piwik.excentos.com/piwik/core/FrontController.php:579]
#9 Piwik\FrontController->doDispatch(...) called at [/srv/www/piwik.excentos.com/piwik/core/FrontController.php:87]
#10 Piwik\FrontController->dispatch(...) called at [/srv/www/piwik.excentos.com/piwik/core/dispatch.php:34]
#11 require_once(...) called at [/srv/www/piwik.excentos.com/piwik/index.php:46]

I propose reopening this issue

diosmosis pushed a commit that referenced this issue Oct 16, 2014
… encoding. Will avoid php warning given on some PHP 5.3 builds for json_encode-ing decoded &nbsp; entities.
@diosmosis
Copy link
Member

I committed a change that should fix this issue 5.3.* versions that experience the bug.

@nkuehn
Copy link

nkuehn commented Oct 16, 2014

Thanks! I'll check if the next version can cope with the forward slashed in our event values

@diosmosis
Copy link
Member

Note: if you'd like to check sooner, you can replace the core/DataTable/Filter/PivotByDimension.php file with this one: https://raw.githubusercontent.com/piwik/piwik/ebc7d6c2f08d231c95a1aed04c7966c1acf927d3/core/DataTable/Filter/PivotByDimension.php

@nkuehn
Copy link

nkuehn commented Oct 17, 2014

Hi @diosmosis, I applied your changed version - sorry to tell you that nothing changed. As the PivotByDimension Class doesn't appear in my stacktrace (above) that's explicable.

@diosmosis
Copy link
Member

Looks like a dumb mistake on my part, I added the code to the wrong part of the file, I'll apply another fix soon.

diosmosis pushed a commit that referenced this issue Oct 17, 2014
…PHP. When decoding &nbsp; use UTF8 encoding so json_encode will not complain.
@diosmosis
Copy link
Member

@nkuehn I've applied a correct fix to the PivotByDimension.php file. I tested on an ec2 instance setup with php 5.3.2 (via ubuntu 10.04), so this should work. You can apply it in the same manner as before.

@nkuehn
Copy link

nkuehn commented Oct 20, 2014

Hooray, it works! Thank you very much @diosmosis

I still have that "Failed to get data from API: The date '2014-10-09' is not a correct date range" error, but that's probably a different issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Projects
None yet
Development

No branches or pull requests

6 participants