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: koha-bugs@lists.koha-community.org Reporter: angel.duran@coria.org QA Contact: testopia@bugs.koha-community.org 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.