Hello,
we’re having a website running on ExpressionEngine v2.6.1.
We’ve been using the Relationship fieldtype for quite a while there, no issues.
Now however, there’s one entry (an Event) that needs 7 entries in this Relationship field. These are 7 different names, coming from another channel (Participant).
However, somehow only 4 or 5 of the entries we enter actually get stored. The others just disappear, and there’s no logic there whatsoever. The ones disappearing seem completely random.
I’ve noticed in the database that the order field from exp_relationships usually increments from 1 to a certain number. In this case it leaves the numbers out of those that disappear (so we could have 2,4,5,6,7 for example).
We’ve tried to change this field in a Playa fieldtype instead, and tried the same thing. Then we get the next issue: “Data too long for column field_id_31”.
We’ve tried to change the type of this field from Varchar to Text, LongText, LongBlob, ... but to no avail.
Then we changed it back to relationship, tried changing the type there, still the same issue.
Now, with another set of Participants (so not the ones needed for this entry) we manage to get more than 4 of 5, but there’s just nothing in those other Participants that I can point out as ‘possibly breaking’.
I have also tried some var_dumps in the save and post_save methods of the fieldtype itself, and indeed - the data is incomplete in $data[‘data’].
Anyone had a similar issue, or a clue where to look? Would be great. Thanks!