Skip to content

Can't install/upgrade

I tried to update the app from 0.0.1 to 0.2 but it didn't work due to a SQL error. Removed app and tried to do a fresh install. Same error:

An exception occurred while executing 'ALTER TABLE oc_episodes ADD description VARCHAR(255) DEFAULT NULL, ADD podcastid INT NOT NULL, DROP author, CHANGE duration duration INT CHARACTER SET utf8mb4 NOT NULL COLLATE utf8mb4_bin, CHANGE playtime playtime INT CHARACTER SET utf8mb4 NOT NULL COLLATE utf8mb4_bin, CHANGE lastplayed lastplayed INT CHARACTER SET utf8mb4 NOT NULL COLLATE utf8mb4_bin':\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CHARACTER SET utf8mb4 NOT NULL COLLATE utf8mb4_bin, CHANGE playtime playt...

Using Nextcloud 20.0.8, MariaDB 10.4.17 and Linux.

Any ideas what's wrong?

Best regards, Andreas