[support] filedepot tags unresponsive

[Earnie Boyd]

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 at 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/ ]



-- 
Earnie
-- https://sites.google.com/site/earnieboyd