Jump to:
| Project: | Views |
| Version: | 6.x-2.7 |
| Component: | Views Data |
| Category: | bug report |
| Priority: | normal |
| Assigned: | honorfield |
| Status: | closed (fixed) |
Issue Summary
Since i experimented with the both modules flag/flagfriends and user relationships i get the following error message in views:
* An illegal choice has been detected. Please contact the site administrator.
* 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 = 62 AND na.realm = 'user_relationship_node_access_1') OR (na.gid = 14 AND na.realm = 'user_relationship_node_access_author'))) LIMIT 0, 10 in /var/www/vhosts/8lions.com.au/httpdocs/sites/default/modules/views/includes/view.inc on line 765.
I have the problem when i open user related views (like the "user relationship" created view for content of related users).
Does anyone have an idea what's happening here?
Comments
#1
Here some more informaion that i got from the log:
Type form
Date Friday, 13 November, 2009 - 16:10
User buiss001
Location http://www.-------------/friends
Referrer
Message Illegal choice blog in type element.
Severity error
Hostname ----------------
Operations
And i also get this error message when creating a new view with user relationships:
Type php
Date Friday, 13 November, 2009 - 16:10
User buiss001
Location http://www.--------------/friends
Referrer
Message 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 = 62 AND na.realm = 'user_relationship_node_access_1') OR (na.gid = 14 AND na.realm = 'user_relationship_node_access_author'))) LIMIT 0, 10 in /var/www/vhosts/--------.com.au/httpdocs/sites/default/modules/views/includes/view.inc on line 765.
Severity error
Hostname ----------------
Operations
#2
If this error occurs only while using a module that utilizes Views, this bug should be filed against that module first.
Also, there is not nearly enough detail here. You don't state what you're doing when the error happens, nor export a view. Very little can be done with this amount of information.
#3
Ok,
what i do is i go to "panels" and enable the "user profile template".
In the "user profile template" i go to: content --> add content --> views-->user_relationships_content.
I choose "default", "no context" for user relationships, and finish.
When i go now to view the panel page i get the error message:
"Error message: An illegal choice has been detected. Please contact the site administrator."
I checked the same thing on two different Drupal installations with the same result.
Thanks for helping me, i really appreciate it!
honorfield
#4
Hey there,
i was working the last two days on this issue and couldn't figure it out. I'm not a coder and still quite new to Drupal. But to me it seems like a bug. . .
I would really appreciate any help with that as it slows the development of my page down a lot.
Regards
honorfield
#5
update
#6
NO NO NO NO NO i didn't mean to click that
#7
comment #2 suggests that you post an export of the view to show what might be causing the issue
#8
Not enough information.