Hello, I update my server since NC13. I am on a shared hosting by OVH. Since the update to NC15, I have new alerts in the Administration> Overview section: The database is missing some indexes. Due to the fact that they added indexes on big tables they were not added automatically. By running “oc…

Awesome ! :sunglasses: So to synthesize sql requests via phpmyadmin and equivalent to OCC commands it gives: Up to NC14: ALTER TABLE `oc_share` ADD KEY `share_with_index` (`share_with`) USING BTREE; ALTER TABLE `oc_share` ADD KEY `parent_index` (`parent`) USING BTREE; ALTER TABLE `oc_filecache` …

Thanks a Million I had to do all of these. Edit by @Schmu : Careful! The following queries are not correct and may corrupt your database. Don’t use them! Rather use the queries by @Maurice down below and only use them if you really cannot use the Nextcloud occ commands! ALTER TABLE `oc_share` ADD…

I updated my DB with the lines from @ffs69 and all works fine… BUT :sob: After update my DB with the code from @bettsr down the line “fileID” i get now a “Internal Server Error” !!! OOOHHH F**** And in the nextcloud.log File the entries explode with the following values {“reqId”:“XB4f3@3JfHdDuVt…

@Ralf setting of fileID should look like this: [db-structure] Try to fix the issue with the following query: ALTER TABLE `oc_filecache` MODIFY `fileid` bigint NOT NULL AUTO_INCREMENT; ALTER TABLE `oc_filecache` MODIFY `storage` bigint NOT NULL DEFAULT '0'; ALTER TABLE `oc_filecache` MODIFY `pare…

I also used the lines from bettsr and nextcloud didn’t work anymore. I tried you suggestion but phpmyadmin gave the following error: Error SQL query: ALTER TABLE `oc_filecache` MODIFY `fileid` bigint NOT NULL AUTO_INCREMENT MySQL said: Documentation #1062 - ALTER TABLE causes auto_increment res…

Hi @vanMacG Well this is bad, sorry to hear that. We really need to take our time and check everything, before we suggest or make any changes to our databases. We can really mess things up. This is actually a job for a database expert then or you take your time and read into this issue a bit more.…

@vanMacG - If you have value 0 on the column where you want to set AUTO_INCREMENT then you will get the following error: ERROR 1062 (23000): ALTER TABLE causes AUTO_INCREMENT resequencing, resulting in duplicate entry '1' for key 'PRIMARY' Cause: It is not possible to set AUTO_INCREMENT on a colum…

Thanks a lot. It worked fine with me. There ist one query missing for mimetypes.id. Could you please add the correct query for this field?

@chrismy - the following query should fix your issue at mimetypes.id: ALTER TABLE `oc_mimetypes` MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

Which part is the database name? MariaDB [(none)]> ALTER TABLE oc_filecache MODIFY mtime bigint NOT NULL DEFAULT ‘0’; ERROR 1046 (3D000): No database selected MariaDB [(none)]>

"The database is missing some indexes." and "Some columns in the database are missing a conversion to big int." with phpmyadmin and-or CRON job (can't use occ command in shared hosting)

📑 How to

ffs69 December 30, 2019, 9:46pm 24