Sun Jun 29 2025 20:30:14 UTC
I’ll getcha by Clark
Hide Search Description
80 bugs found.
ID Product Comp Assignee Status Resolution Summary Changed
3777 Koha Database gmcharlt REOPENED --- Datatypes in borrowers table are inconsistent 2023-10-07
813 Koha Database koha-bugs NEW --- OPAC lists should store comments 2024-03-22
7802 Koha Database gmcharlt NEW --- A MySQLism is used to get the current date. 2019-04-28
25667 Koha Database koha-bugs NEW --- Add field for items.notforloan_on to record when a notforloan status is applied 2024-05-01
14179 Koha Database koha-bugs NEW --- Field width for currency is wrong in the GUI 2023-08-16
3309 Koha Database gmcharlt NEW --- Deleting authorized values when data exists 2024-05-03
5334 Koha Database gmcharlt NEW --- Omnibus: Add explicit foreign key constraints 2024-10-21
11164 Koha Database gmcharlt NEW --- creator_batches table uses borrower_number not borrowernumber? 2020-01-08
11195 Koha Database gmcharlt NEW --- Rename biblioitems.publishercode into publisher 2020-01-05
13429 Koha Database gmcharlt NEW --- Add helper functions to create links in reports 2023-07-28
13542 Koha Database gmcharlt NEW --- Subscription is the only table to store userid instead of borrowernumber 2023-07-28
13833 Koha Database gmcharlt NEW --- biblionumber in deletedbiblio should not be autoincrement 2022-12-06
17306 Koha Database gmcharlt NEW --- Update scripts fail with Mysql 5.7 2020-01-11
18188 Koha Database gmcharlt NEW --- Should we rename items.booksellerid to items.acqsource ? 2020-01-11
6795 Koha Database koha-bugs NEW --- Library-specific OPAC preferences 2019-10-10
18176 Koha Database koha-bugs NEW --- aqbooksellers.listprice and aqbooksellers.invoiceprice need to be renamed for currencies 2020-01-11
19963 Koha Database koha-bugs NEW --- ethnicity and ethnicity tables and columns survived update 2022-12-06
20255 Koha Database koha-bugs NEW --- deletedbiblio_metadata id should not increment 2018-02-26
20269 Koha Database koha-bugs NEW --- Allow selecting default collate rule 2024-01-29
21062 Koha Database koha-bugs NEW --- Clean up borrower_password_recovery when patron is deleted 2018-07-11
22079 Koha Database koha-bugs NEW --- Store the borrowernumber of user returning item in associatedborrower in statistics table 2023-09-23
25083 Koha Database koha-bugs NEW --- List possible values for circulation_rules.rule_name in schema 2020-04-08
25878 Koha Database koha-bugs NEW --- Schema incorrectly describes course_items fields 2020-08-30
26493 Koha Database koha-bugs NEW --- Add missing FK constraints to aqbudgets 2021-10-28
26622 Koha Database koha-bugs NEW --- Unique Constraint on Authorised Values conflicts with use of Report Subgroup category 2021-01-05
26682 Koha Database koha-bugs NEW --- Allow authorised values to use "Other" value with free text 2020-10-14
26868 Koha Database koha-bugs NEW --- biblio and biblio_metadata tables timestamp do not update when moving an item 2023-12-09
27663 Koha Database koha-bugs NEW --- statistics table should have some way to include items.permanent_location 2023-06-16
29235 Koha Database koha-bugs NEW --- Export/Import configuration and basic data for testing 2023-06-24
29426 Koha Database koha-bugs NEW --- borrower_debarments.created is "ON UPDATE current_timestamp()" 2021-11-16
29677 Koha Database koha-bugs NEW --- Add more detailed serials logs 2021-12-10
29938 Koha Database koha-bugs NEW --- Allow a secondary database 2022-02-11
30414 Koha Database koha-bugs NEW --- Inconsistent (duplicated) FK constraint name: aqbudgets.aqbudgetperiods_ibfk_1 2022-04-07
30495 Koha Database koha-bugs NEW --- marc_modification_template_actions.action should be NOT NULL 2022-04-08
30496 Koha Database koha-bugs NEW --- message_attributes.message_name should be NOT NULL 2022-04-08
30951 Koha Database koha-bugs NEW --- Duplicate entry 'ar' for key 'PRIMARY' 2025-04-29
31172 Koha Database koha-bugs NEW --- Shouldn't issues.issuedate have a DEFAULT NOW() and be NOT NULL? 2022-07-18
32590 Koha Database koha-bugs NEW --- Add FK constraint for search_history.userid 2023-01-08
32700 Koha Database koha-bugs NEW --- Action logs logging should be divided into smaller components to reduce table size 2023-02-03
32719 Koha Database koha-bugs NEW --- db_revs 210600001 can take a long time 2023-01-27
34065 Koha Database koha-bugs NEW --- Remove unnecessary column-level collation settings for upgraded databases 2023-06-21
34428 Koha Database koha-bugs NEW --- Update database creates a wrong table transport_cost 2024-02-18
35712 Koha Database koha-bugs NEW --- Record issue_id in old_reserves for completed holds 2024-11-12
35898 Koha Database koha-bugs NEW --- Database update for encrypting vendor_edi_account passwords can be run twice 2024-01-25
35900 Koha Database koha-bugs NEW --- Different schema on MySQL 8 2024-01-24
36667 Koha Database koha-bugs NEW --- aqorders.quantity should be NOT NULL 2024-04-22
36969 Koha Database koha-bugs NEW --- Populate list of system preferences when first introduced in Koha database 2024-05-27
37599 Koha Database koha-bugs NEW --- Increase char limit of borrowers.userid database field 2024-08-08
37960 Koha Database koha-bugs NEW --- Prevent recording of duplicate circulation transactions 2024-09-18
38133 Koha Database koha-bugs NEW --- Create a touch_all_authorities.pl script 2024-12-12
38421 Koha Database koha-bugs NEW --- matchpoint_component_norms.norm_routine should be 'none' by default 2024-11-12
38634 Koha Database koha-bugs NEW --- marc21_framework_DEFAULT.yml refers to non-existant column biblioitems.cn_prefix 2024-12-05
38700 Koha Database koha-bugs NEW --- Add items table field to record transfer status 2024-12-16
38788 Koha Database koha-bugs NEW --- Fix '0000-00-00' issue on database 2024-12-27
38953 Koha Database koha-bugs NEW --- borrower_message_preferences.borrowernumber should not be DEFAULT NULL 2025-01-23
39107 Koha Database koha-bugs NEW --- kohastructure.sql doesn't load on new MySQL versions 2025-02-14
39150 Koha Database koha-bugs NEW --- Should borrowers.contacttitle be removed? 2025-02-17
39167 Koha Database koha-bugs NEW --- creator_layouts: scale_height and scale_width should be DECIMAL, not FLOAT 2025-02-19
39683 Koha Database koha-bugs NEW --- suggestion.copyrightdate and suggestion.publicationyear 2025-04-18
39935 Koha Database koha-bugs NEW --- Add a FK on `itemtypes` for the `items` table 2025-05-19
40054 Koha Database tomascohen NEW --- `items.itype` should be a FK 2025-06-02
30486 Koha Database koha-bugs ASSIGNED --- [OMNIBUS] Synchronize database schema with (older) database revisions 2024-07-19
20271 Koha Database koha-bugs In Discussion --- Merge deleted biblio, biblioitems, biblio_metadata, and items tables 2024-06-06
13668 Koha Database jonathan.druart In Discussion --- Creator of an SQL report shoudl be NULL when the staff patron is deleted 2024-01-17
7365 Koha Database koha-bugs In Discussion --- Koha should support PostgreSQL 2022-08-22
38062 Koha Database koha-bugs In Discussion --- If not using RecordLocalUseOnReturn, "Return" statistic is recorded regardless of whether item was checked out in the first place 2024-10-02
23066 Koha Database kyle In Discussion --- Add foreign key for issues tables to branches table for branchcodes 2019-12-03
36101 Koha Database lmstrand In Discussion --- Deleting an item removes the itemnumber from old_reserves when it should not 2024-03-19
36569 Koha Database andreas.jonsson Needs Signoff --- Compact action_logs indicies 2025-04-02
38906 Koha Database nick Needs Signoff --- REGEXP_REPLACE not in MySQL < 5.7b DB update 24.06.00.064 fails 2025-03-31
38922 Koha Database januszop Signed Off --- auth_header.origincode and auth_header.linkid never used -- shouldn't it be removed? 2025-04-04
32729 Koha Database lmstrand Failed QA --- Deleting an item removes the itemnumber from old_issues when it probably should not 2024-07-29
19316 Koha Database matt.blenkinsop Failed QA --- Items should have sort1 and sort2 fields 2024-11-21
26535 Koha Database didier.gautheron Patch doesn't apply --- Remove issues old_issues redundant indexes 2021-04-22
34142 Koha Database emmi.takkinen Patch doesn't apply --- Add column sub_location to items table 2025-05-08
13707 Koha Database olli-antti.kivi... Patch doesn't apply --- Adding a new column datereceived for items and biblioitems 2017-06-15
39062 Koha Database andrew Pushed to main --- Increase length of inventory number field in database 2025-05-26
40109 Koha Database baptiste.wojtko... Pushed to main --- Path to fix_invalid_dates.pl is incorrect in fix_invalid_dates.pl and search_for_data_inconsistencies.pl Tue 21:26
30888 Koha Database m.de.rooy Pushed to main --- Add a table for deletedauthorities 2025-05-26
38602 Koha Database emmi.takkinen Pushed to stable --- Columns bookings.creation_date and bookings.modification_date not added if multiple databases are in use 2025-06-19
80 bugs found.

as

File a new bug in the "Database" component of the "Koha" product