Error message: An illegal choice has been detected. Please contact the site administrator. [#631640]

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

Comment #1

honorfield commented 13 November 2009 at 05:44

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

Comment #2

merlinofchaos commented 13 November 2009 at 18:46

Status:

Active

» Postponed (maintainer needs more info)

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.

Comment #3

honorfield commented 14 November 2009 at 08:55

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

Comment #4

honorfield commented 17 November 2009 at 05:05

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