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
- local (self-hosted) sites issues
setup: - `composer run installer:dev` issues - Getting error when visiting the site ```Synchronous function execution timed out. Use asynchronous execution in...
- education plan not activated
Hi I have an edu id 13103046@iubat.edu but when I am trying to claim my plan and trying to logging with github where education student plan active. the appwrite...
- I'm getting an error on the console "j?....
On my self hosted instance version 1.8.1 the console is giving me this error when trying to view the rows for a table I recently created. My application is read...