Bug 34594

Summary: Incorrect table name in OpacHiddenItems causes searches to fail or details not to display
Product: Koha Reporter: Liz Rea <wizzyrea>
Component: System AdministrationAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: minor    
Priority: P5 - low CC: dcook, gmcharlt, lucas
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Liz Rea 2023-08-22 21:26:11 UTC
Example case:

Library put

damage: [1,2]

and searches failed with the following error: 

[2023/08/22 14:19:05] [WARN] No method count found for Koha::Items DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.damage' in 'where clause' at /usr/share/koha/lib/Koha/Objects.pm line 578


It would be so nice to fix this so that invalid configurations are ignored, or the preference could check upon save to verify the values input are valid.
Comment 1 David Cook 2024-07-30 23:31:24 UTC
I have been thinking for a while that having a "validate" step when saving system configurations would be amazing. Think we'd need some UI work to surface the validation failures though.