[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-bugs] [Bug 791] New: Syntax error in query for thesaurus
From: |
bugzilla-daemon |
Subject: |
[Koha-bugs] [Bug 791] New: Syntax error in query for thesaurus |
Date: |
18 Jun 2004 09:31:27 -0000 |
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: address@hidden
ReportedBy: address@hidden
QAContact: address@hidden
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.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Koha-bugs] [Bug 791] New: Syntax error in query for thesaurus,
bugzilla-daemon <=