<div dir="ltr"><div><div><div>I am using drupal 7.20 with filedepot 7.x-1.0 module <br></div>I am uploading a file into a folder and I have a strange problem.<br><br>Error <br><em class="">PDOException</em>: 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=<a href="http://b.id">b.id</a> WHERE
b.tagword is not NULL AND type='filedepot' GROUP BY tagid ORDER BY
a.tagid ASC, metric DESC; Array
(
)
in <em class="">template_preprocess_filedepot_tagcloud()</em> (line <em class="">1853</em> of <em class="">/var/www/drupal-7.20/sites/all/modules/filedepot/filedepot.module</em>).<br><br></div>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 <br>
<br>$sql .= "GROUP BY tagid ORDER BY a.tagid ASC, metric DESC";<br></div>to <br>$sql .= "GROUP BY tagid, b.tagword, a.metric ORDER BY a.tagid ASC, metric DESC";<br><div><br></div><div>and the filedepot module loads fine.<br>
</div><div>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.<br></div><div><br>Please let me know.<br>
Thanks !<br></div><div><br>Regards,<br></div><div>KM <br></div></div>