Error when rebuilding node access permissions

Created on 15 March 2022, over 2 years ago
Updated 3 April 2024, 8 months ago

I am getting a PHP error whose message is very similar to the one on this issue: https://www.drupal.org/project/content_access/issues/2971094 β†’

But it is a different php file.

When I run Rebuild Node Access permissions (or edit/save a node with access permissions set) I get this error:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `node_access`.`gid` at row 3: INSERT INTO "node_access" ("nid", "langcode", "fallback", "realm", "gid", "grant_view", "grant_update", "grant_delete") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7), (:db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15), (:db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23); Array ( [:db_insert_placeholder_0] => 338 [:db_insert_placeholder_1] => en [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => content_access_roles [:db_insert_placeholder_4] => 5 [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 0 [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => 338 [:db_insert_placeholder_9] => en [:db_insert_placeholder_10] => 1 [:db_insert_placeholder_11] => content_access_roles [:db_insert_placeholder_12] => 4 [:db_insert_placeholder_13] => 1 [:db_insert_placeholder_14] => 0 [:db_insert_placeholder_15] => 0 [:db_insert_placeholder_16] => 338 [:db_insert_placeholder_17] => en [:db_insert_placeholder_18] => 1 [:db_insert_placeholder_19] => content_access_roles [:db_insert_placeholder_20] => [:db_insert_placeholder_21] => 1 [:db_insert_placeholder_22] => 1 [:db_insert_placeholder_23] => 1 ) in Drupal\node\NodeGrantDatabaseStorage->write() (line 242 of /web/core/modules/node/src/NodeGrantDatabaseStorage.php).

I am running Drupal 9.3.6 and the latest dev version of Content Access.

Any help would be appreciated, especially as I am not a developer.

πŸ› Bug report
Status

Needs work

Version

2.0

Component

Code

Created by

πŸ‡ΈπŸ‡ͺSweden edward.peters

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