▶ Support intro Nextcloud version 27.0.2 Operating system and version Webhosting environment

[image] Nikola_Driver: Thank you, honestly The place where the indices are stored has changed a bit since my last post. It is now an event and not simply hardcoded in the command. Now all indices that are required are stored here: core/Application.php 54afea4b0 …

try searching the forum and the docs… there miraids of topics talking about “occ db:add-missing-indices"

It’s fully documented in the “How to upgrade” section of the Admin Manual. Here’s the direct link to the spot you’re looking for. P.S. The manual is fully searchable by keyword.

Many Thanks for your answers, but I can’t run occ in my environment so I serach for the SQL-Commands alter table… or can anybody tell mye where can I find the php-script add-missing-indices? Best regards Peter

[image] nusspe: can anybody tell mye where can I find the php-script add-missing-indices? Voila (for your version 27.0.2): nextcloud/server/blob/v27.0.2/core/Command/Db/AddMissingIndices.php <?php declare(strict_types=1); /** * @copyright Copyright (c) 2017 Bjoern Schiessl…

[image] nusspe: but I can’t run occ in my environment Can you tell us more details about this? - If you have access to SQL command line, you also should have access to occ, if you use the correct syntax and path.

[image] nusspe: I serach for the SQL-Commands Tell me which Indices your nextcloud is missing exactly and I will try to get it in the right form for you: here one more example: nextcloud/server/blob/v27.0.2/core/Command/Db/AddMissingIndices.php#L487 if (!…

[image] Mornsgrans: If you have access to SQL command line, you also shoiukd should have access to occ Even though you didn’t ask me: Some providers do not allow ssh access while the database can be managed with other interfaces.

[image] ernolf: } No. As stated, you cant change to the required user for OCC. The issue doesnt exist with MySQL Sudo root can access the SQL database, while with the security suite on our hosting only specific users can execute scripts in the CLI, so you login to the basic CLI, attempt t…

Thank you, honestly i had got to the point with this, that i had been staring at it so long, i couldn’t even process data anymore.

[image] Nikola_Driver: so you login to the basic CLI, attempt to run it as a sudo root command, but cant because the files are not owned by root and OCC will only allow itself to be executed by its true owner. If you have the ability to run sudo as root, you likely can run sudo as another use…

Nextcloud community

SQL commands for missing indices

ℹ️ Support

database

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled