Back
Invalid document structure: Unknown attribute: "pingCount" after running appwrite migrate
I have a production server running Appwrite 1.7.4. I'm testing Appwrite 1.8.0 on a separate test server.
To transfer data from my 1.7.4 installation to 1.8, I followed this guide: https://appwrite.io/blog/post/how-to-back-up-your-appwrite-data
Specifically, I copied over the functions/uploads/builds volumes, and restored the database using the commands in the article. I am using the same .env files as well.
Everything works fine on the 1.8 installation until I run "docker compose exec appwrite migrate". After running the migrate command, I get this error when calling the ping endpoint:
TypeScript
[Error] Method: GET
[Error] URL: /v1/ping
[Error] Type: Utopia\Database\Exception\Structure
[Error] Message: Invalid document structure: Unknown attribute: "pingCount"
[Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
[Error] Line: 4896
And this error when updating the "services" within project settings:
TypeScript
[Error] Method: PATCH
[Error] URL: /v1/projects/:projectId/service
[Error] Type: Utopia\Database\Exception\Structure
[Error] Message: Invalid document structure: Unknown attribute: "pingCount"
[Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
[Error] Line: 4896
Before running appwrite migrate, both work fine.
TL;DR
Developers encounter 'Unknown attribute: "pingCount" error after running Appwrite migrate from version 1.7.4 to 1.8.0. The issue arises due to a database structure mismatch. The solution is to update the database schema to include the new attribute "pingCount" by following the migration guide provided by Appwrite.