Skip to content
Back

Upsert with setting permissions

  • 0
  • 2
  • Self Hosted
  • Databases
whataboutno13
9 Feb, 2026, 13:54

Hi there, I am using self-hosted appwrite v1.7.4 and trying to use the bulk update stuff that was released with 1.7.x. Unfortunally I found that there is an server error (500) thrown, if i try to set $permissions to each document. Is it possible to set permissions with upsert?

TL;DR
Depends on permissions; recommending updating to v1.8.x for upsert support. Ensure backups, update to 1.7.5 first. Issue may be fixed in future versions.
10 Feb, 2026, 08:43

Depends on what the permissions are being set to. Also are you doing it server side with an API key or client side?

10 Feb, 2026, 09:54

I'm doing it server side and try to set Teams and Teamrole permissions. But why is there a difference depending on what the permissions are being set to?

10 Feb, 2026, 09:55

I also read in another post, that upsert is only supported from v1.8.x and thats very confusing tbh

10 Feb, 2026, 10:36

Then I recommend updating. Make sure to make backups before of the database and the entire instance. Also that they work. You should first update and migrate to 1.7.5

10 Feb, 2026, 10:41

But why? When you guys drop a feature in version X and then say its only working in version Y it really doesnt create a level of trust

10 Feb, 2026, 10:42

I also found, that it only sometimes fails with permissions being set. So whats the official rule here? The documentation does not help with anything regarding this

10 Feb, 2026, 10:47

Except if you're setting it server sided and with proper API key permissions, I'm not sure what could be the issue. Maybe it has been fixed in future versions, that's why I recommend updating

10 Feb, 2026, 10:56

Does the following error message help finding the problem?

10 Feb, 2026, 11:05

Looks like a bug. Probably solved in future versions

10 Feb, 2026, 14:19

Thats very disapointing tbh. We try to run appwrite in a stable version and really looked forward to updates on batches and transactions. But features being announced and then fixed in the next major version is not very promising.

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