[support] filedepot tags unresponsive

[km]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20130301/eb1e6ae2/attachment.html