https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33183 --- Comment #1 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 148017 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=148017&action=edit Bug 33183: Error inserting matchpoint_components when creating record matching rules with MariaDB 10.6 The word "offset" is now a keyword. At the very least we need to escape the fieldname with backticks. It would be nice to switch to Koha::Objects for this module eventually. C4::Matcher::_store_matchpoint(): DBI Exception: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, length) VALUES ('27', '1', '999'...' at line 2 at /usr/share/koha/lib/C4/Matcher.pm line 314 Test Plan: 1) Set up Koha with MariaDB 10.6 2) Attempt to create a matching rule 3) Note the error screen 4) Apply this patch 5) Restart all the things! 6) Attempt to create another matching rule 7) No errors this time -- You are receiving this mail because: You are watching all bug changes.