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@cmsd.bc.ca ReportedBy: mparienti@easter-eggs.com QAContact: koha-bugs@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.