Drupal Questions & Answers

Ask and answer Drupal related questions! No question too simple or complex!
honorfield's picture
Asked by on Thu 12th Nov 2009
Error message: An illegal choice has been detected.

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/——-.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?

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

Commenting on this Drupal Question is closed.