Attempt to update field failed: field_sql_storage cannot change the schema for an existing field with data. [#2005918]

After using the same setup of collection field for another language (on another D7 installation), it seems impossible to translate the field, nor by the translation UI, nor by overwriting the label in another language.

When trying to save the updated label (domain.com/admin/structure/field-collections/field-ingredients/fields/field_myfield), I'm getting the following notice:

Attempt to update field MyField failed: field_sql_storage cannot change the schema for an existing field with data.

I've tried this patch to no avail. How can I solve this?

Comment	File	Size	Author
#1	Afbeelding 2.png	160.64 KB	knalstaaf

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

knalstaaf CreditAttribution: knalstaaf commented 29 May 2013 at 07:52

File	Size
Screen (Navicat Lite)	160.64 KB

I solved this by doing the following:

I opened the database and went for the table named "field_config_instance",
There I looked in the column "field_name" for the field that causes the trouble,
I edited the BLOB so it would show the desired label name.

Regarding saving special characters in MySQL BLOB files

E.g.: s:x -> the "x" should be the amount of characters that are used in the name of (in this case) the label. But when using a special character (like é), you should add one extra. Each special character equals 2. So for "Qualité", for instance, this would be: s:9:"Quantité"; - eventhough that word only counts 8 characters for the naked eye.