Bug 9186

Summary: Filters on invoices page not functional
Product: Koha Reporter: Katrin Fischer <katrin.fischer>
Component: AcquisitionsAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact:
Severity: major    
Priority: P5 - low CC: nengard
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 Katrin Fischer 2012-12-02 14:32:05 UTC
In order to test this, you need some shipments in your system (received orders with items and the like)

Filters on the invoices page don't work correctly.

For example a search by branch 'Midwäy' in my system results in 0 results with following errors in the log:

[Sun Dec 02 15:24:52 2012] [error] [client 127.0.0.1] [Sun Dec  2 15:24:52 2012] invoices.pl: DBD::mysql::st execute failed: Unknown column 'aqorders.branchcode' in 'where clause' at /home/katrin/kohaclone/C4/Acquisition.pm line 2275., referer: http://localhost:8080/cgi-bin/koha/acqui/invoices.pl?op=do_search
[Sun Dec 02 15:24:52 2012] [error] [client 127.0.0.1] [Sun Dec  2 15:24:52 2012] invoices.pl: DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at /home/katrin/kohaclone/C4/Acquisition.pm line 2277., referer: http://localhost:8080/cgi-bin/koha/acqui/invoices.pl?op=do_search
[Sun Dec 02 15:24:52 2012] [error] [client 127.0.0.1] [Sun Dec  2 15:24:52 2012] invoices.pl: Use of uninitialized value $searchstring in concatenation (.) or string at /home/katrin/kohaclone/C4/Bookseller.pm line 65., referer: http://localhost:8080/cgi-bin/koha/acqui/invoices.pl?op=do_search
Comment 1 Nicole C. Engard 2012-12-10 21:36:14 UTC

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