Manually removed fields from DB

[Peter Knight]

Duplicated an existing site hoping to save some time on the general setup and Modules install.

Time to remove a lot of previous fields. Clicking a field name and visitng the Delete tab was getting boring. I thought I'd manually remove the rows from the database and hit refresh.

The fields are still showing within the Fields page/tab when I thought they would have been force removed.

Now when I try to manually select a field and browse to the Delete tab, the delete checkbox is greyed out.

This field may not be deleted because it is in use by one or more templates.

Which is not true of course.

Interestingly, if you remove a template from the database and then visit the templates page (under Setup), the Templates are succesfully removed.

Realising that field removal isn't supposed to be carried out in this way. :-/

[teppo]

Realising that field removal isn't supposed to be carried out in this way. :-/

True

Anyway, you haven't specified where you deleted these fields from; since they're referenced (at least) in tables "fields" and "fieldgroups_fields", in addition to having their own database tables ("field_fieldname"), you'll want to make sure that there's no leftover data anywhere.

[kongondo]

This is why we have the API...it can do all the heavy lifting...cleanly

[Peter Knight]

Anyway, you haven't specified where you deleted these fields from; since they're referenced (at least) in tables "fields" and "fieldgroups_fields", in addition to having their own database tables ("field_fieldname"), you'll want to make sure that there's no leftover data anywhere.

I just deleted the tables in the root of the databse where the name matched a field I wanted to zap.

Good to know there are other places.