[Koha-devel] ISSUESLIP and old_checkouts in template code

[Mark Alexander]

Excerpts from Jonathan Druart's message of 2019-10-24 16:11:50 +0200:
> @ Members.pm:596 @ sub IssueSlip {
>          );
>          %loops = (
>              issues => [ map { $_->{issues}{itemnumber} } @checkouts ],
> +            old_issues => [ $patron->old_checkouts->get_column('itemnumber') ],
>              overdues   => [ map { $_->{issues}{itemnumber} } @overdues ],
>              opac_news => [ map { $_->{opac_news}{idnew} } @news ],
>          );

This didn't quite work as expected; see the SQL error below.  But
it does get me on the right track, so thank you for that!  I'll continue
playing with this, perhaps by trying to get old_issues to look exactly
like issues in the way it's constructed.

Thanks again!

SQL error follows:

DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , , , , , , , , , , , , , , , , , , , 3950, 26730, 26730, 28220, 26730, 28220' at line 1 [for Statement "SELECT `me`.`issue_id`, `me`.`borrowernumber`, `me`.`itemnumber`, `me`.`date_due`, `me`.`branchcode`, `me`.`returndate`, `me`.`lastreneweddate`, `me`.`renewals`, `me`.`auto_renew`, `me`.`auto_renew_error`, `me`.`timestamp`, `me`.`issuedate`, `me`.`onsite_checkout`, `me`.`note`, `me`.`notedate`, `me`.`noteseen` FROM `old_issues` `me` WHERE ( ( `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` = ? OR `itemnumber` IS NULL OR `itemnumber` IS NULL OR `itemnumber` = ? ) ) ORDER BY field(itemnumber, , , , , , , , , , , , , , , , , , , , , , 3950, 26730, 26730, 28220, 26730, 28220, 26730, 22133, 25086, 28133, 27996, 24500, 28480, 18222, 28491, , , 28494)" with ParamValues: 0='3950', 1='26730', 2='26730', 3='28220', 4='26730', 5='28220', 6='26730', 7='22133', 8='25086', 9='28133', 10='27996', 11='24500', 12='28480', 13='18222', 14='28491', 15='28494'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832.
ERROR PROCESSING TEMPLATE: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , , , , , , , , , , , , , , , , , , , 3950, 26730, 26730, 28220, 26730, 28220' at line 1 at /usr/share/koha/lib/Koha/Objects.pm line 269
 at /usr/share/koha/lib/C4/Members.pm line 602.