Hi,
I see below error while creating a record,
There is no key ""SURVEY_PROPERTY_ID" available in either DB or Record
The counter seems to increase every time I try to write to record. But always shows the same error.
Thanks in advance
Discussion posts and replies are publicly visible
Check if you have any triggers configured in the table that might be affecting this column in another table and causing this error
Depending on the data model and relations, you might have to also check other tables.
If you implemented additional DB-logic like triggers, constraints or foreign keys, you will have to investigate these as well.
There might be a unique index named SURVEY_PROPERTY_ID on your table (likely leftover from a dropped column or relationship).Run SHOW INDEX FROM <table>; You might see it. Drop that index, sync the record.