MySQL Retrive positions from Deleted device

Macan3 years ago

Hello,

The devices have been deleted but when I try to add the same device IMEI I get an error "IME in use" something like that and I can't add the device to the traccar server.
I also tried to link again devices via admin account but there is no devices with that IMEI or name.

I tried to find the device by IMEI number through the database table tc_devices (uniqueid column), but it is empty.

My question is: Is it possible to pull all positions for the that deleted device from the tc_positions table even though device is not in the tc_devices table?

Based on what can I search for a position for the device in the table tc_positions ?

Best regards

Anton Tananaev3 years ago

If you're getting that error, it means that device is still there.

Macan3 years ago

But where is it if its not in the tc_devices table ?

Anton Tananaev3 years ago

It should be in tc_devices. If you provide exact error message it would be more helpful.

Macan3 years ago

Ok, but which columns I can merge that I can search positions from tc_positions table for the devices?

Anton Tananaev3 years ago

There's a deviceId column.

Macan3 years ago

Ok , I will take a look

Thank you