I commented the part of <entry key='database.insertPosition'> and every thing looks fine now.
Still like to know what is wrong with the config file part.
You can't use :now
anymore.
I also have one issue when upgrading to 3.14 and the WebUI is not accessible.
If i remove the database i can access the WebUI
2017-09-10 01:24:20 INFO: Version: 3.14-SNAPSHOT
2017-09-10 01:24:32 INFO: Query not provided: database.selectUsers
2017-09-10 01:24:32 INFO: Query not provided: database.selectUserUsers
2017-09-10 01:24:32 INFO: Query not provided: database.selectGroups
2017-09-10 01:24:32 INFO: Query not provided: database.selectDevices
2017-09-10 01:24:33 WARN: Table "SERVER" not found; SQL statement:
SELECT * FROM server; [42102-196] - JdbcSQLException (... < QueryBuilder:62 < *:132 < DataManager:357 < PermissionsManager:92 < ...)
2017-09-10 01:24:33 INFO: Query not provided: database.selectGroups
2017-09-10 01:24:33 INFO: Query not provided: database.selectDevices
2017-09-10 01:24:33 INFO: Query not provided: database.selectUserGroups
2017-09-10 01:24:33 INFO: Query not provided: database.selectUserDevices
2017-09-10 01:24:33 INFO: Query not provided: database.selectGroups
2017-09-10 01:24:33 INFO: Query not provided: database.selectGeofences
2017-09-10 01:24:33 INFO: Query not provided: database.selectUserGeofences
2017-09-10 01:24:33 INFO: Query not provided: database.selectDevices
2017-09-10 01:24:33 INFO: Query not provided: database.selectDevices
2017-09-10 01:24:33 INFO: Query not provided: database.selectCalendars
2017-09-10 01:24:33 INFO: Query not provided: database.selectUserCalendars
2017-09-10 01:24:35 INFO: Query not provided: database.selectAttributeAliases
2017-09-10 01:24:35 INFO: Query not provided: database.selectAttributes
2017-09-10 01:24:35 INFO: Query not provided: database.selectUserAttributes
2017-09-10 01:24:35 INFO: Query not provided: database.selectGroupAttributes
2017-09-10 01:24:35 INFO: Query not provided: database.selectDeviceAttributes
2017-09-10 01:24:35 INFO: Query not provided: database.selectDevices
2017-09-10 01:24:35 INFO: Query not provided: database.selectDrivers
2017-09-10 01:24:35 INFO: Query not provided: database.selectUserDrivers
2017-09-10 01:24:35 INFO: Query not provided: database.selectGroupDrivers
2017-09-10 01:24:35 INFO: Query not provided: database.selectDeviceDrivers
2017-09-10 01:24:35 INFO: Query not provided: database.selectDevices
2017-09-10 01:24:35 INFO: Starting server...```
There is something seriously wrong with your config file.
i did some testing with the same config file, installed 3.10 and upgrade to 3.11, 3.12, 3.13 was ok.
from the moment i upgrade to 3.14, i have this issue.
I will run some more tests
if :now
is not working anymore, what can we use?
You can use standard database functions. For example MySQL has NOW()
.
I have this error after upgrading to 3.14
The position update in the database has stopped.
This is in my config file:
<entry key='database.insertPosition'> INSERT INTO positions (deviceId, protocol, serverTime, deviceTime, fixTime, valid, latitude, longitude, altitude, course, address, attributes, accuracy, network) VALUES (:deviceId, :protocol, :now, :deviceTime, :fixTime, :valid, :latitude, :longitude, :altitude, :speed, :course, :address, :attributes, :accuracy, :network); </entry>
I am running Traccar on a Synology and version 3.13 was running fine.