Projects unusable after update to 1.9.9

Hi,

In order to fix yesterdays php issues I had to update a 1.7.4 Server to 1.9.9.
I went through all migrations where needed.

Everything worked up to 1.9.8.

This morning i wanted to update to 1.9.9, but now I lost access to all the projects.

When I click on a project in console i get the following error:
´´´...
appwrite | http.request · 185.5ms · a8716673
appwrite |
appwrite | level error
appwrite | http.method GET
appwrite | http.path /v1/project
appwrite | http.response.code 500
appwrite |
appwrite | Utopia\Database\Exception\Structure: Invalid document structure: Unknown attribute: "pingCount"
...```

Endusers also cannot login into the Apps:

appwrite                            |   level              error
appwrite                            |   http.method        POST
appwrite                            |   http.path          /v1/account/sessions/email
appwrite                            |   http.response.code 500
appwrite                            |
appwrite                            |   Utopia\Database\Exception\Structure: Invalid document structure: Missing required attribute "$createdAt"
appwrite                            |     at /usr/src/code/vendor/utopia-php/database/src/Database/Database.php:6346
...```

Can someone help me get this running again?

I've not been successful in upgrading my production environment from 1.7.4 to anything higher because of similar errors. I've always ended up rolling back to 1.7.4. Even a successful deployment left CPU flatlining at 100%, and the database never recovered.

Tbf, this database was originally deployed when Appwrite was still 0.13, and I think a lot of legacy stuff hasn't translated well through the various migrations, despite following each migration path correctly.

I compromised and deployed 2.3.0, and wrote a migration tool to move all my collections and data over using REST and the official SDKs to the clean 2.3.0 installation. I'm still testing but when I'm happy, I'll cut-over to the latest version.

Depending on your deployment, you might want to consider a similar path.

@Cord @Matthias Merk the error shared here doesnt seem related to particular 1.9.9 release but a failed migration somewhere along the way. Re-running the 1.8.0 migration on 1.9.9 should repair the pingCount problem

Thanks for getting Back to me! Fixed it in the meantine by adding the attributes.

just wanted to check on the server again now, I'm unable to login to the web console...

appwrite | http.request · 204.5ms · c64b827c
appwrite |
appwrite | level error
appwrite | http.method POST
appwrite | http.path /v1/account/sessions/email
appwrite | http.response.code 500
appwrite |
appwrite | Utopia\Database\Exception\Structure: Invalid document structure: Missing required attribute "$createdAt"
appwrite | at /usr/src/code/vendor/utopia-php/database/src/Database/Database.php:6346
appwrite | at /usr/src/code/vendor/utopia-php/database/src/Database/Adapter.php:432
appwrite | at /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/Pool.php:169
appwrite | at /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php:229
appwrite | ... 12 more

seems like some kind of failed migration somewhere, u can try this sql command or a fresh install

Yes, had a NULL there and put some value instead of it, running again! Thank You!