Back

1.4.0 Fatal error: Uncaught Utopia\Database\Exception\Query: Invalid query: Invalid cursor: UID must

  • 0
  • Self Hosted
AidsMcGhee
30 Aug, 2023, 16:18

it did complete this time

TL;DR
Summary: The user encountered a fatal error (1.4.0 Fatal error: Uncaught Utopia\Database\Exception\Query: Invalid query: Invalid cursor: UID must) in their Appwrite instance. They found a solution on a Discord thread and applied it. However, they then encountered another error (Error 500 on functions page) after changing a setting. It is suggested to set the `_APP_DOMAIN` environment variable to the IP address of the server and update the `hosts` file accordingly. The user confirms that they are using a development server and not a domain. They also mention a new error ("router_host_not_found")
Binyamin
30 Aug, 2023, 16:18

I see that the asterisks are part of Appwrite design

Binyamin
30 Aug, 2023, 16:18

After deleting all the rows?

AidsMcGhee
30 Aug, 2023, 16:18

yeah

Binyamin
30 Aug, 2023, 16:19

Interesting I think maybe it had something else other than asterisk, but if it's working then that's okay

AidsMcGhee
30 Aug, 2023, 16:20

i have a new error "router_host_not_found"

Drake
30 Aug, 2023, 16:20

full error please

AidsMcGhee
30 Aug, 2023, 16:21
Drake
30 Aug, 2023, 16:22

are you using a domain to access your appwrite instance?

AidsMcGhee
30 Aug, 2023, 16:22

i am not

AidsMcGhee
30 Aug, 2023, 16:22

this is my dev server

Drake
30 Aug, 2023, 16:22

so localhost or ip address?

AidsMcGhee
30 Aug, 2023, 16:22

ip address

Binyamin
30 Aug, 2023, 16:23

set some domain to _APP_DOMAIN in your .env file Then set that domain in your hosts file

Binyamin
30 Aug, 2023, 16:23

Then access your server using that domain

Drake
30 Aug, 2023, 16:24

or maybe you can set the _APP_DOMAIN env var to your ip address

AidsMcGhee
30 Aug, 2023, 16:24

i did that and it works. now i have error 500 on functions page 😅

AidsMcGhee
30 Aug, 2023, 16:26

what was the old "default" to "_APP_CONNECTIONS_MAX"?

Binyamin
30 Aug, 2023, 16:26

Where you saw this variable?

AidsMcGhee
30 Aug, 2023, 16:27

being spammed in my console during migration. and possibly the error to my functions page

Binyamin
30 Aug, 2023, 16:28

It's pretty new (since 1.3.8)

AidsMcGhee
30 Aug, 2023, 16:29

my admin account is missing scope apparently

AidsMcGhee
30 Aug, 2023, 16:29
TypeScript
[Error] Timestamp: 2023-08-30T16:28:42+00:00
[Error] Method: GET
[Error] URL: /v1/vcs/installations
[Error] Type: Appwrite\Extend\Exception
[Error] Message: myemail@email.com (role: owner) missing scope (none)
[Error] File: /usr/src/code/app/controllers/general.php
[Error] Line: 475
Binyamin
30 Aug, 2023, 16:30

It's the same error as this

Binyamin
30 Aug, 2023, 16:31

Do this solution.

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