After updating to nextcloud 16.0.0 you might get the following error:
- Fehlender Index “version” in der Tabelle “oc_whats_new”.
- Fehlender Index “twofactor_providers_uid” in der Tabelle “oc_twofactor_providers”.
- Fehlender Index “cards_abid” in der Tabelle “oc_cards”.
- Fehlender Index “cards_prop_abid” in der Tabelle “oc_cards_properties”.
To solve the problem above you can add the missing indices by using the following SQL queries on your MSSQL database:
ALTER TABLE `oc_whats_new` ADD KEY `version` (`version`) USING BTREE;
ALTER TABLE `oc_twofactor_providers` ADD KEY `twofactor_providers_uid` (`uid`) USING BTREE;
ALTER TABLE `oc_cards` ADD KEY `cards_abid` (`addressbookid`) USING BTREE;
ALTER TABLE `oc_cards_properties` ADD KEY `cards_prop_abid` (`addressbookid`) USING BTREE;
Good luck