[Koha-bugs] [Bug 35820] Table on Hold ratios page at circ/reserveratios.pl has wrong id

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

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

David Nind <david at davidnind.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |david at davidnind.com

--- Comment #3 from David Nind <david at davidnind.com> ---
Testing notes using KTD:

1. Place four holds on a record.

2. To get the report to display I needed to:
   2.1 Edit /etc/koha/sites/kohadev/koha-conf.xml
   2.2 Change strict mode to 0: <strict_sql_modes>0</strict_sql_modes>
   2.3 Restart everything
   2.4 Otherwise, I get the group by error trace:
CGI::Compile::ROOT::kohadevbox_koha_circ_reserveratios_2epl::reserveratios_2epl():
DBI Exception: DBD::mysql::st execute failed:
'koha_kohadev.reserves.reservedate' isn't in GROUP BY at
/usr/share/perl5/CGI/Emulate/PSGI.pm line 30
 at /usr/share/perl5/DBIx/Class/Exception.pm line 77

Additional things noted - both before and after the patch:

1. Row alignment - these columns are in the center, whereas all the other
columns are aligned to the top of the row:
   - Holds
   - Items
   - Items needed

2. The item type column is labelled 'Itype', should be labelled as 'Item type'.

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