https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28029 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|minor |trivial Version|20.05 |master --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- It looks like the MariaDB version on ktd is too old to test this: 10.5.19-MariaDB-1:10.5.19+maria~ubu2004 The error I get indicates that the SQL statement was used as I entered it, but that the DBMS doesn't support it. So I think a change in Koha might not be needed: 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 '10 Joe, can you verify you were testing with 10.6 or later? MariaDB: https://mariadb.com/kb/en/select-offset-fetch/ MySQL seems to have had it for a while: https://dev.mysql.com/doc/refman/8.0/en/select.html https://dev.mysql.com/doc/refman/5.7/en/select.html -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.