Column not found: 1054 Unknown column 'node_field_data.deleted'

Created on 1 November 2023, 8 months ago
Updated 3 November 2023, 8 months ago

Version drupal 9.5
php 8.0
para replicar
Install sheduler luego install trash

He instaldo el modulo de trash por lo que elimino la columna node_field_data"."deleted" en la base de datos a lo que modifico la vista de contenido planificado que hace parte de un modulo scheduler que estaba funcionando bien.

Mensaje: Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Contenido planificado[scheduler_scheduled_content]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node_field_data.deleted' in 'where clause': SELECT COUNT(*) AS "expression" FROM (SELECT 1 AS "expression" FROM "node_field_revision" "node_field_revision" LEFT JOIN "node_field_data" "node_field_data_node_field_revision" ON node_field_revision.nid = node_field_data_node_field_revision.nid AND node_field_data_node_field_revision.langcode = node_field_revision.langcode INNER JOIN "node_revision" "node_revision" ON node_field_revision.vid = node_revision.vid LEFT JOIN "users_field_data" "users_field_data_node_revision" ON node_revision.revision_uid = users_field_data_node_revision.uid LEFT JOIN "node_field_revision" "node_field_revision2" ON node_field_revision.nid = node_field_revision2.nid AND node_field_revision2.vid > node_field_revision.vid WHERE (("node_field_revision2"."nid" IS NULL) AND ("node_field_data"."deleted" IS NULL)) AND (("node_field_revision"."publish_on" IS NOT NULL) OR ("node_field_revision"."unpublish_on" IS NOT NULL))) "subquery"; Array ( ) in main() (line 19 of /var/www/html/web/index.php).

πŸ› Bug report
Status

Closed: duplicate

Version

3.0

Component

Code

Created by

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

Comments & Activities

Production build 0.69.0 2024