Geofences problem.

TempoGPS2 years ago

Hello, I run traccar in latest version. I realize that when I set geofences for a unit and the unit insert or exit the geofences goes offline. After while it goes online, again offline etc.
When I delete the geofences all is good.
Any idea?

Anton Tananaev2 years ago

There's probably some error with notification. Check logs.

TempoGPSa year ago

Hello again. When a device tries to enter a geofence i get this error. 

2022-12-22 17:50:59  INFO: [Tc10894f5] error - ERROR: column "geofenceids" of relation "tc_devices" does not exist
  Position: 23 - PSQLException (... < QueryBuilder:469 < DatabaseStorage:115 < GeofenceEventHandler:84 < ...)

2022-12-22 17:50:39  INFO: [T2c469358] error - ERROR: column "geofenceids" of relation "tc_devices" does not exist
  Position: 23 - PSQLException (... < QueryBuilder:469 < DatabaseStorage:115 < GeofenceEventHandler:84 < ...)

2022-12-22 17:50:09  INFO: [Tb6c28b27] error - ERROR: column "geofenceids" of relation "tc_devices" does not exist
  Position: 23 - PSQLException (... < QueryBuilder:469 < DatabaseStorage:115 < GeofenceEventHandler:84 < ...)

Any solution???

TempoGPSa year ago

https://github.com/traccar/traccar/commit/b51526fdb177d3641e2780d5485586b487850874
Probably this is the fix? Which file I have to change and where it is?

TempoGPSa year ago
2022-12-23 11:36:58  INFO: [T7739d698] error - ERROR: column "geofenceids" of relation "tc_devices" does not exist
  Position: 23 - PSQLException (... < QueryBuilder:469 < DatabaseStorage:115 < GeofenceEventHandler:84 < ...)

2022-12-23 11:37:59  WARN: Geolocation network error - No valid cell IDs or LACs provided (3) - GeolocationException (OpenCellIdGeolocationProvider:59 < *:46 < ...)

First message is the same. I also get the second when i set a geofence.

Anton Tananaeva year ago

The first error should be fixed if you upgrade the server correctly. If not, manually fix it in the database.

Second error probably means that you're trying to use Opencellid for WiFi or some invalid data.

TempoGPSa year ago

I have access to server via ssh but i don't know how to do it manually. I searched the forum for a guide or something but i don't understand what i have to do. I'm a little noob.
Is there anybody who can help me do it?

Anton Tananaeva year ago

We have paid support available if you want someone to actually do it for you. If you're interested feel free to send an email to the support address.