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


#1

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


#2

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]


(Matthieu Aubry) #3

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


#4

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

carlo


#5

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


#6

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


(Matthieu Aubry) #7

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!


#8

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]


(Matthieu Aubry) #9

@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!


#10

Hi,

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

Thanks.


(Matthieu Aubry) #11

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)


#12

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.


(Matthieu Aubry) #13

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.


#14

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


#15

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]


#16

your backtrace looks very similar to mine posted above.


(Matthieu Aubry) #17

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?


#18

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.


#19

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


(Matthieu Aubry) #20

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