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 CRM_Contact_BAO_Contact::triggerInfo
.
"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".