Craft 4 - Integrity violation after saving entry with link field

[Antimated]

Trying to save a link field (on an existing craft install that's been updated to craftcms 4.0.0.1) results in a integrity violation error. This error occurs mostly when switching from/to different link types. In my case the error occurs inside of a matrix field, not sure if it's also the case when the field is just plain added to an entry.

Plugin version: 2.1.1-rc

[sebastian-lenz]

The error does not contain a reference to a link field, also the affected table is not the link field table. Why do you assume that error is related to this plugin?

[Antimated]

The error does not contain a reference to a link field, also the affected table is not the link field table. Why do you assume that error is related to this plugin?

Because whenever I update this field the error occurs :/ Seems like switching options in the dropdown (where you have: "no link", entry, custom,...) and then saving throws me the error. Does not happen (as far as I can reproduce) when changing other fields)

[Antimated]

I'm also not able to select an entry from a typed link field, just gives a server error.

[sebastian-lenz]

I've received another issue from a user who also complains about a similar foreign key issue, I guess the new CMS version exposes issues within the data structure of certain projects. In you example, the database complains about an element with the id 166 not being present in the table craft_elements. Can you check whether the element record is there? Also, does the element select dialog work in other instances, e.g. for reference fields?

[Antimated]

I've received another issue from a user who also complains about a similar foreign key issue, I guess the new CMS version exposes issues within the data structure of certain projects. In you example, the database complains about an element with the id 166 not being present in the table craft_elements. Can you check whether the element record is there?

No, doesn't seem like that element is present for some reason...

Also, does the element select dialog work in other instances, e.g. for reference fields?

Yes I added a simple "entries" field with these sources (it's a relatively empty site) and the element select dialog seems to work there.

Maybe an extra sidenote: This is a multi language site

[sebastian-lenz]

Okay, I think I've found the bug, it's related to the way Craft now handles newly created elements. I've published a new release that contains the fix.