in reply to Re: Error in query with DBD-SQLite-1.37 - Aggregate functions are not allowed in the GROUP BY clause.
in thread Error in query with DBD-SQLite-1.37 - Aggregate functions are not allowed in the GROUP BY clause.

Notably:

MIN(stat_md5) AS stat_md5,
...
GROUP BY ... stat_md5

[download]

Which exactly matches the error message the original poster is getting. (It also looks like an error in another way: Just before that in the select statement is a request for stat_md5 as a separate field. So he's asking for two fields, with the same name, one of which is an aggregate of the first.)

  • Comment on Re^2: Error in query with DBD-SQLite-1.37 - Aggregate functions are not allowed in the GROUP BY clause.
  • Download Code

In Section Seekers of Perl Wisdom