Back
Getting Message: Invalid value for relationship
TypeScript
appwrite | [Error] File: /usr/src/code/app/controllers/api/databases.php
appwrite | [Error] Line: 848
appwrite | [Error] Timestamp: 2023-07-30T15:08:07+00:00
appwrite | [Error] Method: GET
appwrite | [Error] URL: /v1/databases/:databaseId/collections/:collectionId
appwrite | [Error] Type: Appwrite\Extend\Exception
appwrite | [Error] Message: Collection with the requested ID could not be found.
appwrite | [Error] File: /usr/src/code/app/controllers/api/databases.php
appwrite | [Error] Line: 848
appwrite | [Error] Timestamp: 2023-07-30T15:13:55+00:00
appwrite | [Error] Method: PATCH
appwrite | [Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
appwrite | [Error] Type: Exception
appwrite | [Error] Message: Invalid value for relationship
appwrite | [Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
appwrite | [Error] Line: 3110
appwrite | [Error] Timestamp: 2023-07-30T15:14:15+00:00
appwrite | [Error] Method: PATCH
appwrite | [Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
appwrite | [Error] Type: Exception
appwrite | [Error] Message: Invalid value for relationship
appwrite | [Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
appwrite | [Error] Line: 3110
appwrite | [Error] Timestamp: 2023-07-30T15:14:33+00:00
appwrite | [Error] Method: PATCH
appwrite | [Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
appwrite | [Error] Type: Exception
appwrite | [Error] Message: Invalid value for relationship
appwrite | [Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
appwrite | [Error] Line: 3110
While trying to update the enum via console getting this error...
TL;DR
Issue: User is getting an "Invalid value for relationship" error while trying to update a collection in Appwrite. The error occurred after deleting documents in the collection that had relationships with other collections.
Solution: It seems that deleting documents with relationships caused the issue. To fix it, the user should check the database and make sure there are no documents with invalid relationship values. If there are, the user should update or remove those documents to resolve the error. Additionally, it is advised to avoid deleting documents that are referenced by other documents to prevent this error from occurring in the future. also, server error while trying to update the document
for this video this is the below log
TypeScript
appwrite | [Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
appwrite | [Error] Line: 3110
appwrite | [Error] Timestamp: 2023-07-30T15:20:00+00:00
appwrite | [Error] Method: PATCH
appwrite | [Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
appwrite | [Error] Type: Exception
appwrite | [Error] Message: Invalid value for relationship
appwrite | [Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
appwrite | [Error] Line: 3110
appwrite | [Error] Timestamp: 2023-07-30T15:20:24+00:00
appwrite | [Error] Method: PATCH
appwrite | [Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
appwrite | [Error] Type: Exception
appwrite | [Error] Message: Invalid value for relationship
appwrite | [Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
appwrite | [Error] Line: 3110
appwrite | [Error] Timestamp: 2023-07-30T15:21:06+00:00
appwrite | [Error] Method: DELETE
appwrite | [Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
appwrite | [Error] Type: Appwrite\Extend\Exception
appwrite | [Error] Message: Document cannot be deleted because it is referenced by another document.
appwrite | [Error] File: /usr/src/code/app/controllers/api/databases.php
appwrite | [Error] Line: 3542
appwrite | [Error] Timestamp: 2023-07-30T15:21:17+00:00
appwrite | [Error] Method: PATCH
appwrite | [Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
appwrite | [Error] Type: Exception
appwrite | [Error] Message: Invalid value for relationship
appwrite | [Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
appwrite | [Error] Line: 3110
What version of Appwrite?
1.3.7
Hmm I thought this wasn't a problem anywhere...
Would you please provide reproducible steps?
I had the same issue (v1.3.7) . It seems like this: I have setup collection A with relationships to 2 other collections with "Restrict - document can not be deleted"
Then we deleted documents in collection A (we were new, didn't know what we were doing) and then we started getting errors like:
TypeScript
appwrite | [Error] Timestamp: 2023-11-06T19:59:31+00:00
appwrite | [Error] Type: Utopia\Exception
appwrite | [Error] Message: Not Found
appwrite | [Error] File: /usr/src/code/vendor/utopia-php/framework/src/App.php
appwrite | [Error] Line: 803
and now we are hit with this when we try to update collection A:
TypeScript
appwrite | [Error] Type: Exception
appwrite | [Error] Message: Invalid value for relationship
appwrite | [Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
appwrite | [Error] Line: 3090
