database.selectAllDevices getting error unknown device

Prince Rajput2 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-trace2 years ago

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

Anton Tananaev2 years ago

You cannot customize queries anymore on new versions.

Prince Rajput2 years ago

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

Anton Tananaev2 years ago

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