Download & Extend

SQL Warning on login with content access

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

Category:bug report» support request
Status:active» fixed

#4

Status:fixed» closed (fixed)

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?

nobody click here