Cleaning up Yii logs

There’s a bunch of unnecessary information in my yii log files that I’d like to clean up. Right now, I have my yii logrouter levels set to “trace, warning, info, error”. I’m wondering why I’m getting the following log:

(Bunch of unnecessary SQL, there are no errors in the SQL or anything)

2011/07/01 11:00:01 [trace] [system.CModule] Loading "log" application

component

2011/07/01 11:00:01 [trace] [system.CModule] Loading "db" application

component

2011/07/01 11:00:01 [trace] [system.db.CDbConnection] Opening DB

connection

2011/07/01 11:00:01 [trace] [system.db.CDbCommand] Querying SQL: SHOW

COLUMNS FROM Batches

2011/07/01 11:00:01 [trace] [system.db.CDbCommand] Querying SQL: SHOW

CREATE TABLE Batches

2011/07/01 11:00:01 [trace] [system.db.ar.CActiveRecord]

Batches.findAll()

2011/07/01 11:00:01 [trace] [system.db.CDbCommand] Querying SQL:

SELECT * FROM Batches …

Any ideas? I understand these aren’t “errors” perse, but why am I getting this logged to my app? I’m a little confused as none of my other SQL commands aren’t logging.

I’m sure disabling trace would fix this, I’d just like to know why I’m getting this.

Also, this app is running as a cron job if that helps.

You get this messages, because they are of level [trace] and you configured your log route to include that level. Maybe read again Section 1 here:

http://www.yiiframew…message-logging