Version 1.4.13 - Selfhosted.
i have a collection called "games" that i created a relationship with another collection called "servers" originally it was a one way relation that was many to one, but it would error out with the following error:
appwrite-realtime | Connection open (user: 13)
appwrite | [Error] Timestamp: 2024-12-17T05:21:32+00:00
appwrite | [Error] Method: PATCH
appwrite | [Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
appwrite | [Error] Type: Utopia\Database\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: 3574
I rebooted the appwrite instance and deleted the relation but it has the same issue.
When i created a 2 way many to many it had the same issue as well, but when i made it on the "server" collection it worked.
I tried running a migrate for giggles and that didnt change results either.
TL;DR
Developers are experiencing server relation issues when setting up a one-way relationship between collections "games" and "servers" in Appwrite 1.4.13. Despite attempts to reboot and delete the relation, the error persists. However, changing the relationship to two-way many-to-many or creating it in the "servers" collection works successfully. Running a migration did not resolve the issue.
