database.selectAllDevices getting error unknown device

Prince Rajputa year 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-tracea year ago

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

Anton Tananaeva year ago

You cannot customize queries anymore on new versions.

Prince Rajputa year ago

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

Anton Tananaeva year ago

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