Problem registering the notification token

Steffen 21 days ago

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:

WARN: Failed to store action create

Is this related to the token generation? I am using newest Android app from google play store.

Anton Tananaev 21 days ago

Are you sure you have official Traccar without any modifications?

Anton Tananaev 21 days ago

This error likely means you have some database schema issue.

Steffen 21 days ago

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>
Steffen 21 days ago

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.

Anton Tananaev 20 days ago

This change will fix the problem:

https://github.com/traccar/traccar/commit/ff09f38e17713471cb526869f99bd5ca5d28b6d7

But I think this is just a warning currently.

911GPS Colombia 18 days ago

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.

Anton Tananaev 18 days ago

Please create separate threads if it's unrelated to the topic.