Problem/Motivation

ResponseText: The website encountered an unexpected error. Please try again later.Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'gid' cannot be null: 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), (:db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31); Array
(
[:db_insert_placeholder_0] => 8
[:db_insert_placeholder_1] => fr
[:db_insert_placeholder_2] => 1
[:db_insert_placeholder_3] => domain_unpublished
[:db_insert_placeholder_4] => 111111
[:db_insert_placeholder_5] => 1
[:db_insert_placeholder_6] => 1
[:db_insert_placeholder_7] => 1
[:db_insert_placeholder_8] => 8
[:db_insert_placeholder_9] => fr
[:db_insert_placeholder_10] => 1
[:db_insert_placeholder_11] => view_unpublished_content
[:db_insert_placeholder_12] => 1
[:db_insert_placeholder_13] => 1
[:db_insert_placeholder_14] => 0
[:db_insert_placeholder_15] => 0
[:db_insert_placeholder_16] => 8
[:db_insert_placeholder_17] => fr
[:db_insert_placeholder_18] => 1
[:db_insert_placeholder_19] => view_unpublished_AAAAA
[:db_insert_placeholder_20] => 1
[:db_insert_placeholder_21] => 1
[:db_insert_placeholder_22] => 0
[:db_insert_placeholder_23] => 0
[:db_insert_placeholder_24] => 8
[:db_insert_placeholder_25] => fr
[:db_insert_placeholder_26] => 1
[:db_insert_placeholder_27] => view_unpublished_author
[:db_insert_placeholder_28] => 
[:db_insert_placeholder_29] => 1
[:db_insert_placeholder_30] => 0
[:db_insert_placeholder_31] => 0
)

Issue fork view_unpublished-3485023

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

About issue forks

Comments

vhin0210 created an issue. See original summary.

vhin0210 opened merge request !17

vhin0210’s picture

vhin0210 commented
Status: Active » Needs review
tobiasb’s picture

tobiasb
Primary language German
Location Berlin
commented
Issue summary: View changes
Status: Needs review » Postponed (maintainer needs more info)
tobiasb’s picture

tobiasb
Primary language German
Location Berlin
commented

Something other must be broken.

vhin0210’s picture

vhin0210 commented

My theory is that some author/users were deleted and that makes the node owner to be null (anonymous) ?

tobiasb’s picture

tobiasb
Primary language German
Location Berlin
commented

anonymous (0) has is also valid owner. When you open Node 8 you should see owner.

❯ ddev drush php
Psy Shell v0.12.4 (PHP 8.1.30 — cli) by Justin Hileman
OpenCulturas (Drupal 10.3.6)
> \Drupal\node\Entity\Node::load(100)->getOwnerId();
= "0"
vhin0210’s picture

vhin0210 commented

Interesting. I don't know exactly what happened but it's something similar to this
https://www.drupal.org/project/unpublished_node_permissions/issues/3427115

tobiasb’s picture

tobiasb
Primary language German
Location Berlin
commented
Related issues: +#3427115: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'gid' cannot be null: INSERT INTO "node_access"
tobiasb’s picture

tobiasb
Primary language German
Location Berlin
commented
Status: Postponed (maintainer needs more info) » Needs work

Let's just do it. MR needs a rebase.

dhruv.mittal’s picture

dhruv.mittal commented
Assigned: Unassigned » dhruv.mittal

Working on it

vhin0210’s picture

vhin0210 commented

Done rebasing the MR

tobiasb’s picture

tobiasb
Primary language German
Location Berlin
commented
Assigned: dhruv.mittal » tobiasb

  • tobiasb committed feb959bc on do-3485023 
    fix: #3485023 Rebuild permission failing

  • tobiasb committed e9dd4a6a on do-3485023 
    fix: #3485023 Rebuild permission failing

  • tobiasb committed 866201c9 on do-3485023 
    fix: #3485023 Rebuild permission failing

  • tobiasb committed 162f7685 on do-3485023 
    fix: #3485023 Rebuild permission failing

  • tobiasb committed 162f7685 on 2.0.x 
    fix: #3485023 Rebuild permission failing
tobiasb’s picture

tobiasb
Primary language German
Location Berlin
commented
Assigned: tobiasb » Unassigned
Status: Needs work » Fixed

I choose a different way to prevent the SQL error.

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.