After upgrade from Craft 3 a form content column was dropped

gglnx commented 2 months ago

Describe the bug

After upgrade my Craft 3 installation to Craft 4 one of my form content columns with content will be dropped while migration:

*** applying m221206_000000_fix_syncs
> drop column field_young_beitrag from table {{%fmc_foerdermitgliedschaft}} ... done (time: 0.004s)
    > Dropped column field_young_beitrag in {{%fmc_foerdermitgliedschaft}}.

I can not change the field handle, because it's used in an integration.

Steps to reproduce

Create a form with a field with young_beitrag (without suffix) in a Craft 3 installation
Try to upgrade

Form settings

Multi-page form: Yes
Submission Method: Page Reload
Client-side Validation: No
Custom Form Templates: Yes

Craft CMS version

4.8.9

Plugin version

2.1.10

Multi-site?

Yes

Additional context

No response

engram-design commented 2 months ago

This would from the sync fixing migration where we try and determine the content column for the field. Having an underscore in the field handle and no suffix (this field probably was created on an older Craft 3 install) means that it's tricky to figure out of beitrag is part of the field handle or just the suffix. Sometimes even on newer Craft 3 installs, the suffix is missing.

Fixed for the next release. To get this early, run composer require verbb/formie:"dev-craft-4 as 2.1.10".

engram-design commented 2 months ago

Fixed in 2.1.11

verbb / formie