https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33800
Marcel de Rooy <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Marcel de Rooy <[email protected]> --- (In reply to Eugene Espinoza from comment #1) > Additionally, after updating to 22.11.06, we are getting the error message > below in plack-error.log: > CGI::Compile::ROOT:: > usr_share_koha_intranet_cgi_2dbin_reports_issues_stats_2epl::calculate(): > DBI Exception: DBD::mysql::st execute failed: The used SELECT statements > have a different number of columns at > /usr/share/koha/intranet/cgi-bin/reports/issues_stats.pl line 92 Eugene, This SQL error seems to be caused by a UNION statement. The only one in this script is in the calculate routine (called on L92). If you go there, you will see: $strcalc .= "LEFT JOIN (SELECT * FROM items UNION SELECT * FROM deleteditems) items ON statistics.itemnumber=items.itemnumber " You could try SELECT * FROM items UNION SELECT * FROM deleteditems in MySQL client to see if it works. It does on current master. If it doesnt, please compare the columns of items and deleteditems in your database, and tell us the differences. Did you make modifications to the tables? -- You are receiving this mail because: You are the assignee for the bug. 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/
