Error upgrading traccar 5.0 to 5.4

Marcos Ferreira 3 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 Tananaev 3 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 Ferreira 3 years ago

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

Marcos Ferreira 3 years ago

Is there a way to fix the error?

Anton Tananaev 3 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.