Yii MySQL DB Migration trying to use SQLite

Question

I'm creating a test application with Yii and have created my first migration.

<?php

class m111128_223507_reverse_bed_patient extends CDbMigration
{
public function up()
{

    $this->dropForeignKey('fk_bed_patient1', 'bed');
    $this->dropColumn('bed', 'patient_id');
    $this->addColumn('patient', 'bed_id', 'int(11)');
    $this->addForeignKey('fk_patient_bed1', 'patient', 'bed_id', 'bed', 'id', 'NO ACTION', 'NO ACTION');

}

public function down()
{
    echo "m111128_223507_reverse_bed_patient does not support migration down.\n";
    return false;
}

}

for some reason Yii thinks I'm using a SQLite db even though in my app main.php I have MySQL settings which works correctly everywhere else and the SQLite lines commented out.

I'm getting this error when I try my first migrate.

* applying m111128_223507_reverse_bed_patient drop column patient_id from table bed ...exception 'CDbException' with message 'Dropping DB column is not supported by SQLite.' in ..

What am I missing here?

Alex Z · Accepted Answer · 2011-11-28 23:09:46Z

4

Probably your yiic tool is using console.php config file (as it is by default in Yii), try to review DB connection settings in protected/config/console.php.

answered Nov 28, 2011 at 23:09

Alex Z

3353 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Yii MySQL DB Migration trying to use SQLite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related