Cutom Atributes

davidfungf 3 years ago

I want to create an attribute to store the vehicle warranty date (say 31-Dec-2023). When I create an attribute of a device, it returned the following error. Any idea?

Column "EXPIRATIONTIME" not found; SQL statement: UPDATE tc_devices SET uniqueid = ?, phone = ?, model = ?, contact = ?, category = ?, disabled = ?, expirationtime = ?, name = ?, groupid = ?, attributes = ? WHERE id = ? [42122-206] - JdbcSQLSyntaxErrorException (... < QueryBuilder:73 < *:140 < DatabaseStorage:103 < BaseObjectResource:98 < ...)

https://drive.google.com/file/d/1Claf7G9lS0PNVDgJS4eTUMGUGOcGhhEF/view?usp=sharing

Anton Tananaev 3 years ago

It seems like you're using web app from master branch with an outdated backend.

davidfungf 3 years ago

I am using Server Version 5.2 (linux x64 version) which downloaded it from https://www.traccar.org/download/

davidfungf 3 years ago

Maybe we copied it from the Git Hub because we implemented the new GPS device protocol layer. i.e. an outdated version is used.

Anton Tananaev 3 years ago

The web app you're using has to match the backend.

davidfungf 3 years ago

I see. Thank you!