Recalculation of Odometer.

Hi all.
Total distance on some of my device reset to zero, I really do not know why and how it happened, but then I would like to know the process of recalculating odometer on the traccar server, so that subsequent reports will be accurate.

https://im.ge/i/Otfsh from the image in link,
odometer start and end on the red marker is the original value.
Odometer start and stop on the blue marker is a result of a reset odometer value.

I would like to recalculate odometer from where the glitch occurs.

Would any be kind to point me in the right direction. or any documentation i need to understand to get this done.

Thanks

You would have to do it manually in the database.

Okay. So I'm an intermediate programmer. From what you have said.
I need to edit the entry that creates odometer value.

Doing this mean I would have to edit hundreds of entries.

Please is there a method I can use, where i upload value and click on recalculate so which recalculate all other values?

My apologies if my question sounds lazy, honestly I am #petface

Please is there a method I can use, where i upload value and click on recalculate so which recalculate all other values?

No, there's no method to do it automatically for you.

Dear Anton,
I am about to begin database modification to correct the error. would you be kind to let me know the table that contains the odometer.

I tried working form tc_positions but i realized distance and total distance is inside attribute.
I dont know how to access a nested table via mysql. can you please give me a hint.

Thanks

Dear Anton... Nevermind. I was using the wrong quote to close the string.

will start the modification now...