Dave Cohen wrote:
On Thursday 26 July 2007 10:48, Ron Parker wrote: [snip]
So, my question is: Why is this hook_db_rewrite_sql code in a custom module creating a circumstance where views no longer work as user #1 when the same code does NOT create this problem when replacing the node_db_rewrite_sql function in the node.module?
Sounds like the node.module code is granting access, where your code is not. Look for enties with realm 'all' in the node_access table.
Actually, it was the exact opposite: My new code was granting access. I resolved it by adding code that exempts user #1 (or any user with "administer nodes" permission).
I'm ThisClose to making this all work after several months of banging my head against the wall, so any suggestions are much appreciated. Thanks!
My suggestions are: 1) Install devel module and enable the query log. Look at the exact SQL that is the result of all the rewriting. And 2) Enable devel_node_access and see what it has to say. And of course 3) debug your problem.
I did install devel module. Thanks for the suggestion.
I'm also going to reiterate what Moshe said earlier. Think long and hard before implementing your own hook_db_rewrite_sql. The grant hooks can do quite a lot for you. Sounds like you may know what you're doing - I don't mean to imply that you don't.
Again, you are right. I actually used the hook_node_access_records() in another module to create the exact permission grants I needed for private access to work without hook_db_rewrite_sql(). Problem here is I've not though through a way to grant permissions that take into account OG, TAC and Content Access (CA) access control. I can assure you I take everything you suggest as an effort to help, and apprecite it as such. Using the node access API is a much better way to go, no question about it. I just have not figured out how to do it as efficiently or effectively as I have with hook_nodeapi and hook_db_rewrite_sql. Thanks for all the help! -ron
-Dave
__________ NOD32 2424 (20070726) Information __________
This message was checked by NOD32 antivirus system. http://www.eset.com
-- Ron Parker Software Creations http://www.scbbs.com Self-Administration Web Site http://saw.scbbs.com SDSS Subscription Mgmt Service http://sdss.scbbs.com Central Ave Dance Ensemble http://www.centralavedance.com R & B Salsa http://www.randbsalsa.com