evgenii/redmine_issue_notification — Issue #3: postgresql error
Author: avances123
Created: 2012-02-22 10:11:34+00:00
State: open

whith :

rake --trace issue_notification:send RAILS_ENV=production

The command gives me this trace:

rake aborted!
PGError: ERROR: operator does not exist: date > integer
LINE 1: ...cation = true and done_ratio < 100 and ( due_date > 0 or on_...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
: SELECT * FROM "issues" WHERE (issues.id >= 0) AND (send_notification = true and done_ratio < 100 and ( due_date > 0 or on_date_notification > 0 )) ORDER BY issues.id ASC LIMIT 100