[Koha-bugs] [Bug 29418] Error searching for analytics in detail view

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29418

David Nind <david at davidnind.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |david at davidnind.com

--- Comment #26 from David Nind <david at davidnind.com> ---
This is now signed off by Katrin, but here are my testing notes for what they
are worth!

I'm not very familiar with analytical records, and I wasn't sure whether the ?
should be in the host record or the child/analytical record.

I tried combinations for the host record and the child/analytical record, and
for both.

I haven't changed the bug status.

(Hopefully, I recorded my observations correctly!)

Testing notes using koha-testing-docker
=======================================

Starting 21.05.x instance:
a) For Koha repository, git checkout 21.05.x
b) Edit koha-testing-docker .env file and change IMAGE=master to IMAGE=21.05

Set up an analytical record:
a) Enable the EasyAnalyticalRecords system preference
b) For any record, select Edit > Link to host record - choose any other record
(I tested with a record that had an item already attached to it)
c) For the record chosen as the host item, add a ? to the title

Used two records for testing:
- Host record: Programming Perl (biblionumber = 262)
- Child/analytical record: Perl best practices (biblionumber = 5)

Before the patch is applied
~~~~~~~~~~~~~~~~~~~~~~~~~~~

1. If only the host record has a ? in the title:
  - Viewing the host record in the staff interface - error displayed before the
title: "There was an error searching for analytic records, please see the logs
for details."
  - Viewing the host record in the OPAC - no visible error message displayed
(like in the staff interface), but there is an error message in the
/var/log/koha/kohadev/plack-opac-error.log log file:
    [2022/07/03 22:39:46] [WARN] CCL parsing error (10014) Embedded truncation
not supported ZOOM for query: Host-item=(Programming ? Perl /) at
/kohadevbox/koha/C4/Search.pm line 241.
    [2022/07/03 22:39:46] [WARN] Warning from simple_search_compat: CCL parsing
error (10014) Embedded truncation not supported ZOOM at
/kohadevbox/koha/opac/opac-detail.pl line 208.

2. If only the child/analytical record has a ? in the title:
   - Staff interface: 
     . Host record displays 'Analytics: Show analytics'
     . Clicking on 'Show analytics' link displays the child/analytical record
     . Error displayed before the title in the child/analytical record: "There
was an error searching for analytic records, please see the logs for details."
   - Viewing the host record in the OPAC
     . no error displayed
     . displays 'Analytics: Show analytics'
     . clicking on show analytics: child/analytical record displayed with no
error, but error in the logs as per 1
   - Viewing the child/analytical record in the OPAC:
     . no error displayed
     . but error in the logs as per 1

3. Both the host and child/analytical record have a ? in the title:
   . same as 1 for both the host and child/analytical record

After the patch is applied
~~~~~~~~~~~~~~~~~~~~~~~~~~

1. If only the host record has a ? in the title:
   - Staff interface:
     . Host record shows 'Analytics: Show analytics', no error messages
     . Clicking on the 'Show analytics' link: No results match your search for
'Host-item:(Programming ? Perl )'. 
     . Error in the /var/log/koha/kohadev/plack-intranet-error.log log file:
       [2022/07/03 23:40:01] [WARN] WARNING: query problem with
Host-item=(Programming ? Perl ) ZOOM error 10014 "CCL parsing error" (addinfo:
"Embedded truncation not supported") from diag-set 'ZOOM' at
/kohadevbox/koha/C4/Search.pm line 349.
   - OPAC:
     . Host record shows 'Analytics: Show analytics'
     . Error message in the /var/log/koha/kohadev/plack-opac-error.log log
file:
        [2022/07/03 23:41:25] [WARN] WARNING: query problem with
Host-item=(Programming ? Perl ) ZOOM error 10014 "CCL parsing error" (addinfo:
"Embedded truncation not supported") from diag-set 'ZOOM' at
/kohadevbox/koha/C4/Search.pm line 349.
        [2022/07/03 23:41:25] [WARN] Use of uninitialized value $times in
subtraction (-) at /kohadevbox/koha/C4/Search.pm line 1709.

2. If only the child/analytical record has a ? in the title: works as expected,
no errors in the log

3. Both the host and child/analytical record has a ?:
   - Staff interface and OPAC:
     . Host record shows 'Analytics: Show analytics'
     . Clicking on the 'Show analytics' link: No results match your search for
'Host-item:(Programming ? Perl )'.

-- 
You are receiving this mail because:
You are watching all bug changes.