[Koha-bugs] [Bug 23330] New: deleteditemsstocknumberidx should not be a unique index
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Jul 17 10:21:53 CEST 2019
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23330
Bug ID: 23330
Summary: deleteditemsstocknumberidx should not be a unique
index
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Database
Assignee: koha-bugs at lists.koha-community.org
Reporter: dcook at prosentient.com.au
QA Contact: testopia at bugs.koha-community.org
At the moment, deleteditemsstocknumberidx is a unique index, which means that
an item will fail to delete if its "Inventory number" already exists in the
deleteditems table.
Its counterpart itemsstocknumberidx was renamed to itemstocknumberidx in
version 3.03.00.042 (dating from April/May 2011) and made non-unique.
I've worked on Koha since early 2012 and only today have I had someone stung by
this problem. They've been storing "Copy number" in "Inventory number" for some
reason, and it's caught them out.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list