Server Error 500: If you try to set Double field from given default value to Null

db logs doesn't seems would be that helpful

TL;DR

The user encountered a server error (500) when trying to set a Double field from its default value to null. They provided a JSON code snippet and mentioned trying to debug the issue using the network tab and console. They suspected that the browser may be causing the issue. They also mentioned creating the attribute for testing with the default value of 0 and specified the min and max values. They suggested trying to replicate the issue using the Appwrite API and provided a link. The user noticed that the default value changed from 0.0 (double) to 0 (integer) and shared an error message indicating that the default value does not

In these lines

TypeScript

[Error] Method: PATCH
[Error] URL: /v1/databases/:databaseId/collections/:collectionId/attributes/float/:key
[Error] Type: Exception
[Error] Message: Default value 0 does not match given type double
[Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
[Error] Line: 956

yaa, for some reason

should not have happen

That's for sure

So you've created a double with default value as 0 right?

yap

and then tried to change that to null via console

Can you try to change it to 0.0

Instead of 0?

umm, let me try

same error,

TypeScript

[Error] Timestamp: 2023-07-20T13:23:21+00:00
[Error] Method: PATCH
[Error] URL: /v1/databases/:databaseId/collections/:collectionId/attributes/float/:key
[Error] Type: Exception
[Error] Message: Default value 0 does not match given type double
[Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
[Error] Line: 956

You can see here, this is how Appwrite verifying the default value for the type

So some how the value changed to 0 from the double one 0.0

Maybe it worth trying to do so with the Appwrite API https://appwrite.io/docs/server/databases?sdk=nodejs-default#databasesCreateFloatAttribute

And try to put 0.0 there

TypeScript

"document":{"$id":"1_3_testing","key":"testing","databaseInternalId":"1","databaseId":"64b403562105501ffe56","collectionInternalId":"3","collectionId":"64b8c9d71b86ae78319a","type":"double","status":"processing","size":0,"required":false,"signed":true,"default":0,"array":false,"format":"floatRange","formatOptions":{"min":0,"max":1},"filters":[],"options":[],"$collection":"attributes","$createdAt":"2023-07-20T13:23:13.540+00:00","$updatedAt":"2023-07-20T13:23:13.540+00:00","$internalId":"44","min":0,"max":1},

this is the attribute I created for testing

So the default is 0 the integer

I did put, min:0 and max:1

wired it shouldn't as I did pass, 0.0 as defult

I think maybe the browser doing that

let me try to check once more, and have netwrok tab

in console

TypeScript

{"key":"test","required":false,"min":0,"max":1,"default":0,"array":false}

network tab

Yep,

So this will cause the problem

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

Recommended threads

Need support?

Join our Discord

Get premium support