How can I fix this database error which resulted from creating a new field in Admin?

Questions and Answers
2

I’m not sure why that might have happened.

Your best bet to get going again is to delete the column from the Strapi metadata.