Back

Error when deleting document containing relations

  • 0
  • Databases
hosiekiwanuka
20 Jun, 2023, 05:53

Trying to delete document, getting server error 500

TL;DR
User is experiencing an error when trying to delete a document containing relations. There is a possible solution mentioned of deleting and recreating the collections, but the user states that it is not ideal in this case. Relations are still in beta and not fully perfected. No clear cause of the error is identified.
safwan
20 Jun, 2023, 06:53

Are you using relations?

hosiekiwanuka
20 Jun, 2023, 10:00

@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

hosiekiwanuka
20 Jun, 2023, 10:28

Not sure what the cause is

safwan
20 Jun, 2023, 10:31

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

hosiekiwanuka
20 Jun, 2023, 10:36

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

Binyamin
20 Jun, 2023, 12:59

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

joeyouss
20 Jun, 2023, 13:10

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?

hosiekiwanuka
20 Jun, 2023, 13:16

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

hosiekiwanuka
20 Jun, 2023, 13:18

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

joeyouss
20 Jun, 2023, 13:19
joeyouss
20 Jun, 2023, 13:20

hmm, this is not the intended behaviour

joeyouss
20 Jun, 2023, 13:20

I'll look into this

joeyouss
20 Jun, 2023, 13:21

and get back to you with more details

joeyouss
20 Jun, 2023, 13:22

Error when deleting document containing relations

hosiekiwanuka
20 Jun, 2023, 13:22

Thanks a lot

Drake
20 Jun, 2023, 14:46

did you recreate the collection and the related collection?

hosiekiwanuka
20 Jun, 2023, 14:54

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

Drake
20 Jun, 2023, 15:48

Glad it's resolved.

Did you edit the relationship after it was created?

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more