Why I didn't get Geofence web alert and report?

Hi,

I use latest version of Traccar v5.4, I use iOS Traccar Client as my GPS device, I have configured 3 Geofence areas and link them to it, I also had configured the Geofence enter and exit notification to all devices and set it to Web channel, and today I went those areas many times, but didn't have any web alert!, I have checked into the report, it's empty for Geofence enter and exit criteria..

and now, I also in the Geofence area, but I still didn't get the alert!

what did I miss?

below is my traccar.xml:

<entry key='database.driver'>org.postgresql.Driver</entry>
<entry key='database.url'>jdbc:postgresql://127.0.0.1:5432/traccar</entry>
<entry key='database.user'>postgres</entry>
<entry key='database.password'>xxxxxxxxxxxx</entry>

<entry key='forward.enable'>true</entry>
<entry key='forward.url'>http://localhost:7228/testing/api/traccar/live</entry>
<entry key='forward.json'>true</entry>
<entry key='forward.header'>Authorization: Basic XXXXX</entry>

<entry key='event.forward.enable'>true</entry>
<entry key='event.forward.url'>http://localhost:7228/testing/api/traccar/live</entry>
<entry key='event.forward.json'>true</entry>
<entry key='event.forward.header'>Authorization: Basic XXXXXX</entry>

I tried to check /opt/traccar/logs, I saw some:

2022-10-22 21:07:53  INFO: [Ta5a206b8] error - ERROR: column "geofenceids" of relation "tc_devices" does not exist
  Position: 23 - PSQLException (... < QueryBuilder:473 < DatabaseStorage:108 < GeofenceEventHandler:84 < ...)

I also checked tc_devices and it already had geofenceIds -- varchar(128) and all geofenceIds values are null

I'm on the same issue, from some days on I have not been receiving notifications.
I tought there was some misconfiguration but no, It was working fine until about 2 weeks ago.

@Richard,
I have changed the field geofenceIds to geofenceids in tc_devices table, now it works as expected..
good luck!

Why was that table with wrong name? did you changed it already for some reason?

Because I saw below in the logs folder

2022-10-22 21:07:53  INFO: [Ta5a206b8] error - ERROR: column "geofenceids" of relation "tc_devices" does not exist
  Position: 23 - PSQLException (... < QueryBuilder:473 < DatabaseStorage:108 < GeofenceEventHandler:84 < ...)

but how did that changed in the first place that traccar stopped working....

I don’t know your case, but mine was happened after upgraded to v5.4

Probably related to this:

https://github.com/traccar/traccar/issues/4945