[Koha-bugs] [Bug 878] New: updatedatabase breaks parameters (author and title searches fail)
bugzilla-daemon at wilbur.katipo.co.nz
bugzilla-daemon at wilbur.katipo.co.nz
Mon Dec 13 21:30:41 CET 2004
http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=878
Summary: updatedatabase breaks parameters (author and title
searches fail)
Product: Koha
Version: CVS
Platform: PC
Status: NEW
Severity: normal
Priority: P2
Component: Database
AssignedTo: chris at katipo.co.nz
ReportedBy: jferraro at athenscounty.lib.oh.us
QAContact: koha-bugs at lists.sourceforge.net
output for updatedatabase seems normal but it breaks parameters. For instance,
title and author searches don't use the right biblio.something. Here's a clip
from the log:
Q2 : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as
m1,marc_word as m2 where biblio.biblionumber=marc_biblio.biblionumber and
biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and
(m1.bibid=m2.bibid) and ((m1.word like 'neal' and m1.tagsubfield in
('bibl'))and (m2.word like 'stephenson' and m2.tagsubfield in('bibl'))) order by
biblio.title term is neal stephenson at
/usr/local/koha/intranet/modules//C4/SearchMarc.pm line 267.
The (bibl) isn't right!
Here's the copy of the updatedatabase being run:
[root at koha updater]# perl -I /build/cvsroots/production/koha/ updatedatabase
connected to your DB. Checking & modifying it
Alter z3950random in marc_breeding
Alter bookfundid in aqbookfund
Alter aqbudgetid in aqbudget
Alter id in z3950servers
Checking for data required in table userflags...
Checking for data required in table systempreferences...
------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.
More information about the Koha-bugs
mailing list