After upgrade : SQLSTATE[42000] [1203]

Support & Bugs
1

Hi,

With version Piwik 0.4.1 , i’ve no problem, no error message. style_emoticons/<#EMO_DIR#>/rolleyes.gif

But now…After online upgrade yesterday to piwik 0.4.2 , i have a message in some widget window: style_emoticons/<#EMO_DIR#>/sad.gif
It’s not always the same widget. I have to reload the page many times. I’ve clear the cache and test it on 3 computers.

Here the message i have in some widget.

[b]Piwik # open source web analytics

SQLSTATE[42000] [1203] User xxxxxx already has more than ‘max_user_connections’ active connections
Backtrace:

#0 /xxxxxx/www/piwik/libs/Zend/Db/Adapter/Abstract.php(228): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /xxxxxx/www/piwik/core/Piwik.php(1207): Zend_Db_Adapter_Abstract->getConnection()
#2 /xxxxxx/www/piwik/core/FrontController.php(206): Piwik::createDatabaseObject()
#3 /xxxxxx/www/piwik/index.php(52): Piwik_FrontController->init()
#4 {main}

* Piwik homepage
* Piwik Frequently Asked Questions
* Piwik Documentation
* Piwik Forums
* Piwik Online Demo[/b]

I repeat that i’ve never seen this message with version 0.4.1

Do you have an idea ?
If there is no solution, where can i download the old version 0.4.1 ?

Thanks for your help.

2

If the problem persists, try adding this line to index.php:

require_once PIWIK_INCLUDE_PATH .'/core/Loader.php';
Zend_Session::start(); // this line is new

if(!defined('PIWIK_ENABLE_ERROR_HANDLER') || PIWIK_ENABLE_ERROR_HANDLER)

You can find current & past Piwik releases at builds.piwik.org

3

Thank you very much

It’s good now with the line in index.php.

style_emoticons/<#EMO_DIR#>/rolleyes.gif

4

One minor change to that patch. Can you see if this still helps in your environment?

if(!Zend_Session::sessionExists())
{
        Zend_Session::start();
}
5

Hi,

I’ve got the same error message with

if(!Zend_Session::sessionExists())
{
Zend_Session::start();
}

…

There is no more error message with only the line

Zend_Session::start();

6

Thank you. I’ll commit the fix to SVN.