You should look and ask support at http://drupal.org/project/issues/filedepot.
Earnie
On Thu, Feb 28, 2013 at 11:06 PM, km srikrishnamohan@gmail.com wrote:
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
-- [ Drupal support list | http://lists.drupal.org/ ]