Hello
I use
Drupal 6.12
Nodeaccess 6.x-1.3
Views 6.x-2.6

Are you able to reproduce this bug ?
Try to login without username nor password. My Drupal give me this warning:
* Username field is required.
* Password field is required.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((n' at line 1 query: INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'nodeaccess_rid') OR (na.gid = 0 AND na.realm = 'nodeaccess_uid') OR (na.gid = 0 AND na.realm = 'nodeaccess_author'))) in /home/puech/drupal-6/sites/all/modules/views/includes/view.inc on line 759.

Then if I disable Nodeaccess module this sql warning disappears and there is only the normal warning:
* Username field is required.
* Password field is required.

thank

Comments

vlad.pavlovic’s picture

vlad.pavlovic commented
Issue summary: View changes
Status: Active » Closed (won't fix)

This is an issue with core. node_access table doesn't belong to Nodeaccess module (nodeaccess is the table name used by this module). Chances are good that this issue has already been repaired either in core or in Views, especially considering the age of the issue.