https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37238 --- Comment #5 from Lucas Gass <lucas@bywatersolutions.com> --- (In reply to Owen Leonard from comment #4)
I'm getting inconsistent behavior from the column header search fields. Sometimes they work, sometimes they incorrectly filter out all results, and sometimes I get a 500 error:
C4::Items::SearchItems(): DBI Exception: DBD::mysql::st execute failed: Column 'itemnumber' in where clause is ambiguous at /kohadevbox/koha/catalogue/itemsearch.pl line 252 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 DBIx::Class::Exception::throw('DBIx::Class::Exception', 'DBI Exception: DBD::mysql::st execute failed: Column \'itemnumber\' in where clause is ambiguous', 0) called at /usr/share/perl5/DBIx/Class/Schema.pm line 1118
Thanks Owen. For the 500 error, I am reproducing that without my patch applied. It seems specific to the itemnumber column? It also seems like many of the columns, but not all, are incorrectly filtering without this patch applied. -- You are receiving this mail because: You are watching all bug changes.