I was able to upgrade to Nextcloud v20.0.1 on SME 9.2.
My system still complains about needing utfmb4 to support emojis - fixing that would require
mysql55 or
mysql57.
Details:
* Install SME 9.2
* Install the
nextcloud contrib
* Reconfigure nextcloud to use php73 (the first two are links to earlier posts in this topic):
*
Reconfigure NC to use php73 *
copy php72 opcache settings to php73 and install gmp *
Update /usr/bin/OCC to use php73 (this would need to be repeated after installing an updated version of the nextcloud contrib):
sed -i 's/php72/php73/' /usr/bin/OCC
* use the web updater to update to v17.0.10
* Run post-upgrade database updates listed at Settings -> Overview
OCC db:convert-filecache-bigint
* use the web updater to update to v18.0.10
* The updater failed with an error "Column name "oc_flow_operations.entity" is "NotNull", but has empty string or null as default".
* I found the solution at
https://github.com/nextcloud/server/issues/23174:
mysql nextcloud -e "alter table oc_flow_operations add column entity character varying(256) not null;"
OCC upgrade
* The update indicated that the 'gallery' app was being disabled
* use the web updater to update to v19.0.4
* Run the post-upgrade database updates listed at Settings -> Overview
OCC db:add-missing-indices
OCC db:add-missing-columns
* use the web updater to update to v20.0.1
Note: I was not offered the update to v20.0.1 until I changed the nextcloud update channel from 'stable' to 'beta'