Just upgraded my Appwrite instance from 1.6.1 → 1.7.4 and ran into some issues during the migration process.
What I did:
- Upgraded Appwrite to 1.7.4
- Imported my backup using:
sudo docker-compose exec -T mariadb sh -c 'exec mysql -u"$MYSQL_USER" -p"$MYSQL_PASSWORD"' < ./backups/appwrite-dump-20250820_131433.sql - Ran migration with docker compose exec appwrite migrate
The Error I'm Getting:
sudo docker compose exec appwrite migrate
Starting Data Migration to version 1.7.4
[Error] Timestamp: 2025-08-21T12:24:44+00:00
[Error] Type: PDOException
[Error] Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'appwrite._console_devKeys' doesn't exist
[Error] File: @swoole/library/core/Database/PDOStatementProxy.php
Questions:
Is this a known compatibility issue between these versions?
Should I be running additional setup commands after restoring the database backup?
Any suggestions on how to fix this missing table issue?
Any help would be much appreciated! 🙏
TL;DR
Developers upgraded Appwrite from version 1.6.1 to 1.7.4 and encountered an error during migration mentioning a missing table '_console_devKeys'. This is a compatibility issue between the versions. After restoring the database backup, developers need to run `docker compose exec appwrite migrate`. They can fix the missing table issue by manually creating the 'appwrite._console_devKeys' table in the database.
