Error is thrown when viewing archives in ContentBox 1.2

Communities ContentBox CMS
1

Well I can see this release got a lot of testing……

I am getting the following error

Ohh man! Something really went wrong with your request. The administrator has been adviced, so do not worry! Please try your request again!

Fault Action: archives

Error Information:
Error while executing the Hibernate query. java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Column “cb_content.publishedDate” is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.

Line 213 in BaseORMService.cfc

2

ooops make that line 153 modules\contentbox\model\content\EntryService.cfc

3

Ok fixed…

Damn Luis, I raised that bug over 12 months ago, why has it not been fixed yet?

4

Where is your pull request??

5

I hate git Curt, well not hate but haven’t had the time to learn it at the moment, secondly the ticket was raised and the solution was posted in here and in should be also in the ticket.