Are you sure you have official Traccar without any modifications?
This error likely means you have some database schema issue.
I am using traccar with docker with a very basic yml. I am not aware of any schema issues.
services:
traccar:
image: traccar/traccar:latest
container_name: traccar
restart: always
ports:
- "10.252.1.1:8082:8082"
- "10.252.1.1:5055:5055"
volumes:
- ./logs:/opt/traccar/logs
- ./data:/opt/traccar/data
- ./traccar.xml:/opt/traccar/conf/traccar.xml:ro
environment:
TZ: Europe/Berlin
traccar.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>
<properties>
<!-- Documentation: https://www.traccar.org/configuration-file/ -->
<entry key='database.driver'>org.h2.Driver</entry>
<entry key='database.url'>jdbc:h2:./data/database</entry>
<entry key='database.user'>sa</entry>
<entry key='database.password' />
<entry key='event.status.enable'>true</entry>
<entry key='notificator.types'>traccar,web,sms</entry>
<entry key='notificator.traccar.key'><API-KEY></entry>
<entry key='status.timeout'>10</entry>
<entry key='logger.level'>debug</entry>
</properties>
I've reinstalled the docker image with mysql from scratch. Same issue. I've found out (with the help of Claude) that according to the log there is an suspicious INSERT query related to "token":
INSERT INTO tc_actions(actionType, actionTime, address, attributes, userId, objectId, objectType) VALUES ('create', '2026-07-22 18:32:52.711', '10.252.1.3', '{}', 1, 3073803337116921467, 'token')
If I execute this query manually I receive the error:
ERROR 1264 (22003): Out of range value for column 'objectid' at row 1
The value 3073803337116921467 is a 19-digit number. That far exceeds the range of MySQL INT (maximum 2147483647, i.e. 10 digits). The reason is that Traccar appears to generate token IDs as long random long values (64-bit), while the objectId column in tc_actions is likely defined as INT (32-bit) instead of BIGINT.
If I modify the type to BIGINT and re-execute the query manually, the error is gone:
"Query OK, 1 row affected (0.005 sec)"
The error in the tracker-server.log "WARN: Failed to store action create" is gone.
Nevertheless, the token under attributes in user is still not generated after re-login.
This change will fix the problem:
https://github.com/traccar/traccar/commit/ff09f38e17713471cb526869f99bd5ca5d28b6d7
But I think this is just a warning currently.
Hi Anton, I forgot to mention that regarding notifications, both the tokens and the sending process are working correctly. However, I have a problem: the Reports - Logs page is blank. Could this be related to a setting in the traccar.xml file?
I'm also having problems with a GS10GLA_V01_20231226 device. Previously, Protrack displayed the device's battery level and external voltage, but Traccar isn't doing so. I monitored the log and found that the HEX string starts with 7979, but I can't find the protocol manual for this device, and the AI isn't giving me precise information about whether the bytes are the ones the device should be sending.
Please create separate threads if it's unrelated to the topic.
I am on 6.14.5 and my Traccar Manager app does not generate a token. I can see in the logs the following entry upon login via the app:
Is this related to the token generation? I am using newest Android app from google play store.