I was using wix code to update a field in a database. The code had a typo in the field key definition. The correct key was currentMemberTerm however the code defined the new data for the field to be updated to currentMmemberTerm (NOTE the double letter "Mm").
When viewing live site in "Wix Dashboard/Content Manager", you could see the new field with the Error annotation where popup tells you to go into Editor and define the field and republish the site. Also, there is no way to delete a field in the Live database.
The problem is, when you go into the editor for that database the new field does Not exist. If you try to follow the directions provided by going into Wix Editor to define the field you do NOT see the associated field in manage fields, hence no way to delete it.
Here is the solution:
1. From the Wix Dashboard/Content Manger, select the database and do an Export to save the data in case something goes wrong.
2. Go into Wix Editor / Databases and select the database
3. Change the view from "Sandbox" to "Live"
4. Click "Zero Out Sandbox and Replace With Live"
Then change view back to "Sandbox" and now you can see the field.
1. "Define the Field"... ( I set it as a Text field and the Error Goes Away)
2. select "Properties" of the Field
3. select "Move to Trash"
4. Then "Sync Sandbox To Live"
5. Publish the website.
Go into "Wix Dashboard/Content Manager" and you will see that the bad field is gone.
OF COURSE THIS COULD ALL HAVE BEEN AVOIDED BY TESTING IN SANDBOX FIRST!
