Database bugs
- Blocker
- Critical
- Major
- Normal
- Minor
- Trivial
- Enhancement
- New Feature
New 51
Update database creates a wrong table transport_cost
Error in SQL syntax when upgrading to 22.06.00.084
3309
GC
Deleting authorized values when data exists
Different schema on MySQL 8
Duplicate entry 'ar' for key 'PRIMARY'
borrower_debarments.created is "ON UPDATE current_timestamp()"
Add missing FK constraints to aqbudgets
11164
GC
creator_batches table uses borrower_number not borrowernumber?
7802
GC
A MySQLism is used to get the current date.
matchpoint_component_norms.norm_routine should be 'none' by default
Field width for currency is wrong in the GUI
13542
GC
Subscription is the only table to store userid instead of borrowernumber
Remove unnecessary column-level collation settings for upgraded databases
ethnicity and ethnicity tables and columns survived update
message_attributes.message_name should be NOT NULL
marc_modification_template_actions.action should be NOT NULL
Inconsistent (duplicated) FK constraint name: aqbudgets.aqbudgetperiods_ibfk_1
Schema incorrectly describes course_items fields
11195
GC
Rename biblioitems.publishercode into publisher
Record issue_id in old_reserves for completed holds
Create a touch_all_authorities.pl script
5334
GC
Omnibus: Add explicit foreign key constraints
Prevent recording of duplicate circulation transactions
Increase char limit of borrowers.userid database field
Populate list of system preferences when first introduced in Koha database
Add field for items.notforloan_on to record when a notforloan status is applied
aqorders.quantity should be NOT NULL
OPAC lists should store comments
Allow selecting default collate rule
Database update for encrypting vendor_edi_account passwords can be run twice
biblio and biblio_metadata tables timestamp do not update when moving an item
Store the borrowernumber of user returning item in associatedborrower in statistics table
13429
GC
Add helper functions to create links in reports
Export/Import configuration and basic data for testing
statistics table should have some way to include items.permanent_location
Action logs logging should be divided into smaller components to reduce table size
db_revs 210600001 can take a long time
Add FK constraint for search_history.userid
13833
GC
biblionumber in deletedbiblio should not be autoincrement
Shouldn't issues.issuedate have a DEFAULT NOW() and be NOT NULL?
Allow a secondary database
Add more detailed serials logs
Unique Constraint on Authorised Values conflicts with use of Report Subgroup category
Allow authorised values to use "Other" value with free text
List possible values for circulation_rules.rule_name in schema
aqbooksellers.listprice and aqbooksellers.invoiceprice need to be renamed for currencies
18188
GC
Should we rename items.booksellerid to items.acqsource ?
17306
GC
Update scripts fail with Mysql 5.7
Library-specific OPAC preferences
Clean up borrower_password_recovery when patron is deleted
deletedbiblio_metadata id should not increment
Assigned 1
[OMNIBUS] Synchronize database schema with (older) database revisions
In discussion 6
If not using RecordLocalUseOnReturn, "Return" statistic is recorded regardless of whether item was checked out in the first place
36101
LS
Deleting an item removes the itemnumber from old_reserves when it should not
Merge deleted biblio, biblioitems, biblio_metadata, and items tables
13668
JD
Creator of an SQL report shoudl be NULL when the staff patron is deleted
Koha should support PostgreSQL
23066
KMH(
Add foreign key for issues tables to branches table for branchcodes
Failed QA 2
19316
MB
Items should have sort1 and sort2 fields
32729
LS
Deleting an item removes the itemnumber from old_issues when it probably should not
Patch doesn't apply 2
26535
DG
Remove issues old_issues redundant indexes
13707
OK
Adding a new column datereceived for items and biblioitems
Signed off 1
30888
MDR
Add a table for deletedauthorities
Pushed to main 2
38434
TG(
(Bug 35906 follow-up) dbrev different from kohastructure.sql
22421
MR(
accountlines.issue_id is missing a foreign key constraint
Needs documenting 1
37476
TCA(
RANK is a reserved word in MySQL 8.0.2+