Self HostedDatabases

Error when trying to fetch a document with relationship query

Mar 15, 2024, 14:00

View on Discord

Votes

Replies

Participants

Unknown

Messages

Mr. BakbukiOriginal post

Rank 1: Thread

Mar 15, 2024, 13:23

This code works fine:

JavaScript

const doc = await databases.getDocument("main", "users", account.$id, [
    Query.select(["premium"]),
  ]);

But this code throws an error:

JavaScript

const doc = await databases.getDocument("main", "users", account.$id, [
    Query.select(["premium", "albums"]),
  ]);
``` where "albums" is a relationship attribute

The error:
```json
{
  "code": 500,
  "type": "general_unknown",
  "response": {
    "message": "Server Error",
    "code": 500,
    "type": "general_unknown",
    "version": "1.5.3"
  }
}

And in the logs:

Bash

[Error] Method: GET
[Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
[Error] Type: Utopia\Database\Exception
[Error] Message: Cannot select attributes: albums
[Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
[Error] Line: 5249

Summary

Error occurs when trying to fetch a document with a relationship query including the "albums" attribute. Server throws a 500 error indicating "Cannot select attributes: albums".Relationship query attribute causes server error.

Error when trying to fetch a document with relationship query

Need support?_