Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Visitor log shows a table with all raw columns #5236

Closed
anonymous-matomo-user opened this issue May 26, 2014 · 9 comments
Closed

Visitor log shows a table with all raw columns #5236

anonymous-matomo-user opened this issue May 26, 2014 · 9 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.
Milestone
2.4.0

Comments

@anonymous-matomo-user
Copy link

Hi,

As see in the forum post http://forum.piwik.org/read.php?2,115082 i have a problem with the e-commerce visitor log widget.

On some column i have the following stacktrace :

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]

The bug can be reproduced with the database attached, (extract of my own database, reduced to the last two weeks, and with some value obfusced).

I have removed the password and the token API. The user to use is test (password testtest), the site to use is test too (in e-commerce section). The widget is in the E-commerce dashboard.

Thanks for the help
Keywords: ecommerce
@anonymous-matomo-user
Copy link
Author

Attachment:
piwik.7z.001

@anonymous-matomo-user
Copy link
Author

Attachment:
piwik.7z.002

@anonymous-matomo-user
Copy link
Author

Sorry,

due to the limit size i have split the file with 7z in two part.

@mattab
Copy link
Member

mattab commented May 27, 2014

Thank you for the report and providing your DB dump! we will investigate next few days.

@tsteur
Copy link
Member

tsteur commented May 30, 2014

I tried to reproduce with your DB dump but couldn't. Probably it is related to a server setting. Have you tried to reproduce it with this DB dump? Would you mind letting me know the exact steps to reproduce just in case I am doing something different.

BTW: I remember we had a similar issue before the 2.0 release see http://forum.piwik.org/read.php?2,107327,page=1#msg-107558 and the fix 9ba9d46 . Basically there was a problem if "magic quotes" were enabled but we fixed this issue.

@anonymous-matomo-user
Copy link
Author

Hmmm strange,

I have the problem on my server (debian 7.5 and my laptop with debian 7.5). Both have the problem.
To test on my laptop, i take the dump and a fresh installation of the latest.zip. I deploy the dump and tell to piwik to use exisiting table. Then i ask to piwik archiver to generate missing table (reports).

I have

  • MySQL : Server version: 5.5.37-0+wheezy1 (Debian)
  • PHP : PHP 5.4.4-14+deb7u9 (cli) (built: Apr 18 2014 14:34:31)

I have the same version of PHP on the production server, but i use the php-fpm on the server and php + apache on my laptop.

magic_quotes have been removed from php 5.4.

@anonymous-matomo-user
Copy link
Author

I must show the log of the 23 may too (after there is no data), and click on the "e-commerce tab in the dashboard".

@anonymous-matomo-user
Copy link
Author

Sorry,

I found the problem, the widget is written as a "table" visualization (in Factory.php) (and not VisitorLog). I recreate the dashboard, and the problem is resolved.

I think that i have already recreated the widget there is long ago, and i don't have retry.

The problem is now resolved for me by recreating the dashboard. I don't known why the type of the widget is false. Sorry for the time you have passe.

@mattab
Copy link
Member

mattab commented Jun 2, 2014

See also: http://forum.piwik.org/read.php?2,115082,115876#msg-115876

@anonymous-matomo-user anonymous-matomo-user added this to the 2.4.0 - Piwik 2.4.0 milestone Jul 8, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Milestone
2.4.0
Development

No branches or pull requests
3 participants
@tsteur @mattab @anonymous-matomo-user