Nextcloud 18 to 19.1 upgrade


I upgraded nextcloud 18 to 19.1 I could not pass these errors I ask for your help

The database is missing some optional columns. Due to the fact that adding columns on big tables could take some time they were not added automatically when they can be optional. By running “occ db:add-missing-columns” those missing columns could be added manually while the instance keeps running. Once the columns are added some features might improve responsiveness or usability.

Missing optional column "reference_id" in table "oc_comments".![Ekran Resmi 2020-08-22 10.48.03|690x204](upload://sUJXUAq5dfvHK5iqDvggqT7y5I1.png)

How you fix this will depend how you have Nextcloud installed and running, but in principle you run the occ command from within the ./nextcloud folder, usually as the www user.

I’m running Nextcloud in a FreeBSD jail so mine looked like this:

cd /usr/local/www/nextcloud
sudo php -u www occ db:add-missing-columns

Thanks for help