"Created vs closed issues" does not work on PostgreSQL

[martinvonwittich]

I've created a chart in our Redmine 3.4.2 instance with the following configuration:

Name: test2
Chart type: Created vs closed issues
Public: yes
Tracker: All trackers
in the past: 30 days

When I try to view this chard, I only get a red box with a database exception in it. The full error message from the PostgreSQL log:

2017-07-21 11:28:59 CEST [17412-7] redmine@redmine_staging ERROR:  operator does not exist: timestamp without time zone > integer at character 316
2017-07-21 11:28:59 CEST [17412-8] redmine@redmine_staging HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
2017-07-21 11:28:59 CEST [17412-9] redmine@redmine_staging STATEMENT:  SELECT "issues".* FROM "issues" WHERE (issues.project_id IN (72,81,87,14,83,6,19,5,74,3,60,43,44,27,42,29,61,40,66,80,30,25,34,41,45,67,46,54,22,39,38,53,59,64,58,51,31,21,26,49,37,52,48,47,24,56,55,50,32,63,33,28,57,36,70,35,68,7,8,9,69,75,20,82,88,4,84,86,85) AND issues.created_on > '2017-06-21') AND (closed_on > 0)  ORDER BY "issues"."closed_on" ASC

Maybe you want to use closed_on IS NOT NULL instead of closed_on > 0?

[masweetman]

Thanks! I think it's fixed. Let me know if it works.