Hello there! Im currently experiencing issues with the not so long ago officially announced upserting funcionality. Im running appwrite 1.7.4 self hosted and node-appwrite 17.2.0 on nextjs15. Everytime i want to use the upserting function, im getting the 500 general_unknown error. This happens if neither document exists or not. Even with a dummy table and dummy data it wont work (code below)
export async function testUpsert() {
try {
const { databases } = await createSessionClient();
await databases.upsertDocument(APPWRITE_DATABASE, "test", "test-id", {
test: "test",
});
return { success: true, message: "test_complete" };
} catch (error: any) {
return { success: false, message: error.code.toString() };
}
}
And that's the console output from the backend container, when upsert the test document
[Error] Timestamp: 2025-09-12T10:06:01+00:00
[Error] Method: PUT
[Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
[Error] Type: TypeError
[Error] Message: array_unique(): Argument #1 ($array) must be of type array, null given
[Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Document.php
[Error] Line: 85
Creating and updating data, via their designated functions works fine tough. Ive seen another thread where someone experiencied this issue, but he was using the cloud saas version of appwrite.
Is this issue about to be fixed and maybe released soon?
Would be nice if someone knows, if im making something wrong or if this issue is about to be fixed in the near future.
Thanks a lot in advance!
I believe upsert was only added in v1.8.
Hmm okay, i thought it maybe would be in 1.7.4, as upsert is in the 17.2.0 sdk
Unfortunately not. You need to wait for the 1.8.0 release or use cloud for now 😅
Well i have a workaround so, i probably just wait, but thank you all!
Quick question regarding upserting only working in 1.8.x. The documentation says it works with 1.7.x, so what information is actually valid? 😅
Recommended threads
- Clean install of 1.9.0 shows errors in a...
I just run a full clean install of Appwrite on my server following the Manual installation guide in the docs page. The console seems to work, visually there d...
- Setup custom domain on selfhosted behind...
Hello everyone, can anyone help me to setup a custom domain on a selfhosted appwrite instance thats running behind cloudflare tunnels? Current setup: Appwrite r...
- Why does this happen?
`AppwriteException: general_argument_invalid, Invalid `secret` param: Value must be a valid string and at least 1 chars and no longer than 256 chars (400)` the...