migrating baikal from one server to another with mysql mariaDB Distrib 10.4*

[gstlouisgit]

I thought I would share this - no action needs to be taken

My current server env:
virtualmin
centos7
httpd
php 5.6
mysql Ver 14.14 Distrib 5.7.27, for Linux (x86_64) using EditLine wrapper

My new server
virtualmin
centos7
httpd
php 7.3
mysql Ver 15.1 Distrib 10.3.17-MariaDB, for Linux (x86_64) using readline 5.1

I had previously installed mariaDB Distrib 10.4* on the "new server", but when I would mysqldump baikal (from old server) and import it to this mysql server it would not import all my records and I would get an error when trying to access my default calendar through the link

ErrorException: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/smbservices/domains/cal.smbservices.ca/public_html/vendor/sabre/dav/lib/CalDAV/ICSExportPlugin.php:321

I assumed this was because my previous server was not dumping the records properly causing invalid characters or broken records and php would crash looping records. But no.

finally I imported this on another test machine using mysql 10.3* and it imported just fine. So I remove mysql 10.4 and install the 10.3.17 stated above under "My new server"

now everything works fine that I can see and when I hit my default cal link I can see all the ics.

so, weird but importing with mysql 10.4 was really not working. I would always do select count(*) from calendarobjects; to see if my row count was always the same is how I started seeing this problem.

it would import about 148 records but I had 700+...

[gstlouisgit]

looks like I misspoke. The error is still there.

ErrorException: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/domain/domains/cal.domain.ca/public_html/vendor/sabre/dav/lib/CalDAV/ICSExportPlugin.php:321
Stack trace:
#0 /home/domain/domains/cal.domain.ca/public_html/vendor/composer/ClassLoader.php(444): Baikal\Framework::exception_error_handler(2, '"continue" targ...', '/home/smbservic...', 321, Array)
#1 /home/domain/domains/cal.domain.ca/public_html/vendor/composer/ClassLoader.php(444): include()
#2 /home/domain/domains/cal.domain.ca/public_html/vendor/composer/ClassLoader.php(322): Composer\Autoload\includeFile('/home/smbservic...')
#3 [internal function]: Composer\Autoload\ClassLoader->loadClass('Sabre\CalDAV\IC...')
#4 /home/domain/domains/cal.domain.ca/public_html/Core/Frameworks/Baikal/Core/Server.php(170): spl_autoload_call('Sabre\CalDAV\IC...')
#5 /home/domain/domains/cal.domain.ca/public_html/Core/Frameworks/Baikal/Core/Server.php(112): Baikal\Core\Server->initServer()
#6 /home/domain/domains/cal.domain.ca/public_html/html/dav.php(59): Baikal\Core\Server->__construct(true, true, 'Basic', 'BaikalDAV', Object(PDO), '/dav.php/')
#7 {main}

is this a PHP version issue?

my records in the database seem fine and have the same records as my old server.

[ByteHamster]

is this a PHP version issue?

Yes. We currently only support php 7.2. Support for 7.3 is already implemented but not released yet because the most recent sabre/dav dependency contains some errors.

[gstlouisgit]

in the end, after missing around with all sort of options. I downgraded to php 7.1 and it now seems to be working.

still weird about the certain mysql not importing all records though!

[gstlouisgit]

@ByteHamster
Thanks for replying. Is there really that much a difference between 7.2 and 7.3?

[ByteHamster]

sabre/dav only needed a few lines to be updated to support php 7.3

[ByteHamster]

Version 0.6.0 with support for php 7.3 is now available.