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

            Bug ID: 43488
           Summary: The location field contains parentheses: `Boadilla del
                    Monte (Madrid)`. If these are not properly escaped or
                    enclosed in quotes from the parser's perspective, the
                    system might misinterpret the inner closing
                    parenthesis `)` as the end of a command group ra
   Initiative type: ---
        Sponsorship ---
            status:
           Product: Koha
           Version: 26.05
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Searching
          Assignee: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]
  Target Milestone: ---

WARNING: query problem with (rk=(kw,wrdl,rtrn="ccl=pl:"Boadilla del Monte
(Madrid)" and se:El barco de vapor. [Serie blanca] and se:Serie Pupi and ((
(allrecords,AlwaysMatches='') and (not-onloan-count,st-numeric >= 1) and
(lost,st-numeric=0) )) and au=Menéndez-Ponte, María" )) and se=El barco
de vapor. [Serie blanca] ZOOM error 10014 "CCL parsing error" (addinfo: "')'
expected") from diag-set 'ZOOM' at /usr/share/koha/lib/C4/Search.pm line 383.

From Gemini IA

This is a database search error from an integrated library system (Koha) using
the ZOOM CCL (Common Command Language) parser.

## What the Error Means

* **Error Code:** `ZOOM error 10014`
* **Message:** `"CCL parsing error" (addinfo: "')' expected")`
* **Cause:** The search query string contains a **mismatched or missing
parenthesis (`(` or `)`)**. The parser expected a closing parenthesis to
complete an expression block, but it reached the end of the query or
encountered an unexpected character instead.

---

## How to Fix It

1. **Check Parentheses Matching:**
Look closely at the nested parentheses in your query structure, particularly
around the availability limits:
`(( (allrecords,AlwaysMatches='') and (not-onloan-count,st-numeric >= 1) and
(lost,st-numeric=0) ))`
Make sure every opening parenthesis has a corresponding closing parenthesis.
2. **Check Special Characters in Fields:**
The location field contains parentheses: `Boadilla del Monte (Madrid)`. If
these are not properly escaped or enclosed in quotes from the parser's
perspective, the system might misinterpret the inner closing parenthesis `)` as
the end of a command group rather than plain text.
3. **Simplify the Query:**
Try running the search with fewer filters (e.g., just searching for the author
`Menéndez-Ponte, María` and series `El barco de vapor`) and add the
availability or location constraints step-by-step to see where the syntax
breaks.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to