Thread

We recently moved to a new host and we accidentally left the ALTER permissions off the db.

I found out because when I created a new custom field, it gave me an error but then seemingly created the new custom field anyway. Now when I try and delete the custom field, I get this error:

MySQL ERROR:
Error Number: 1091
Description: Can’t DROP ‘field_id_115’; check that column/key exists
Query: ALTER TABLE exp_weblog_data DROP COLUMN field_id_115

How can we delete this field from the database? I assume we’ll need to go into phpmyadmin, but I’m not exactly sure what I need to delete.

Currently I cannot update any posts that contain this custom field bc it doesn’t actually seem to exist.

Thanks,
John

Hi, John. First things first. Make a backup copy of your exp_weblog_data table. Then inside of PHPMyAdmin do a

DESC exp_weblog_data

Is there a field_id_115? What about a field_ft_115?

Hi Sue, I made a backup and then went into phpmyadmin and did the following:

DELETE FROM `my***db`.`exp_weblog_fields` WHERE `exp_weblog_fields`.`field_id` = 115

That appears to have gotten everything back to normal. I guess part of the field was created when ALTER wasn’t turned on, and that’s why EE was having trouble deleting it; bc it only existed in the exp_weblog_fields and not in the exp_weblog_data table.

By deleting the exp_weblog_fields entry 115 that appears to have worked. The field is now gone from my Custom Fields area and I can update entries again without any issues.

Thanks for your help.

-John

I am very glad to see Sue was able to help. Please post again as needed.