STATUS and Address problem

[leontino]

Hello, my traccar show me this error on tracker log.
2015-12-31 01:44:25 WARN: Unknown column 'status' in 'field list' - MySQLSyntaxErrorException (... < QueryBuilder:431 < DataManager:256 < ConnectionManager:110 < ...)

and my devices don't show the address.

Traccar version: 3.3

Thanks

[ghost]

Hello,

For addresse NOT display....
same problem but Traccar3.3

[gsiotas]

About the status problem after updating to traccar 3.3 I got the same error. After fiddling with the traccar.xml I think maybe the query in the updateDeviceStatus entry should change. I am talking about this one:

UPDATE devices SET status = :status, lastUpdate = :lastUpdate WHERE id = :id;

For the meantime I have commented it, but I still get a relevant warning message in the log files:

WARN: Query was empty - MySQLSyntaxErrorException (... < QueryBuilder:431 < DataManager:256 < ConnectionManager:110 < ...)

Edit: I am using traccer web 0.10.3

[vitalidze]

This query is not yet supported, i.e. there are no status and lastUpdate columns in the devices table yet. The warning can be safely ignored or you can remove/comment out the status update query if the warning bothers you.

[PascalVD]

i use the last Android client and last server version and i see no location of all my devices ...
can you help to find the problem ?

[peptoni]

Do we have info about the 'status' column? Could we just add the field to the table...? It's annoying to have error messages in the log every couple of seconds. It does not help to find other errors and clogs the server available space (I'm on a EC2 server, with limited disk space).

[vitalidze]

@peptoni you can either add column of following type:

<column name="status" type="VARCHAR(128)" />

Or just comment out the updateStatus query in traccar.xml:

    <!-- entry key='database.updateDeviceStatus'>
        UPDATE devices SET status = :status, lastUpdate = :lastUpdate WHERE id = :id;
    </entry -->

In future I think it's worth to have such column in the web UI mod.

[peptoni]

Thank you. I also had to add column "lastUpdate" as TIMESTAMP. Now all errors have gone.

[peptoni]

Shit... lastUpdate initializes as not null... And I get this error:
WARN: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp - SQLException (... < QueryBuilder:346 < *:409 < DataManager:231 < *:118 < *:138 < BaseProtocolDecoder:47 < ...)

[peptoni]

Ok. I solved doing this:
ALTER TABLE devices ADD lastUpdate DATETIME DEFAULT NULL;

Now it's working.

[peptoni]

So, the complete thing goes here:

msql -u USER -pPASSWORD
use TRACCAR;
ALTER TABLE devices ADD lastUpdate DATETIME DEFAULT NULL;
ALTER TABLE devices ADD status VARCHAR(128);
quit

[vitalidze]

Fixed, written news, updated latest and demo versions.