This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
April 05, 2011 3:25pm
Subscribe [2]#1 / Apr 05, 2011 3:25pm
I’m getting the following error when attempting to delete a custom field…
MySQL ERROR:
Error Number: 1091
Description: Can’t DROP ‘field_id_121’; check that column/key exists
Query: ALTER TABLE exp_weblog_data DROP COLUMN field_id_121
Any insight you can provide is appreciated, and we are using EE 1.6.9.
Thanks!
Scott
#2 / Apr 06, 2011 11:40am
Hi, Scott. Have you checked to see that there really is a field_id_121 field is in the exp_weblog_data table?
What kind of custom field is this?
#3 / Apr 06, 2011 3:10pm
There is not a field_id_121 field in the exp_weblog_data table- it goes from field_id_79 to field_id_175.
This is a custom Weblog field that was created from here:
Site › Admin › Weblog Administration › Field Groups
#4 / Apr 07, 2011 3:58pm
Looks like you have some data corruption then. Do you recall which exp_weblog_fields value is set for that field?
You may need to delete that entry from the exp_weblog_fields table by hand, if there isn’t a corresponding one in exp_weblog_data.
Make backups first, though before attempting any sort of direct database manipulation.
#5 / Apr 07, 2011 4:42pm
Sue, that totally worked- thanks bunches!
#6 / Apr 08, 2011 6:13pm
Yay! Glad that works for you.. Feel free to start a new thread if you have any more questions.