Views group by broke after upgrade
| Project: | Views Group By |
| Version: | 6.x-1.0-rc2 |
| Component: | User interface |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Jump to:
What I am trying to do is when you view an article, it displays other authors that write in this particular subject. We have gotten it to work, but we only want to display only unique authors. We were able to get it working using this module with RC1 (Get the author name and Uid and do a count on the Uid), but when we upgraded to RC2, it broke and I can't figure out a solution.
Here is the query being run:
SELECT node.nid AS nid,
node_data_field_article_author.field_article_author_uid AS node_data_field_article_author_field_article_author_uid,
node.type AS node_type,
node.vid AS node_vid,
COUNT(users.uid) AS users_uid
FROM node node
INNER JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN content_type_article node_data_field_article_author ON node.vid = node_data_field_article_author.vid
INNER JOIN users users ON node.uid = users.uid
WHERE (node.type in ('article')) AND (term_node.tid = 1)
GROUP BY node_data_field_article_author_field_article_author_uid, nid, node_type, node_vid
ORDER BY users_uid DESC
#1
Is this the query from RC2?
Any chance you might be able to post queries from both versions, so that we can compare?
Thank you
#2
Here is from RC1:
SELECT node.nid AS nid,
node_data_field_article_author.field_article_author_uid AS
node_data_field_article_author_field_article_author_uid,
node.type AS node_type,
node.vid AS node_vid,
COUNT(users.uid) AS users_uid
FROM node node
INNER JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN content_type_article node_data_field_article_author ON
node.vid = node_data_field_article_author.vid
INNER JOIN users users ON node.uid = users.uid
WHERE (node.type in ('article')) AND (term_node.tid = 1)
GROUP BY node_data_field_article_author_field_article_author_uid, nid,
node_type, node_vid
ORDER BY users_uid DESC
When we reverted back, it worked just as it did before.
#3
switched from support to bug report. (Since it works in RC1 and not RC2)
#4
Andrew,
the two SQLs you posted are exactly the same. Can you, please, provide SQLs generated when run with RC2 and RC1? That would be tremendous help.
Thank you
Irakli
#5