Cutom Atributes

davidfungf2 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 Tananaev2 years ago

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

davidfungf2 years ago

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

davidfungf2 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 Tananaev2 years ago

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

davidfungf2 years ago

I see. Thank you!