Database error when showing a category
Crashtest - April 5, 2007 - 23:30
Hi,
when I try to display only nodes of one category (i.e. http://www.mysite.com/taxonomy/term/60) I get this error message:
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_created_created DESC LIMIT 0, 10' at line 1 query: SELECT DISTINCT(node.nid), node.sticky AS node_sticky, value, node.created AS node_created_created FROM dru_node node LEFT JOIN dru_term_node term_node ON node.nid = term_node.nid WHERE (node.status = '1') AND (term_node.tid = '60') ORDER BY node_sticky DESC, DESC, node_created_created DESC LIMIT 0, 10 in /path/to/httpdocs/includes/database.mysql.inc on line 172.The last thing I did was to update the Fivestar module and to install the "Update Status" module. But I have no idea if there is a connection. I am also not able to tell exactly when this problem appears the first time.
Can you please help me? I've no idea what this error message tells me and how I can get rid of it.
System:
Drupal 5.1 (with this patch: http://drupal.org/node/114822 concerning revisions)
Apache 2.x
MySQL 5.0.30
PHP 5.2.0
thx
I've found the problem.
I've found the problem. Somehow there was an error in the views module. I've rearranged the taxonomy/term entry and now it works again.