If you faced location data with future dates you can edit your database to remove incorrect dates.
You can use for it any administrative tool, e.g. HeidiSQL:
https://www.heidisql.com/download.php
To edit your database please follow this guide:
1. Open HeidiSQL and connect to your SQL server.
If it is first opening of programm you should first create new session. In session settings you should set your - network type, server ip and name, authentication type.
2. Open query tab and make following request:
SELECT * FROM [RadioServer].[dbo].[LocationData] where "dt" > getdate ()
to find all locations with dates later that current.
3. Then make following request:
DELETE from [RadioServer].[dbo].[LocationData] where dt>'yyyy-mm-dd'
where yyyy-mm-dd is current date, to delete all locations with dates later that current.
4. Then you can make again request:
SELECT * FROM [RadioServer].[dbo].[LocationData] where "dt" > getdate ()
just for make sure that you deleted all incorrect dates.
Comments