Bugzilla – Bug List
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Sun Jun 29 2025 20:30:14 UTC
I’ll getcha by Clark
Hide Search Description
Product:
Koha
Component:
Database
Status:
UNCONFIRMED, REOPENED, NEW, CONFIRMED, ASSIGNED, In Discussion, Needs Signoff, Signed Off, Passed QA, Failed QA, Patch doesn't apply, Pushed to main, Pushed to stable, Pushed to oldstable, Pushed to oldoldstable, Pushed to oldoldoldstable, Needs documenting, BLOCKED
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.
Change Columns
Edit Search
as
File a new bug in the "Database" component of the "Koha" product