[Koha-bugs] [Bug 32511] Circulation statistics result Error 500 where select Collection, Shelving location, Home library or Holding library

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32511

--- Comment #7 from Hammat wele <hammat.wele at inlibro.com> ---
Created attachment 145637
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=145637&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

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.