| Project: | Ubercart Contributions |
| Component: | Code |
| Category: | |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
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
