- Koha-devel - lists.koha-community.org

CDKModuleHasProblems
by Stephen Hedges 27 Mar '04

27 Mar '04

The wiki page for CDK problems (CDKModuleHasProblems, http://www.saas.nsw.edu.au/wiki/index.php?page=CDKModuleHasProblems) seems to have been hacked. Does anyone remember what the problems were? -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com

2 1

new features to test
by paul POULAIN 26 Mar '04

26 Mar '04

Hi, In CVS head, i've commited some nice new things : * shelves in OPAC (the css one, that will become the default one for 2.2) * mix of marc & simple search in MARC search. Now the search can be build only by using MARCsearch.pm and the MARC tables. The result should be indexed in any case & can have complex requests. pls test it. In the log, the exact SQL query is shown. With a "explain" just before, in a mysqladmin or phpmyadmin, you can see if it's always indexed. * The "seealso" can search in fields "related to" the main one. For example, author can now search in 700a,701a,702a. I agree the "seealso" is a poor term that is usually used for something else. Could you give me a better word ? * the search can also be ordered by title, author, copyrightdate... i plan to work next on the order to have "the last heroe" ordered in "L", not in "T". -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

3 4

catmaintain.pl
by MJ Ray 26 Mar '04

26 Mar '04

I'm having two problems with catmaintain: First, catmaintain.pl doesn't use templates, as far as I can tell. It seems to call C4::Output::startmenu, which is apparently broken. Should I remove that function and rewrite anything using it? Possibly related, some browsers go to /cgi-bin/koha/search.marc/search.pl?type=intranet, click on "Cat Maintenance" and end up at /cgi-bin/koha/maint/<!-- TMPL_VAR name= which 404s. Why? Bug 600 is the original problem, which no-one was interested in. In bug 721, Ambrose says catmaintain is templated. Does it fix the second problem too? I'll test, but I'd still appreciate comments. -- MJR/slef My Opinion Only and possibly not of any group I know. Please http://remember.to/edit_messages on lists to be sure I read http://mjr.towers.org.uk/ gopher://g.towers.org.uk/ slef(a)jabber.at Creative copyleft computing services via http://www.ttllp.co.uk/

2 2

More reports for 2.0.0
by Baiju M 25 Mar '04

25 Mar '04

Hi, I started converting CDS/ISIS datas into Koha-2.0.0RC4 My libraraian requires more reports. Now I am about to start writing a perlscript for that. But recently when I checked out Koha CVS (rel_2_0 branch), I have seen one more report (inventry) in that. If anyone working on more koha reports, I can wait for sometime or contribute code. I just started learning perl, anyway here are the details of four reports which I am planning to create for my librarian. C4::Reports (perl module for reports) cgi-bin/koha/reports/checklist.pl?list=issues (Daily issue report, my librarian use : Issue Check List) cgi-bin/koha/reports/checklist.pl?list=renewals (Daily renewals report) cgi-bin/koha/reports/checklist.pl?list=returns (Daily returns report) cgi-bin/koha/reports/statistics.pl (daily statistics) Check List Output : Barcode Cardnumber Borrowername Borroweraddress output of daily statistics will decide later. There will be checklist.tmpl and statistics.tmpl in template directory. Should I add this to bugs.koha.org with more details? Regards, Baiju M PS. Internet usage is costly here. ____________________________________________________________ Find what you are looking for with the Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.as…

2 1

Catalogue marc search problem
by Serge RENAUX 24 Mar '04

24 Mar '04

Hi, I have installed Koha-2.0.0RC4 and i am testing it. Search are working from OPAC and from catalogue simple mode, but it did not work from catalogue Marc search. I got the error below tail koha-error_log [Wed Mar 24 15:22:40 2004] [error] [client 147.215.1.224] Premature end of script headers: /usr/local/koha/intranet/cgi-bin/search.marc/search.pl Can't use an undefined value as a HASH reference at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 116. [Wed Mar 24 15:38:43 2004] [error] [client 147.215.1.224] Premature end of script headers: /usr/local/koha/intranet/cgi-bin/search.marc/search.pl Do you know where it comes from ? Regards Serge -- Serge Renaux Groupe ESIEE / CCI Paris EMail:s.renaux@esiee.fr Tel:(33)1.45.92.67.46

2 1

Re: [Koha-devel] Total issues
by Owen Leonard 23 Mar '04

23 Mar '04

> Owen, it's just a link to bookcount.pl. The > moredetail.pl script only > works with data on the biblioitem level ... > The bookcount.pl script goes a > layer deeper and retrieves data by itemnumber. That's just the information I was looking for. It sounds like the template could be changed to make it clearer. Thanks, Owen

1 0

Total issues
by Owen Leonard 22 Mar '04

22 Mar '04

One of the items listed by moredetail.pl is 'Total Issues:' It's an active link, but it doesn't list a number there on moredetail.pl. Should it? Or is it just a way to link to bookcount.pl? -- Owen

2 1

Re: [Koha-devel] new features to test
by paul POULAIN 22 Mar '04

22 Mar '04

Stephen Hedges wrote: >Paul - > >I've been testing the changes you made to search.marc/search.pl and >SearchMarc.pm and thought you would like to see some results. > yep, thanks. >First some questions. The "query" that gets displayed as you are building >the search is confusing. It always seems to start with "biblioitems.illus >contains ''." Is that actually correct? And does the query start by >using the koha fields? Is that where it's finding the tags to search on? >(I should have taken a closer look at your code.) > a bug, probably. that's why it's in HEAD branch :-D >Also three general problems. The marclist seems to be broken, since it is >not available in the pull-down menu (neither in the default template nor >the npl template). And MARCdetail.pl never seems to display any results. >And all of the queries are followed in the log with this error: > >DBD::mysql::st execute failed: Unknown column 'seealso' in 'field list' at >/usr/local/koha/intranet/modules//C4/Biblio.pm line 235. >[sounds like we need to updatedatabase] > yes ;-) >So now for some search results -- > >* Search on keyword "dog" (worked OK): >explain select distinct m1.bibid from >biblio,biblioitems,marc_biblio,marc_word as m1 where >biblio.biblionumber=marc_biblio.biblionumber and >biblio.biblionumber=biblioitems.biblionumber and >m1.bibid=marc_biblio.bibid and (m1.word like 'dog%' and >m1.tag+m1.subfieldid in ('')) order by biblio.title; >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ >| table | type | possible_keys | key | key_len | ref > | rows | Extra | >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ >| m1 | range | bibid,word | word | 255 | NULL > | 2200 | Using where; Using temporary; Using filesort | >| marc_biblio | eq_ref | PRIMARY,biblionumber | PRIMARY | 8 | m1.bibid > | 1 | Using where; Distinct | >| biblio | eq_ref | PRIMARY,blbnoidx | PRIMARY | 4 | >marc_biblio.biblionumber | 1 | Distinct > | >| biblioitems | ref | bibnoidx | bibnoidx | 4 | >biblio.biblionumber | 12 | Using index; Distinct > | >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ > Nice result set : 2200 x 1 x 1 x12 rows to parse. Not too many. >* Search on author "Henry" (worked OK): > <snip> >* Search on author "Sue Henry" order by author (worked _very_ well!) > <snip> >* Search on author "Sue Henry" order by title (worked _very_ well!) > <snip> >* BUT NOTE -- Search on author "Henry, Sue" did NOT work: >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 >'henry,%' and m1.tag+m1.subfieldid in ('100a'))and (m2.word like 'sue%' >and m2.tag+m2.subfieldid in('100a'))) order by biblio.author >[no results returned] >* Search on title "I'll be home for Christmas" (failed): >select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as >m1,marc_word as m2,marc_word as m3 where >biblio.biblionumber=marc_biblio.biblionumber and >biblio.biblionumber=biblioitems.biblionumber and >m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid and m1.bibid=m3.bibid) >and ((m1.word like 'I'll%' and m1.tag+m1.subfieldid in ('245a'))and >(m2.word like 'home%' and m2.tag+m2.subfieldid in('245a'))and (m3.word >like 'Christmas%' and m3.tag+m3.subfieldid in('245a'))) order by >biblio.title >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 syntax to use near 'll%' and m1.tag+m1.subfieldid in ('245a'))and >(m2.word like 'ho >[we need to escape apostrophes] > we need to remove ' and , and other useless characters. enter a bugs.koha.org pls >* Search on barcode (worked very well): >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ >| table | type | possible_keys | key | key_len | ref > | rows | Extra | >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ >| m1 | range | bibid,word | word | 255 | NULL > | 1 | Using where; Using temporary; Using filesort | >| marc_biblio | eq_ref | PRIMARY,biblionumber | PRIMARY | 8 | m1.bibid > | 1 | Using where; Distinct | >| biblio | eq_ref | PRIMARY,blbnoidx | PRIMARY | 4 | >marc_biblio.biblionumber | 1 | Distinct > | >| biblioitems | ref | bibnoidx | bibnoidx | 4 | >biblio.biblionumber | 12 | Using index; Distinct > | >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ > wonderful :1 x 1 x 1 x 12 rows to parse in the DB !!! For a 1Gb DB if your test DB is a copy of your real one ? >* Search ("Q2") on keyword "England" and itemtype "AB" (failed--returned >no results); >explain 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 >'england%' and m1.tag+m1.subfieldid in (''))and (m2.word like 'AB%' and >m2.tag+m2.subfieldid in('item'))) order by biblio.title; >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ >| table | type | possible_keys | key | key_len | ref > | rows | Extra | >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ >| m1 | range | bibid,word | word | 255 | NULL > | 5377 | Using where; Using temporary; Using filesort | >| marc_biblio | eq_ref | PRIMARY,biblionumber | PRIMARY | 8 | m1.bibid > | 1 | Using where; Distinct | >| biblio | eq_ref | PRIMARY,blbnoidx | PRIMARY | 4 | >marc_biblio.biblionumber | 1 | Distinct > | >| biblioitems | ref | bibnoidx | bibnoidx | 4 | >biblio.biblionumber | 12 | Using index; Distinct > | >| m2 | ref | bibid,word | bibid | 8 | m1.bibid > | 20 | Using where; Distinct | >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ > mmm... this one is important : the marc_word does NOT store words <= 2 letters. sub MARCaddword { # split a subfield string and adds it into the word table. # removes stopwords my ($dbh,$bibid,$tag,$tagorder,$subfieldid,$subfieldorder,$sentence) =@_; $sentence =~ s/(\.|\?|\:|\!|\'|,|\-|\"|$|$|\[|\]|\{|\})/ /g; my @words = split / /,$sentence; my $stopwords= C4::Context->stopwords; my $sth=$dbh->prepare("insert into marc_word (bibid, tag, tagorder, subfieldid, subfieldorder, word, sndx_word) values (?,?,?,?,?,?,soundex(?))"); foreach my $word (@words) { # we record only words longer than 2 car and not in stopwords hash if (length($word)>2 and !($stopwords->{uc($word)})) { $sth->execute($bibid,$tag,$tagorder,$subfieldid,$subfieldorder,$word,$word); if ($sth->err()) { warn "ERROR ==> insert into marc_word (bibid, tag, tagorder, subfieldid, subfieldorder, word, sndx_word) values ($bibid,$tag,$tagorder,$subfieldid,$subfieldorder,$word,soundex($word))\n"; } } } } What should we decide here ? * also store <=2 letters word. * say that itemtype & other fields must be >2 chars ? >Hope this helps --- Stephen > yes, thanks a lot. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Bug importing MARC records?
by Edward M. Corrado 20 Mar '04

20 Mar '04

Hello all, I have a fresh install of Koha 2.0.0RC4 and I want to import some MARC records. I tried using the bulkimport.pl script, but it seems I am getting some errors. The errors say: DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 289 DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 371 They just keep repeating. I assumed that it was getting the password from pass=XXX in /etc/koha.conf, so I checked that and I have the correct password there. I then tried the script with more verbose output. It said it was adding the records - so I looked and indeed they were added. Is the error messages a bug or am I doing something wrong? Thanks, Edward Corrado

5 9

Katipo style number validation
by T & J Kotula 19 Mar '04

19 Mar '04

Hi, Could someone point me to what would need to be done to include "Katipo" checksum validation of the barcode field on the /cgi-bin/koha/acqui.simple/additem.pl page. Many thanks tomasz kotula.

2 1