SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node_revision__publish_date.nid' in 'where clause'

Created on 24 April 2017, over 7 years ago
Updated 5 September 2024, 3 months ago

Scheduled updates are not firing on cron, I have the following patches against 8.x-1.0-alpha6

      "drupal/scheduled_updates": {
        "Show the entities being updated in the list builder - https://www.drupal.org/node/2698143": "https://www.drupal.org/files/issues/update-title.patch",
        "Register DrupalConsole commands as services - https://www.drupal.org/node/2840235#comment-11852907": "https://www.drupal.org/files/issues/register_drupalconsole-2840235-5.patch",
        "Cron Updates not run by User #1 - https://www.drupal.org/node/2793489#comment-12016637": "https://www.drupal.org/files/issues/cron-updates-2793489-6.patch",
        "Not setting current revision after changing moderation state - https://www.drupal.org/node/2820827#comment-11745903": "https://www.drupal.org/files/issues/setCurrentRevision-2820827-3.patch",
        "Add configure link - https://www.drupal.org/node/2864708#comment-12010546": "https://www.drupal.org/files/issues/scheduled_updates-configure_attribute-2864708-2-8x.patch",
        "The embedded update runner does not pick up all updates - https://www.drupal.org/node/2820944#comment-11741128": "https://www.drupal.org/files/issues/update_runner_not_picking_all_updates-2820944-2.patch"
      },

The following message is logged when cron fires:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node_revision__publish_date.nid' in 'where clause': SELECT base_table.vid AS vid, base_table.nid AS nid FROM {node_revision} base_table INNER JOIN {node_revision__publish_date} node_revision__publish_date ON node_revision__publish_date.revision_id = base_table.vid WHERE (node_revision__publish_date.publish_date_target_id IN (:db_condition_placeholder_0)) AND ( EXISTS (SELECT na.nid AS nid FROM {node_access} na WHERE (( (gid IN (:db_condition_placeholder_1)) AND (realm = :db_condition_placeholder_2) )OR( (gid IN (:db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7)) AND (realm = :db_condition_placeholder_8) )OR( (gid IN (:db_condition_placeholder_9, :db_condition_placeholder_10, :db_condition_placeholder_11, :db_condition_placeholder_12, :db_condition_placeholder_13)) AND (realm = :db_condition_placeholder_14) )OR( (gid IN (:db_condition_placeholder_15, :db_condition_placeholder_16, :db_condition_placeholder_17, :db_condition_placeholder_18, :db_condition_placeholder_19)) AND (realm = :db_condition_placeholder_20) )OR( (gid IN (:db_condition_placeholder_21, :db_condition_placeholder_22, :db_condition_placeholder_23, :db_condition_placeholder_24, :db_condition_placeholder_25)) AND (realm = :db_condition_placeholder_26) )OR( (gid IN (:db_condition_placeholder_27, :db_condition_placeholder_28, :db_condition_placeholder_29, :db_condition_placeholder_30, :db_condition_placeholder_31)) AND (realm = :db_condition_placeholder_32) )OR( (gid IN (:db_condition_placeholder_33, :db_condition_placeholder_34, :db_condition_placeholder_35, :db_condition_placeholder_36, :db_condition_placeholder_37)) AND (realm = :db_condition_placeholder_38) )OR( (gid IN (:db_condition_placeholder_39, :db_condition_placeholder_40, :db_condition_placeholder_41, :db_condition_placeholder_42, :db_condition_placeholder_43)) AND (realm = :db_condition_placeholder_44) )OR( (gid IN (:db_condition_placeholder_45, :db_condition_placeholder_46, :db_condition_placeholder_47, :db_condition_placeholder_48, :db_condition_placeholder_49)) AND (realm = :db_condition_placeholder_50) )OR( (gid IN (:db_condition_placeholder_51, :db_condition_placeholder_52, :db_condition_placeholder_53, :db_condition_placeholder_54, :db_condition_placeholder_55)) AND (realm = :db_condition_placeholder_56) ))AND (na.grant_view >= :db_condition_placeholder_57) AND (node_revision__publish_date.nid = na.nid) )); Array ( [:db_condition_placeholder_0] => 31 [:db_condition_placeholder_1] => 0 [:db_condition_placeholder_2] => all [:db_condition_placeholder_3] => 1 [:db_condition_placeholder_4] => 6 [:db_condition_placeholder_5] => 26 [:db_condition_placeholder_6] => 31 [:db_condition_placeholder_7] => 36 [:db_condition_placeholder_8] => gnode:blog [:db_condition_placeholder_9] => 1 [:db_condition_placeholder_10] => 6 [:db_condition_placeholder_11] => 26 [:db_condition_placeholder_12] => 31 [:db_condition_placeholder_13] => 36 [:db_condition_placeholder_14] => gnode:blog_landing [:db_condition_placeholder_15] => 1 [:db_condition_placeholder_16] => 6 [:db_condition_placeholder_17] => 26 [:db_condition_placeholder_18] => 31 [:db_condition_placeholder_19] => 36 [:db_condition_placeholder_20] => gnode:consultation [:db_condition_placeholder_21] => 1 [:db_condition_placeholder_22] => 6 [:db_condition_placeholder_23] => 26 [:db_condition_placeholder_24] => 31 [:db_condition_placeholder_25] => 36 [:db_condition_placeholder_26] => gnode:event [:db_condition_placeholder_27] => 1 [:db_condition_placeholder_28] => 6 [:db_condition_placeholder_29] => 26 [:db_condition_placeholder_30] => 31 [:db_condition_placeholder_31] => 36 [:db_condition_placeholder_32] => gnode:news [:db_condition_placeholder_33] => 1 [:db_condition_placeholder_34] => 6 [:db_condition_placeholder_35] => 26 [:db_condition_placeholder_36] => 31 [:db_condition_placeholder_37] => 36 [:db_condition_placeholder_38] => gnode:news_listing [:db_condition_placeholder_39] => 1 [:db_condition_placeholder_40] => 6 [:db_condition_placeholder_41] => 26 [:db_condition_placeholder_42] => 31 [:db_condition_placeholder_43] => 36 [:db_condition_placeholder_44] => gnode:page [:db_condition_placeholder_45] => 1 [:db_condition_placeholder_46] => 6 [:db_condition_placeholder_47] => 26 [:db_condition_placeholder_48] => 31 [:db_condition_placeholder_49] => 36 [:db_condition_placeholder_50] => gnode:venue [:db_condition_placeholder_51] => 1 [:db_condition_placeholder_52] => 6 [:db_condition_placeholder_53] => 26 [:db_condition_placeholder_54] => 31 [:db_condition_placeholder_55] => 36 [:db_condition_placeholder_56] => gnode:venue_listing [:db_condition_placeholder_57] => 1 ) in Drupal\scheduled_updates\Plugin\UpdateRunner\LatestRevisionUpdateRunner->getEntityIdsReferencingReadyUpdates() (line 55 of /var/beetbox/docroot/modules/contrib/scheduled_updates/src/Plugin/UpdateRunner/LatestRevisionUpdateRunner.php).

After adding the the line to skip access checks I get the following error running cron:
Fatal error: Call to a member function getRevisionId() on null in /var/beetbox/docroot/modules/contrib/scheduled_updates/src/Plugin/UpdateRunner/LatestRevisionUpdateRunner.php on line 72

$latest_revision = $this->updateUtils->getLatestRevision($this->updateEntityType(), $entity_id);

πŸ› Bug report
Status

Needs work

Version

1.0

Component

Code

Created by

πŸ‡¦πŸ‡ΊAustralia realityloop

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

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024