[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 #9 from Mohd Hafiz Yusoff <mhby87 at gmail.com> ---
Created attachment 145661
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=145661&action=edit
Circulation statistics result after test

(In reply to Hammat wele from comment #7)
> Created attachment 145637 [details] [review]
> 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

Patch tested by me with my database on Koha 22.11.01. All work!

Signed-off-by: Mohd Hafiz Yusoff <mhby87 at gmail.com>

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