Closed (won't fix)
Project:
Views (for Drupal 7)
Version:
5.x-1.6
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
20 Jul 2008 at 20:24 UTC
Updated:
25 Sep 2009 at 17:48 UTC
I get this error when searching for ceartain titles with an exposed filter, I think it started after I aded a "sticky" decending sort criteria...
Don't have a clue...
* 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 'node'attlefield%'))' at line 1 query: SELECT count( DISTINCT(node.nid)) FROM node node LEFT JOIN content_field_nog_niet_af node_data_field_nog_niet_af ON node.vid = node_data_field_nog_niet_af.vid WHERE (node.type IN ('grp')) AND (node.status = '1') AND ((node_data_field_nog_niet_af.field_nog_niet_af_value NOT IN ('1') OR node_data_field_nog_niet_af.field_nog_niet_af_value IS NULL)) AND (UPPER(node.title) LIKE UPPER(''node'attlefield%')) in /var/accounts/CN20081633/www/includes/database.mysql.inc on line 172.
* 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 'node'attlefield%')) ORDER BY node_sticky DESC, node_created_created DESC LIMIT ' at line 1 query: SELECT DISTINCT(node.nid), node.sticky AS node_sticky, node.created AS node_created_created, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN content_field_nog_niet_af node_data_field_nog_niet_af ON node.vid = node_data_field_nog_niet_af.vid WHERE (node.type IN ('grp')) AND (node.status = '1') AND ((node_data_field_nog_niet_af.field_nog_niet_af_value NOT IN ('1') OR node_data_field_nog_niet_af.field_nog_niet_af_value IS NULL)) AND (UPPER(node.title) LIKE UPPER(''node'attlefield%')) ORDER BY node_sticky DESC, node_created_created DESC LIMIT 0, 10 in /var/accounts/CN20081633/www/includes/database.mysql.inc on line 172.
* 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 'node'attlefield%')) ORDER BY node_sticky DESC, node_created_created DESC LIMIT ' at line 1 query: SELECT DISTINCT(node.nid), node.sticky AS node_sticky, node.created AS node_created_created, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN content_field_nog_niet_af node_data_field_nog_niet_af ON node.vid = node_data_field_nog_niet_af.vid WHERE (node.type IN ('grp')) AND (node.status = '1') AND ((node_data_field_nog_niet_af.field_nog_niet_af_value NOT IN ('1') OR node_data_field_nog_niet_af.field_nog_niet_af_value IS NULL)) AND (UPPER(node.title) LIKE UPPER(''node'attlefield%')) ORDER BY node_sticky DESC, node_created_created DESC LIMIT 0, 3 in /var/accounts/CN20081633/www/includes/database.mysql.inc on line 172.
Comments
Comment #1
jnvsor commentedThere is a patch, but don't you think you should include this in the core download?
Comment #2
merlinofchaos commentedThis will not be fixed in Views 1.