aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorsoshial <soshial@gmail.com>2021-09-13 21:42:56 +0200
committersoshial <soshial@gmail.com>2021-09-13 21:42:56 +0200
commita6ccfd679686cfb62f8390334229ba7fdf92eb42 (patch)
tree198b9ca3550b66483f0e8483a3d089d21a8f8404
parentfd91d6bbb189b091799708a4d3f4e9d9ca114763 (diff)
downloadtraccar-server-a6ccfd679686cfb62f8390334229ba7fdf92eb42.tar.gz
traccar-server-a6ccfd679686cfb62f8390334229ba7fdf92eb42.tar.bz2
traccar-server-a6ccfd679686cfb62f8390334229ba7fdf92eb42.zip
fix SQL syntax in XML
-rw-r--r--setup/default.xml2
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 &lt;= :time ORDER BY fixTime DESC LIMIT 1
</entry>
<entry key='database.selectLatestPositions'>