▶ Support intro Nextcloud version (eg, 12.0.2):15.0 Operating system and version (eg, Ubuntu 17.04):? Apache or nginx version (eg, Apache 2.4.25): ? PHP version (eg, 7.1): 7.2 MySQL version: 5.7.21-nmm1-log - (Ubuntu) The issue you are facing: Modifications on the database as suggested by NextC…

I goggled a bit and found out the following. This worked for me: ALTER TABLE `your_table_prefix_activity` MODIFY `activity_id` bigint NOT NULL AUTO_INCREMENT; ALTER TABLE `your_table_prefix_activity` MODIFY `object_id` bigint NOT NULL DEFAULT ‘0’; ALTER TABLE `your_table_prefix_activity_mq` MODIF…

Hi @nieroster , Do you think these 2 lines can fix the second part of my problem in this post? : ALTER TABLE oc_filecache MODIFY mtime bigint NOT NULL DEFAULT ‘0’; ALTER TABLE oc_filecache MODIFY storage_mtime bigint NOT NULL DEFAULT ‘0’; [image] "The database is missing s…

Hello, In case you need to perform occ commands and don’t have shell access due to the usage of hosting providers, you could use cronjobs to do the job for you. Just to have another idea. Then you could run the occ command safely and don’t need to worry about breaking your database.

Hi ffs69, before applying SQL commands you should make a backup using phpMyAdmin. Use the export tab to generate an sql file of the entire database. Don’t forget to change your NextCloud instance to maintenance mode before continuing. The 2 commands above are correct provided your table prefix is …

Hi schmu, how do you run occ commands using webcron? Cron itself is not available on shared hosting.

Hi @nieroster I don’t need a shared hoster myself, but read a user comment here, who solved the problem with OCC commands on shared hosts with cron, so I thought I mention it here and you know how to do it :smiley: After your question it took me a while to find that post again: [image…

Another new solution is available. See [image] How to use occ commands on a Shared Hosting without SSH access 📑 How to This app is deprecated and not usable for Nextcloud version newer than NC v18 I have a test instance of NC15 on a Shared Hosting. Works pretty well, bu…

@rakekniven You sir are a legend. You have solved something simply and quickly that I had been struggling with for hours. I have my own VPS with NextCloud installed via cPanel and the convert-filecache-bigint script wouldn’t run no matter which of the hundreds of suggestions I tried. I installed…

Problems converting indices to bigint

ℹ️ Support

rakekniven February 1, 2019, 3:28pm 8

Another new solution is available. See