Bug 31347 - Suggestion list date filters broken
Summary: Suggestion list date filters broken
Status: RESOLVED DUPLICATE of bug 31158
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on: 23991
Blocks:
  Show dependency treegraph
 
Reported: 2022-08-11 23:50 UTC by Victor Grousset/tuxayo
Modified: 2022-08-11 23:51 UTC (History)
2 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Victor Grousset/tuxayo 2022-08-11 23:50:37 UTC
In suggestions: in Filter by: "Suggestion information" the 3 date filters yield these 3 respective errors:

DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'suggesteddate_from' in 'where clause' at /kohadevbox/koha/Koha/Objects.pm line 394
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'manageddate_from' in 'where clause' at /kohadevbox/koha/Koha/Objects.pm line 394
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'accepteddate_from' in 'where clause' at /kohadevbox/koha/Koha/Objects.pm line 394

Bisecting showed that it's due to
d533a92aa8283de29dd64cdf698588dd707af353
Bug 23991: Move SearchSuggestion to Koha::Suggestions
Comment 1 Victor Grousset/tuxayo 2022-08-11 23:51:49 UTC

*** This bug has been marked as a duplicate of bug 31158 ***