table "XXX_file_locks_2023-10-06" collides with the constraint on table "XXX_file_locks".
Search the forum for the collides with the constraint on table part. You’ll find resources.
The gist is you have a table that doesn’t belong (looks like maybe a manually created backup or copy of your existing database made on 2023-10-06). That table needs to be dropped since it conflicts with the live one.
Make sure you back up your database first (hopefully you were already doing that, but I always like to remind people to do so).