Upgrade 3.16 to 4.14: Duplicate column name 'disabled' - SQLSyntaxErrorException

Hartmut4 years ago

Hi,

I upgraded my server from Ubuntu 14.04 to 20.04 and traccar from 3.16 to 4.14. I use the same mysql database. Now traccar-server.log reports:

ERROR: Main method error - Duplicate column name 'disabled' - SQLSyntaxErrorException (... < DataManager:297 < *:90 < Context:290 < Main:120 < ...)

Do you have any hint for me?

Hartmut

Anton Tananaev4 years ago

I suspect migration failed and you tried it again and you get this error. Have you checked logs? Restore the database and try again. Make sure you check logs.

Hartmut4 years ago

Thank you, I can confirm that migration failed.

I stopped the traccar server, droped mysql's traccar database, created a empty new one, imported a dump of my old database and restarted traccar. Now it runs fine and my old tracking data are still there.

The trick for me seems to stop the traccar server during drop and recreation of the mysql database.

Thanks for your great software and best regards to St. Petersburg.