With the update from 22 to 23 there seems again a database issue.
The OCC addon does not work any more. And why should I go to a Linux login to correct this?
Missing index āfs_id_storage_sizeā in table āoc_filecacheā.
Missing index āfs_storage_path_prefixā in table āoc_filecacheā
If you read the message completely, it wonāt be done within the update process because for large installations this could run into timeouts and leave you with broken installations.
Yes, Iāve read that.
But one could add this as an option in the process. Or update the good old OCC addon. That worked fine for most maintanance on all NC instals we have. (most < 40GB).
You have go in Linux with SSH and adequate rights. (I my case ROOT does not work. It should be the owner of the account.
Then you go to the Nextcloud folder and then:
php occ db:add-missing-indices
That should be enough. It can be done on a running NC installation. But if you want, you can use these:
php occ maintenance:mode --on
php occ maintenance:mode --off
As you say, root doesnāt work. Says that the owner of the file is ā33ā which I believe is āwww-dataā.
I got that info by typing āgetent passwd ā33āā - is that right?
If so, how do I log in as www-data. Though I presume that this:
runuser -l www-data -c āphp occ db:add-missing-indicesā