Querycachedependency How To Set

ramram · April 17, 2014, 5:09am

I set this configuration for db component but it cause an error message because it runs my dependency on database not model

‘db’ => [

        'class'         		=&gt; 'yii&#092;db&#092;Connection',


        'dsn'           		=&gt; 'mysql:host=localhost;dbname=xxx',


        'username'              =&gt; 'root',


        'password'              =&gt; '',


        'charset'       		=&gt; 'utf8',


        'tablePrefix'   		=&gt; '',


        'emulatePrepare'        =&gt; true,


        'enableQueryCache'      =&gt; true,


        'queryCache'            =&gt; 'cache',


        'queryCacheDuration'    =&gt; true ? 0 : 864000, // 10 days


        'queryCacheDependency'  =&gt; new yii&#092;caching&#092;DbDependency(array('sql'=&gt;'SELECT MAX(updated_at)')),


        'enableSchemaCache' 	=&gt; true,


        'schemaCache'   		=&gt; 'cache',


        'schemaCacheDuration'   =&gt; true ? 0 : 864000, // 10 days


        'enableSavepoint'   	=&gt; true


    ],

error message

[color="#E51717"][font="inherit"][size="2"]Database Exception[/size][/font][/color] – yii\db\Exception

[b]SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘updated_at’ in ‘field list’

The SQL being executed was: SELECT MAX(updated_at)[/b]

[font="Times"][size="2"][color="#E51717"][font="inherit"][size="2"]↵[/size][/font][/color]

[color="#E51717"][font="inherit"][size="2"]Caused by:[/size][/font][/color] [color="#E51717"][font="inherit"][size="2"]PDOException[/size][/font][/color]

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘updated_at’ in ‘field list’

[color="#AAAAAA"][font="Arial, sans-serif"][size="4"]in [font="inherit"][size="2"]/Users/ramin/Server/xxx/vendor/yiisoft/yii2/db/Command.php[/size][/font] at line [font="inherit"][size="2"]404[/size][/font][/size][/font][/color]

[/size][/font]

[font="Times"][size="2"]---------------[/size][/font]

[font="Times"][size="2"]I know that I should mention table name in dependency but how should I do that when it wants to set as a global and will applied to all tables?[/size][/font]