There may certainly be something going on with db_rewrite_sql(), so you'll probably have to find out what the actual query is when it gets sent to mysql. Stepping into db_query() is a great way to do this.
-Randy On Thu, Apr 8, 2010 at 11:20 AM, Aaron Winborn <[email protected]>wrote: > Can you post your Drupal query? Hard to troubleshoot w/o the original > code. > > > nan wich wrote: > > I have the following query, which works fine in PhpMyAdmin, but Drupal > upchucks on it. Why? > > SELECT nc.nid, n.title, n.created, nc.daycount AS views_today, > nc.totalcount AS total_views, > (SELECT COUNT(*) FROM comments c WHERE c.timestamp >= 1270699200 AND > c.nid=nc.nid) AS comments_today, > cs.comment_count > FROM node_counter nc > INNER JOIN node n ON n.nid=nc.nid > LEFT JOIN node_comment_statistics cs ON cs.nid=nc.nid > WHERE nc.daycount > 0 > ORDER BY nc.daycount DESC > > Yes, in Drupal, I do put the brackets around the table names. > > The error message says there's a problem at " AS > comments_today, cs.comment_count FROM...". > > > *Nancy E. Wichmann, PMP* > > Sometimes the questions are complicated and the answers are simple. - Dr. > Suess > > > > -- > Aaron Winborn > > Advomatic, LLChttp://advomatic.com/ > > Drupal Multimedia available in > September!http://www.packtpub.com/create-multimedia-website-with-drupal/book > > My blog:http://aaronwinborn.com/ > > -- Randy Fay Drupal Development, troubleshooting, and debugging [email protected] +1 970.462.7450
