Migrating 18.8 to 21.4 fails utterly, breaks layout

• Bug

I have test-upgraded my test site (which is a copy of the productive site with slightly less content, but duplicate files, layout, CSS) and upgrading failed. Miserably.

First, there was one (1) SQL error:

UPDATE `users_objectpermissions` SET `permName` = 'tiki_p_read_article' WHERE `permName` = 'tiki_p_topic_read' AND `objectType` = 'topic'
                                Duplicate entry '4dadd7eebd7a5fc8790114f9f5aaa8b6-topic-Anonymous-tiki_p_read_art' for key 'PRIMARY'

For the moment, I checked the checkmark in order to proceed (it's not the productive site anyway, and I have a backup of both the files and the DB).

After logging in, I was flabbergasted. I thought my layout (originally done by Gary to imitate a standard layout of 12.14 that was dropped with later updates: Geo) was kind of conservative, absolutely nothing fancy. Standard, classic Tiki layout with 3 containers, a header, a left module zone, a center wiki content and a right module zone.

There is one horizontal menu which was VERY hard to create on 18.8 (because creating menus from scratch is simply not possible (at all) on 18.8., due to an unfixed bug. I made it possible with a trick, I created a second standard menu, exported it, modified it as needed, and re-imported.

Since at that time I did not want to indulge in the depths of the CSS, I created style directives in the context of the menu, which worked satisfactorily. Most of the site is classic Wiki content. Some articles for news, a calendar (which was horribly bug-ridden and thus dysfunctional on 18.8) and a small shop (CART).

So nothing fancy at all. No categories (besides what CART brought with it), no perspectives, etc.

And now the catastrophe: The left module zone is now sitting on the right, and the right module zone went to far-right. Yes, both left and right module zone now sit on the right-hand side.

The menu is a mess with wrong fonts, wrong sizing, wrong spacing etc.

When I call the control panels, they come up as one column (!) in a seemingly endless page, hardly usable at all.

This is the worst upgrade I have ever witnessed. And I thought 12.14 -> 18.2 was a bad. Little did I know...

I checked the look & feel setting, found nothing special in there, it is still on "classic Tiki 3 container". The admin setting was off, to "1 container", but setting that to "Classic Tiki 3 container" to match the site's default changed nothing...

If Tiki keeps breaking my layouts, I am seriously considering to let go. If it weren't for more than one decade of content, I would be gone already. Enough is enough.

This bug has been demonstrated on show2.tiki.org

Please demonstrate your bug on show2.tiki.org