[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

Biblibre Sandboxes <sandboxes at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #145637|0                           |1
        is obsolete|                            |

--- Comment #11 from Biblibre Sandboxes <sandboxes at 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 <mhby87 at gmail.com>

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