[Koha] Newbie - first question

Jorge de Cardenas jorgedec at neo.rr.com
Mon Aug 13 04:52:07 NZST 2007


I have alot of questions but I'll start with this:

Are all errors reported in koha-error_log actually errors?

I have a fresh install of Koha 2.2.9 on a debian linux box, with 
MySql5.0. I cannot add books. The first error in the
process seems to be a sql query but I have manually performed the
the query in MySql and it does not produce an error just zero items
selected.

In the process of adding a book this is the first error after 
Catalogue>Add Biblio>Enter ISBN>

*******start*******
[Sat Aug 11 17:08:27 2007] [error] [client 192.168.0.3]
Q :

select distinct m1.bibid from 
biblio,biblioitems,marc_biblio,marc_subfield_table as m1
where biblio.biblionumber=marc_biblio.biblionumber
and biblio.biblionumber=biblioitems.biblionumber
and m1.bibid=marc_biblio.bibid
and (m1.subfieldvalue like '0596000480%' and 
concat(m1.tag,m1.subfieldcode) in ('020a'))
order by biblio.title ASC

at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 277.,
referer: http://192.168.0.4:8080/cgi-bin/koha/acqui.simple/addbooks.pl

Note: These tables get populated:
biblio
bilioitems
bibliosutitle
additionalauthors
bibliosubject
catalogueentry

these are empty:
items
marc_word
marc_biblio
marc_subfield_table

Hope you can help as to where to start looking.

Jorge



More information about the Koha mailing list