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
durationduration INT CHARACTER SET utf8mb4 NOT NULL COLLATEutf8mb4_bin, CHANGEplaytimeplaytime INT CHARACTER SET utf8mb4 NOT NULL COLLATEutf8mb4_bin, CHANGElastplayedlastplayed INT CHARACTER SET utf8mb4 NOT NULL COLLATEutf8mb4_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 COLLATEutf8mb4_bin, CHANGEplaytimeplayt...
Using Nextcloud 20.0.8, MariaDB 10.4.17 and Linux.
Any ideas what's wrong?
Best regards, Andreas