Baikal: Upgrading from 0.4.6 to newer version same as #810

[BobWs]

Baikal version: 0.4.6 to 0.6.0

• [ x] I have searched open and closed issues for duplicates
• [ x] I have installed the release zip, not the source code zip
• [ x] I have moved the whole, untouched Specific folder to the new installation

Problem:
I Upgraded my baikal 0.4.6 on Synology with PHP 7.3 and apache 2.4 but I'm getting the same error as #810. (Sorry for creating a new issue couldn't reopen issue #810)

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'baikal.calendarinstances' doesn't exist in /volume1/web/baikal/Core/Frameworks/Flake/Core/Database.php:180 Stack trace: #0 /volume1/web/baikal/Core/Frameworks/Flake/Core/Database.php(180): PDO->query('SELECT count(*)...') #1 /volume1/web/baikal/Core/Frameworks/Flake/Core/Requester/Sql.php(202): Flake\Core\Database->query('SELECT count(*)...') #2 /volume1/web/baikal/Core/Frameworks/BaikalAdmin/Controller/Dashboard.php(48): Flake\Core\Requester\Sql->count() #3 /volume1/web/baikal/Core/Frameworks/Flake/Core/Render/Container.php(69): BaikalAdmin\Controller\Dashboard->render() #4 /volume1/web/baikal/Core/Frameworks/Flake/Controller/Page.php(85): Flake\Core\Render\Container->renderBlocks() #5 /volume1/web/baikal/html/admin/index.php(92): Flake\Controller\Page->render() #6 {main}

I've deleted every thing except the Specifc folder. Got the update screen (green button) after that I've got a screen said update successful start using admin page, and than I got this error message.

So I've tried next step by deleting everything incl. Specfic en reinstalled Baikal, configured as new. But still the error.

Any idea how to solve this?

[ByteHamster]

Do you use MySQL or SQLite? What tables does your database have? Could you please post your database schema? This can be dumped using the following command: mysqldump -u root -p --no-data dbname > schema.sql. Looking at the error message, I think that somehow your database was upgraded to 0.5.1 but Baikal believes that it's already 0.5.2 (or newer). Did you try to install 0.5.x versions earlier?

[BobWs]

Do you use MySQL or SQLite? What tables does your database have? Could you please post your database schema? This can be dumped using the following command: mysqldump -u root -p --no-data dbname > schema.sql. Looking at the error message, I think that somehow your database was upgraded to 0.5.1 but Baikal believes that it's already 0.5.2 (or newer). Did you try to install 0.5.x versions earlier?

I'm Using maraidb 10 on synology. I did updated the baikal server once before to 0.5.1 but then I received an error (can't remember what is was to long a go). The I reverted back to 0.4.6
After that I didn't upgrade anymore until totday, thought to give it another try with 0.6.0

I'm going try to make a database dump for you

[ByteHamster]

I did updated the baikal server once before to 0.5.1 but then I received an error (can't remember what is was to long a go). The I reverted back to 0.4.6

How did you revert? Restored a full backup or just replaced the installation with the older version's files? I have a feeling that this failed upgrade is responsible for the problems you face now.

I have a dangerous idea what you could do. Please create a backup of the Specific folder and the database first. Then make sure you have the 0.6.0 code installed. After that, set BAIKAL_CONFIGURED_VERSION in Specific/config.system.php to 0.5.0 and start the admin interface to execute upgrade process again. If there are errors, please post them.

[BobWs]

I did updated the baikal server once before to 0.5.1 but then I received an error (can't remember what is was to long a go). The I reverted back to 0.4.6

How did you revert? Restored a full backup or just replaced the installation with the older version's files? I have a feeling that this failed upgrade is responsible for the problems you face now.

I have a dangerous idea what you could do. Please create a backup of the Specific folder and the database first. Then make sure you have the 0.6.0 code installed. After that, set BAIKAL_CONFIGURED_VERSION in Specific/config.system.php to 0.5.0 and start the admin interface to execute upgrade process again. If there are errors, please post them.

Okay I'm going to try that

[BobWs]

Thanks it is fxed! That did the trick