Bugzilla – Bug List
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Mon Sep 29 2025 23:00:26 UTC
How many programmers does it take to screw in a light bulb? None- that's a hardware issue
Hide Search Description
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
Product:
Koha
79 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
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
2025-08-26
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
---
Make clear in historical data when a checkout fills a hold
2025-09-04
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
2025-08-14
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
14179
Koha
Database
koha-bugs
ASSIGNED
---
Field width for currency is wrong in the GUI
2025-07-17
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
Wed 16:21
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
34142
Koha
Database
emmi.takkinen
Needs Signoff
---
Add column sub_location to items table
2025-08-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
38922
Koha
Database
januszop
Patch doesn't apply
---
auth_header.origincode and auth_header.linkid never used -- shouldn't it be removed?
2025-07-25
13707
Koha
Database
olli-antti.kivi...
Patch doesn't apply
---
Adding a new column datereceived for items and biblioitems
2017-06-15
38906
Koha
Database
nick
Pushed to stable
---
REGEXP_REPLACE not in MySQL < 5.7b DB update 24.06.00.064 fails
2025-09-20
40109
Koha
Database
baptiste.wojtko...
Pushed to oldstable
---
Path to fix_invalid_dates.pl is incorrect in fix_invalid_dates.pl and search_for_data_inconsistencies.pl
2025-07-25
39062
Koha
Database
andrew
Needs documenting
---
Increase length of inventory number field in database
2025-08-04
30888
Koha
Database
m.de.rooy
Needs documenting
---
Add a table for deletedauthorities
2025-08-27
79 bugs found.
Change Columns
Edit Search
as
File a new bug in the "Database" component of the "Koha" product