Piwik Powershell Script Error - Mysql Driver Not Installed after upgrading to 1.10.1

Support & Bugs
1

Starting Piwik archiving…
Piwik archiving finished.
Starting Scheduled tasks…

Fatal error: Uncaught exception ‘Zend_Db_Adapter_Exception’ with message ‘The mysql driver is not currently installed’ in C:\inetpub\wwwroot\libs\Zend\Db\Adapter\Pdo\Abstract.php:112
Stack trace:
#0 C:\inetpub\wwwroot\libs\Zend\Db\Adapter\Pdo\Mysql.php(109): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 C:\inetpub\wwwroot\core\Db\Adapter\Pdo\Mysql.php(46): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 C:\inetpub\wwwroot\core\Db\Adapter.php(62): Piwik_Db_Adapter_Pdo_Mysql->getConnection()
#3 C:\inetpub\wwwroot\core\Piwik.php(2052): Piwik_Db_Adapter::factory(‘PDO_MYSQL’, Array)
#4 C:\inetpub\wwwroot\core\FrontController.php(275): Piwik::createDatabaseObject()
#5 C:\inetpub\wwwroot\index.php(52): Piwik_FrontController->init()
#6 {main}
thrown in C:\inetpub\wwwroot\libs\Zend\Db\Adapter\Pdo\Abstract.php on line 112

Finished Scheduled tasks.

The 1.10.1 installation is logging entries to the database and the installation passed all checks. I am unable to archive at this time. I had to revert to 1.9.2.

2

HI what version of php are you using?

Is it a windows server?

3

I’m running on Windows Server 2008R2, IIS, and PHP 5.4.10.

4

extension=php_pdo_mysql.dll

http://zend-framework-community.634137.n4.nabble.com/The-mysql-driver-is-not-currently-installed-td660514.html

This link has some info maybe when you upgraded these settings were lost in your php.ini?

5

As previously stated, operations go back to normal when reverting to 1.9.2. I did not modify or touch my PHP installation during the upgrade. And if I didn’t have php_pdo_mysql.dll, the analytics wouldn’t be logging or I wouldn’t be seeing live updates.

For sanity reasons here are the enabled extensions in the php.ini:

extension=php_gd2.dll
extension=php_mbstring.dll
extension=php_mysqli.dll
extension=php_pdo_mysql.dll

I also ran the system check under settings and it reports no issues, warnings, errors. It reports:

Huzzah! There are no problems with your Piwik setup. Give yourself a pat on the back.

Ideas?

6

Can you check what are the memory settings of the php.ini after you update? Is it possible it changed lower what was it in 1.9.2 and what was it when upgraded?

Is the error from backtrace or from logs?

7
  1. The memory settings are 128 MB, again no changes were made in the php.ini.
  2. No logs because it never has a chance to connect to a database or parse any logs. The nearest thing I have is what is listed in post #1.

I have resorted to calling php.exe and the archive.php script to perform the work. It runs without issues.