Recently I upgraded my Nextcloud instance and after upgrading I got some missing indexes to fix. That's normal with Nextcloud, you will get things from time to time to update. Here we will fix an error 'column size too large' when you run the occ command on the server.
You can automatically upgrade your Nextcloud instance from Admin settings. But for whatever reason you are not able to automatically upgrade, you can still manually upgrade Nextcloud.
In this article, we will install Nextcloud 23 on Ubuntu 20.04 with PHP 8. Nextcloud 23 does not recommend to use PHP 7.3 anymore, so it's time to just install PHP 8.