After an Appwrite downtime, an error occurs when attempting to add a column (totalOrder) to the database. The error message is:
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'totalOrder'.
This error is misleading because the column totalOrder is not present in the database schema or the table
Summary
Developers experiencing a duplicate column error 'totalOrder' in Appwrite after November 2 update. The error persists despite the column not existing in the database schema or table. This occurred after an Appwrite downtime. Solution: Confirm with Appwrite support if the column was accidentally created during updates and await further instructions.
OG
Web Developer
Dec 3, 2024, 20:37
@Moderator
D5
Dec 3, 2024, 20:37
Please, avoid pinging all moderators
D5
Dec 3, 2024, 20:38
When did this start happening?
D5
Dec 3, 2024, 20:38
You're using appwrite cloud?
D5
Dec 3, 2024, 20:39
Do you can DM me too the collection and database ID so the team can debug the error faster?
OG
Web Developer
Dec 3, 2024, 20:51
Ok
OG
Web Developer
Dec 3, 2024, 20:52
yes im using appwrite cloud and please check dm i have messaged you the database ID and Project ID