1. Manual installation on any suPHP server only.
2. Remove inserts from oc_authtoken, oc_filecache, oc_file_locks, oc_circles_circle, oc_circles_member it gets created after login
3. "1|" is added in hashed password in "lib\private\security\hasher.php". In case password changes check "1" constant from this file.
4. Delete "appdata_********" folder from data directory, it gets created after login
5. Delete "configvalue" for 'scss.variables' or "theming.variables" in `oc_appconfig` table as it generates itself on visiting. (Since 12.0.0)
6. Check and move apps/bruteforcesettings from manual to zip and to cross check compare with https://apps.nextcloud.com/apps/bruteforcesettings (check the respective supported bruteforcesettings version from the link, for the respective nextcloud release, download and check in every version and move accordingly)
7. Always check https://docs.nextcloud.com/server/stable/admin_manual/maintenance/manual_upgrade.html in major versions and set "$allowed_ver" accordingly in upgrade.php
8. PHP REQUIREMENT LINK: https://docs.nextcloud.com/server/stable/admin_manual/installation/system_requirements.html
9. We have added "admin_email" in "oc_preferences" table since 16.0.4. ( In Forget password it asks for Email ID ).
10. Take database dump while First run wizard page is loaded(i.e before the dashboard page is loaded). Taking dump on dashboard page would add the entry '('[[admin_username]]', 'firstrunwizard', 'show', '0')' in oc_preferences table which would disable the run wizard.
11. We have set PHP requirement to 7.4 because manual installation doesn't start on PHP 7.3.
12. click "skip" on install recommended apps option in manual installation in last step.
13. Changelog : https://nextcloud.com/changelog/
14. PRIMARY keys are not generated while upgrading to 20.0.2, to generate these keys manually, user can run following command. sudo -u [[USER]] [[PATH to PHP]] [[SOFTPATH]]/occ db:add-missing-primary-keys
15. Increase version number everytime in upgrade.php to remove the previous files as it fails intrigrity check if we keep the old files.
16. We have manually changed file_id's in oc_files_versions table because it was throwing "duplicate entry" error while importing database through Softaculous.