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@katipo.co.nz ReportedBy: jferraro@athenscounty.lib.oh.us QAContact: koha-bugs@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@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.