[Koha-bugs] [Bug 7065] reserves table needs a primary key

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

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

Kyle M Hall <kyle.m.hall at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Failed QA                   |Needs Signoff

--- Comment #6 from Kyle M Hall <kyle.m.hall at gmail.com> ---
(In reply to comment #4)

The problem was that the updates weren't using enough columns to ensure each
update worked on a unique row. This new version uses *every* column, so we
shouldn't have that problem now.

I also removed the print lines for each update, they really shouldn't have been
in there in the first place.

> This doesn't quite work for me. First of all, I'm a little dubious about
> listing every single change. Second, the update for old_reserves set the
> reservenumber to 0 for the first 1078 reserves in my database, leaving only
> 8 with valid reservenumbers. This led to the following error:
> DBD::mysql::db do failed: Duplicate entry '0' for key 'PRIMARY' at
> installer/data/mysql/updatedatabase.pl line 4960.

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are watching all bug changes.