Submissions results not accessible

Created on 29 March 2024, about 1 year ago
Updated 8 April 2024, about 1 year ago

Problem/Motivation

When I try to access the results page of a webform, I get an error and can't access the page. If I look in the recent logs I get this error:

Drupal\Core\Database\DatabaseExceptionWrapper : SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.entity_type' in 'field list': SELECT COUNT(*) AS "expression" FROM (SELECT DISTINCT "s"."entity_type" AS "entity_type", "s"."entity_id" AS "entity_id", 1 AS "expression" FROM "webform_submission" "s" WHERE ("webform_id" = :db_condition_placeholder_0) AND ("entity_type" <> :db_condition_placeholder_1) AND ("entity_type" IS NOT NULL) AND ("entity_id" <> :db_condition_placeholder_2) AND ("entity_id" IS NOT NULL)) "subquery"; Array ( [:db_condition_placeholder_0] => report_update [:db_condition_placeholder_1] => [:db_condition_placeholder_2] => ) dans Drupal\webform\WebformSubmissionStorage->getSourceEntitiesTotal() (ligne 334 de C:\wamp64\www\_Projects\Schaerbeek\schaerbeek-1030-php\web\modules\contrib\webform\src\WebformSubmissionStorage.php).

Steps to reproduce

I simply installed the module, in the database I don't have "entity_type nor "entity_id" in the webform_submission table. Whatever the webform, if I go to build -> results, the error occurs (/admin/structure/webform/manage/report_update/results/submissions).

πŸ› Bug report
Status

Closed: cannot reproduce

Version

6.2

Component

User interface

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024