Jump to:
| Project: | Content Access |
| Version: | 6.x-1.1 |
| Component: | Code |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
Hello
I use
Drupal 6.12
content access 6.x-1.1
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 = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) in /home/puech/drupal-6/sites/all/modules/views/includes/view.inc on line 759.
Then if I disable content access module this sql warning disappears and there is only the normal warning:
* Username field is required.
* Password field is required.
thank
Comments
#1
Did you try using the development snapshot?
#2
No I use : content access 6.x-1.1
It seems nobody else can reproduce this bug... I must made a mistake...
thank.
#3
#4
Automatically closed -- issue fixed for 2 weeks with no activity.
#5
I was having this problem when wrong password was entered. It turned out to be related to a view that created a block on the user login page. Turning off the block on the login page caused the warning message to go away. Not sure why, but it seems to be a views error, possibly when views is trying to remember the most recent settings for a user?