[CLOSED] (Bugged) Query.select = 500 general unknown error

I get in sentry this error: Can not select attributes: $createdAt

TL;DR

Title: [CLOSED] Query.select = 500 general unknown error Discussion: - The user encountered a bug with the Query.select function, which resulted in a general unknown error (Error 500). - The user found a GitHub issue related to the bug and discovered that it will be fixed in the next version of Appwrite. - The user asked if creating an index for the 'createdAt' attribute might help, but it was unclear if an index was necessary. - Other users confirmed experiencing the same error with different attributes and received a 'Numeric value out of range' error as well. - The user also shared a related error

And this one too: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'value' at row 1

Tied with other attributes and same error

Same on my side, error 500.

(With appwrite 1.3.8 self-hosted)

did you create an index for createdAt 😅

Is it needed an index for that? 👀

maybe, I'm not sure lol

give it a try i guess

Yes, will try

Take a look here https://github.com/appwrite/appwrite/issues/5376 It seems like it will be added in the next version https://github.com/utopia-php/database/pull/299/files

Not using relationships

Yes I think that part is not in relationships only

I'm trying to perform this in a standard document and throws the mentioned error

You can see here https://github.com/utopia-php/database/pull/299/files that the $createdAt was always added Till the change on the right in which it checks each field

Giving you the ability to select them

Then why I get such error?

Oh, so you mean it's bugged for now until this pr is merged (new Appwrite version released)?

Yep

https://github.com/appwrite/appwrite/milestone/16

56% completed... I'm anxious to see that 100%

Edit: now 58, some good progress Edit 2: 70% this is fassst

[BUGGED] Query.select = 500 general unknown error

Uh, maybe closed is better or what?

I went over the code again,

[CLOSED] (Bugged) Query.select = 500 general unknown error

I think that's better