https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32511
Biblibre Sandboxes <sandbo...@biblibre.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #145637|0 |1
is obsolete| |
--- Comment #11 from Biblibre Sandboxes <sandbo...@biblibre.com> ---
Created attachment 145662
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=145662&action=edit
Bug 32511: Circulation statistics result Error 500 where select Collection,
Shelving location, Home library or Holding library
Circulation statistics show error 500 when the tables 'items' and
'deleteditems' do not have the same number of columns. The error 'The used
SELECT statements have a different number of columns' is shown in apache log.
This patch resolvs the problem by selecting the common columns before execute
the 'UNION' operator.
To Test
1. In Staff interface, click on Reports module
2. Click on Circulation
3. Fill the form
Period: Click on 'Row' and Select a date interval
4. Click on 'Submit'
--> Koha gives a 500 error message
5. Apply the patch
6. Repeat step 1,2,3,4
--> There's no more error
Signed-off-by: Mohd Hafiz Yusoff <mhb...@gmail.com>
--
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/
