Hi

When i go to the my subscription menu and i try to click to blog etc i get this error

user warning: Invalid use of group function query: SELECT n.nid FROM node n LEFT JOIN term_node tn ON n.nid=tn.nid GROUP BY n.nid ORDER BY MAX(n.created) DESC LIMIT 0, 10 in /home/web/site/includes/database.mysql.inc on line 167.

Comments

arthurf’s picture

arthurf commented
Status: Active » Closed (fixed)

I'm not able to duplicate this error. Can you try installing the latest version of the 5.0 code and let me know if you're still getting this error? In the mean time, I'm going to close this issue.

MarkDerrick’s picture

MarkDerrick commented
Version: 5.x-1.x-dev » 5.x-1.0

I'm getting the following error:
user warning: Invalid use of group function query: SELECT n.nid FROM drupal_node n LEFT JOIN drupal_term_node tn ON n.nid=tn.nid GROUP BY n.nid ORDER BY MAX(n.created) DESC LIMIT 0, 10 in /home/1899/domains/mydomain.com/html/includes/database.mysql.inc on line 167.

This happens when I do the following:
(1) I go to My Account/My Subscriptions
(2) I select RSS Feed
(3) I hit the back button

This is happening with both Safari and Firefox under Mac OSX