Summary: | fix query in 'title exists' in `search_for_data_inconsistencies.pl` | ||
---|---|---|---|
Product: | Koha | Reporter: | Fridolin Somers <fridolin.somers> |
Component: | Command-line Utilities | Assignee: | Fridolin Somers <fridolin.somers> |
Status: | CLOSED FIXED | QA Contact: | Testopia <testopia> |
Severity: | normal | ||
Priority: | P5 - low | CC: | aleisha, lucas, robin |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | Trivial patch |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: |
20.11.00, 20.05.05
|
|
Circulation function: | |||
Bug Depends on: | 23871 | ||
Bug Blocks: | |||
Attachments: |
Bug 26407: fix query in 'title exists' in `search_for_data_inconsistencies.pl`
Bug 26407: fix query in 'title exists' in `search_for_data_inconsistencies.pl` Bug 26407: fix query in 'title exists' in `search_for_data_inconsistencies.pl` |
Description
Fridolin Somers
2020-09-08 14:52:34 UTC
Created attachment 109754 [details] [review] 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 Created attachment 109763 [details] [review] 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> Created attachment 109942 [details] [review] 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> Pushed to master for 20.11, thanks to everybody involved! backported to 20.05.x for 20.05.05 missing dependencies, not backported to 19.11.x |