XF 2.2 database error after changing DB from "mysql" to "mariaDB"

[Hoib3rgA]

Hello,
my provider moved my account to an other space, using mariaDB on the new root.

PHP-Version
7.3.26

MySQL-Version
10.3.27 (10.3.27-MariaDB-1:10.3.27+maria~stretch)

Before this, everthing was fine!
Now, by using mariaDB i get this error, when i try to open the "style options":

XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now in src/XF/Db/AbstractStatement.php at line 228

    XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
    XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 134
    XF\Db\Mysqli\Statement->fetchRowValues() in src/XF/Db/AbstractStatement.php at line 93
    XF\Db\AbstractStatement->fetchAliasGrouped() in src/XF/Mvc/Entity/Finder.php at line 1381
    XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/StyleProperty.php at line 56
    XF\Repository\StyleProperty->getUngroupedPropertyMapsInStyle() in src/XF/Admin/Controller/Style.php at line 253
    XF\Admin\Controller\Style->actionStyleProperties() in src/XF/Mvc/Dispatcher.php at line 350
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    XF\App->run() in src/XF.php at line 488
    XF::runApp() in admin.php at line 13

The Serverlog says:

    XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now src/XF/Db/AbstractStatement.php:228

    Generiert von: Chris 14 Januar 2021 um 14:24

Stack-Trace

            SELECT `xf_option_group_relation`.*, `xf_option_Option_1`.*, `xf_option_group_OptionGroup_2`.*
            FROM `xf_option_group_relation`
            INNER JOIN `xf_option` AS `xf_option_Option_1` ON (`xf_option_Option_1`.`option_id` = `xf_option_group_relation`.`option_id`)
INNER JOIN `xf_option_group` AS `xf_option_group_OptionGroup_2` ON (`xf_option_group_OptionGroup_2`.`group_id` = `xf_option_group_relation`.`group_id`)
            WHERE (`xf_option_Option_1`.`addon_id` = 'ITM/GetTMSBack') AND (`xf_option_group_OptionGroup_2`.`debug_only` = 0)
            ORDER BY `xf_option_group_OptionGroup_2`.`display_order` ASC, `xf_option_group_relation`.`display_order` ASC, `xf_option_Option_1`.`option_id` ASC
        
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL fetch err...', 2014, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(134): XF\Db\Mysqli\Statement->getException('MySQL fetch err...', 2014, 'HY000')
#2 src/XF/Db/AbstractStatement.php(93): XF\Db\Mysqli\Statement->fetchRowValues()
#3 src/XF/Mvc/Entity/Finder.php(1381): XF\Db\AbstractStatement->fetchAliasGrouped()
#4 src/XF/Repository/Option.php(94): XF\Mvc\Entity\Finder->fetch()
#5 src/XF/Admin/Controller/AddOn.php(221): XF\Repository\Option->getGroupsAndOptionsForAddOn('ITM/GetTMSBack')
#6 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\AddOn->actionControls(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Controls', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\AddOn), NULL)
#8 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\AddOn), NULL)
#9 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#11 src/XF.php(488): XF\App->run()
#12 admin.php(13): XF::runApp('XF\\Admin\\App')
#13 {main}

array(4) {
  ["url"] => string(172) "/admin.php?add-ons/ITM-GetTMSBack/controls&_xfRequestUri=%2Fadmin.php%3Fadd-ons%2F&_xfWithData=1&_xfToken=1610634245%2C802127b2078d942c886fa2b09ad7e67c&_xfResponseType=json"
  ["referrer"] => string(45) "http://www.zafira-forum.de/admin.php?add-ons/"
  ["_GET"] => array(5) {
    ["add-ons/ITM-GetTMSBack/controls"] => string(0) ""
    ["_xfRequestUri"] => string(19) "/admin.php?add-ons/"
    ["_xfWithData"] => string(1) "1"
    ["_xfToken"] => string(43) "1610634245,802127b2078d942c886fa2b09ad7e67c"
    ["_xfResponseType"] => string(4) "json"
  }
  ["_POST"] => array(0) {
  }
}

 

[Hoib3rgA]

i think, it was a wrong settings of "strict_mode / sql_mode".
At the moment everything is fine