Error running first migration on empty database

[vbeffa]

I am trying to run my initial SQL script on an empty database but I am getting this error:

Error: migration 0 was previously applied but is missing in the resolved migrations

The code I am using is:

let pool = PgPool::connect(&db_url).await?;

migrate!("./sql").run(&pool).await?;

The _sqlx_migrations table was created but it is empty.

[mehcode]

What does your ./sql directory look like? Migrations should be <VERSION>_<NAME>.sql with the version being an integer above 0.

[vbeffa]

The current migration file in ./sql is named 0000_tables.sql. I just tried renaming it to 0001_tables.sql and also 1_tables.sql but got the same error.

[vbeffa]

Actually I think it may have been an error in my SQL script that was causing the newer attempt (with 0001_tables.sql) to fail. I fixed that error and now the migration runs as expected.

[mareq]

Yes, the 0000 is indeed the problem. Had the same one: 81983a8#diff-76f717eda89b6eae159b446a6d38bcaf875627728e329aaed78a858ab39e4701R18