Missing indexes after upgrade to NC18, db:add-missing-indices failing

I’ve tried that. It tells me OCC is not a supported command. It doesn’t even know sudo. I’ve had this problem for a while when accessing a container with docker exec -it CONTAINER_NAME bash.

When you connect to your docker container, do you change directory to NC root? OCC can only be executed from either inside the NC root folder, or by providing the full path to it.

What error message are you getting, when you execute the sudo command inside the docker container?

This is the error I get: bash: sudo: command not found

Thank for this.
Just for letting you know that you can do it using the CLI / SSH, if available:

MariaDB [ncocloud]> ALTER TABLE oc_calendarobjects_props DROP INDEX calendarobject_value_index;

And then run:

php occ db:add-missing-indices

All good now.
Cheers.
JG

1 Like