[Koha-bugs] [Bug 5860] New: Adding duplicate stocknumber will fail silently

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5860

             Bug #: 5860
           Summary: Adding duplicate stocknumber will fail silently
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: master
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: critical
          Priority: P5
         Component: Cataloging
        AssignedTo: gmcharlt at gmail.com
        ReportedBy: katrin.fischer at bsz-bw.de
         QAContact: koha-bugs at lists.koha-community.org
                CC: ian.walls at bywatersolutions.com


To test:

Add new field 952 $i to framework and map to items.stocknumber.
Add a new item, make stocknumber 1.
Add another item, make stocknumber 1.

The second stocknumber will not be saved, because the items.stocknumber is
unique.

The logs show an error message:
[Sun Mar 13 22:12:37 2011] [error] [client ::1] [Sun Mar 13 22:12:37 2011]
additem.pl: DBD::mysql::st execute failed: Duplicate entry '1' for key
'itemstocknumberidx' at /home/katrin/kohaclone/C4/Items.pm line 1896., referer:
http://localhost:8080/cgi-bin/koha/cataloguing/additem.pl

We need an error message for the user like we have barcode, which is also
unique.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.