Error all around piwik dashboard


#1

Hi Team,

I woke up this morning and bunch of errors are all around Piwik platform.

It seems it started after creation on these 2 archive tables for April 2015:

If I delete them everything is fine and the system works… once they are created
issue pops up.

Please help I have tried everything as a solution on this forum nothing worked :frowning:

Here is a screenshot and copy of the errors:

Errors

There is an error. Please report the message (Piwik 2.3.0) 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/innercir/public_html/analytics/core/Db/BatchInsert.php on line 237

Backtrace -->

#0 Piwik\Error::errorHandler(…) called at [/home/innercir/public_html/analytics/core/Db/BatchInsert.php:237]
#1 Piwik\Db\BatchInsert::createCSVFile(…) called at [/home/innercir/public_html/analytics/core/Db/BatchInsert.php:85]
#2 Piwik\Db\BatchInsert::tableInsertBatch(…) called at [/home/innercir/public_html/analytics/core/DataAccess/ArchiveWriter.php:249]
#3 Piwik\DataAccess\ArchiveWriter->insertBulkRecords(…) called at [/home/innercir/public_html/analytics/core/DataAccess/ArchiveWriter.php:91]
#4 Piwik\DataAccess\ArchiveWriter->insertBlobRecord(…) called at [/home/innercir/public_html/analytics/core/ArchiveProcessor.php:316]
#5 Piwik\ArchiveProcessor->insertBlobRecord(…) called at [/home/innercir/public_html/analytics/plugins/Actions/Archiver.php:461]
#6 Piwik\Plugins\Actions\Archiver->insertTable(…) called at [/home/innercir/public_html/analytics/plugins/Actions/Archiver.php:437]
#7 Piwik\Plugins\Actions\Archiver->insertPageUrlsReports(…) called at [/home/innercir/public_html/analytics/plugins/Actions/Archiver.php:427]
#8 Piwik\Plugins\Actions\Archiver->insertDayReports(…) called at [/home/innercir/public_html/analytics/plugins/Actions/Archiver.php:98]
#9 Piwik\Plugins\Actions\Archiver->aggregateDayReport(…) called at [/home/innercir/public_html/analytics/core/ArchiveProcessor/PluginsArchiver.php:100]
#10 Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(…) called at [/home/innercir/public_html/analytics/core/ArchiveProcessor/Loader.php:118]
#11 Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(…) called at [/home/innercir/public_html/analytics/core/ArchiveProcessor/Loader.php:72]
#12 Piwik\ArchiveProcessor\Loader->prepareArchive(…) called at [/home/innercir/public_html/analytics/core/Archive.php:800]
#13 Piwik\Archive->prepareArchive(…) called at [/home/innercir/public_html/analytics/core/Archive.php:613]
#14 Piwik\Archive->cacheArchiveIdsAfterLaunching(…) called at [/home/innercir/public_html/analytics/core/Archive.php:555]
#15 Piwik\Archive->getArchiveIds(…) called at [/home/innercir/public_html/analytics/core/Archive.php:496]
#16 Piwik\Archive->get(…) called at [/home/innercir/public_html/analytics/core/Archive.php:367]
#17 Piwik\Archive->getDataTable(…) called at [/home/innercir/public_html/analytics/plugins/VisitorInterest/API.php:28]
#18 Piwik\Plugins\VisitorInterest\API->getDataTable(…) called at [/home/innercir/public_html/analytics/plugins/VisitorInterest/API.php:46]
#19 Piwik\Plugins\VisitorInterest\API->getNumberOfVisitsPerPage(…) called at [:]
#20 call_user_func_array(…) called at [/home/innercir/public_html/analytics/core/API/Proxy.php:209]
#21 Piwik\API\Proxy->call(…) called at [/home/innercir/public_html/analytics/core/API/Request.php:215]
#22 Piwik\API\Request->process(…) called at [/home/innercir/public_html/analytics/core/ViewDataTable/Request.php:48]
#23 Piwik\ViewDataTable\Request->loadDataTableFromAPI(…) called at [/home/innercir/public_html/analytics/core/Plugin/ViewDataTable.php:287]
#24 Piwik\Plugin\ViewDataTable->loadDataTableFromAPI(…) called at [/home/innercir/public_html/analytics/core/Plugin/Visualization.php:166]
#25 Piwik\Plugin\Visualization->buildView(…) called at [/home/innercir/public_html/analytics/core/Plugin/ViewDataTable.php:374]
#26 Piwik\Plugin\ViewDataTable->render(…) called at [/home/innercir/public_html/analytics/core/Plugin/Controller.php:281]
#27 Piwik\Plugin\Controller->renderReport(…) called at [/home/innercir/public_html/analytics/plugins/VisitorInterest/Controller.php:34]
#28 Piwik\Plugins\VisitorInterest\Controller->getNumberOfVisitsPerPage(…) called at [:]
#29 call_user_func_array(…) called at [/home/innercir/public_html/analytics/core/FrontController.php:500]
#30 Piwik\FrontController->doDispatch(…) called at [/home/innercir/public_html/analytics/core/FrontController.php:85]
#31 Piwik\FrontController->dispatch(…) called at [/home/innercir/public_html/analytics/core/dispatch.php:34]
#32 require_once(…) called at [/home/innercir/public_html/analytics/index.php:47]


(Matthieu Napoli) #2

Piwik 2.3.0 is very outdated, try to upgrade to the latest version and see if the problem is still here.