Back
problem with some tables (cant read rows)
I have a weird problem with some tables - they wont show the rows (in console it is stuck loading). I checked in mariadb directly and the collection can be read correctly. also the columns are shown correctly. I tried to delete one column (which worked) - then restored a backup, but the column still isnt shown. when I add the column again I get Column with the requested key x already exists.
appwrite doctor gives me (external mariadb, not in docker): 🔴 Console.DB.(console)...........................disconnected 🔴 Projects.DB.(database_db_main).................disconnected
TL;DR
Issue: Some tables not displaying rows in console, stuck loading. Columns and data can be read in MariaDB directly. Tried deleting and adding columns, but issue persists. Appwrite doctor reports disconnected status for console and database.
Solution: Disconnect and reconnect the console and database connections in Appwrite settings. Restart the server if the issue persists.