Auth broken after update from 1.8.0 to 1.9.0 (selfhosted)

So ive been having issues creating, deleting or updating users on my appwrite instance after i updated from 1.8.0 to version 1.9.0. When trying to create a user via the sdk, rest api and dashboard ive gotten this error which basically drove me insane yesterday.

Neither user deletion, creation or updates work on the dashboard, api and sdk.

{
  message: 'Server Error',
  code: 500,
  type: 'general_unknown',
  version: '1.9.0'
}```

so i looked into the logs from the docker container and saw this error occurring every time i attempt to make a user for any of my projects.

──────────────────────────────────────────────────────────── [0] /usr/src/code/app/controllers/api/users.php : 173 -> createDocument() [1] /usr/src/code/app/controllers/api/users.php : 262 -> createUser() [2] /usr/src/code/vendor/utopia-php/framework/src/Http/Http.php : 677 -> {closure:/usr/src/code/app/controllers/api/users.php:259}() [3] /usr/src/code/vendor/utopia-php/framework/src/Http/Http.php : 976 -> execute() [4] /usr/src/code/vendor/utopia-php/framework/src/Http/Http.php : 857 -> runInternal() [5] /usr/src/code/app/http.php : 551 -> run() [6] [internal function] : -> {closure:/usr/src/code/app/http.php:513}() http.request · 282.5ms · 2a16248e

http.method POST http.path /v1/users http.response.code 500 level error

Utopia\Database\Exception\Structure: Invalid document structure: Unknown attribute: "emailCanonical" at /usr/src/code/vendor/utopia-php/database/src/Database/Database.php:5583 at /usr/src/code/app/controllers/api/users.php:173 at /usr/src/code/app/controllers/api/users.php:262 at /usr/src/code/vendor/utopia-php/framework/src/Http/Http.php:677 ... 4 more

──────────────────────────────────────────────────────────── ```