[tekrda]

Hi everyone,
I'm having problem with migration, migration runs successfully on CLI but it doesn't create any table except migration table which contains migration related detail. Any help?
pls find the images below:

[InsiteFX]

I'm not sure on this one but I believe you need to add all the fields with addKey.
All the migrations that I have seen do it this way, see below.

PHP Code:

/*
 * Users
 */
$this->forge->addField([
    'id'               => ['type' => 'int', 'constraint' => 11, 'unsigned' => true, 'auto_increment' => true],
    'email'            => ['type' => 'varchar', 'constraint' => 255],
    'username'         => ['type' => 'varchar', 'constraint' => 30, 'null' => true],
    'password_hash'    => ['type' => 'varchar', 'constraint' => 255],
]);

$this->forge->addKey('id', true);
$this->forge->addUniqueKey('email');
$this->forge->addUniqueKey('username');

$this->forge->createTable('users', true); 


[tekrda]

I'm not sure on this one but I believe you need to add all the fields with addKey.
All the migrations that I have seen do it this way, see below.

PHP Code:

/*
 * Users
 */
$this->forge->addField([
    'id'               => ['type' => 'int', 'constraint' => 11, 'unsigned' => true, 'auto_increment' => true],
    'email'            => ['type' => 'varchar', 'constraint' => 255],
    'username'         => ['type' => 'varchar', 'constraint' => 30, 'null' => true],
    'password_hash'    => ['type' => 'varchar', 'constraint' => 255],
]);

$this->forge->addKey('id', true);
$this->forge->addUniqueKey('email');
$this->forge->addUniqueKey('username');

$this->forge->createTable('users', true); 


Thanks for the reply,

i got the solution. the problem is that when you run migration, codeigniter does not generate any exception if there is any issue in your migration class, it silently says "Done" and does not create table in DB based on your schema. This behavior makes the developer clueless. This need to be addressed by codeigniter developers team.

the problem was that i had declared "email" field unique twice one in field's array and other is via addUniqueKey() function and also i had not specified DBGroup variable as  protected $DBGroup = 'default';

[InsiteFX]

You can report it as an issue here:

CodeIgniter 4 Development

If you on the top toolbar you will see the issue button.