SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'value' at row 1
- 0
- Databases
- Accounts
- General
- Self Hosted
- Users

So I'm not sure what caused this but the only thing I know I did was testing out multiple Sign in with Google - I used my personal account and a disposable Gmail account. Once I was happy with it, I went into the Appwrite console and deleted the disposable account from the list of users under the Auth page.
Now Sentry is reporting this error for me regularly. I've gotten over 1.3k events since last night.
Here's the stack trace from Sentry:
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'value' at row 1: null
#10 /usr/src/code/src/Appwrite/Extend/PDOStatement.php(88): execute
#9 /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/MariaDB.php(607): execute
#8 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(2511): createDocument
#7 /usr/src/code/src/Appwrite/Usage/Calculators/TimeSeries.php(421): createDocument
#6 /usr/src/code/src/Appwrite/Usage/Calculators/TimeSeries.php(503): createOrUpdateMetric
#5 /usr/src/code/src/Appwrite/Usage/Calculators/TimeSeries.php(528): syncFromInfluxDB
#4 /usr/src/code/app/tasks/usage.php(132): collect
#3 /usr/src/code/vendor/utopia-php/cli/src/CLI/Console.php(208): {closure}
#2 /usr/src/code/app/tasks/usage.php(137): loop
#1 /usr/src/code/vendor/utopia-php/cli/src/CLI/CLI.php(233): {closure}
#0 /usr/src/code/app/cli.php(32): run

@Steven Do you have any idea what this could be and how to fix it? I've temporarily ignored these events in Sentry for a day because it was eating up a lot of my usage limits and I'm hoping I could get this sorted out before then.

it could be a bug with the usage. We're rewriting it so best to ignore these for now

Okay thank you. Hopefully it doesn't break anything.

your usage info just might look incorrect

That's fine, I don't look at it that much anyway.

I'm seeing similar errors in sentry. Usage in the dashboard seems to be correct, but high ram usage 🤔
Recommended threads
- Attribute creation stuck at processing f...
Hey Appwrite community! 👋 I'm running into a persistent issue with my self-hosted Appwrite installation (v1.6.1) where programmatically creating attributes fo...
- Could not open input file: /usr/src/code...
I updated my selfhosted instance to `1.6.2` and the new service (`appwrite-task-stats-resources`) failed to start. The only log message I see is: ``` Could not ...
- A feature/Fix request
Whenever I use Appwrite then to see the items of document I've to click "columns" option and select those items that I want to see then if I refresh browser/pa...
