Back
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'document
Just installed Appwrite in docker on windows 10. Apprwrite container is crashing:
TypeScript
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'documentSecurity' in 'field list' in @swoole/library/core/Database/PDOStatementProxy.php:44
2024-08-14 16:04:40 Stack trace:
2024-08-14 16:04:40 #0 @swoole/library/core/Database/PDOStatementProxy.php(44): PDOStatement->execute()
2024-08-14 16:04:40 #1 /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/MariaDB.php(846): Swoole\Database\PDOStatementProxy->__call('execute', Array)
2024-08-14 16:04:40 #2 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(3100): Utopia\Database\Adapter\MariaDB->createDocument('_metadata', Object(Utopia\Database\Document))
2024-08-14 16:04:40 #3 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(1022): Utopia\Database\Database->createDocument(Object(Utopia\Database\Document), Object(Utopia\Database\Document))
2024-08-14 16:04:40 #4 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(483): Utopia\Database\Database->Utopia\Database\{closure}()
2024-08-14 16:04:40 #5 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(1022): Utopia\Database\Database->silent(Object(Closure))
2024-08-14 16:04:40 #6 /usr/src/code/app/http.php(151): Utopia\Database\Database->createCollection('schedules', Array, Array)
2024-08-14 16:04:40 #7 [internal function]: {closure}()
2024-08-14 16:04:40 #8 {main}
2024-08-14 16:04:40 thrown in @swoole/library/core/Database/PDOStatementProxy.php on line 44
TL;DR
Fatal error due to unknown column 'documentSecurity' in Appwrite database causing container crash. Can be fixed by adding the missing column 'documentSecurity' to the database. TypeScript
Stack trace:
2024-08-14 16:07:43 #0 @swoole/library/core/Database/PDOStatementProxy.php(44): PDOStatement->execute()
2024-08-14 16:07:43 #1 /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/MariaDB.php(846): Swoole\Database\PDOStatementProxy->__call('execute', Array)
2024-08-14 16:07:43 #2 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(3100): Utopia\Database\Adapter\MariaDB->createDocument('_metadata', Object(Utopia\Database\Document))
2024-08-14 16:07:43 #3 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(1022): Utopia\Database\Database->createDocument(Object(Utopia\Database\Document), Object(Utopia\Database\Document))
2024-08-14 16:07:43 #4 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(483): Utopia\Database\Database->Utopia\Database\{closure}()
2024-08-14 16:07:43 #5 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(1022): Utopia\Database\Database->silent(Object(Closure))
2024-08-14 16:07:43 #6 /usr/src/code/app/http.php(151): Utopia\Database\Database->createCollection('schedules', Array, Array)
2024-08-14 16:07:43 #7 [internal function]: {closure}()
2024-08-14 16:07:43 #8 {main}
2024-08-14 16:07:43 thrown in @swoole/library/core/Database/PDOStatementProxy.php on line 44
