MySQL Retrive positions from Deleted device

Macan 4 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 Tananaev 4 years ago

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

Macan 4 years ago

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

Anton Tananaev 4 years ago

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

Macan 4 years ago

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

Anton Tananaev 4 years ago

There's a deviceId column.

Macan 4 years ago

Ok , I will take a look

Thank you