my site is running on a machine using MySQL 5 (5.0.16, to be exact). it will make heavy use of the event module (i'm still evaluting and testing drupal, working out the problems, etc). however, whenever i enable simple_access (or node_privacy_byrole), i get weird sql query errors whenever i try to view the calendar as an anonymous user. aside from the SQL query error printed at the top of the page, the calendar shows up as empty, even if it has valid entries. once i log in to the site and authenticate, everything works fine. after searching the support forums, i found a detailed thread about this on the node_privacy_byrole issues forum, drupal.org/node/40623.

i just wanted to alert the authors of simple_access that i get the identical errors using simple_access, too. unfortunately, the other thread hasn't been touched in 10 days, and this is a show-stopper issue before my site can go live. i'm still quite new to drupal, so i can't really solve this problem on my own, but i'm hoping someone here can help resolve this. thanks much!

Comments

spalter’s picture

spalter commented

I have the same problem. It's described in other posts too (http://drupal.org/node/46864, http://drupal.org/node/43735, http://drupal.org/node/40623). This problem occures since
I've updated MySql 4 to MySql 5. Looks like some patches are necessary (I hope someone is able
to do this, because a lot of people have this problems... (I'm afraid I can't... I don't understand PHP etc. :-(

dww’s picture

dww
we/he/they
commented
Status: Active » Closed (duplicate)

the bug isn't really in simple access at all. it's a problem with how other modules (namely event, image and taxonomy) are writing their own queries which breaks once db_rewrite_sql() tries to include the node_access stuff from simple_access.

this issue is now duplicate. the real solutions are in:

http://drupal.org/node/49429
http://drupal.org/node/49430
http://drupal.org/node/49433

thanks, and sorry for the false alarm. ;)
-derek