[Koha-bugs] [Bug 33800] Error 500 in issues_stats.pl

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33800

Marcel de Rooy <m.de.rooy at rijksmuseum.nl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |m.de.rooy at rijksmuseum.nl

--- Comment #3 from Marcel de Rooy <m.de.rooy at 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.