http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=791 mjr@ttllp.co.uk changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED ------- Additional Comments From mjr@ttllp.co.uk 2004-07-01 06:11 ------- Please try changing affected code, starting around line 195 of C4/Authorities.pm, to read: $query .= " limit ?,?"; warn "q : $query".@bind; my $sth=$dbh->prepare($query); for my $i (0..$#bind) { $sth->bind_param($i,$bind[$i]); } $sth->bind_param($#bind+1,$offset,SQL_INTEGER); $sth->bind_param($#bind+2,($pagesize*4),SQL_INTEGER); $sth->execute(); Also change line 24 to read: use DBI qw(:sql_types); Thanks to Kris Boutilier for the pointer to SQL_INTEGER. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.