This is a problem they are experiencing when they try to add new books: [Thu May 19 09:29:42 2011] [error] [client 192.168.1.251] Q2 : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1,marc_word as m2,marc_word as m3,marc_word as m4,marc_word as m5,mar c_word as m6,marc_word as m7,marc_subfield_table as m8 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibi d and m1.bibid=m3.bibid and m1.bibid=m4.bibid and m1.bibid=m5.bibid and m1.bibid=m6.bibid and m1.bibid=m7.bibid and m1.bibid=m8.bibid) and ((m1.word like 'Chronicles' and m1.tagsubfield in ('245a'))and (m2. word like 'of' and m2.tagsubfield in('245a'))and (m3.word like 'Nadia' and m3.tagsubfield in('245a'))and (m4.word like 'Lewis' and m4.tagsubfield in('100a'))and (m5.word like 'illus' and m5.tagsubfield in('1 00a'))and (m6.word like 'Puline' and m6.tagsubfield in('100a'))and (m7.word like 'Baynes' and m7.tagsubfield in('100a'))and (m8.subfieldvalue = 'Harper Collins Publishers' and concat(m8.tag,m8.subfieldcode) in ('300c'))) order by biblio.title ASC term is The Chronicles of Nadia C S Lewis illus Puline Baynes Harper Collins Publishers at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 285., referer: htt p://kohaadmin.warrington.school.nz/cgi-bin/koha/acqui.simple/addbiblio.pl?isbn=0007215029 [Thu May 19 09:29:43 2011] [error] [client 192.168.1.251] Arguments must be MARC::Field object at /usr/local/koha/intranet/modules/C4/Biblio.pm line 1330, referer: http://kohaadmin.warrington.school.nz/cgi-b in/koha/acqui.simple/addbiblio.pl?isbn=0007215029 [Thu May 19 09:29:43 2011] [error] [client 192.168.1.251] Premature end of script headers: addbiblio.pl, referer: http://kohaadmin.warrington.school.nz/cgi-bin/koha/acqui.simple/addbiblio.pl?isbn=0007215029
also I saw this in the logs: [Tue May 17 10:29:57 2011] [error] [client 192.168.1.251] Q : select distinct m1.bibid from biblio,biblioitems,marc_biblio, where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioit ems.biblionumber and m1.bibid=marc_biblio.bibid and order by biblio.title ASC at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 288., referer: http://kohaadmin.warrington.school.nz/cgi-bin/koha/acqu i.simple/addbiblio.pl?isbn=0007215029 [Tue May 17 10:29:57 2011] [error] [client 192.168.1.251] DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syn tax to use near 'where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=bibli' at line 1 at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 290., referer: http://kohaadmin.warringt on.school.nz/cgi-bin/koha/acqui.simple/addbiblio.pl?isbn=0007215029 [Tue May 17 10:29:57 2011] [error] [client 192.168.1.251] DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 334., referer: http://kohaadmin.w arrington.school.nz/cgi-bin/koha/acqui.simple/addbiblio.pl?isbn=0007215029 The application is installed on a debian system which has had the operating system upgraded in the meantime. I don't recall what the version of Koha installed was, and I'm having trouble finding where I can find out what version it is. The upgrade to a later version of the mysql server could be causing the "You have an error in your SQL syntax" problem? It could also be that perl packages were unintentionally removed during the upgrade, or modules originally checked out of CPAN may no longer be working? As a general approach, if I upgrade Koha now to the latest version, would this be a good first step? Cheers, Alex _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha