https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32511
--- Comment #9 from Mohd Hafiz Yusoff <[email protected]> --- 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 <[email protected]> -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] 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/
