Error at upgrade from 3.13 to 3.14

Eddy Geurts7 years ago

I have this error after upgrading to 3.14

 No value specified for parameter 3 - SQLException (... < QueryBuilder:477 < DataManager:327 < DefaultDataHandler:27 < ...)

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.

Eddy Geurts7 years ago

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.

Anton Tananaev7 years ago

You can't use :now anymore.

Irinel Porcariu7 years ago

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...```
Anton Tananaev7 years ago

There is something seriously wrong with your config file.

Irinel Porcariu7 years ago

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

Tommaso7 years ago

if :now is not working anymore, what can we use?

Anton Tananaev7 years ago

You can use standard database functions. For example MySQL has NOW().