SQL Error after update 1.9.2 to 1.10.1

Support & Bugs
1

after Update from 1.9.2 auf 1.10.1
Update site show: Update OK
When i open Piwik it shows me an error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘stats.piwik_report’ doesn’t exist

This table is not in DB where is the table?

2

Do you get the backtrace below the error as well please ?

3

here it is…

Backtrace:
#0 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT * ???..’, Array)
#3 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/core/Db/Adapter/Pdo/Mysql.php(223): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT * ???..’, Array)
#4 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/libs/Zend/Db/Adapter/Abstract.php(736): Piwik_Db_Adapter_Pdo_Mysql->query(‘SELECT * ???..’, Array)
#5 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/core/PluginsFunctions/Sql.php(80): Zend_Db_Adapter_Abstract->fetchAll(‘SELECT * ???..’, Array)
#6 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/core/PluginsFunctions/Sql.php(467): Piwik_Sql::fetchAll(‘SELECT * ???..’, Array)
#7 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/plugins/PDFReports/API.php(258): Piwik_FetchAll(‘SELECT * ???..’, Array)
#8 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/plugins/PDFReports/PDFReports.php(588): Piwik_PDFReports_API->getReports()
#9 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/plugins/PDFReports/PDFReports.php(565): Piwik_PDFReports->getTopMenuTranslationKey()
#10 [internal function]: Piwik_PDFReports->addTopMenu(Object(Piwik_Event_Notification))
#11 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/libs/Event/Dispatcher.php(284): call_user_func_array(Array, Array)
#12 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/core/PluginsManager.php(723): Event_Dispatcher->postNotification(Object(Piwik_Event_Notification), false, false)
#13 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/core/Menu/Top.php(64): Piwik_PostEvent(‘TopMenu.add’)
#14 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/core/Menu/Top.php(77): Piwik_Menu_Top->get()
#15 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/core/Controller.php(473): Piwik_GetTopMenu()
#16 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/core/Controller.php(460): Piwik_Controller->setBasicVariablesView(Object(Piwik_View))
#17 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/plugins/CoreHome/Controller.php(60): Piwik_Controller->setGeneralVariablesView(Object(Piwik_View))
#18 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/plugins/CoreHome/Controller.php(95): Piwik_CoreHome_Controller->getDefaultIndexView()
#19 [internal function]: Piwik_CoreHome_Controller->index()
#20 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/core/FrontController.php(138): call_user_func_array(Array, Array)
#21 /var/www/vhosts/print-weilburg.de/httpdocs/x-stats/index.php(53): Piwik_FrontController->dispatch()
#22 {main}

4

i have this problem too :
i get this error :

Backtrace:
#0 /home/ogoldent/public_html/analyze/plugins/CoreUpdater/Controller.php(53): Piwik_CoreUpdater_Controller->checkNewVersionIsAvailableOrDie()
#1 /home/ogoldent/public_html/analyze/core/FrontController.php(138): Piwik_CoreUpdater_Controller->oneClickUpdate()
#2 /home/ogoldent/public_html/analyze/index.php(53): Piwik_FrontController->dispatch(Array, Array)
#3 {main}

5

Jayq, it sounds like the plugin PdfReports didn’t install properly

can you delete the line PluginsInstalled = PdfReports from the config.ini.php file and try again to install the plugin in the plugin settings ?

6

I deleted the line and it works. thanks a lot. !