5.4 Modern standard commands while device is offline.

Track-trace2 years ago

On 5.4 Modern with Mysql database, when i send a standard command from the dropdown menu to the device it works (for instance poweroff).

But when a device is offline and then the same command is sent it will throw an error on screen:

Field 'description' doesn't have a default value - SQLException (... < QueryBuilder:469 < DatabaseStorage:95 < CommandsManager:87 < ...)

Logicly the device is offline, but is this expected behaviour ?

Anton Tananaev2 years ago
Track-trace2 years ago

Actually, I downloaded the sourcecode from https://github.com/traccar/traccar/releases/tag/v5.4 on 24 october 2022

When i compare these three files that i use to compile tracker-server.jar with. They are the same as the files from

https://github.com/traccar/traccar/commit/8f537de3bbf4dc1a742222dfd3123090b79e6419

BaseCommand.java
Command.java
QueuedCommand.java

But not the changes in have the file changelog-5.5.xml
changelog-master.xml

So changelog-5.5.xml fix that issue ?

Track-trace2 years ago

I think i get it. The fix drops the description columnName in tc_commands_queue Table

 <dropColumn tableName="tc_commands_queue" columnName="description" />