Errors in module=Referrers&action=index

[Ademaro]

There is an error. Please report the message (Piwik 2.0.4-b2) 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 /var/www/_my_domain_/tmp/templates_c/51/41/fc1ffbea79963da20f174c860dedd0f47b29bfbaa72f2fc55f8adbe53b6e.php on line 85

Backtrace -->

#0 Piwik\Error::errorHandler(...) called at [/var/www/_my_domain_/tmp/templates_c/51/41/fc1ffbea79963da20f174c860dedd0f47b29bfbaa72f2fc55f8adbe53b6e.php:85]
#1 __TwigTemplate_5141fc1ffbea79963da20f174c860dedd0f47b29bfbaa72f2fc55f8adbe53b6e->doDisplay(...) called at [/var/www/_my_domain_/vendor/twig/twig/lib/Twig/Template.php:276]
#2 Twig_Template->displayWithErrorHandling(...) called at [/var/www/_my_domain_/vendor/twig/twig/lib/Twig/Template.php:250]
#3 Twig_Template->display(...) called at [/var/www/_my_domain_/tmp/templates_c/48/cb/d914a3c3b199cadaa95573bb1a2f0fa97ac2a7cc0bce6876fa53b7ec1bee.php:119]
#4 __TwigTemplate_48cbd914a3c3b199cadaa95573bb1a2f0fa97ac2a7cc0bce6876fa53b7ec1bee->doDisplay(...) called at [/var/www/_my_domain_/vendor/twig/twig/lib/Twig/Template.php:276]
#5 Twig_Template->displayWithErrorHandling(...) called at [/var/www/_my_domain_/vendor/twig/twig/lib/Twig/Template.php:250]
#6 Twig_Template->display(...) called at [/var/www/_my_domain_/tmp/templates_c/bc/94/8af3286b8c6f3cc3d87c415fd2e958e2ea1bdf8d246ba0af383431f0678b.php:117]
#7 __TwigTemplate_bc948af3286b8c6f3cc3d87c415fd2e958e2ea1bdf8d246ba0af383431f0678b->doDisplay(...) called at [/var/www/_my_domain_/vendor/twig/twig/lib/Twig/Template.php:276]
#8 Twig_Template->displayWithErrorHandling(...) called at [/var/www/_my_domain_/vendor/twig/twig/lib/Twig/Template.php:250]
#9 Twig_Template->display(...) called at [/var/www/_my_domain_/vendor/twig/twig/lib/Twig/Template.php:261]
#10 Twig_Template->render(...) called at [/var/www/_my_domain_/vendor/twig/twig/lib/Twig/Environment.php:292]
#11 Twig_Environment->render(...) called at [/var/www/_my_domain_/core/View.php:253]
#12 Piwik\View->renderTwigTemplate(...) called at [/var/www/_my_domain_/core/View.php:248]
#13 Piwik\View->render(...) called at [/var/www/_my_domain_/core/Plugin/ViewDataTable.php:363]
#14 Piwik\Plugin\ViewDataTable->render(...) called at [/var/www/_my_domain_/core/Plugin/Controller.php:230]
#15 Piwik\Plugin\Controller->renderReport(...) called at [/var/www/_my_domain_/plugins/Referrers/Controller.php:153]
#16 Piwik\Plugins\Referrers\Controller->getAll(...) called at [:]
#17 call_user_func_array(...) called at [/var/www/_my_domain_/core/FrontController.php:519]
#18 Piwik\FrontController->doDispatch(...) called at [/var/www/_my_domain_/core/FrontController.php:88]
#19 Piwik\FrontController->dispatch(...) called at [/var/www/_my_domain_/index.php:62]

I tried to delete a folder (/var/www/my_domain/tmp/templates_c/) – the same result…

UPD: I apologize for repeating (301 Moved Permanently)
UPD2: In another piwik without goals – all ok…

[matthieu (Matthieu Aubry)]

Please apply this patch: Refs #4432 Fixing the error in one case (Referrers>Overview / Goals> … · matomo-org/matomo@8a42ff8 · GitHub

Then delete your piwik_archive_* tables for the months affected by this bug

Then load the reports -> if you are still seeing the error please let me know, as I need your help to fix it!

[Ademaro]

I applied the patch, but I really need to delete all archive_blob* and archive_numeric* tables? As well bug shows itself if I choose any day: yesterday, a month ago, a few months ago…
This error appears when the date range is specified as one day. If you select weekly or monthly – no errors.

Some screenshots:

[matthieu (Matthieu Aubry)]

Do you still have your logs ? If you don’t delete old logs then it’s safe to delete all piwik_archive tables

It will take some minute sto re-process but should work fine!

[Ademaro]

Strangely enough, nothing changed, tables are not deleted, not updated – but now works without errors …