[Koha-bugs] [Bug 791] New: 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

           Summary: Syntax error in query for thesaurus
           Product: Koha
           Version: 2.0.0
          Platform: PC
        OS/Version: Linux - Debian
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: Parameters
        AssignedTo: tonnesen at cmsd.bc.ca
        ReportedBy: mparienti at easter-eggs.com
         QAContact: koha-bugs at lists.sourceforge.net


The query for thesaurus word ends with "limit '0', '80'", which causes a syntax
error with my mysql server version, the 4.0.20. The right syntax is "limit 0, 80".

To correct this, I change the code:

line 38 of koha/intranet/cgi-bin/admin/thesaurus becomes:
my $offset= 0 + $input->param('offset');

line 197, 198 of koha/intranet/modules/C4/ change from:
         $query .= " limit ?,?";
         push(@bind,$offset,($pagesize*4));
to:
         $query .= " limit $offset," . ($pagesize*4);



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