Hello,
yesterday I upgraded my Piwik installation from 2.2.0 to 2.8.1. also updated php from 5.3.28 to 5.5.18.
It is a high traffic server with a total Db Size over 15GB. I added “record_statistics = 0” to the config file and started the automatic update process.
Database Upgrade was started from the shell.
The upgrade took nearly 2 hours and ended with “Piwik has been successfully updated!”
so I’m now running Piwik 2.8.1 on IIS7 with php 5.5.18.
but at the moment there is no data shown, the overview is empty.
There are Data in “Real Time Visitor Count”, “Visitors in Real-Time” or “Visitors->Visitor Log”, partly with Errors but it seems Piwik is tracking.
There is an error. Please report the message (Piwik 2.8.1) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).
Notice: Undefined index: config_device_type in EXAMPLE\FILESYSTEM\webstat\app\plugins\DevicesDetection\DevicesDetection.php on line 49
Backtrace -->
#0 Piwik\Error::errorHandler(...) called at [EXAMPLE\FILESYSTEM\webstat\app\plugins\DevicesDetection\DevicesDetection.php:49]
#1 Piwik\Plugins\DevicesDetection\DevicesDetection->extendVisitorDetails(...) called at [:]
#2 call_user_func_array(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\EventDispatcher.php:121]
#3 Piwik\EventDispatcher->postEvent(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\Piwik.php:678]
#4 Piwik\Piwik::postEvent(...) called at [EXAMPLE\FILESYSTEM\webstat\app\plugins\Live\Visitor.php:74]
#5 Piwik\Plugins\Live\Visitor->getAllVisitorDetails(...) called at [EXAMPLE\FILESYSTEM\webstat\app\plugins\Live\API.php:584]
#6 Piwik\Plugins\Live\API->Piwik\Plugins\Live\{closure}(...) called at [:]
#7 call_user_func_array(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\DataTable.php:408]
#8 Piwik\DataTable->filter(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\DataTable.php:453]
#9 Piwik\DataTable->applyQueuedFilters(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\API\ResponseBuilder.php:211]
#10 Piwik\API\ResponseBuilder->handleDataTable(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\API\ResponseBuilder.php:97]
#11 Piwik\API\ResponseBuilder->getResponse(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\API\Request.php:218]
#12 Piwik\API\Request->process(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\ViewDataTable\Request.php:48]
#13 Piwik\ViewDataTable\Request->loadDataTableFromAPI(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\Plugin\ViewDataTable.php:327]
#14 Piwik\Plugin\ViewDataTable->loadDataTableFromAPI(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\Plugin\Visualization.php:166]
#15 Piwik\Plugin\Visualization->buildView(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\Plugin\ViewDataTable.php:414]
#16 Piwik\Plugin\ViewDataTable->render(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\Plugin\Report.php:304]
#17 Piwik\Plugin\Report->render(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\Plugin\Controller.php:327]
#18 Piwik\Plugin\Controller->renderReport(...) called at [EXAMPLE\FILESYSTEM\webstat\app\plugins\Live\Controller.php:61]
#19 Piwik\Plugins\Live\Controller->indexVisitorLog(...) called at [:]
#20 call_user_func_array(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\FrontController.php:587]
#21 Piwik\FrontController->doDispatch(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\FrontController.php:95]
#22 Piwik\FrontController->dispatch(...) called at [EXAMPLE\FILESYSTEM\webstat\app\core\dispatch.php:34]
#23 require_once(...) called at [EXAMPLE\FILESYSTEM\webstat\app\index.php:46]
and there is also an error when I start the archive script from the console
ERROR CoreConsole[2014-10-22 08:19:31] [02138] Got invalid response from API request: http://www.example.com/webstat/app/index.php?module=API&method=API.get&idSite=1&period=day&date=last52&format=php&token_auth=TOKEN&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:83:"Mysqli prepare error: Unknown column 'log_visit.config_device_type' in 'field list'";}'
ERROR CoreConsole[2014-10-22 08:19:31] [02138] Empty or invalid response '' forwebsite id 1, Time elapsed: 2.808s, skipping
ERROR CoreConsole[2014-10-22 08:19:33] [02138] Got invalid response from API request: http://www.example.com/webstat/app/index.php?module=API&method=API.get&idSite=4&period=day&date=last52&format=php&token_auth=TOKEN&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:83:"Mysqli prepare error: Unknown column 'log_visit.config_device_type' in 'field list'";}'
...
...
...
ERROR CoreConsole[2014-10-22 08:21:51] [02138] Empty or invalid response '' for website id 48, Time elapsed: 2.870s, skipping
ERROR CoreConsole[2014-10-22 08:21:52] [02138] 42 total errors during this script execution, please investigate and try and fix these errors.
any help would be greatly appreciated! if you need more info please let me know.
