Bug 34594 - Incorrect table name in OpacHiddenItems causes searches to fail or details not to display
Summary: Incorrect table name in OpacHiddenItems causes searches to fail or details no...
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: System Administration (show other bugs)
Version: Main
Hardware: All All
: P5 - low minor
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-08-22 21:26 UTC by Liz Rea
Modified: 2024-07-30 23:31 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.