I downloaded version 2.16.0 installed and everything seemed alright, then I updated it to version 2.16.1, through the UI. I guess the connection timed out and I got a 500 server error. Then I re-uploaded the files for version 2.16.0 and I started to get a “ViewDataTable ID ‘table’ is already in use!” error.
I googled the issue but it seems that there have been only two cases with a similar error:
In both threads, it seems the problem with this kind of message gets fixed if you reupload the files manually.
Since this is a fresh installation, I dropped all the tables in the DB, deleted all the files in the server, and started from scratch. After installing version 2.16.0, and, this time, downloading the RC, I uploaded and updated the software. No errors… cool.
Then I noticed that Piwik is not tracking. As one of the things this page suggests:
I checked the “
piwik_log_visit” table… it has no rows, then, I enabled the “DBStats” plugin, and when I check the Database usage I get the same message:
ViewDataTable ID ‘table’ is already in use!
This is a fresh install, I uploaded the files manually, the FTP transfer was set to binary… How can I solve this? Is there something else I need to do? should I just re-upload version 2.16.0? I can definitely try that, but if I get the same error, how can it be fixed?
When I do a System Check, everything has a green check mark next to it.
After a while it seems I’m starting to get some data; however, the ‘table’ is already in use still persists. Here are some screen shots that will hopefully help?
I get the same messge for:
- Length of Visits
- Referrer Websites
- Visits by Server Time
- Visitor Browser
- Search Engines
It seems the problem has to do with
/piwik/plugins/CoreVisualizations/Visualizations/HtmlTable/PivotBy.php (piwik-2.16.1-rc1 doesn’t have it anymore). I’m assuming is no longer needed, so I deleted it; The error is now gone, and data is being displayed in those modules where it appeared.
getAvailableViewDataTables function of
Manager class sets the
table index of the results array:
["table"]=> string(65) "Piwik\Plugins\CoreVisualizations\Visualizations\HtmlTable\PivotBy"
But it seems that the
pivotBy index gets never unset (source:
$this->requestConfig->request_parameters_to_modify['pivotBy'] = null; // always unset pivotBy
Could this be a bug?
My approach seems to have fixed my issue. So I’m posting it here in case it helps someone else; if, however, this is not the right approach, maybe Matthieu (or someone more familiar with the software than me) will hopefully read this and let me know.