I'm using Appwrite locally on version 1.4.13
I have two related collections: user_profile
and climb
. A user_profile
can have many climb
s, and a climb
can have one user_profile
.
When deleting a user_profile
I want to do a setNull
on the related climb
s.
But when doing so, I get an Appwrite "Server Error"
My appwrite.json
has this:
On the user_profile
:
{
"key": "climb",
"type": "relationship",
"status": "available",
"error": "",
"required": false,
"array": false,
"relatedCollection": "65dcb2225a080e10109f",
"relationType": "oneToMany",
"twoWay": true,
"twoWayKey": "setter",
"onDelete": "setNull",
"side": "parent"
}
On the climb
:
{
"key": "setter",
"type": "relationship",
"status": "available",
"error": "",
"required": false,
"array": false,
"relatedCollection": "65dcb0b8eb253f1b0df9",
"relationType": "oneToMany",
"twoWay": true,
"twoWayKey": "climb",
"onDelete": "setNull",
"side": "child"
}
I can work around this by manually setting the climb.setter
to null
, but this seems to be functionality the "onDelete": "setNull"
should do.
If I don't manually set the climb.setter
to null
, I can't delete the user_profile
and get the "Server Error".
Please advise how I can update my JSON to get the required functionality, or confirm if this is a bug?
Recommended threads
- Argument of type '"top"' is not assignab...
Hi there! Can someone take a look at my code? I followed the steps from the instruction video, and yet this error appeared out of nowhere. The error is what I m...
- API key doesn't have permission even tho...
Hi All, I seem to be having issues with nodejs and the sdk. I've setup an API key which has all scopes for the project, but I keep getting the "The current us...
- Query.or with Query.equal('$id', id) don...
Selfhosted: Version 1.5.5 Sdk: "appwrite": "^14.0.1" ```ts [ Query.or([ Query.equal('$id', parentDocumentId), Query.equal('parent...