Can't delete file from library

[federicocappellotto97]

Preflight Checklist

• I have completed all Troubleshooting Steps.
• I'm on the latest version of Directus.
• There's no other issue that already describes my problem.

Describe the Bug

If i delete an image from library i get this error:
{ "errors": [ { "message": "delete fromdirectus_fileswhereid in ('e9c5f419-f465-4548-8be9-42e5ec32e0f1') - ER_ROW_IS_REFERENCED_2: Cannot delete or update a parent row: a foreign key constraint fails (directus-saccardo.directus_settings, CONSTRAINT directus_settings_project_logo_foreign FOREIGN KEY (project_logo) REFERENCES directus_files (id))", "extensions": { "code": "INTERNAL_SERVER_ERROR" } } ] }

To Reproduce

Delete an image from library

Errors Shown

{
"errors": [
{
"message": "delete from directus_files where id in ('e9c5f419-f465-4548-8be9-42e5ec32e0f1') - ER_ROW_IS_REFERENCED_2: Cannot delete or update a parent row: a foreign key constraint fails (directus-saccardo.directus_settings, CONSTRAINT directus_settings_project_logo_foreign FOREIGN KEY (project_logo) REFERENCES directus_files (id))",
"extensions": {
"code": "INTERNAL_SERVER_ERROR"
}
}
]
}

What version of Directus are you using?

9.0.1

What version of Node.js are you using?

14.18.1

What database are you using?

MysQL

What browser are you using?

Chrome

What operating system are you using?

macOS Monterey (12)

How are you deploying Directus?

Locally

[federicocappellotto97]

Update, resolved: this file was the project logo.
I removed the logo then i deleted correctly the file.

[ruihildt]

I hit the same error for the same reason, either the logo should be deleted or a nicer error be shown.

[federicocappellotto97]

Maybe it would be better to give more tips about the error instead of "Internal server error"

[azrikahar]

This has indeed been brought up quite a few times, and technically a duplicate of #9507, so I'll proceed to close this 👍