DB Error from CRM_Contact_BAO_Contact::triggerInfo when enabling/disabling extensions
I just switched to a new localhost with a bleeding-edge LAMPP stack:
- PHP 7.3.11
- MariaDB 10.4.8
- Apache 2.4.41
I was able to setup buildkit and install a site, but when enabling/disabling an extension I get:
DB Error: unknown error bubbling up from
Civi\Core\SqlTriggers->rebuild(). The offending query is
"DROP FUNCTION IF EXISTS civicrm_strip_non_numeric" called by
"Unknown error" isn't much to go on so I'm posting this to see if anyone has encountered this as well. If my
theory hunch is right then it's due to my newer-than-recommended MariaDB version.
So far I've tried removing the
DROP FUNCTION query and having it just do the subsequent
CREATE FUNCTION (I appended
IF EXISTS) but that too crashes with "unknown error".