[Koha] Problems with a Koha instance

Alex King alex at king.net.nz
Thu May 19 11:37:57 NZST 2011

This is a problem they are experiencing when they try to add new books:

[Thu May 19 09:29:42 2011] [error] [client] 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 
  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
[Thu May 19 09:29:43 2011] [error] [client] 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
[Thu May 19 09:29:43 2011] [error] [client] Premature end 
of script headers: addbiblio.pl, referer: 

also I saw this in the logs:

[Tue May 17 10:29:57 2011] [error] [client] Q : select 
distinct m1.bibid from biblio,biblioitems,marc_biblio, where 
biblio.biblionumber=marc_biblio.biblionumber and 
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
[Tue May 17 10:29:57 2011] [error] [client] 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: 
[Tue May 17 10:29:57 2011] [error] [client] DBD::mysql::st 
fetchrow failed: fetch() without execute() at 
/usr/local/koha/intranet/modules/C4/SearchMarc.pm line 334., referer: 

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?


More information about the Koha mailing list