https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38906 --- Comment #8 from Nick Clemens (kidclamp) <nick@bywatersolutions.com> --- (In reply to Jonathan Druart from comment #3)
Are you sure the patch is correct?
What versions are you on? Your MariaDB connection id is 59988 Server version: 10.5.28-MariaDB-ubu2004 mariadb.org binary distribution Debian GNU/Linux 12 (bookworm) When I run your SQL: MariaDB [koha_kohadev]> select REGEXP_REPLACE(columnname, '.*holdings_', ''), SUBSTRING(columnname,LOCATE("_",columnname)+1) from columns_settings WHERE module = 'catalogue' AND page='detail' AND tablename = "holdings_table"; +-----------------------------------------------+------------------------------------------------+ | REGEXP_REPLACE(columnname, '.*holdings_', '') | SUBSTRING(columnname,LOCATE("_",columnname)+1) | +-----------------------------------------------+------------------------------------------------+ | actions | actions | | barcode | barcode | | booksellerid | booksellerid | | ccode | ccode | | checkbox | checkbox | | copynumber | copynumber | | course_reserves | course_reserves | | cover_image | cover_image | | dateaccessioned | dateaccessioned | | datelastborrowed | datelastborrowed | | enumchron | enumchron | | holdingbranch | holdingbranch | | homebranch | homebranch | | hostrecord | hostrecord | | issues | issues | | item_group | item_group | | itemcallnumber | itemcallnumber | | itemnotes | itemnotes | | itemnotes_nonpublic | itemnotes_nonpublic | | itype | itype | | lastseen | lastseen | | localuse | localuse | | location | location | | materials | materials | | renewals | renewals | | spinelabel | spinelabel | | status | status | | stocknumber | stocknumber | | uri | uri | | usedin | usedin | +-----------------------------------------------+------------------------------------------------+ 30 rows in set (0.010 sec) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.