[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