I have been getting this error since updating from 1.3 to 1.4
Only happens when I click on a taxonomy link. Pretty much crippled my site. Oh my.
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 'DESC, node_title DESC, node_data_field_ceu_decimal_field_ceu_decimal_value DES' at line 1 query: SELECT DISTINCT(node.nid), field_ceus_value, node.title AS node_title, node_data_field_ceu_decimal.field_ceu_decimal_value AS node_data_field_ceu_decimal_field_ceu_decimal_value, node_data_field_image_cache.field_image_cache_fid AS node_data_field_image_cache_field_image_cache_fid, node_data_field_image_cache.field_image_cache_title AS node_data_field_image_cache_field_image_cache_title, node_data_field_image_cache.field_image_cache_alt AS node_data_field_image_cache_field_image_cache_alt, node.changed AS node_changed, uc_products.sell_price AS uc_products_sell_price FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_ceu_decimal node_data_field_ceu_decimal ON node.vid = node_data_field_ceu_decimal.vid LEFT JOIN content_field_image_cache node_data_field_image_cache ON node.vid = node_data_field_image_cache.vid LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid WHERE (node.status = '1') AND (term_node.tid = '26') ORDER BY DESC, node_title DESC, node_data_field_ceu_decimal_field_ceu_decimal_value DESC LIMIT 0, 20 in /var/www/vhosts/prodseminars.net/httpdocs/includes/database.mysql.inc on line 172.
You can see it live here:
http://www.prodseminars.net/category/presenter/heather-bruce



Solved
Hi,
This was solved by a friend of mine:
"i think that what happened was that the taxonomyterm view was trying to sort using a field that no longer exists. I deleted the bad sort entry, and things are showing up again, with out error."
I was using the custom view that Views comes with to sort taxonomy/term.
-Eric