database migration is not working in yii

Question

In Yii framework I used migration just like ./yiic migrate create tbl_demo it made the migration file where I entered the values for up like

<?php

class m110714_094912_tbl_demo extends CDbMigration
{
  public function up()
  {
    $this-> createTable('{{tbl_demo}}', array(
      'id' => 'pk',
      'name' => 'VARCHAR \'80\' NOT NULL',
    ))
  }

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

  /*
  // Use safeUp/safeDown to do migration with transaction
  public function safeUp()
  {
  }

  public function safeDown()
  {
  }
  */
}

after entering this it is showing message like

New migration created successfully.

But whenever I am checking mysql database there is no table for tbl_demo is found. I also put all the values of up in safeup but it not made any result.Every thing is working fine but don't know why new table is not creating? Please help me

ddinchev · Accepted Answer · 2011-07-14 10:31:01Z

2

You should go to the command line and call yiic migrate up and it will ask you if you want to apply the tbl_demo migration and when you type in "yes" it will execute the code. The message New migration created successfully. appears when you execute yiic migrate create -something- not when you apply the migration.

If you want to apply the migration again, you should delete the row regarding "tbl_demo" migration in the "migrations" db table that yiic created to log the migrations.

answered Jul 14, 2011 at 10:31

ddinchev

34.8k28 gold badges95 silver badges138 bronze badges

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

3 Comments

NewUser Over a year ago

ya I have made that..Yiic migrate up and it showed messge like Migrated up successfully. But no new table is found in the database.

ddinchev Over a year ago

You haven't said what is your DB server (mysql?) I would do 'name' => 'VARCHAR(80) NOT NULL' which is the right syntax and if it doesn't help I would go to CDbConnection's createTable command and see how the SQL query is built, then dump it with echo and exit after the dump. Once you see what the query is, go try it yourself with other sql client to see if all is right with the query itself. ALSO keep in mind that the migrations use the DB config in console.php, not main.php - your console.php might point to another db?

NewUser Over a year ago

thanks buddy it helped me.Actually I had not made connection ib console.php. I had made connection to the database in main.php. So really thank u :)

Dan Ray · Accepted Answer · 2013-04-16 17:57:49Z

2

I just fixed this problem myself.

The answer is, the default /protected/config/console.php comes out of the box configured to use a SQLite database called testdrive.db. You have to configure it to talk to your MySQL database.

answered Apr 16, 2013 at 17:57

Dan Ray

22k7 gold badges65 silver badges88 bronze badges

Collectives™ on Stack Overflow

database migration is not working in yii

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related