@phoob opened this Issue on February 5th 2016 Contributor

After upgrading to Piwik 2.16.0, I get errors when viewing the events report, specifically when I click to view the "Event Actions" sub-report. Instead of a table, the following error message is displayed:

Unsupported pivot: the subtable dimension for 'Events.Event Actions' does not match the requested pivotBy dimension. [subtable dimension = Events.EventName, pivot by dimension = Events.EventCategory]

And if I immediately go to the Administration page thereafter, I get this additional error message:

ERROR: Failed to get data from API: Unsupported pivot: the subtable dimension for 'Events.Event Actions' does not match the requested pivotBy dimension. [subtable dimension = Events.EventName, pivot by dimension = Events.EventCategory] <a href='/0'>#0</a> /var/www/xx.xx.xx/public_html/core/DataTable/Filter/PivotByDimension.php(170): Piwik\DataTable\Filter\PivotByDimension-&gt;checkSupportedPivot() <a href='/1'>#1</a> [internal function]: Piwik\DataTable\Filter\PivotByDimension-&gt;__construct(Object(Piwik\DataTable), 'Events.getActio...', 'Events.EventCat...', '', 0, 0) <a href='/2'>#2</a> /var/www/xx.xx.xx/public_html/core/DataTable.php(493): ReflectionClass-&gt;newInstanceArgs(Array) <a href='/3'>#3</a> /var/www/xx.xx.xx/public_html/core/API/DataTablePostProcessor.php(160): Piwik\DataTable-&gt;filter('PivotByDimensio...', Array) <a href='/4'>#4</a> /var/www/xx.xx.xx/public_html/core/API/DataTablePostProcessor.php(110): Piwik\API\DataTablePostProcessor-&gt;applyPivotByFilter(Object(Piwik\DataTable)) <a href='/5'>#5</a> /var/www/xx.xx.xx/public_html/core/Plugin/Visualization.php(444): Piwik\API\DataTablePostProcessor-&gt;process(Object(Piwik\DataTable)) <a href='/6'>#6</a> /var/www/xx.xx.xx/public_html/core/Plugin/Visualization.php(185): Piwik\Plugin\Visualization-&gt;applyFilters() <a href='/7'>#7</a> /var/www/xx.xx.xx/public_html/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization-&gt;buildView() <a href='/8'>#8</a> /var/www/xx.xx.xx/public_html/core/Plugin/Report.php(338): Piwik\Plugin\ViewDataTable-&gt;render() <a href='/9'>#9</a> /var/www/xx.xx.xx/public_html/core/Plugin/Controller.php(327): Piwik\Plugin\Report-&gt;render() <a href='/10'>#10</a> /var/www/xx.xx.xx/public_html/plugins/Events/Controller.php(96): Piwik\Plugin\Controller-&gt;renderReport('getAction') <a href='/11'>#11</a> /var/www/xx.xx.xx/public_html/plugins/Events/Controller.php(48): Piwik\Plugins\Events\Controller-&gt;indexEvent('indexAction') <a href='/12'>#12</a> [internal function]: Piwik\Plugins\Events\Controller-&gt;indexAction() <a href='/13'>#13</a> /var/www/xx.xx.xx/public_html/core/FrontController.php(495): call_user_func_array(Array, Array) <a href='/14'>#14</a> /var/www/xx.xx.xx/public_html/core/FrontController.php(99): Piwik\FrontController-&gt;doDispatch(NULL, NULL, NULL) <a href='/15'>#15</a> /var/www/xx.xx.xx/public_html/core/dispatch.php(34): Piwik\FrontController-&gt;dispatch() <a href='/16'>#16</a> /var/www/xx.xx.xx/public_html/index.php(27): require_once('/var/www/xx.xx...') <a href='/17'>#17</a> {main}

I have Piwik running on PHP 5.5.9-1ubuntu4.14 on Ubuntu 14.04.3 LTS.

I have also posted this issue in the Piwik forum.

@phoob commented on February 5th 2016 Contributor

Tested in latest Safari, Chrome and Firefox on Mac OS, and IE11 on Windows.

@tsteur commented on February 7th 2016 Owner

What are the steps to reproduce this? I couldn't reproduce it. Are you using any custom plugins?

@mattab could you reproduce it?

@phoob commented on February 8th 2016 Contributor

@tsteur Here are the steps to reproduce:

  1. Go to Piwik dashboard
  2. Open the Actions menu
  3. Open the Events report
  4. Click on Event Actions in the Top Events link list
  5. Observe first error message (see screen shot 1)
  6. Click on the cog wheel in the top right corner to go to Administration
  7. Observe second error message (see screen shot 2)

Screen shot 1

Screen shot 2

@tsteur commented on February 10th 2016 Owner

Thx. I can reproduce it with these steps: https://github.com/piwik/piwik/issues/9667

Tried to fix it but currently couldn't find a way to do it. Need to have a more detailed look some day later

@hoang89 commented on February 19th 2016

How can i escape this bug to view normal events, i cannot view events when this bug occur

@tsteur commented on February 22nd 2016 Owner

If you can, try to switch to another visualization. Or create a new user and view the reports with this user.

@tsteur commented on March 8th 2016 Owner

@phoob @hoang89 did it work to switch to another visualization?

@phoob commented on March 8th 2016 Contributor

Can you please describe how you mean I should do to switch to another visualization? As you can in my attached screen shot above (the first one) there is just an error message – no data table where I can choose another visualization.

@tsteur commented on March 8th 2016 Owner

I just realize this is not possible there as you are seeing this all the time. In my case, when I reproduced it, I was still able to change the visualization.

Can you maybe try to execute a query on the DB:

delete from piwik_option where option_name like "viewDataTableParameters_$YOUR_PIWIK_USERNAME_Events.%";
-- for example when username is "root"
delete from piwik_option where option_name like "viewDataTableParameters_root_Events.%";
@phoob commented on March 8th 2016 Contributor

Awesome! Deleting the options from piwik_option solved the issue for me.

@mattab commented on March 10th 2016 Owner

FYI Added a FAQ to document how to reset the report settings: How do I reset the visualisations settings stored for a specific user, or for all users?

@mattab commented on March 30th 2016 Owner

Hopefully this issue is fixed in 2.16.1-b3 (Learn more: http://piwik.org/faq/how-to-update/faq_159/ ). I'm closing now but if you experience this issue and are already using > 2.16.1-b3 please leave a comment asking to re-open this issue.

This Issue was closed on March 30th 2016
Powered by GitHub Issue Mirror