ismop / dap

3 stars 0 forks source link

Errors in ThreatAssessmentController on dap-prod #166

Closed nowakowski closed 7 years ago

nowakowski commented 7 years ago

After pushing master to dap-prod and clicking on Analysis view:

E, [2016-10-28T15:17:23.896033 #5272] ERROR -- : PG::InvalidParameterValue: ERROR:  time zone "gmt+200" not recognized
LINE 8: ...      WHERE threat_assessments.created_at BETWEEN 'Fri Oct 2...
                                                             ^
:           SELECT id, created_at, status, rank
            FROM (
              SELECT id, created_at, status, rank()
              OVER (PARTITION BY profile_id ORDER BY created_at DESC)
              FROM (
                SELECT threat_assessments.id, threat_assessments.created_at, threat_assessments.status, profile_selections.profile_id
                FROM threat_assessments JOIN profile_selections ON threat_assessments.id=profile_selections.threat_assessment_id
                WHERE threat_assessments.created_at BETWEEN 'Fri Oct 21 09:00:00 GMT+200 2016' AND 'Fri Oct 21 09:15:00 GMT+200 2016') 
tpq
            ) inq
          WHERE rank < 2

I, [2016-10-28T15:17:23.896260 #5272]  INFO -- : Completed 500 Internal Server Error in 1406ms

@tbartynski This looks like a latent bug in your recent branch.

nowakowski commented 7 years ago

Fixed it myself. Closing ticket.