Ran into this bug. When I did an update of the document in the collection, I mistakenly passed other id to the relationship attribute. After that I won't be able to clear that attribute into an empty array. these undefined fields in the array remained all the time, and after I add right ids. You can see it in the pictures below. Only deleting the document helped
Interesting...was it still there after refreshing the page?
Yes
I cant delete them from ui too
I'll try now to reproduce and refresh the whole page
interesting...from my experience, the relationship doesn't save if the document ID doesn't exist 🧐
I did a repeat. Yes, undefined again. and I sent not ids but an array of strings (I mixed up the arrays when this first happened)
@Steven I can send to you video, how it works. When I try delete, after that window freeze, and I refresh window
array of strings? What od you mean exactly? and can you share the JSON response for the get document api call for this document?
JSON:
{ "user_id" : "6477728b7ed36c3d3b05", "$id" : "6477728bbbc03f383897", "device_id" : null, "deleted" : false, "background" : null, "$createdAt" : "2023-05-31T16:15:07.769+00:00", "$updatedAt" : "2023-05-31T16:21:21.672+00:00", "$collectionId" : "644ccfb5873757ec93fa", "active_status" : false, "phone" : null, "chatRooms" : [
], "nick_name" : "testA", "created_by" : "64763abdbfa4ab03e718", ||"role_id" : [ { "$collectionId" : "6450c122e4cc1bf2e41a", "$databaseId" : "644ccfacafd0a0087649" }, { "$collectionId" : "6450c122e4cc1bf2e41a", "$databaseId" : "644ccfacafd0a0087649" } ],|| "first_name" : "first", "$databaseId" : "644ccfacafd0a0087649", "team_id" : "646e0dad7c68c11a09ba", "$permissions" : [
] }
const update_user = await database.updateDocument(db_id, db_users_id, user_document_id, {'team_id':payload.team_id, 'role_id':role_ids, "updated_by":by_user});
role_ids: ["645e5f3f1e810c950493", "644ccfb5873757ec93fa"] must be like this, but was by mistake role_ids: ["admin","manager"]
@Steven
Attribute role_id is Relationship (many to many)
make sure to use 3 back ticks for multi line code
ah that was it...
would you please create an issue for this and include all this info?
we need to check and verify the document exists before doing this step: https://github.com/utopia-php/database/blob/d821d1f18dfe83b0350ed208be3658764aec99d7/src/Database/Database.php#L3212-L3224
Yes, of course I will do it tomorrow
Recommended threads
- Unable to create Sites or Functions with...
Heya, I was looking at the appwrite documentation for Sites API with the server api: https://appwrite.io/docs/references/cloud/server-nodejs/sites I can’t fin...
- listRows result parsing issue
I'm using Appwrite Dart SDK "24.2.0". When I perform a listRows call in dart, I have this reponse in JSON: in " Future<models.RowList> listRows()" { "total" :...
- Index for combination of columns
How am i suppposed to apply index so that combination of two columns alwasy remain unique in appwrite table though console