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

jnvsor’s picture

There is a patch, but don't you think you should include this in the core download?

merlinofchaos’s picture

Status: Active » Closed (won't fix)

This will not be fixed in Views 1.