[Koha-bugs] [Bug 462] Request with specific item type causes error in moremember.pl

[bugzilla-daemon at wilbur.katipo.co.nz]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=462

ctho at freeshell.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         OS/Version|                            |All



------- Additional Comments From ctho at freeshell.org  2003-05-17 03:34 -------
Reason:
In FindReserves, columns "timestamp" from both reserves and biblio are selected.
The returned value of timestamp is the value in table biblio which is not equal
to the value of timestamp in table reserveconstraint. So getreservetitle returns
 empty hash. This causes error in moremember.pl

Suggestion:
In FindReserves in Reserve2.pm, replace:
  my $query="SELECT *,reserves.branchcode,biblio.title AS btitle
by:
  my $query="SELECT *,reserves.branchcode,biblio.title AS btitle,
reserves.timestamp as rtimestamp

In moremember.pl, in getreservetitle() near the end of file, replace:
  $reserveline->{'timestamp'}
by
  $reserveline->{'rtimestamp'}



------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.