Last update is for location updates. It has nothing to do with device record updates.
@anton how tc_device is updating, I want to know which file in responsible for updating the data in tc_device like status, last update columns.
Table is updating only when we logged in or traccar service is updating the data in background when we are not logged in.
@tananaev please do the needful
I have the same problem after upgrade form v5.4 to v5.12 on production server. Everything is running fine, no error in the logs. All schema changes were made automatically.
But no updates are done. In ConnectionManager.java this is called (and does not fail):
storage.updateObject(device, new Request(
new Columns.Include("status", "lastUpdate"),
new Condition.Equals("id", "id")));
But "status", "lastUpdate" are not updated in tc_devices. No errors in db-log and no entries in traccar-log.
This is not critical for our application as we are only forwarding the tc_position-data to our own telematics platform. But nevertheless I would like to fix it in case tc_devices entries might be needed one day.
On production server I am still running mysql 5.7 on ubuntu 22.
How do you know that it's getting called and doesn't fail?
Looking at tc_devices, I am updating a particular record (Name, Identifier, even image) and the date doesn't change.
I am on V5.10 running on ubuntu.
Is this supposed to work? I rely on this for sequencing changes in an external database (hold a log of all record changes), and haven't had this being a problem in the past.