Hello

When I send a webform I get a white screen and in dblog I can see this error message. I recently upgraded to 8.x-5.0-rc2.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base.locked' in 'field list': SELECT base.sid AS sid, base.webform_id AS webform_id, base.uuid AS uuid, base.langcode AS langcode, base.serial AS serial, base.token AS token, base.uri AS uri, base.created AS created, base.completed AS completed, base.changed AS changed, base.in_draft AS in_draft, base.current_page AS current_page, base.remote_addr AS remote_addr, base.uid AS uid, base.entity_type AS entity_type, base.entity_id AS entity_id, base.locked AS locked, base.sticky AS sticky, base.notes AS notes FROM {webform_submission} base WHERE base.sid IN (:db_condition_placeholder_0); Array ( [:db_condition_placeholder_0] => 94 ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->getFromStorage()

Any ideas? Thanks
Daniel

CommentFileSizeAuthor
#7 webform-submission-locked-table.png128.01 KBbrentschuddinck
#6 localhost localhost drupal_d8_webform webform_submission phpMyAdmin 4 7 4.png321.71 KBjrockowitz

Comments

kusiwa created an issue. See original summary.

jrockowitz’s picture

jrockowitz commented

Did you run all pending database updates?

The webform_update_8099() update hook must not have executed.

The most immediate fix would be to execute the update hook using the below drush command but there might be other things wrong with your installation if these update hooks are not being executed.

drush php-eval 'module_load_include('install', 'webform'); webform_update_8099())';

jrockowitz’s picture

jrockowitz commented
Status: Active » Postponed (maintainer needs more info)
jrockowitz’s picture

jrockowitz commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)
brentschuddinck’s picture

brentschuddinck commented

I discovered the same problem when updating form an older version of webform 8.x-5.0-beta15+54-dev to 8.x-5.0-rc16. Running database updates stops at webform_update_8099().

webform_update_8099() and webform_update_8100() are referring to the same issue #2888862. So maybe these are two fixes for the same error (but not 100% sure about that)? I've test this by manually skipping webform_update_8099() in webform.install.update.inc and proceeding with webform_update_8100().

Afterwards, all other webform updates were running smoothly without further issues.

I have not had the time to view this in detail, but I think the issue is only applicable when updating from an old version of webform. If someone discovers the same error, in my case, manually skipping webform_update_8099() did the trick.

jrockowitz’s picture

jrockowitz commented
StatusFileSize
new localhost localhost drupal_d8_webform webform_submission phpMyAdmin 4 7 4.png321.71 KB

@brentschuddinck Does your webform submission table have the 'locked' column?


brentschuddinck’s picture

brentschuddinck commented
StatusFileSize
new webform-submission-locked-table.png128.01 KB

@jrockowitz yes

jrockowitz’s picture

jrockowitz commented

So when I re-execute this update hook using the below drush command I am not getting any fatal errors.

drush php-eval 'module_load_include('install', 'webform'); webform_update_8099();';

Does executing the above drush command throw any errors?

I am running Drupal 8.6.x-dev. What version of Drupal are you using?

One guess is another update hook like webform_update_8082() is triggering the error in webform_update_8099().