diff options
| author | soshial <soshial@gmail.com> | 2021-09-13 21:42:56 +0200 |
|---|---|---|
| committer | soshial <soshial@gmail.com> | 2021-09-13 21:42:56 +0200 |
| commit | a6ccfd679686cfb62f8390334229ba7fdf92eb42 (patch) | |
| tree | 198b9ca3550b66483f0e8483a3d089d21a8f8404 | |
| parent | fd91d6bbb189b091799708a4d3f4e9d9ca114763 (diff) | |
| download | trackermap-server-a6ccfd679686cfb62f8390334229ba7fdf92eb42.tar.gz trackermap-server-a6ccfd679686cfb62f8390334229ba7fdf92eb42.tar.bz2 trackermap-server-a6ccfd679686cfb62f8390334229ba7fdf92eb42.zip | |
fix SQL syntax in XML
| -rw-r--r-- | setup/default.xml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/setup/default.xml b/setup/default.xml index 419eaef45..e427d05e5 100644 --- a/setup/default.xml +++ b/setup/default.xml @@ -49,7 +49,7 @@ </entry> <entry key='database.selectPrecedingPosition'> - SELECT * FROM tc_positions WHERE deviceId = :deviceId AND fixTime lte :time ORDER BY fixTime DESC LIMIT 1 + SELECT * FROM tc_positions WHERE deviceId = :deviceId AND fixTime <= :time ORDER BY fixTime DESC LIMIT 1 </entry> <entry key='database.selectLatestPositions'> |