Closed (fixed)
Project:
Drupal core
Version:
5.9
Component:
database system
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
11 Oct 2008 at 19:39 UTC
Updated:
25 Oct 2008 at 19:53 UTC
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 'ASC LIMIT 0, 10' at line 1 query: SELECT node.nid, timestamp, node.title AS node_title, node.changed AS node_changed FROM node node WHERE (node.status = '0') ORDER BY ASC LIMIT 0, 10 in J:\wamp\www\askdan\includes\database.mysqli.inc on line 156.
Comments
Comment #1
dave reidInteresting...there's no order by field...
Comment #2
sparkguitar05 commentedI figured it out. In one of my views, I had something set to "order by comment creation time" when it was really supposed to be "order by node creation time". Then I deleted the comment module because I never wanted comments on my site in the first place.
Comment #3
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.