I've enabled per node settings - and now I'm unable to update existing nodes - I'm getting:

PDOException: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block: SELECT settings FROM {content_access} WHERE nid = :nid; Array ( [:nid] => 3 ) in content_access_get_per_node_settings() (line 434 of /srv/www/sitename/htdocs/sites/all/modules/content_access/content_access.module).

Database looks pretty empty:

select * from content_access;
nid | settings
-----+----------
(0 rows)

Any hints welcome ;)

Comments

jduhls’s picture

jduhls commented

Did you ever resolve this? I currently can't edit my content. Checking and unchecking multiple content access settings to try and resolve...no luck yet even if I grant full permissions to even anon users.

UPDATE: The nodes I was having trouble with were aliased as "user/content/[node:nid]". I changed the alias to "content/[node:nid]" and I could edit the node again. So something to do with having the node under "user/*" perhaps?

gisle’s picture

gisle
he/him
Primary language Norwegian Bokmål
Location Norway
commented
Version: 7.x-1.2-beta1 » 7.x-1.x-dev
Issue summary: View changes
Status: Active » Closed (outdated)

This issue has not received any updates in the previous 8 years. If you believe it to still be relevant, you are encouraged to reopen the issue and update it.

If you got an email about this Issue status update, it is because you at one time (possibly a very long time ago), subscribed to it. To learn how to unsubscribe yourself, please visit: https://www.drupal.org/project/webmasters/issues/3142987