Problem after updating and also clean install Baikal 0.6.0: Calendars disappeared

[BobWs]

Baikal version: 0.4.6 to 0.6.0

Expected behaviour:

Current behaviour: Calendars disappeared

Steps to reproduce:

So I have a bit of a strange problem. After an successful update yesterday (after the fix #810)
I’ve noticed that not all my Calendars and events are showing in the admin dashboard properly. I’ve added some screenshots, as you can see the difference between before and after updating to the latest version 0.6.0

This is the result before updating Baikal server

Steps I have done trying to fix this:

1. restore the database with a recent backup (didn’t help)
2. created a new clean database and restore the data from a database backup
   Now it got worse, all my calendars disappeared only the Calendars events showing and my addressbooks with entries and my users. (see screenprint)

Result after updating baikal server to version 0.6.0 (Entries doesn't match)

To test my problem I installed this time a (clean) docker version of Baikal-server 0.6.0 with mariadb 10.4 and I had the same result as mentioned above. Then I reverted back to version 0.4.6 and everything was okay all my Calendars showed up an all the entries.

Result after restoring backup into a clean database. And an clean install of the docker version to see if the problem was also there.

When inspecting the database through phpmyadmin I can see all the Calendars, events, entries and users. But the Calendars don't show up in the dashboard of the adminpage.

So I’m a bit confused. How do I solve this?

Can you please help me figure out this problem?

[ByteHamster]

Result after restoring backup into a clean database.

A backup of the 0.4.6 database or the 0.6.0 database? You can not simply restore the old database to a new version of Baikal. Version 0.5.1 added a new calendarinstances table that now contains the data, while the calendars table just points to the instances. That's done automatically on upgrade but it looks like something went wrong on your end...

As for the number of events: That dashboard entry displays the number of rows in the calendaritems table. There were no changes in that table in the last few updates. I don't know where the different number here comes from.

[BobWs]

Result after restoring backup into a clean database.

A backup of the 0.4.6 database or the 0.6.0 database? You can not simply restore the old database to a new version of Baikal. Version 0.5.1 added a new calendarinstances table that now contains the data, while the calendars table just points to the instances. That's done automatically on upgrade but it looks like something went wrong on your end...

As for the number of events: That dashboard entry displays the number of rows in the calendaritems table. There were no changes in that table in the last few updates. I don't know where the different number here comes from.

The backup is a mysqldump from the 0.4.6 version. So How do I restore a 0.4.6 database backup into a 0.6.0 version? Also before I restored the database dump I just updated the server without touching the database.

[BobWs]

So I guess I could try this:

1. Reinstall version 0.4.6 and restore the 0.4.6 database dump
2. update to version 0.5.1 and if everything goes well that update to version 0.6.0
   Theoretically this should solve the problem. What do you think?

[ByteHamster]

How do I restore a 0.4.6 database backup into a 0.6.0 version?

Only by installing 0.4.6 and upgrading. Apart from doing the upgrades manually, there is no other way.

update to version 0.5.1 and if everything goes well that update to version 0.6.0
Theoretically this should solve the problem. What do you think?

I don't think this will have a higher chance at fixing things as directly upgrading. Baikal does all upgrade steps that are needed if you skip versions, too. Additionally, there was no database change between 0.5.1 and 0.6.0:

Baikal/Core/Frameworks/BaikalAdmin/Controller/Install/VersionUpgrade.php

Line 382 in 0a036ba

if (version_compare($sVersionFrom, '0.5.1', '<')) {

[BobWs]

Okay I will try to reinstall version 0.4.6 restore the 0.4.6 database and than update to version 0.6.0 and see what happens. I will report back!

[BobWs]

So it worked!
I've completely reinstalled version 0.4.6 with a clean Maraidb database, than I restored my 0.4.6 backup mysqldump. After this successfully restore I've updated the baikal-server to version 0.6.0 and after completion checking dashboard on adminpage everything was okay. All my calendars, users, addresbooks en entries where as before.

So thank you for clarifying thing for me!