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

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Apr 18 12:03:10 CEST 2011


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

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|FIXED                       |

--- Comment #7 from Katrin Fischer <katrin.fischer at bsz-bw.de> 2011-04-18 10:03:10 UTC ---
This patch needs a follow-up for 3.2.x and master.

Problem: The applied patch and update will work only for databases created
after the stocknumber field was added to the items table.

For databases created before stocknumber was introduced to the database the
update will fail with an error message and the unique attribute will not be
removed.

The problem is, that the indexname in kohastructure.pl is different to the name
in updatadatabase.pl:

kohastructur.sql:
1033   KEY `itemstocknumberidx` (`stocknumber`),

updatadatabase.pl:
3251  ALTER TABLE items ADD UNIQUE INDEX itemsstocknumberidx (stocknumber);

I am not sure how to solve this so that no error message will be shown while
updating the database. And not sure I can work on this in time for the 3.4
release. If someone else has time and is able to fix this - please do.

-- 
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.


More information about the Koha-bugs mailing list