Back
Duplicate Column Error in Appwrite After November 2 Update
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
TL;DR
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.@Moderator
Please, avoid pinging all moderators
When did this start happening?
You're using appwrite cloud?
Do you can DM me too the collection and database ID so the team can debug the error faster?
Ok
yes im using appwrite cloud and please check dm i have messaged you the database ID and Project ID
