@nikolas opened this Issue on October 1st 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 -->

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

    Event Names

Event Categories

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

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

">
1.�Page Load

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

">
2.�Download

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

">
3.�student.pdf

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

">
4.�teacher pdf.pdf
@mattab commented on October 2nd 2014 Owner

Thanks for the report!

What version of PHP are you using?

@nikolas commented on October 2nd 2014

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

@mattab commented on October 2nd 2014 Owner

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

@nikolas commented on October 2nd 2014

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

@nikolas commented on October 2nd 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 commented on October 2nd 2014 Owner

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 commented on October 2nd 2014 Member

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?

@diosmosis commented on October 2nd 2014 Member

@sgiehl It appears to be the decoded '&nbsp;' 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 commented on October 2nd 2014 Member
@diosmosis commented on October 2nd 2014 Member

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

@tsteur commented on October 4th 2014 Owner

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 commented on October 6th 2014 Owner

@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 commented on October 6th 2014 Member

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

@mattab commented on October 6th 2014 Owner

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

@nkuehn commented on October 16th 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'.
<a href='/0'>#0</a> /srv/www/piwik.excentos.com/piwik/core/Period.php(102): Piwik\Period\Range->generate()
<a href='/1'>#1</a> /srv/www/piwik.excentos.com/piwik/core/Period/Range.php(96): Piwik\Period->getDateStart()
<a href='/2'>#2</a> /srv/www/piwik.excentos.com/piwik/core/Period.php(272): Piwik\Period\Range->getDateStart()
<a href='/3'>#3</a> /srv/www/piwik.excentos.com/piwik/core/Archive/DataCollection.php(120): Piwik\Period->getRangeString()
<a href='/4'>#4</a> /srv/www/piwik.excentos.com/piwik/core/Archive.php(506): Piwik\Archive\DataCollection->__construct(Array, 'blob', Array, Array, NULL)
<a href='/5'>#5</a> /srv/www/piwik.excentos.com/piwik/core/Archive.php(375): Piwik\Archive->get('Events_name_cat...', 'blob', '2')
<a href='/6'>#6</a> /srv/www/piwik.excentos.com/piwik/core/Archive.php(470): Piwik\Archive->getDataTable('Events_name_cat...', '2')
<a href='/7'>#7</a> /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')
<a href='/8'>#8</a> /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')
<a href='/9'>#9</a> [internal function]: Piwik\Plugins\Events\API->getCategoryFromNameId('1', 'range', '2014-10-09', '2', false)
<a href='/10'>#10</a> /srv/www/piwik.excentos.com/piwik/core/API/Proxy.php(209): call_user_func_array(Array, Array)
<a href='/11'>#11</a> /srv/www/piwik.excentos.com/piwik/core/API/Request.php(216): Piwik\API\Proxy->call('\Piwik\Plugins\...', 'getCategoryFrom...', Array)
<a href='/12'>#12</a> /srv/www/piwik.excentos.com/piwik/core/API/Request.php(304): Piwik\API\Request->process()
<a href='/13'>#13</a> /srv/www/piwik.excentos.com/piwik/core/Plugin/Report.php(646): Piwik\API\Request::processRequest('Events.getCateg...', Array)
<a href='/14'>#14</a> /srv/www/piwik.excentos.com/piwik/core/DataTable/Filter/PivotByDimension.php(290): Piwik\Plugin\Report->fetchSubtable(2, Array)
<a href='/15'>#15</a> /srv/www/piwik.excentos.com/piwik/core/DataTable/Filter/PivotByDimension.php(263): Piwik\DataTable\Filter\PivotByDimension->loadSubtable(Object(Piwik\DataTable), Object(Piwik\DataTable\Row))
<a href='/16'>#16</a> /srv/www/piwik.excentos.com/piwik/core/DataTable/Filter/PivotByDimension.php(192): Piwik\DataTable\Filter\PivotByDimension->getIntersectedTable(Object(Piwik\DataTable), Object(Piwik\DataTable\Row))
<a href='/17'>#17</a> /srv/www/piwik.excentos.com/piwik/core/DataTable.php(425): Piwik\DataTable\Filter\PivotByDimension->filter(Object(Piwik\DataTable))
<a href='/18'>#18</a> /srv/www/piwik.excentos.com/piwik/core/API/ResponseBuilder.php(172): Piwik\DataTable->filter('PivotByDimensio...', Array)
<a href='/19'>#19</a> /srv/www/piwik.excentos.com/piwik/core/API/ResponseBuilder.php(91): Piwik\API\ResponseBuilder->handleDataTable(Object(Piwik\DataTable))
<a href='/20'>#20</a> /srv/www/piwik.excentos.com/piwik/core/API/Request.php(218): Piwik\API\ResponseBuilder->getResponse(Object(Piwik\DataTable), 'Events', 'getAction')
<a href='/21'>#21</a> /srv/www/piwik.excentos.com/piwik/core/ViewDataTable/Request.php(48): Piwik\API\Request->process()
<a href='/22'>#22</a> /srv/www/piwik.excentos.com/piwik/core/Plugin/ViewDataTable.php(327): Piwik\ViewDataTable\Request->loadDataTableFromAPI(Array)
<a href='/23'>#23</a> /srv/www/piwik.excentos.com/piwik/core/Plugin/Visualization.php(166): Piwik\Plugin\ViewDataTable->loadDataTableFromAPI(Array)
<a href='/24'>#24</a> /srv/www/piwik.excentos.com/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView()
<a href='/25'>#25</a> /srv/www/piwik.excentos.com/piwik/core/Plugin/Report.php(304): Piwik\Plugin\ViewDataTable->render()
<a href='/26'>#26</a> /srv/www/piwik.excentos.com/piwik/plugins/CoreHome/Controller.php(78): Piwik\Plugin\Report->render()
<a href='/27'>#27</a> [internal function]: Piwik\Plugins\CoreHome\Controller->renderReportWidget('Events', 'getAction')
<a href='/28'>#28</a> /srv/www/piwik.excentos.com/piwik/core/FrontController.php(579): call_user_func_array(Array, Array)
<a href='/29'>#29</a> /srv/www/piwik.excentos.com/piwik/core/FrontController.php(87): Piwik\FrontController->doDispatch(NULL, NULL, NULL)
<a href='/30'>#30</a> /srv/www/piwik.excentos.com/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch()
<a href='/31'>#31</a> /srv/www/piwik.excentos.com/piwik/index.php(46): require_once('/srv/www/piwik....')
<a href='/32'>#32</a> {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 -->

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

I propose reopening this issue

@diosmosis commented on October 16th 2014 Member

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

@nkuehn commented on October 16th 2014

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

@diosmosis commented on October 16th 2014 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 commented on October 17th 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 commented on October 17th 2014 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 commented on October 17th 2014 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 commented on October 20th 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.

This Issue was closed on October 6th 2014
Powered by GitHub Issue Mirror