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 COLLATEutf8mb4_bin
, CHANGEplaytime
playtime INT CHARACTER SET utf8mb4 NOT NULL COLLATEutf8mb4_bin
, CHANGElastplayed
lastplayed 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
, CHANGEplaytime
playt...
Using Nextcloud 20.0.8, MariaDB 10.4.17 and Linux.
Any ideas what's wrong?
Best regards, Andreas