Skip to content

Deleting fieldsets with dividers or info fields #244

@thekanbo

Description

@thekanbo

Describe the issue

When trying to delete a fieldset- either on its own or while deleting a form, matrix or taxonomy- the delete process will fail when trying to delete detach it from whatever model it is on.

"SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'field_5'; check that column/key exists (SQL: alter table `form_contact_us` drop `full_name`, drop `email`, drop `state`, drop `country_of_residence`, drop `field_5`, drop `party_info`, drop `number_of_guests`, drop `pinata_options`, drop `balloon_colors`, drop `cake_size`, drop `wishlist`)"

In the above case, field_5 is a divider fieldtype, so it does not have a column on the form_ table. party_info is an information fieldtype, and the same error will occur if the divider is removed from the fieldset. The delete operation will only succeed if both of those fieldtypes are removed from the fieldset first.

To reproduce

Create a fieldset that includes a Divider or Information fieldtype. Attach that fieldset to a matrix. Attempt to delete the matrix or the fieldtype.

Expected behavior

The fieldset should delete and successfully detach from the model.

Bug report checklist

  • I have filled out as much information as I can
  • I have detailed how the issue can be reproduced
  • I have searched for existing issues and to the best of my knowledge this is not a duplicate

Metadata

Metadata

Assignees

Labels

BugSomething isn't working

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions