I created a new content type with two custom fields. Created one entry of this type. Then attempted to delete one of the fields, and got the following error message:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'honyaku7.field_data_' doesn't exist: UPDATE {field_data_} SET deleted=:db_update_placeholder_0 WHERE (bundle = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => 1 [:db_condition_placeholder_0] => ) in field_sql_storage_field_storage_delete_instance() (line 618 of /home/adamrice/8stars.org/h7/modules/field/modules/field_sql_storage/field_sql_storage.module).

The field no longer appears in the list of existing fields, but attempting to create a new field of the same name results in an error complaining that the field already exists.

Comments

sivaji_ganesh_jojodae’s picture

sivaji_ganesh_jojodae commented

Looks like this is fixed. Now it works like a charm for me.

mgifford’s picture

mgifford
he/him
Primary language English
commented
Status: Active » Closed (fixed)

agreed. added a custom field type and then deleted it. No errors were displayed.

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Priority: Normal » Critical
Status: Closed (fixed) » Active

Seeing this behavior again. Looks like the field instance records are never actually deleted, just marked as such.

catch’s picture

catch
he/him
Primary language English
commented

iirc this is by design - deleted field records are purged in batches so it's likely the instance itself sticks around until that happens, leaving critical though, I think bjaspan is most familiar with this.

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Status: Active » Closed (fixed)

JohnAlbin tells me this was corrected (again) after alpha3, and he could not replicate on HEAD.