Cannot upgrade database from 1.7.2 to 1.8.0-RC.1

melichpelegri

I made a backup from MariaDB and restored to a MySQL(tested with 5.7.33 and 8.0.21). After that I made a fresh installation of Fusionauth points to this MySQL. When it start tells that upgrade is required, so I press submit but on 1.8.0-RC.1 stops for the following error:

-- Update the version
UPDATE version
SET version = '1.8.0-RC.1';
.  Cause: java.sql.SQLSyntaxErrorException: Table 'themes' already exists
	at org.apache.ibatis.jdbc.ScriptRunner.executeFullScript(ScriptRunner.java:142)
	at org.apache.ibatis.jdbc.ScriptRunner.runScript(ScriptRunner.java:117)
	at com.inversoft.maintenance.db.SQLExecutor.executeSQLScriptWithError(SQLExecutor.java:43)
	at com.inversoft.maintenance.db.JDBCMaintenanceModeDatabaseService.upgrade(JDBCMaintenanceModeDatabaseService.java:357)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630)
	... 1 common frames omitted

Can someone shed some light on it?

Thanks in advance

dan

hiya @melichpelegri ,

I'm not sure what to suggest. This is a pretty old version.

From reading the release notes, I might try going to 1.8.1-RC

https://fusionauth.io/docs/v1/tech/archive/release-notes/#version-1-8-1-rc1

"Performing a clean install of 1.8.0-RC.1 may fail in some cases"