[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 M. Tompsett changed: What|Removed |Added See Also||http://bugs.koha-community.

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Jonathan Druart changed: What|Removed |Added Blocks||11784 -- You are receivin

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Galen Charlton changed: What|Removed |Added Status|Passed QA |Pushed to Master --- Commen

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Galen Charlton changed: What|Removed |Added Status|Signed Off |Passed QA -- You are recei

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Srdjan Jankovic changed: What|Removed |Added Attachment #21923|0 |1 is obsolete|

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Srdjan Jankovic changed: What|Removed |Added Status|Needs Signoff |Signed Off -- You are rec

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Kyle M Hall changed: What|Removed |Added Attachment #20801|0 |1 is obsolete|

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Kyle M Hall changed: What|Removed |Added Status|Patch doesn't apply |Needs Signoff -- You are rece

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 I'm just a bot changed: What|Removed |Added Status|Needs Signoff |Patch doesn't apply

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 --- Comment #11 from Srdjan Jankovic --- Kyle, I'm afraid DELETE FROM patronimage WHERE cardnumber NOT IN ( SELECT cardnumber FROM borrowers ) is not good. Logically it is ok, however the number of borrowers can be so huge that it wil

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Kyle M Hall changed: What|Removed |Added Attachment #20765|0 |1 is obsolete|

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 --- Comment #9 from Srdjan Jankovic --- 1. I had problems with either borrowers changing card numbers, or being removed (have no idea what is possible, but the situation is real, I'm using a clients prod dump). In order to establish n

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 --- Comment #8 from Kyle M Hall --- That sounds good to me! > If you are happy I'll proceed with sign-off, and we'll let QA team cast the > final verdict. -- You are receiving this mail because: You are watching all bug changes. __

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 --- Comment #7 from Srdjan Jankovic --- No, this is as good as it can be. The only thing that I'm not sure of is whether you should reinstate AutoCommit and RaiseError straight after eval. I hate to admit that whenever I had a db upda

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 --- Comment #6 from Kyle M Hall --- Thanks for the info! Does this new patch have a more sensible database update? Kyle (In reply to Srdjan Jankovic from comment #4) > DDL statements ( ALTER TABLE ) cannot be rolled back, and should

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Kyle M Hall changed: What|Removed |Added Attachment #20724|0 |1 is obsolete|

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Srdjan Jankovic changed: What|Removed |Added CC||srd...@catalyst.net.nz ---

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Kyle M Hall changed: What|Removed |Added Attachment #20723|0 |1 is obsolete|

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Kyle M Hall changed: What|Removed |Added Attachment #20722|0 |1 is obsolete|

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Kyle M Hall changed: What|Removed |Added CC||k...@bywatersolutions.com

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Kyle M Hall changed: What|Removed |Added Status|ASSIGNED|Needs Signoff -- You are rece

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 --- Comment #1 from Kyle M Hall --- Created attachment 20722 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=20722&action=edit Bug 10636 - patronimage should have borrowernumber as PK, not cardnumber Test Plan: 1) Ap

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Galen Charlton changed: What|Removed |Added Blocks||8798 -- You are receiving

[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 Galen Charlton changed: What|Removed |Added Status|NEW |ASSIGNED -- You are receiv