diff options
| author | Dave Arter <davea@mysociety.org> | 2016-08-15 12:05:43 +0100 |
|---|---|---|
| committer | Dave Arter <davea@mysociety.org> | 2016-08-15 12:11:59 +0100 |
| commit | a228f4b05afabe26a1b97a874d82ee838b69e3c4 (patch) | |
| tree | 9740fb07052a2805bd3fa93e41c3eb96303464d3 /perllib/FixMyStreet/DB/ResultSet | |
| parent | c8717ff57781f1fd1501fc0b92a77395afdfa05a (diff) | |
Fix a crash on /admin/timeline
The 'created' and 'state' column names are shared between the 'problem' and
'comment' tables, and this was causing ambiguous column references in the SQL.
Diffstat (limited to 'perllib/FixMyStreet/DB/ResultSet')
| -rw-r--r-- | perllib/FixMyStreet/DB/ResultSet/Comment.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/perllib/FixMyStreet/DB/ResultSet/Comment.pm b/perllib/FixMyStreet/DB/ResultSet/Comment.pm index 9f254a018..b9a3df62d 100644 --- a/perllib/FixMyStreet/DB/ResultSet/Comment.pm +++ b/perllib/FixMyStreet/DB/ResultSet/Comment.pm @@ -20,8 +20,8 @@ sub timeline { return $rs->search( { - state => 'confirmed', - created => { '>=', \"current_timestamp-'7 days'::interval" }, + 'me.state' => 'confirmed', + 'me.created' => { '>=', \"current_timestamp-'7 days'::interval" }, }, { prefetch => $prefetch, |