Sqlite migration directus v9.7.1 to v9.9.0 fails

[Pachat]

Describe the Bug

When runningnpx directus database migrate:latest

09:31:42 Running migrations...
09:31:43 Applying Add Bookmark Icon and Color...
09:31:43 Applying Add Field Validation...
09:31:43 Applying Fix Typecast Flags...
09:31:43 Applying Add Default Language...
09:31:43 DROP TABLE "directus_users" - SQLITE_CONSTRAINT: FOREIGN KEY constraint failed

To Reproduce

Over 9.7.1
npm install directus
npx directus database migrate:latest

Errors Shown

Error: DROP TABLE "directus_users" - SQLITE_CONSTRAINT: FOREIGN KEY constraint failed

What version of Directus are you using?

9.7.1

What version of Node.js are you using?

v16.14.0

What database are you using?

SQLite 3.37

What browser are you using?

Firefox

How are you deploying Directus?

locally

[azrikahar]

Thanks for opening this issue! However this is a duplicate of an existing issues #12529 #10842, so I'll proceed to close this but if you think this is actually a different issue, then please do not hesitate to comment. Otherwise you may subscribe to #10842 for future updates. ¹

Footnotes

1. This is an automated response. ↩