Bug 9186 - Filters on invoices page not functional
Summary: Filters on invoices page not functional
Status: RESOLVED DUPLICATE of bug 8854
Alias: None
Product: Koha
Classification: Unclassified
Component: Acquisitions (show other bugs)
Version: Main
Hardware: All All
: P5 - low major (vote)
Assignee: Bugs List
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-12-02 14:32 UTC by Katrin Fischer
Modified: 2012-12-10 21:36 UTC (History)
1 user (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 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 ***