Self Hosted

relationships are very unstable

Dec 27, 2023, 16:58

View on Discord

Votes

Replies

Participants

Unknown

Messages

rohanOriginal post

Rank 4: Virtual Machine

Nov 12, 2023, 16:26

Hi,
im encountering a number of problems especially while deleting the documents..
it keeps throwing server error

appwrite logs

[Error] Timestamp: 2023-11-12T16:24:46+00:00
[Error] Method: DELETE
[Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
[Error] Type: PDOException
[Error] Message: Unknown column 'castType' in 'field list'
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 62

Summary

The user is experiencing issues with deleting documents in a web SDK. They have provided a link to a GitHub issue where the problem is discussed. The user has three collections with nested relationships, and when trying to delete documents, it throws a server error with the message "Unknown column 'castType' in 'field list'." Solution: The user has reported the issue on GitHub and should wait for a response from the developers.

Eldad

Nov 12, 2023, 16:28

@Jake Can you please take a look here?

Nov 12, 2023, 21:49

Do you know what's the relationship that failed or are you able to replicate the issue by following some steps?

Drake

Nov 12, 2023, 22:03

Details including the attributes and what data there is would also help

rohan

Rank 4: Virtual Machine

Nov 13, 2023, 07:12

i have created a demo project in my appwrite cloud

rohan

Rank 4: Virtual Machine

Nov 13, 2023, 07:12

can you access that and check it?

rohan

Rank 4: Virtual Machine

Nov 13, 2023, 07:13

basically when there are nested relations the delete is not working

rohan

Rank 4: Virtual Machine

Nov 13, 2023, 07:16

basically i have three collections

demo 3 is two way one to many relationship with demo 2
demo 2 is two way many to many relationship with demo 1

Nov 13, 2023, 08:35

Do you have set delete behaviour?

rohan

Rank 4: Virtual Machine

Nov 13, 2023, 08:35

Yes its NULL

Drake

Nov 13, 2023, 16:18

no we cannot

Drake

Nov 13, 2023, 16:19

and what exact steps are you taking? please, be detailed so we can reproduce

rohan

Rank 4: Virtual Machine

Nov 13, 2023, 17:17

@Steven its just this and create documents in all three collections

rohan

Rank 4: Virtual Machine

Nov 13, 2023, 17:18

and try to delete a document from the demo3 collection

Drake

Nov 13, 2023, 18:14

I added your problem here: https://github.com/appwrite/appwrite/issues/5850#issuecomment-1808737829

rohan

Rank 4: Virtual Machine

Nov 13, 2023, 18:17

but when i try to delete it form the web sdk it works...

Drake

Nov 13, 2023, 18:49

in my tests, it depends on what's set for the documents and which document you're deleting first

relationships are very unstable

Need support?_