Error when deleting document containing relations

Trying to delete document, getting server error 500

Are you using relations?

@safwan yes i am using relationships. I have tried to recreate the collection. After deleting the entire collection and recreating, creating the relationship attribute fails

https://discord.com/channels/564160730845151244/1107273792411160696

Not sure what the cause is

It's something to do with relations. They're still in beta and not perfected.

got it. Maybe better to avoid relationship for now. its the third time am hitting this issue. in previous episodes had clear both collections and recreate them, However this time its not ideal to clear one of the collections

Is this a fresh install of Appwrite or you've upgrade is version?
If so did you run migration?

Migration is important to run if you have recently updated your version. And regarding relationship, any chance they have been set to NULL and/or changed?

@joeyouss I experienced the issue first, then decided to upgrade and migrate but the issue persisted

One-to-many, so some records have relations yet.

somebody made a similar issue https://github.com/appwrite/appwrite/issues/5558

hmm, this is not the intended behaviour

I'll look into this

and get back to you with more details

Error when deleting document containing relations

Thanks a lot

did you recreate the collection and the related collection?

@Steven I have had to delete all the collections and recreate them

Glad it's resolved.

Did you edit the relationship after it was created?