Contrib.social

Error with psql

Open on Drupal.org →
Created on 16 November 2023, 7 months ago
Updated 19 January 2024, 5 months ago

Problem/Motivation

Running cron I get the following error using PGSQL:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type smallint: "NULL" LINE 5: ...) AND ("cmsfr"."revision_translation_affected" <> 'NULL') AN... ^: SELECT "nr"."vid" AS "vid" FROM "node_revision" "nr" INNER JOIN "content_moderation_state_field_revision" "cmsfr" ON nr.nid = cmsfr.content_entity_id and nr.vid = cmsfr.content_entity_revision_id WHERE ("nr"."nid" = :db_condition_placeholder_0) AND ("nr"."vid" < :db_condition_placeholder_1) AND ("cmsfr"."langcode" = :db_condition_placeholder_2) AND ("cmsfr"."revision_translation_affected" <> :db_condition_placeholder_3) AND ("cmsfr"."moderation_state" IN (:db_condition_placeholder_4)) ORDER BY "nr"."vid" DESC NULLS LAST LIMIT 9223372036854775807 OFFSET 0; Array ( [:db_condition_placeholder_0] => 14 [:db_condition_placeholder_1] => 339999 [:db_condition_placeholder_2] => en [:db_condition_placeholder_3] => NULL [:db_condition_placeholder_4] => published ) in cm_revision_delete_get_revisions() (line 212 of /var/www/html/dv24.openplus.ca/html/modules/contrib/cm_revision_delete/cm_revision_delete.module).

🐛 Bug report
Status

Fixed

Version

1.1

Component

Code

Created by

🇨🇦Canada smulvih2 Canada 🍁

Live updates comments and jobs are added and updated live.
  • PostgreSQL

    Particularly affects sites running on the PostgreSQL database.

Sign in to follow issues

Comments & Activities

contrib.social Blog FAQ Discussions
Production build 0.69.0 2024