Database bugs
- Blocker
- Critical
- Major
- Normal
- Minor
- Trivial
- Enhancement
- New Feature
New 59
kohastructure.sql doesn't load on new MySQL versions
Fix '0000-00-00' issue on database
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.
creator_layouts: scale_height and scale_width should be DECIMAL, not FLOAT
borrower_message_preferences.borrowernumber should not be DEFAULT NULL
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
Should borrowers.contacttitle be removed?
auth_header.origincode probably never used -- shouldn't it be removed?
Add items table field to record transfer status
Create a touch_all_authorities.pl script
marc21_framework_DEFAULT.yml refers to non-existant column biblioitems.cn_prefix
Record issue_id in old_reserves for completed holds
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
Needs signoff 2
38906
NC(
REGEXP_REPLACE not in MySQL < 5.7b DB update 24.06.00.064 fails
36569
AJ
Compact action_logs indicies
Signed off 1
34142
ET
Add column sub_location to items table
Passed QA 1
39062
AF
Increase length of items.stocknumber (Inventory Number)
Pushed to main 2
22421
MR(
accountlines.issue_id is missing a foreign key constraint
30888
MDR
Add a table for deletedauthorities
Needs documenting 1
37476
TCA(
RANK is a reserved word in MySQL 8.0.2+