[development] Strange query problem

[Randy Fay]

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 <winborn at advomatic.com>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
randy at randyfay.com
+1  970.462.7450
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20100408/08dc5ab7/attachment.html