Bug 5860: Adding duplicate stocknumber fails silently
authorKatrin Fischer <Katrin.Fischer.83@web.de>
Mon, 4 Apr 2011 11:20:20 +0000 (11:20 +0000)
committerChris Cormack <chrisc@catalyst.net.nz>
Mon, 4 Apr 2011 21:16:36 +0000 (09:16 +1200)
commita8ffb2273b63c398492a7cbd08394adedb2aeadb
tree98bf45e3701a3448409bcc873c8d1e483e0f0b70
parentf22b8bcd458df8d8fad29070a7b95a63b6d356a2
Bug 5860: Adding duplicate stocknumber fails silently

When adding a duplicate stocknumber the duplicate was not saved to the database.
This happened, because the field stocknumber in table items was declared to be unique.
Discussion on bug suggests to lift this restriction.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Tested. Corrected typo in updatedatabase script. Version 3.01.00.095 introduced the index with double s, although structure had only one s in index name.
Unaware of this bug, I entered the more general bug 6041 for similar problems with modifying items.
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl