https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33800 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |m.de.rooy@rijksmuseum.nl --- Comment #3 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- (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.