Hi,
I get very - very long SQL error "user warning: You have an error in your SQL syntax ... near 'add AND realm = 'protected_node') OR (gid = 3 AND realm = 'protected_node_owner'' at line 1 query: SELECT COUNT(*) FROM dev_node_access WHERE nid = 0 AND ..." everytime when I'm trying to add a new book or add a page to existing book.
That warning does not appear on any other content-type except the book. Turning PN module on and off switches that warning too.
Is there anything I'm supposed to update/patch before using the Protected-node module on my site?
Thanks in advance,
Michal

Comments

mtolmacs’s picture

mtolmacs commented
Assigned: Unassigned » mtolmacs
Category: bug » support
Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)

Hmmm. Are you using an outdated Devel module? That dev_node_access table seems strange to me. This error message is created by a module where someone creates a synthactically incorrect statement(A hyphen missing after the literal 'and). Judging by the available information for now this is not a bug in protected_node. I turn it to a support request till further info.

Please find out which module installed the table dev_node_access and post back. Maybe we can find out where lies the root of your problem. Thank you for your report.

mblazke’s picture

mblazke commented

Oops, that's mistypo - the "dev_" prefix is my prefix for all Drupal tables inside my MySql database. I didn't notice it when copying the message - SORRY, my fault
So, please read the above warning as " .... SELECT ... FROM node_access ..."

mtolmacs’s picture

mtolmacs commented
Category: support » bug
Status: Postponed (maintainer needs more info) » Active

Then it is a bug with protected_node. Changing back and investigating.

mtolmacs’s picture

mtolmacs commented
Status: Active » Fixed

Please try 5.x-1.1. It will fix the problem you encountered.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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