google-code-export / yii-user

Automatically exported from code.google.com/p/yii-user
1 stars 1 forks source link

Module does not quote profile fields properly #92

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
In /protected/modules/user/controllers/ProfileFieldController.php custom fields 
are automatically quoted with `, which make it fail on Postgres. 

Yii::app()->db->schema->quoteColumnName() should be used instead.

Affected lines are:
325: $sql = 'ALTER TABLE '.Profile::model()->tableName().' ADD 
'.Yii::app()->db->schema->quoteColumnName($model->varname).' ';

437: $sql = 'ALTER TABLE '.Profile::model()->tableName().' DROP 
'.Yii::app()->db->schema->quoteColumnName($model->varname);

Original issue reported on code.google.com by marve...@gmail.com on 17 Jun 2011 at 4:35