v0.5.3 - it's over 900000!
Oh, Niantic, Niantic. Yet again you break things as soon as I'm unavailable. (This time not sleeping, but going for holidays.)
If you're unlucky and your database has been contaminated by entries from September 6, run this SQL query:
DELETE FROM sightings WHERE expire_timestamp > 1473119999
That will remove all sightings from 2016.09.06 0:00:00 and later. As always, have your database backed up in case something goes wrong.
Changelog:
- ignore spawns that have over 900000 time_to_hidden_ms (i.e. more than 15 minutes) (credit: @seikur0)