https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37238
--- Comment #5 from Lucas Gass <lu...@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. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/