i have created appwrite selfhost on digital ocean and installed mariadb in different droplet and changed environment variable . it works and i did signup in appwrite console but , after creating organization , server error comes . after doing error logs in appwrite droplet console this error comes , how to fix this .
[Error] Timestamp: 2025-02-02T10:55:09+00:00
[Error] Method: GET
[Error] URL: /v1/projects
[Error] Type: PDOException
[Error] Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'appwrite_db._console_projects' doesn't exist
[Error] File: @swoole/library/core/Database/PDOStatementProxy.php
[Error] Line: 49
TL;DR
Developers installed Appwrite selfhost on Digital Ocean and MariaDB on a separate droplet, but encountered a server error when trying to create an organization. The console logs showed a PDOException stating that the table '_console_projects' doesn't exist in the 'appwrite_db' database. The solution is to ensure the necessary database tables are created or migrated correctly to fix this issue.
