[development] Strange query problem
nan_wich at bellsouth.net
Thu Apr 8 18:12:19 UTC 2010
And Devel says this:
SELECT nc.nid, n.title, nc.daycount AS views, nc.totalcount, (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 LIMIT 0, 20
And pasting that into PhpMyAdmin gives me the results I would expect.
Nancy E. Wichmann, PMP
From: Aaron Winborn <winborn at advomatic.com>
To: development at drupal.org
Sent: Thu, April 8, 2010 1:20:38 PM
Subject: Re: [development] Strange query problem
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,
> 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
Drupal Multimedia available in September!
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the development