database.selectAllDevices getting error unknown device

Prince Rajput 3 years ago

hello Traccar Community,

i am using latest Traccar Version 5.6 and i am using MS-SQL custom database while traccar devices table tc_devices but we are using own device device_master then we changed in traccar.xml file following code..

 <entry key='database.selectDevices'>
       SELECT DeviceIMEI as id, DeviceIMEI as uniqueId from device_Master;  
</entry>
<entry key='database.selectAllDevices'>
        SELECT DeviceIMEI as id, DeviceIMEI as uniqueId from device_Master;
</entry>

it was working in previous version but currently not working..

kindly assist me how can we fix the problem.

Track-trace 3 years ago

Hi, just for my info, what is the purpose for this. Using the device Imei instead of the shorter device ID ?

Anton Tananaev 3 years ago

You cannot customize queries anymore on new versions.

Prince Rajput 3 years ago

Dear Anton tananaev, by any chance is it possible for new upcoming versions.. it's require for us.

Anton Tananaev 3 years ago

Unfortunately it's not possible because we completely reimplemented the way database communication works.