Entity updates fail on webform fields and entities that already exist

@bobby.gry You might need to compare the table scheme for a clean install of the webform module to your current version of the webform module. I can only guess what is out-of-sync.

@bobby.gry Not really, you might be stuck manually exporting the forms and data, reinstalling the module, and reimporting the forms and data.

I think the source of the problem is existing webform nodes migrated from D6/D7 to D8 are conflicting with the Webform 8.x-5.x node module.

I added a requirement that checks for this problem before the Webform node module is installed.

@see #2856599: Unable to install Sub-module Webform Node

If anyone else is migrating from the YAML Form to the Webform module, they should make sure to delete any existing webform nodes.

I migrated YAML forms to Webforms at the start of 2017 and this problem now suddenly pops up for me too. I do not have any webform data from D6 or D7 as the website was build with D8.

What I tried to do was to install a new module with composer. After that I ran drush entup which caused the below problem:

drush entup
The following updates are pending:

node entity type :
  The node.field_form_referenz field needs to be updated.
  The node.field_formular_referenz field needs to be updated.
  The node.webform field needs to be updated.
webform_submission entity type :
  The Webform submission entity type needs to be updated.
Do you wish to run all pending updates? (y/n): y
Drupal\Core\Entity\Exception\FieldStorageDefinitionUpdateForbiddenException: The SQL storage cannot change the schema for an existing field (field_form_referenz in node entity) with data. in       [error]
Drupal\Core\Entity\Sql\SqlContentEntityStorageSchema->updateDedicatedTableSchema() (line 1285 of
/var/www/website/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorageSchema.php).
Failed: Drupal\Core\Entity\Exception\FieldStorageDefinitionUpdateForbiddenException: !message in Drupal\Core\Entity\Sql\SqlContentEntityStorageSchema->updateDedicatedTableSchema() (line 1285 of [error]
/var/www/website/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorageSchema.php).
Cache rebuild complete.                                                                                                                                                                              [ok]
Finished performing updates.

I was able to solve my problem with:
composer update drupal/webform --with-dependencies

The classic drush entup command was failing to fix the "Mismatched entity and/or field definitions" error for me. #12 fixed one of my errors. After that I could run drush entup to fix the rest of them. After updating webform the 3rd party libraries were out of date, so I needed to run drush webform-libraries-download. Looking good now.

Hmmm... I am not using composer to test my update hooks.

@criscom Why would composer update drupal/webform --with-dependencies fix the issue.

What is --with-dependencies doing? I thought the webform module does not have any dependencies because 3rd party libraries are handled outside of the webform/composer.json file.

Since the last update to Webform, done through the Drupal UI, I've been getting this error:

ENTITY/FIELD DEFINITIONS Mismatched entity and/or field definitions
The following changes were detected in the entity type and field definitions.
Content - The node.webform field needs to be updated.

I have not upgraded from a previous form; this is a fresh install of Webform last month, on a Drupal installation that only had the default Contact forms previously.

Is there any way to solve this without using Drush or Composer? I am sure it would probably be easier to fix with one or both, but it's just not possible to install them on the site at the moment.

Thanks :)

@jrockowitz I had been assuming that the key was that I updated webform to the latest version, not specifically that I used composer to do the update. However, I have no proof.

@cadew Your case might be a good test. Try this (if you have access to your web root.)

1. Update webform to the latest version through the UI at /admin/modules/update.
2. If the error persists, try the non-drush solution at #24 https://www.drupal.org/node/2601762#comment-10835098.

If that works to clear your error, I'd guess that the error has nothing to do with either Composer or Drush.

@Adrian83, thanks. I am giving this a shot. Webform is up to date according to the status report, so I skipped to Step 2.

Webform 8.x-5.0-beta12
Includes: Webform, Webform Demo: Application/Evaluation System, Webform Examples, Webform Node, Webform Templates, Webform UI

AND IT WORKS after clearing caches.

Thank you!

I know we're not supposed to mess with core, but ....

I am not a PHP expert, but I can't see how a try/catch like that would hurt anything if I kept it in there?

@cadew I'm don't know enough to tell you either way, but if I remember correctly, the advice in that other thread was to remove the code afterwards.

Understood, @Adrian83. Thanks again for that link.

Hi Jacob,

I cannot answer your question. I just tried composer update drupal/webform --with-dependencies and the error went away for me. As far as I can remember, composer either downloaded the same version again or a newer version. After that everything worked fine. I also could not reproduce the problem on any other site where I migrated from YAML forms to webform.

Chris

Marking as fixed since there is not much else that can be added to this ticket.

@jrockowitz in case you have not figure it out by now, the --with-dependencies in composer update drupal/webform --with-dependencies updates the dependencies of drupal/webform. By default if you specify packages to update, composer will not update dependencies of those packages just the package given on the commandline.

I normally run composer update --dry-run to see what will be updated. This way I can see what will be updated if I run composer update without specifying any packages to update.

Frederick

after upgrade webform 8.x-5.0-rc16 to 8.x-5.0-rc18 Unable to edit field component on the existing webform