2023-02-12 23:04:23 INFO: Operating system name: Linux version: 5.10.103-v7+ architecture: arm
2023-02-12 23:04:23 INFO: Java runtime name: OpenJDK Server VM vendor: Raspbian version: 11.0.18+10-post-Raspbian-1deb10u1
2023-02-12 23:04:23 INFO: Memory limit heap: 224mb non-heap: 0mb
2023-02-12 23:04:23 INFO: Character encoding: UTF-8 charset: UTF-8
2023-02-12 23:04:23 INFO: Version: 5.6
2023-02-12 23:04:23 INFO: Starting server...
2023-02-12 23:04:24 INFO: HikariPool-1 - Starting...
2023-02-12 23:04:27 INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@7795c7
2023-02-12 23:04:27 INFO: HikariPool-1 - Start completed.
2023-02-12 23:04:28 INFO: Clearing database change log checksums
2023-02-12 23:04:29 INFO: Successfully acquired change log lock
2023-02-12 23:04:30 INFO: Successfully released change log lock
2023-02-12 23:04:31 INFO: Successfully acquired change log lock
2023-02-12 23:04:41 INFO: Reading from traccar.DATABASECHANGELOG
2023-02-12 23:04:45 INFO: Reading from traccar.DATABASECHANGELOG
2023-02-12 23:04:47 INFO: Successfully released change log lock
2023-02-12 23:04:47 ERROR: Main method error - Duplicate column name 'motionstate' - SQLSyntaxErrorException (... < DatabaseModule:96 < <gener:-1 < *:-1 < ... < Main:126 < ...)
Im getting this when trying to run 5.6, what options do I have to fix this, short of nuking my DB and starting fresh?
You can try removing the column.
Im getting this when trying to run 5.6, what options do I have to fix this, short of nuking my DB and starting fresh?