Issue after upgrading from v1.11.1 to v2.1


#1

I tried to upgrade from 1.11.1 to 2.1 but failed with the following errors, retried several times, database seems to be ok (site webtermine.at is up with no issues) - please help, thx!

There is an error. Please report the message (Piwik 2.1.0) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Warning: PDOStatement::execute() [pdostatement.execute]: MySQL server has gone away in /piwik/libs/Zend/Db/Statement/Pdo.php on line 228

Backtrace -->

#0 Piwik\Error::errorHandler(…) called at [:]
#1 PDOStatement->execute(…) called at [/piwik/libs/Zend/Db/Statement/Pdo.php:228]
#2 Zend_Db_Statement_Pdo->_execute(…) called at [/piwik/libs/Zend/Db/Statement.php:300]
#3 Zend_Db_Statement->execute(…) called at [/piwik/libs/Zend/Db/Adapter/Abstract.php:479]
#4 Zend_Db_Adapter_Abstract->query(…) called at [/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php:238]
#5 Zend_Db_Adapter_Pdo_Abstract->query(…) called at [/piwik/core/Db/Adapter/Pdo/Mysql.php:229]
#6 Piwik\Db\Adapter\Pdo\Mysql->query(…) called at [/piwik/libs/Zend/Db/Adapter/Abstract.php:827]
#7 Zend_Db_Adapter_Abstract->fetchOne(…) called at [/piwik/core/Db.php:206]
#8 Piwik\Db::fetchOne(…) called at [/piwik/core/Updates/2.0-a12.php:31]
#9 Piwik\Updates\Updates_2_0_a12::getSql(…) called at [:]
#10 call_user_func(…) called at [/piwik/core/Updater.php:122]
#11 Piwik\Updater->getSqlQueriesToExecute(…) called at [/piwik/plugins/CoreUpdater/Controller.php:118]
#12 Piwik\Plugins\CoreUpdater\Controller->redirectToDashboardWhenNoError(…) called at [/piwik/plugins/CoreUpdater/Controller.php:324]
#13 Piwik\Plugins\CoreUpdater\Controller->runUpdaterAndExit(…) called at [/piwik/plugins/CoreUpdater/Controller.php:270]
#14 Piwik\Plugins\CoreUpdater\Controller->index(…) called at [:]
#15 call_user_func_array(…) called at [/piwik/core/FrontController.php:521]
#16 Piwik\FrontController->doDispatch(…) called at [/piwik/core/FrontController.php:84]
#17 Piwik\FrontController->dispatch(…) called at [/piwik/core/dispatch.php:30]
#18 require_once(…) called at [/piwik/index.php:47]

There is an error. Please report the message (Piwik 2.1.0) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Warning: PDOStatement::execute() [pdostatement.execute]: Error reading result set’s header in /piwik/libs/Zend/Db/Statement/Pdo.php on line 228

Backtrace -->

#0 Piwik\Error::errorHandler(…) called at [:]
#1 PDOStatement->execute(…) called at [/piwik/libs/Zend/Db/Statement/Pdo.php:228]
#2 Zend_Db_Statement_Pdo->_execute(…) called at [/piwik/libs/Zend/Db/Statement.php:300]
#3 Zend_Db_Statement->execute(…) called at [/piwik/libs/Zend/Db/Adapter/Abstract.php:479]
#4 Zend_Db_Adapter_Abstract->query(…) called at [/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php:238]
#5 Zend_Db_Adapter_Pdo_Abstract->query(…) called at [/piwik/core/Db/Adapter/Pdo/Mysql.php:229]
#6 Piwik\Db\Adapter\Pdo\Mysql->query(…) called at [/piwik/libs/Zend/Db/Adapter/Abstract.php:827]
#7 Zend_Db_Adapter_Abstract->fetchOne(…) called at [/piwik/core/Db.php:206]
#8 Piwik\Db::fetchOne(…) called at [/piwik/core/Updates/2.0-a12.php:31]
#9 Piwik\Updates\Updates_2_0_a12::getSql(…) called at [:]
#10 call_user_func(…) called at [/piwik/core/Updater.php:122]
#11 Piwik\Updater->getSqlQueriesToExecute(…) called at [/piwik/plugins/CoreUpdater/Controller.php:118]
#12 Piwik\Plugins\CoreUpdater\Controller->redirectToDashboardWhenNoError(…) called at [/piwik/plugins/CoreUpdater/Controller.php:324]
#13 Piwik\Plugins\CoreUpdater\Controller->runUpdaterAndExit(…) called at [/piwik/plugins/CoreUpdater/Controller.php:270]
#14 Piwik\Plugins\CoreUpdater\Controller->index(…) called at [:]
#15 call_user_func_array(…) called at [/piwik/core/FrontController.php:521]
#16 Piwik\FrontController->doDispatch(…) called at [/piwik/core/FrontController.php:84]
#17 Piwik\FrontController->dispatch(…) called at [/piwik/core/dispatch.php:30]
#18 require_once(…) called at [/piwik/index.php:47]

Web Analytics

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away


(Matthieu Aubry) #2

see How do I fix the error "Mysql Server has gone away"? - Analytics Platform - Matomo