Error upgrading traccar 5.0 to 5.4

Marcos Ferreira3 years ago
ERROR: Main method error - Duplicate key name 'idx_drivers_uniqueid' - SQLSyntaxErrorException (... < DatabaseModule:96 < <gener:-1 < *:-1 < ... < Main:126 < ...)

I use MYSQL Database

Anton Tananaev3 years ago

That index was added in 5.1. I suspect that you had some preview version installed instead of the official 5.0. That would explain this.

Marcos Ferreira3 years ago

Version 5.0 has been installed, and we don't have the preview version installed from other versions

Marcos Ferreira3 years ago

Is there a way to fix the error?

Anton Tananaev3 years ago

The easiest option - restore the database backup and run service again. If you get the same error immediately on the first run - you didn't have the official version 5.0 originally.