MariaDB Usage
MariaDB unfortunately does not contain by default the BIN_TO_UUID and UUID_TO_BIN functions Yet Another Warning System uses for performance reasons.
If you are running MariaDB, you will need to run a query to create these functions. There's a handy polyfill here you can copy and paste in to do this.
Without doing this, MariaDB will NOT WORK and simply error the addon out.
Simply open your database managment software, and run this query:
DELIMITER //
CREATE FUNCTION BIN_TO_UUID(b BINARY(16))
RETURNS CHAR(36)
BEGIN
DECLARE hexStr CHAR(32);
SET hexStr = HEX(b);
RETURN LOWER(CONCAT(
SUBSTR(hexStr, 1, 8), '-',
SUBSTR(hexStr, 9, 4), '-',
SUBSTR(hexStr, 13, 4), '-',
SUBSTR(hexStr, 17, 4), '-',
SUBSTR(hexStr, 21)
));
END//
CREATE FUNCTION UUID_TO_BIN(uuid CHAR(36))
RETURNS BINARY(16)
BEGIN
RETURN UNHEX(REPLACE(uuid, '-', ''));
END//
DELIMITER ;
If you need, theres a .sql file inside yet_another_warn_system/lua/yaws/yaws_polyfill.sql that you can use instead.
If you continue to have issues, drop a ticket and I'll help you out.