SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'gid' cannot be null: INSERT INTO "node_access"

Problem/Motivation

When updating the module to the latest version available, and launching the drush updb command, for some strange reason I am having this error.

After some digging, I realized that the unpublished_node_permissions_node_access_records function is calling Node's getOwnerId() function to obtain the user ID of the specific node, but there may be cases where it can come as NULL, such as you can see in the images.

Proposed resolution

As a solution, I propose to use NULL coalesce, so that in the event that a NULL value (unsupported value) comes, assign a default value.