MariaDB upgrade

[Stinger554]

Hello,

We are looking into upgrading our MariaDB version from 5.5.33 to at least MariaDB 10.1 and just wanted to see if there were any known issues that would occur from this upgrade. I spend some time looking searching but didn't really see any results and just want to see/verify that there were any known issues.

Thanks

[mflorell]

There are some behavior changes in how queries are treated, like the SQL_MODE that defaults to strict settings, which will not work with VICIdial's code.

[Stinger554]

There are some behavior changes in how queries are treated, like the SQL_MODE that defaults to strict settings, which will not work with VICIdial's code.

Understood. Are you aware of any configuration changes inside MariaDB that can be made to accommodate Vicidial's code or should we just not upgrade MariaDB?

[mflorell]

The settings changes are covered in this Issue Tracker ticket:
http://www.vicidial.org/VICIDIALmantis/view.php?id=1108

After you change the SQL_MODE setting, it should work with VICIdial.