CDbException

fhding · August 13, 2010, 2:25am

If my web pages in a period of time has not been visited (about for several hours), page will tip.

Refresh, and to work properly. I don’t know why…

The Exception message is "CDbConnection is inactive and cannot perform any DB operations.".

My yii version is 1.1.3

samdark · August 15, 2010, 4:49pm

Please show your DB config (except credentials).

fhding · August 16, 2010, 2:44am

Database is mysql 5.5 .

The DB config in main.php is

      'db'=&gt;array('connectionString' =&gt; 'mysql:host=***.***.***.11;dbname=api',


                  'emulatePrepare' =&gt; true,


                  'username' =&gt; '...', 


                  'password' =&gt; '*****',


                  'charset' =&gt; 'utf8', 


      ).

Database is merely by simple installed.

samdark · August 16, 2010, 9:21am

Yii config looks OK. Try checking if mysql is using persistent connections.

fhding · August 17, 2010, 6:50am

I use the default DB connections of yii.