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: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]

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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to