[Koha-bugs] [Bug 791] Syntax error in query for thesaurus

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

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

mjr at ttllp.co.uk changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED



------- Additional Comments From mjr at 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". at 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.