Zeke(Jafesu)Original post
Rank 3: Container
I am upgrading my selfhosted environment from 1.4.13 to 1.6.2, I got all the containers running, when I run migrate I get
Migrating Collection authenticators:
Failed to update project ("MySpoons") version with error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'appwrite._1_' doesn't exist
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'appwrite._1_' doesn't exist in @swoole/library/core/Database/PDOStatementProxy.php:49
Stack trace:
#0 @swoole/library/core/Database/PDOStatementProxy.php(49): PDOStatement->execute()
#1 /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/MariaDB.php(1926): Swoole\Database\PDOStatementProxy->__call('execute', Array)
#2 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(5952): Utopia\Database\Adapter\MariaDB->count('', Array, NULL)
#3 /usr/src/code/vendor/utopia-php/database/src/Database/Validator/Authorization.php(166): Utopia\Database\Database->Utopia\Database\{closure}()
#4 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(5953): Utopia\Database\Validator\Authorization::skip(Object(Closure))
#5 /usr/src/code/src/Appwrite/Migration/Migration.php(215): Utopia\Database\Database->count(Object(Utopia\Database\Document))
#6 /usr/src/code/src/Appwrite/Migration/Migration.php(180): Appwrite\Migration\Migration->documentsIterator('authenticators')
#7 /usr/src/code/src/Appwrite/Migration/Version/V21.php(43): Appwrite\Migration\Migration->forEachDocument(Array)
#8 /usr/src/code/src/Appwrite/Platform/Tasks/Migrate.php(125): Appwrite\Migration\Version\V21->execute()
#9 /usr/src/code/src/Appwrite/Platform/Tasks/Migrate.php(38): Appwrite\Platform\Tasks\Migrate->action('1.6.2', Object(Utopia\Database\Database), Object(Closure), Object(Utopia\Registry\Registry))
#10 [internal function]: Appwrite\Platform\Tasks\Migrate->Appwrite\Platform\Tasks\{closure}()
#11 {main}
thrown in @swoole/library/core/Database/PDOStatementProxy.php on line 49
Summary
Developers encountering issues updating their self-hosted environment from version 1.4.13 to 1.6.2, are facing a SQL error during migration. The error message indicates a missing table ('appwrite._1_'). The issue may be due to jumping too far without stepping through the upgrade versions. A solution is to downgrade to the immediate previous version before upgrading to 1.6.2 to ensure a smooth transition and resolve the missing table error.