appwrite: 🐛 Bug Report: Appwrite dumps when creating metadata table after fresh install

👟 Reproduction steps

Use appwrite/install to create a compose file. Start it, Look at the logs for the appwrite container.

👍 Expected behavior

Start up and let me be happy about my freshly installed appwrite stack.

👎 Actual Behavior

No Start up and no one is happy about a freshly install appwrite stack.

Log: Worker 1 started successfully [Setup] - Server database init started… [Setup] - Creating metadata table: appwrite…

Fatal error: Uncaught PDOException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DISTINCT _permission)

                FROM `appwrite`.`_console__metadata_pe' at line 4 in @swoole-src/library/core/Database/PDOStatementProxy.php:64

Stack trace: #0 /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/MariaDB.php(372): Swoole\Database\PDOStatementProxy->__call(‘execute’, Array) #1 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(772): Utopia\Database\Adapter\MariaDB->getDocument(‘_metadata’, ‘audit’) #2 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(379): Utopia\Database\Database->getDocument(Object(Utopia\Database\Document), ‘audit’) #3 /usr/src/code/app/http.php(104): Utopia\Database\Database->getCollection(‘audit’)

} thrown in @swoole-src/library/core/Database/PDOStatementProxy.php on line 64

[2022-04-14 09:25:29 #1.2] ERROR php_swoole_server_rshutdown() (ERRNO 503): Fatal error: Uncaught PDOException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DISTINCT _permission)

                FROM `appwrite`.`_console__metadata_pe' at line 4 in @swoole-src/library/core/Database/PDOStatementProxy.php:64

Stack trace: #0 /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/MariaDB.php(372): Swoole\Database\PDOStatementProxy->__call(‘execute’, Array) #1 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(772): Utopia\Database\Adapter\MariaDB->getDocument(‘_metadata’, ‘audit’) #2 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(379): Utopia\Database\Database->getDocument(Object(Utopia\Database\Document), ‘audit’) #3 /usr/src/code/app/http.php(104): Utopia\Database\Database->getCollection(‘audit’) }

thrown in @swoole-src/library/core/Database/PDOStatementProxy.php on line 64

🎲 Appwrite version

Version 0.13.x

💻 Operating system

Linux

🧱 Your Environment

No, just a minimal debian 11 installation.

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn’t find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct