Error when updating relational field #13584
terion-name
announced in
Archive
Replies: 1 comment 1 reply
-
Could you confirm that the collation is the same across all tables that are used in this relationship? It reminds me of #9897 which was inherently caused by the referencing table being of a different collation in MySQL. |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Describe the Bug
In continuation of #13369 (relational structure is there): because of relation duplication bug, decided to make models immutable. Added a condition to relational field and got:
To Reproduce
See screencast:
screencast.2022-05-18.13-40-48.mp4
Errors Shown
[INTERNAL_SERVER_ERROR] alter table
order_slots
modifyitem
int - UNKNOWN_CODE_PLEASE_REPORT: Referencing column 'item' and referenced column 'id' in foreign key constraint 'order_slots_item_foreign' are incompatible.What version of Directus are you using?
9.10.0
What version of Node.js are you using?
v16.14.0
What database are you using?
mysql
What browser are you using?
brave
How are you deploying Directus?
locally
Beta Was this translation helpful? Give feedback.
All reactions