Shield installation

I'm following the steps in the tutorial:

https://shield.codeigniter.com/getting_started/install/

It seems to work but nothing is created in the database

  Run `spark migrate --all` now? [y, n]: y
Running all new migrations...
Migrations complete.

There are no errors in the proces, there are no migrations files on app\Database\Migrations. I dont know it should be.

I'm really lost here

If there is no errors, the installation has been completed.
The migration files locate in the Shield directory in the vendor directory.

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

If there is no errors, the installation has been completed.
The migration files locate in the Shield directory in the vendor directory.

When the migration is executed, shouldn't the tables have been created? I tried it in project to test and I think the tables on the db were created with the spark shield:update


On migratetatus the migration create_auth_tables appear but the tables are not on the db

When the migration is executed, shouldn't the tables have been created?

Yes.

Code:

$ php spark migrate:status

CodeIgniter v4.4.3 Command Line Tool - Server Time: 2024-02-05 10:37:13 UTC+00:00

+----------------------+-------------------+---------------------+---------+---------------------+-------+
| Namespace            | Version          | Filename            | Group  | Migrated On        | Batch |
+----------------------+-------------------+---------------------+---------+---------------------+-------+
| CodeIgniter\Shield  | 2020-12-28-223112 | create_auth_tables  | default | 2023-12-27 11:52:21 | 1    |
| CodeIgniter\Settings | 2021-07-04-041948 | CreateSettingsTable | default | 2023-12-27 11:52:21 | 1    |
| CodeIgniter\Settings | 2021-11-14-143905 | AddContextColumn    | default | 2023-12-27 11:52:21 | 1    |
+----------------------+-------------------+---------------------+---------+---------------------+-------+

Code:

$ php spark db:table --show

CodeIgniter v4.4.3 Command Line Tool - Server Time: 2024-02-05 10:38:22 UTC+00:00

The following is a list of the names of all database tables:

+----+------------------------+-------------+---------------+
| ID | Table Name            | Num of Rows | Num of Fields |
+----+------------------------+-------------+---------------+
| 1  | migrations            | 3          | 7            |
| 2  | users                  | 2          | 9            |
| 3  | auth_identities        | 3          | 12            |
| 4  | auth_logins            | 0          | 8            |
| 5  | auth_token_logins      | 0          | 8            |
| 6  | auth_remember_tokens  | 0          | 7            |
| 7  | auth_groups_users      | 2          | 4            |
| 8  | auth_permissions_users | 0          | 4            |
| 9  | settings              | 0          | 8            |
+----+------------------------+-------------+---------------+

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

I'm here again

Code:

PS C:\xampp\htdocs\manmount> php spark migrate --all

CodeIgniter v4.4.6 Command Line Tool - Server Time: 2024-03-15 07:30:38 UTC+00:00

Running all new migrations...
Migrations complete.
PS C:\xampp\htdocs\manmount> php spark migrate:status

CodeIgniter v4.4.6 Command Line Tool - Server Time: 2024-03-15 07:30:42 UTC+00:00

+----------------------+-------------------+---------------------+-------+-------------+-------+
| Namespace            | Version          | Filename            | Group | Migrated On | Batch |
+----------------------+-------------------+---------------------+-------+-------------+-------+
| App                  | 2020-12-28-223112 | create_auth_tables  | ---  | ---        | ---  |
| CodeIgniter\Shield  | 2020-12-28-223112 | create_auth_tables  | ---  | ---        | ---  |
| CodeIgniter\Settings | 2021-07-04-041948 | CreateSettingsTable | ---  | ---        | ---  |
| CodeIgniter\Settings | 2021-11-14-143905 | AddContextColumn    | ---  | ---        | ---  |
+----------------------+-------------------+---------------------+-------+-------------+-------+

PS C:\xampp\htdocs\manmount> php spark db:table --show

CodeIgniter v4.4.6 Command Line Tool - Server Time: 2024-03-15 07:30:45 UTC+00:00

The following is a list of the names of all database tables:

+----+------------+-------------+---------------+
| ID | Table Name | Num of Rows | Num of Fields |
+----+------------+-------------+---------------+
| 1  | config    | 0          | 14            |
| 2  | migrations | 0          | 7            |
| 3  | pages      | 8          | 20            |
+----+------------+-------------+---------------+

I dont understand why this happens

It seems your migration files are not executed at all.
I don't know why.

Is there any error in CI4 log file?

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

It seems your migration files are not executed at all.
I don't know why.

Is there any error in CI4 log file?

No errors in the log

Then, there is no error, but your migration files are not executed at all. Weird.

Why do you have two `create_auth_tables`?

| App                  | 2020-12-28-223112 | create_auth_tables  | ---  | ---        | ---  |
| CodeIgniter\Shield  | 2020-12-28-223112 | create_auth_tables  | ---  | ---        | ---  |

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

I dont know, maybe i copied it trying some fix. I delete it now but i got the same

Code:

PS C:\xampp\htdocs\manmount> php spark migrate --all

CodeIgniter v4.4.6 Command Line Tool - Server Time: 2024-03-15 08:07:52 UTC+00:00

Running all new migrations...
Migrations complete.
PS C:\xampp\htdocs\manmount> php spark db:table --show

CodeIgniter v4.4.6 Command Line Tool - Server Time: 2024-03-15 08:07:58 UTC+00:00

The following is a list of the names of all database tables:

+----+------------+-------------+---------------+
| ID | Table Name | Num of Rows | Num of Fields |
+----+------------+-------------+---------------+
| 1  | config     | 0           | 14            |
| 2  | migrations | 0           | 7             |
| 3  | pages      | 8           | 20            |
+----+------------+-------------+---------------+


PS C:\xampp\htdocs\manmount> php spark migrate:status

CodeIgniter v4.4.6 Command Line Tool - Server Time: 2024-03-15 08:08:03 UTC+00:00

+----------------------+-------------------+---------------------+-------+-------------+-------+
| Namespace            | Version           | Filename            | Group | Migrated On | Batch |
+----------------------+-------------------+---------------------+-------+-------------+-------+
| CodeIgniter\Shield   | 2020-12-28-223112 | create_auth_tables  | ---   | ---         | ---   |
| CodeIgniter\Settings | 2021-07-04-041948 | CreateSettingsTable | ---   | ---         | ---   |
| CodeIgniter\Settings | 2021-11-14-143905 | AddContextColumn    | ---   | ---         | ---   |
+----------------------+-------------------+---------------------+-------+-------------+-------+

Did you disable migration?
See https://github.com/codeigniter4/CodeIgni...ns.php#L19

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper