[Koha-bugs] [Bug 15079] Batch Delete Records Error

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

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

--- Comment #6 from Héctor Eduardo Castro Avalos <hector.hecaxmmx at gmail.com> ---
(In reply to Kyle M Hall from comment #5)
> Looks like the issue is related to deleteditems having the same itemnumber
> is an item that is going to be deleted:
> 
> http://screencast.com/t/jTd5b2DcB3A
> 
> After clearing out duplicate itemnumber from deleteditems:
> 
> http://screencast.com/t/PJxpEkf1DP

How itemnumber is corrupted in the table?  I mean it is a unique Id even though
if you execute something like this

UPDATE items SET itemnumber='1' WHERE itemnumber='2';
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'

MYSQL doesn't let to do this kind of operations.

-- 
You are receiving this mail because:
You are watching all bug changes.