[Bug 26407] New: fix query in 'title exists' in `search_for_data_inconsistencies.pl`
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 Bug ID: 26407 Summary: fix query in 'title exists' in `search_for_data_inconsistencies.pl` Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs@lists.koha-community.org Reporter: fridolin.somers@biblibre.com QA Contact: testopia@bugs.koha-community.org CC: robin@catalyst.net.nz Bug 23871 added check for 'title exists' to `search_for_data_inconsistencies.pl`. There is a typo in DBIx query to create or : hashref instead of arrayref. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 Fridolin SOMERS <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |23871 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23871 [Bug 23871] Add check for 'title exists' to `search_for_data_inconsistencies.pl` -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 Fridolin SOMERS <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED Assignee|koha-bugs@lists.koha-commun |fridolin.somers@biblibre.co |ity.org |m -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 Fridolin SOMERS <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |Trivial patch Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 --- Comment #1 from Fridolin SOMERS <fridolin.somers@biblibre.com> --- Created attachment 109754 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=109754&action=edit Bug 26407: fix query in 'title exists' in `search_for_data_inconsistencies.pl` Bug 23871 added check for 'title exists' to `search_for_data_inconsistencies.pl`. There is a typo in DBIx query to create or : hashref instead of arrayref. Test plan : 1) Change title of biblio record XXX in SQL : UPDATE biblio SET title = '' WHERE biblionumber=XXX 2) Change title of biblio record YYY in SQL : UPDATE biblio SET title = NULL WHERE biblionumber=YYY 3) Run misc/maintenance/search_for_data_inconsistencies.pl 4) Check you see both records -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #109754|0 |1 is obsolete| | --- Comment #2 from David Nind <david@davidnind.com> --- Created attachment 109763 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=109763&action=edit Bug 26407: fix query in 'title exists' in `search_for_data_inconsistencies.pl` Bug 23871 added check for 'title exists' to `search_for_data_inconsistencies.pl`. There is a typo in DBIx query to create or : hashref instead of arrayref. Test plan : 1) Change title of biblio record XXX in SQL : UPDATE biblio SET title = '' WHERE biblionumber=XXX 2) Change title of biblio record YYY in SQL : UPDATE biblio SET title = NULL WHERE biblionumber=YYY 3) Run misc/maintenance/search_for_data_inconsistencies.pl 4) Check you see both records Signed-off-by: David Nind <david@davidnind.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #109763|0 |1 is obsolete| | --- Comment #3 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 109942 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=109942&action=edit Bug 26407: fix query in 'title exists' in `search_for_data_inconsistencies.pl` Bug 23871 added check for 'title exists' to `search_for_data_inconsistencies.pl`. There is a typo in DBIx query to create or : hashref instead of arrayref. Test plan : 1) Change title of biblio record XXX in SQL : UPDATE biblio SET title = '' WHERE biblionumber=XXX 2) Change title of biblio record YYY in SQL : UPDATE biblio SET title = NULL WHERE biblionumber=YYY 3) Run misc/maintenance/search_for_data_inconsistencies.pl 4) Check you see both records Signed-off-by: David Nind <david@davidnind.com> Signed-off-by: Nick Clemens <nick@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to master Version(s)| |20.11.00 released in| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 --- Comment #4 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Pushed to master for 20.11, thanks to everybody involved! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 Lucas Gass <lucas@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lucas@bywatersolutions.com Version(s)|20.11.00 |20.11.00, 20.05.05 released in| | Status|Pushed to master |Pushed to stable --- Comment #5 from Lucas Gass <lucas@bywatersolutions.com> --- backported to 20.05.x for 20.05.05 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 Aleisha Amohia <aleisha@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |aleisha@catalyst.net.nz --- Comment #6 from Aleisha Amohia <aleisha@catalyst.net.nz> --- missing dependencies, not backported to 19.11.x -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26407 Bug 26407 depends on bug 23871, which changed state. Bug 23871 Summary: Add check for 'title exists' to `search_for_data_inconsistencies.pl` https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23871 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to master |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org