#✅ Creating a IMAGE relation throws error

1 messages · Page 1 of 1 (latest)

rich prawn
#

I have 5 local instances of directus 10.3 running. In each I tried to create a "image" field (only ine image!) and always get this error:

{
  "errors": [
    {
      "message": "alter table `rwfm_location` add constraint `rwfm_location_main_image_foreign` foreign key (`main_image`) references `directus_files` (`id`) on delete SET NULL - 
      ER_CANT_CREATE_TABLE: Can't create table `directus`.`rwfm_location` (errno: 150 \"Foreign key constraint is incorrectly formed\")",
      "extensions": {
        "code": "INTERNAL_SERVER_ERROR"
      }
    }
  ]
}

I do not see the error I am making.
Is anybody else experiencing the same problem?

Thank you!

PS: Creating a "Files" field does NOT cause that problem.

calm haloBOT
#

Thanks for posting! This is a community powered server, so you may or may not get an answer based on available help and expertise. To increase your chances of somebody being able to help you, please help us help you making sure you:

  • Adding an explanation of exactly what you're trying to achieve.
  • Adding any and all related code or previous attempts.
  • Describing the exact issue or error you are facing.
  • Posting any screenshots if applicable.
  • Reading through https://stackoverflow.com/help/how-to-ask.

When you're done with this thread, please close it. Thanks! ✨

(If you have a support agreement and need help, please contact the core team via email.)

rich prawn
#

Is nobody else experiencing this problem???

calm haloBOT
#

✅ Creating a IMAGE relation throws error