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().