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.

TempoGPS2 years 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???

TempoGPS2 years ago

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

TempoGPS2 years 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 Tananaev2 years 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.

TempoGPS2 years 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 Tananaev2 years 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.