Help please: Visitor log shows a table with all raw columns

Hello,
from version 2.2.1 I have Visitor log showing all raw columns (see attachments) instead of the usual layout (with icons etc), this is with every browser I could test.

Can you help, thank you

carlo

Now also this error:

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

Notice:Array to string conversion in /accounts/cb/www/stat.epysoft.com/analytics/tmp/templates_c/b2/9f/1fee55781f5baeb0bd2da08ee240b606ab34edb61ce05533db57fa39f998.php on line 87

Backtrace -->

#0 Piwik\Error::errorHandler(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/tmp/templates_c/b2/9f/1fee55781f5baeb0bd2da08ee240b606ab34edb61ce05533db57fa39f998.php:87]
#1 __TwigTemplate_b29f1fee55781f5baeb0bd2da08ee240b606ab34edb61ce05533db57fa39f998->doDisplay(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/vendor/twig/twig/lib/Twig/Template.php:278]
#2 Twig_Template->displayWithErrorHandling(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/vendor/twig/twig/lib/Twig/Template.php:252]
#3 Twig_Template->display(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/tmp/templates_c/fc/14/de06a7e91c8c2ed98e3ad5f98f8198512fad505b5e4094768b7014b6c454.php:119]
#4 __TwigTemplate_fc14de06a7e91c8c2ed98e3ad5f98f8198512fad505b5e4094768b7014b6c454->doDisplay(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/vendor/twig/twig/lib/Twig/Template.php:278]
#5 Twig_Template->displayWithErrorHandling(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/vendor/twig/twig/lib/Twig/Template.php:252]
#6 Twig_Template->display(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/tmp/templates_c/5d/c6/c497445afc68827279a897c8cbd5581c33ac611d826b594dea72549efac3.php:117]
#7 __TwigTemplate_5dc6c497445afc68827279a897c8cbd5581c33ac611d826b594dea72549efac3->doDisplay(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/vendor/twig/twig/lib/Twig/Template.php:278]
#8 Twig_Template->displayWithErrorHandling(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/vendor/twig/twig/lib/Twig/Template.php:252]
#9 Twig_Template->display(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/vendor/twig/twig/lib/Twig/Template.php:263]
#10 Twig_Template->render(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/vendor/twig/twig/lib/Twig/Environment.php:292]
#11 Twig_Environment->render(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/core/View.php:246]
#12 Piwik\View->renderTwigTemplate(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/core/View.php:241]
#13 Piwik\View->render(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/core/Plugin/ViewDataTable.php:376]
#14 Piwik\Plugin\ViewDataTable->render(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/core/Plugin/Controller.php:281]
#15 Piwik\Plugin\Controller->renderReport(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/plugins/Live/Controller.php:93]
#16 Piwik\Plugins\Live\Controller->getLastVisitsDetails(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/plugins/Live/Controller.php:87]
#17 Piwik\Plugins\Live\Controller->indexVisitorLog(…) called at [:]
#18 call_user_func_array(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/core/FrontController.php:500]
#19 Piwik\FrontController->doDispatch(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/core/FrontController.php:85]
#20 Piwik\FrontController->dispatch(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/core/dispatch.php:34]
#21 require_once(…) called at [/accounts/cb/www/stat.epysoft.com/analytics/index.php:47]

can you try to re-upload all files of Piwik, in particular the ones in plugins/Live/* ?

thank you Matt, I will re-upload today and let you know.

carlo

Hello Matt,
re-uploaded all files but nothing changed.

If I use PHP 5.3.5 I have no error but Visitor log shows “raw” columns (see above attachments).

If I use PHP 5.4.0 I have still raw columns but with the error above showing in the Actiondetails column.

Before version 2.2.0 everything was fine. What can you suggest? Thank you

Update:
Deleted old installation except for config.ini, reinstalled latest.zip via ssh nothing changed, I have visitor log as a raw table, see my first attachment above.
Very disappointed as the raw table is hard to read. Should I try the new beta version? Thank you

Please create a bug report on our issue tracker: http://dev.piwik.org/ - then we will investigate the bug.

also we would probably need access to your server to reproduce/ understand the issue. Thanks!

Hi,

I have the same problem when i use the e-commerce log view in the dashboard. Have you resolved your problem ?

Thanks.


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

Notice:Array to string conversion in /home/phoenix/shadoware.org/piwik/tmp/templates_c/4f/41/04946c0249d561517321bb2126c08237c1a4ea158598ae133e2a2c1578e7.php on line 87

Backtrace -->

#0 Piwik\Error::errorHandler(…) called at [/home/phoenix/shadoware.org/piwik/tmp/templates_c/4f/41/04946c0249d561517321bb2126c08237c1a4ea158598ae133e2a2c1578e7.php:87]
#1 __TwigTemplate_4f4104946c0249d561517321bb2126c08237c1a4ea158598ae133e2a2c1578e7->doDisplay(…) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:278]
#2 Twig_Template->displayWithErrorHandling(…) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:252]
#3 Twig_Template->display(…) called at [/home/phoenix/shadoware.org/piwik/tmp/templates_c/7d/03/5b51c9adefd06d0a402356a5036fb228399bcad937d1b976bc239a2f0ca1.php:119]
#4 __TwigTemplate_7d035b51c9adefd06d0a402356a5036fb228399bcad937d1b976bc239a2f0ca1->doDisplay(…) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:278]
#5 Twig_Template->displayWithErrorHandling(…) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:252]
#6 Twig_Template->display(…) called at [/home/phoenix/shadoware.org/piwik/tmp/templates_c/bb/5a/d4f6dfb0d6e894c3d3af6ed9399ddb5284e8f26ac55308be26cf91ee3a44.php:117]
#7 __TwigTemplate_bb5ad4f6dfb0d6e894c3d3af6ed9399ddb5284e8f26ac55308be26cf91ee3a44->doDisplay(…) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:278]
#8 Twig_Template->displayWithErrorHandling(…) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:252]
#9 Twig_Template->display(…) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:263]
#10 Twig_Template->render(…) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Environment.php:292]
#11 Twig_Environment->render(…) called at [/home/phoenix/shadoware.org/piwik/core/View.php:246]
#12 Piwik\View->renderTwigTemplate(…) called at [/home/phoenix/shadoware.org/piwik/core/View.php:241]
#13 Piwik\View->render(…) called at [/home/phoenix/shadoware.org/piwik/core/Plugin/ViewDataTable.php:376]
#14 Piwik\Plugin\ViewDataTable->render(…) called at [/home/phoenix/shadoware.org/piwik/core/Plugin/Controller.php:281]
#15 Piwik\Plugin\Controller->renderReport(…) called at [/home/phoenix/shadoware.org/piwik/plugins/Live/Controller.php:93]
#16 Piwik\Plugins\Live\Controller->getLastVisitsDetails(…) called at [/home/phoenix/shadoware.org/piwik/plugins/Live/Controller.php:101]
#17 Piwik\Plugins\Live\Controller->getVisitorLog(…) called at [:]
#18 call_user_func_array(…) called at [/home/phoenix/shadoware.org/piwik/core/FrontController.php:500]
#19 Piwik\FrontController->doDispatch(…) called at [/home/phoenix/shadoware.org/piwik/core/FrontController.php:85]
#20 Piwik\FrontController->dispatch(…) called at [/home/phoenix/shadoware.org/piwik/plugins/Goals/Controller.php:110]
#21 Piwik\Plugins\Goals\Controller->getEcommerceLog(…) called at [:]
#22 call_user_func_array(…) called at [/home/phoenix/shadoware.org/piwik/core/FrontController.php:500]
#23 Piwik\FrontController->doDispatch(…) called at [/home/phoenix/shadoware.org/piwik/core/FrontController.php:85]
#24 Piwik\FrontController->dispatch(…) called at [/home/phoenix/shadoware.org/piwik/core/dispatch.php:34]
#25 require_once(…) called at [/home/phoenix/shadoware.org/piwik/index.php:47]

@phoenix can you please try upgrade to 2.3.0-rc (instructions are simple: I would like to test early beta and RC releases, how do I enable automatic updates to use these development versions? - Analytics Platform - Matomo )

and if you still have the issue, please post a screenshot so I can see where in the page it is displayed, thanks!

Hi,

Is there a risk to update on 2.3.0-rc on my production server ?

Thanks.

No risk, we are here to help in case any problem (but already dozens of users use it in production, and more even use beta versions in production)

Hi,

I have tested the rc, and i always have the problem.

I have two installation of piwik (with differents data), on one installation, i have the problem, and on the other installation i don’t have the problem. But the two intallation you the same php-fpm service and so the same version.

Ok. To debug further further could you please send the content of the first file mentionned in the first error:

#0 Piwik\Error::errorHandler(…) called at [ /home/phoenix/shadoware.org/piwik/tmp/templates_c/XXXXXXXXX.php:87]

so that will help me know which line and which template it refers to.

I had to downgrade to ver 2.0.1, it seems every version past that is affected in my case.

Hi,

Thanks for the response, for the following error, please found the template file attached (i have attached file with pdf extension, else it’s not a valid extension).

Thanks


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

Notice:Array to string conversion in /home/phoenix/shadoware.org/piwik/tmp/templates_c/4f/41/04946c0249d561517321bb2126c08237c1a4ea158598ae133e2a2c1578e7.php on line 87

Backtrace -->

#0 Piwik\Error::errorHandler(...) called at [/home/phoenix/shadoware.org/piwik/tmp/templates_c/4f/41/04946c0249d561517321bb2126c08237c1a4ea158598ae133e2a2c1578e7.php:87]
#1 __TwigTemplate_4f4104946c0249d561517321bb2126c08237c1a4ea158598ae133e2a2c1578e7->doDisplay(...) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:278]
#2 Twig_Template->displayWithErrorHandling(...) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:252]
#3 Twig_Template->display(...) called at [/home/phoenix/shadoware.org/piwik/tmp/templates_c/7d/03/5b51c9adefd06d0a402356a5036fb228399bcad937d1b976bc239a2f0ca1.php:119]
#4 __TwigTemplate_7d035b51c9adefd06d0a402356a5036fb228399bcad937d1b976bc239a2f0ca1->doDisplay(...) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:278]
#5 Twig_Template->displayWithErrorHandling(...) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:252]
#6 Twig_Template->display(...) called at [/home/phoenix/shadoware.org/piwik/tmp/templates_c/bb/5a/d4f6dfb0d6e894c3d3af6ed9399ddb5284e8f26ac55308be26cf91ee3a44.php:117]
#7 __TwigTemplate_bb5ad4f6dfb0d6e894c3d3af6ed9399ddb5284e8f26ac55308be26cf91ee3a44->doDisplay(...) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:278]
#8 Twig_Template->displayWithErrorHandling(...) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:252]
#9 Twig_Template->display(...) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Template.php:263]
#10 Twig_Template->render(...) called at [/home/phoenix/shadoware.org/piwik/vendor/twig/twig/lib/Twig/Environment.php:292]
#11 Twig_Environment->render(...) called at [/home/phoenix/shadoware.org/piwik/core/View.php:245]
#12 Piwik\View->renderTwigTemplate(...) called at [/home/phoenix/shadoware.org/piwik/core/View.php:240]
#13 Piwik\View->render(...) called at [/home/phoenix/shadoware.org/piwik/core/Plugin/ViewDataTable.php:375]
#14 Piwik\Plugin\ViewDataTable->render(...) called at [/home/phoenix/shadoware.org/piwik/core/Plugin/Controller.php:281]
#15 Piwik\Plugin\Controller->renderReport(...) called at [/home/phoenix/shadoware.org/piwik/plugins/Live/Controller.php:92]
#16 Piwik\Plugins\Live\Controller->getLastVisitsDetails(...) called at [/home/phoenix/shadoware.org/piwik/plugins/Live/Controller.php:100]
#17 Piwik\Plugins\Live\Controller->getVisitorLog(...) called at [:]
#18 call_user_func_array(...) called at [/home/phoenix/shadoware.org/piwik/core/FrontController.php:500]
#19 Piwik\FrontController->doDispatch(...) called at [/home/phoenix/shadoware.org/piwik/core/FrontController.php:85]
#20 Piwik\FrontController->dispatch(...) called at [/home/phoenix/shadoware.org/piwik/plugins/Goals/Controller.php:109]
#21 Piwik\Plugins\Goals\Controller->getEcommerceLog(...) called at [:]
#22 call_user_func_array(...) called at [/home/phoenix/shadoware.org/piwik/core/FrontController.php:500]
#23 Piwik\FrontController->doDispatch(...) called at [/home/phoenix/shadoware.org/piwik/core/FrontController.php:85]
#24 Piwik\FrontController->dispatch(...) called at [/home/phoenix/shadoware.org/piwik/core/dispatch.php:34]
#25 require_once(...) called at [/home/phoenix/shadoware.org/piwik/index.php:47]

your backtrace looks very similar to mine posted above.

please execute this SQL query on your database


DELETE FROM piwik_option WHERE option_name LIKE '%viewDataTableParameters_root_Live%'

Does it fix the error maybe?

The query following query return 0 lines.

SELECT * FROM piwik_option WHERE option_name LIKE ‘%viewDataTableParameters_root_Live%’;

I have adapted the line to

SELECT * FROM piwik_option WHERE option_name LIKE ‘%viewDataTableParameters%’

and i have the following lines

“viewDataTableParameters_eve_Goals.getItemsSku”,"{“filter_sort_column”:“nb_visits”}",“0"
“viewDataTableParameters_phoenix_Goals.getEvolutionGraph”,”{“evolution_week_last_n”:52,“evolution_month_last_n”:120,“evolution_day_last_n”:90}",“0"
“viewDataTableParameters_phoenix_Referrers.getKeywords”,”{“viewDataTable”:“table”}",“0"
“viewDataTableParameters_phoenix_Referrers.getReferrerType”,”{“viewDataTable”:“graphPie”,“filter_sort_column”:“goal_1_conversion_rate”}",“0"
“viewDataTableParameters_phoenix_Referrers.getSearchEngines”,”{“viewDataTable”:“graphPie”}",“0"
“viewDataTableParameters_phoenix_Referrers.getWebsites”,”{“viewDataTable”:“graphPie”}",“0"
“viewDataTableParameters_phoenix_UserSettings.getBrowserType”,”{“viewDataTable”:“graphPie”}",“0"
“viewDataTableParameters_phoenix_UserSettings.getOS”,”{“viewDataTable”:“graphPie”}",“0”

So nothing about “Live”.
Sorry.

I have create an extract of 18M of by base that can be used to reproduce the problem.

How can i send you a link to the file (privatly).

My mail is ulrich.vdh … at … shadoware.org

@phoenix, this could work, maybe you even have temporary SSH access to your Piwik server?