When attempting to view a book as a non-administrator user, whether given permission to view the book or not, I get the following:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'nid' in where clause is ambiguous: SELECT DISTINCT node.title AS title FROM {node} node INNER JOIN {node_access} na ON na.nid = node.nid WHERE (nid = :db_condition_placeholder_0) AND(( (na.gid = :db_condition_placeholder_1) AND (na.realm = :db_condition_placeholder_2) )OR( (na.gid = :db_condition_placeholder_3) AND (na.realm = :db_condition_placeholder_4) )OR( (na.gid = :db_condition_placeholder_5) AND (na.realm = :db_condition_placeholder_6) )OR( (na.gid = :db_condition_placeholder_7) AND (na.realm = :db_condition_placeholder_8) )OR( (na.gid = :db_condition_placeholder_9) AND (na.realm = :db_condition_placeholder_10) )OR( (na.gid = :db_condition_placeholder_11) AND (na.realm = :db_condition_placeholder_12) )OR( (na.gid = :db_condition_placeholder_13) AND (na.realm = :db_condition_placeholder_14) ))AND (na.grant_view >= :db_condition_placeholder_15) ; Array ( [:db_condition_placeholder_0] => 2 [:db_condition_placeholder_1] => 0 [:db_condition_placeholder_2] => all [:db_condition_placeholder_3] => 6 [:db_condition_placeholder_4] => book_access_author [:db_condition_placeholder_5] => 2 [:db_condition_placeholder_6] => book_access_role [:db_condition_placeholder_7] => 4 [:db_condition_placeholder_8] => book_access_role [:db_condition_placeholder_9] => 6 [:db_condition_placeholder_10] => book_access_user [:db_condition_placeholder_11] => 2 [:db_condition_placeholder_12] => forum_access [:db_condition_placeholder_13] => 4 [:db_condition_placeholder_14] => forum_access [:db_condition_placeholder_15] => 1 ) in book_block_view() (line 287 of /home/scarlet/public_html/mutedwings/modules/book/book.module).

Comments

ScarletJay’s picture

Priority: Major » Normal

Actually... this seems to be a problem with the core book module, not the book access module. I've re-posted the issue in the core modules area.

strellman’s picture

Status: Active » Needs review

See http://drupal.org/node/1013864
Until fixed try removing book navigation block.

rovo’s picture

Applying this patch to the core book module fixed it for me:

http://drupal.org/files/issues/book_63.patch

Anonymous’s picture

Status: Needs review » Closed (duplicate)

This is a problem with Drupal core code. See #766382: Column 'nid' is ambiguous when using node access modules.