Upgrade 9.0 to 9.03.90 story

Yesterday I found out there was an official release of PHPfusion to 9.03.90.

I am playing with the thought of upgrading v8 sites to v9, so I grabbed the new version.
For testing purposes and curiosity I upgraded an early v9 site to 9.03.90.

Upgrade process went smooth.
Couldn't access the admin section, but that was because I had an admin theme "Venus" from 2016. Looked for a newer Venus admin theme and found one from 2018. After uploading these newer Venus files I could access the admin section again. Switched directly to AdminLTE and removed all other admin themes.

Hint 1: As AdminLTE is the only admin theme provided in 9.03.90 I suggest to alter the db admin_theme to AdminLTE when upgrading.

Cleared the errorlog and started playing with the new site/version.

Errors starting to pop up for exclude_user1 to 4. Indeed not present in db settings.
Undefined index: exclude_user3
Line: 348 File -- public_html/administration/settings_main.php

Undefined index: logoposition_md and sd sm xs lg. Also not present in db settings.
Line: 254 File -- public_html/administration/settings_main.php

So I'm clearly missing fields in my database.

Hint 2: Create database fields on the fly. (After a check if not exists only for standard needed db fields used by the core files of PHPfusion)

!!!! Ignore the hints above!!!!! upgrade/9.0.upgrade.inc has it all!

So my guess is I had an v9 rc or an early v9 stable installed that did not yet had all the tables needed, but the installer/upgrader (did not noticed this).
Fixed all above issues by altering the version field in the db to a v8 release and ran the installer/upgrader again.

Hint: during install/upgrade not to solely rely on the version number in the database, but do some checks as well if new (needed) fields are present.



One problem remaining is Permalinks.
Not tested extensively, but they seem to be working. But on Permalinks admin page I have all most all options double! Tried reinstall, disabling and enabling to see if that would fix the doubles.

Rewrite Name Description
Articles
Disable·Edit· Reinstall

Enable Permalinks for the Articles on the site.
v1.0 by PHPFusion Dev Team
Articles
Disable·Edit· Reinstall

Enable Permalinks for the Articles on the site.
v1.0 by PHPFusion Dev Team
Blog
Disable·Edit· Reinstall

Enable Permalinks for the Blog on the site.
v1.0 by PHPFusion Dev Team
Blog
Disable·Edit· Reinstall

Enable Permalinks for the Blog on the site.
v1.0 by PHPFusion Dev Team