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

[bugzilla-daemon]

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

address@hidden changed:

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



------- Additional Comments From address@hidden  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"address@hidden;
        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.