I am using drupal 7.20 with filedepot 7.x-1.0 module I am uploading a file into a folder and I have a strange problem.
Error *PDOException*: SQLSTATE[42803]: Grouping error: 7 ERROR: column "b.tagword" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT a.tagid,b.tagword,a.metric from nextag_metrics a LEFT... ^: SELECT a.tagid,b.tagword,a.metric from {nextag_metrics} a LEFT JOIN {nextag_words} b ON a.tagid=b.id WHERE b.tagword is not NULL AND type='filedepot' GROUP BY tagid ORDER BY a.tagid ASC, metric DESC; Array ( ) in *template_preprocess_filedepot_tagcloud()* (line *1853* of * /var/www/drupal-7.20/sites/all/modules/filedepot/filedepot.module*).
SO I understand that postgresql is asking for b.tagword to be part of the group by statement So in /var/www/drupal-7.20/sires/all/modules/filedepot/fildepot.module I did
$sql .= "GROUP BY tagid ORDER BY a.tagid ASC, metric DESC"; to $sql .= "GROUP BY tagid, b.tagword, a.metric ORDER BY a.tagid ASC, metric DESC";
and the filedepot module loads fine. But I see that the tags are visible but unresponsive for click. I mean when I click the tags associated with the file, they do not show me all the files with those tags.
Please let me know. Thanks !
Regards, KM