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

koha-3.00.00 make fails
by Rick Welykochy 28 Dec '13

28 Dec '13

Hi all, I have downloaded http://download.koha.org/koha-3.00.00.tar.gz and began installing it on Debian/etch (in a Linux vserver environment). 0. FINE: cd koha-3.00.00 1. FINE: perl Makefile.PL 2. FAIL: make : : : Manifying blib/man3/C4::UploadedFile.3pm Manifying blib/man3/C4::BackgroundJob.3pm Manifying blib/man3/opac::opac-dictionary.3pm Manifying blib/man3/serials::member-search.3pm /usr/bin/perl "-Iblib/arch" "-Iblib/lib" fix-perl-path.PL blib /usr/bin/perl "-Iblib/arch" "-Iblib/lib" rewrite-config.PL blib/KOHA_CONF_DIR/koha-conf.xml Bad arg length for Socket::inet_ntoa, length is 0, should be 4 at rewrite-config.PL line 67. make: *** [blib/KOHA_CONF_DIR/koha-conf.xml] Error 255 Any ideas what went wrong and how to fix? Aside: there were a couple of other problems with this "out of the box" debian based install of Koha 3.0 which had to be fixed along the way, e.g. seven missing perl modules and libgd not found. I'll report on the entire process from unpacking to a running Koha/3.00.00 once I get to the end. cheers rickw -- ________________________________________________________________ Rick Welykochy || Praxis Services || Internet Driving Instructor The manual said Windows XP/SP2 or better so I installed Linux.

4 5

git.koha.org outage
by Clay Fouts 01 Feb '10

01 Feb '10

Hi, all. Just a brief update on the git.koha.org outage. That server is currently unreachable, even on an administrative basis. We've been working with the hosting provider (Spry) for the past several hours to get it back online. It ought to be available again soon. Cheers, Clay

7 11

Need for reindex with Zebra?
by David Schuster 22 Dec '09

22 Dec '09

In a legacy system that I used to be using we were encouraged to once a year do a complete system reindex to clean things up and make the system perform better. I have not seen any recommendations anywhere on this so was looking for opinions. I'm coming up on a very long holiday that would be perfect for this type of work. Thanks! David Schuster Plano ISD -- View this message in context: http://old.nabble.com/Need-for-reindex-with-Zebra--tp26575069p26575069.html Sent from the Koha - Dev mailing list archive at Nabble.com.

3 4

Help with SQL report
by Adrea Lund 18 Dec '09

18 Dec '09

Dear KOHA Users, With the help of Beverly Church at Liblime (Thank You Beverly!!), our library is trying to get an SQL report that we can use for weeding our collections. We are getting closer to what we want, but we have gotten stuck - are there any SQL gurus out there who can help us? Right now we have the following 2 reports. we want to merge them into one report (I'll describe how below). Report #1 gives us all items within a specified call number range with less than 5 total circulations during a specified time period (circulations include issues, renewals and local use). select count(*), itemcallnumber as ' call number', dateaccessioned, author, title, barcode, datelastseen as 'last seen', itemlost as 'lost status', damaged from statistics, items, biblio where statistics.itemnumber = items.itemnumber and items.biblionumber = biblio.biblionumber and statistics.type in ('issue','renew', 'localuse') and date(datetime) between '2004-01-01' and '2009-12-31' and itemcallnumber between 'MUSIC 1999 CD' and 'MUSIC ZZ TOP CD' group by statistics.itemnumber having count(*) < 5 order by cn_sort Report #2 gives us a list breakdown by year of all items within a specified call number range that have less than 5 total circulations during any year within a specified time frame (circulations include issues, renewals and local use). select year(datetime) as 'year', count(*), itemcallnumber as ' call number', dateaccessioned, author, title, barcode, datelastseen as 'last seen', itemlost as 'lost status', damaged from statistics, items, biblio where statistics.itemnumber = items.itemnumber and items.biblionumber = biblio.biblionumber and statistics.type in ('issue','renew', 'localuse') and date(datetime) between '2004-01-01' and '2009-12-31' and itemcallnumber between 'MUSIC 1999 CD' and 'MUSIC ZZ TOP CD' group by year, statistics.itemnumber having count(*) < 5 order by cn_sort We would like to merge them into a report which gives us the "individual" circulation counts by year, but also limits the list of materials to ones with a total circulation of less than 5 during the total specified time period. Is there a way to include totals and sub-totals on the same report? We would greatly appreciate any help! Thank you, Adrea Adrea Lund Head of Adult Services Grand County Public Library 257 E. Center St. Moab, UT 84532 435-259-1111 ext11

5 8

Re: [Koha-devel] Koha Zebra Reindexing
by Waylon Robertson 30 Nov '09

30 Nov '09

An update to my tale. So far, ive managed to get my new field indexed, and searcing via @attr in yazclient works. I have no knowledge of CCL, and help files on its syntax seem to be nonexistant. What Ive done is put it in ccl.properties appropiately, so jn is Journal-number and Journal-number 1=9903 .... how do i do a 'not' on jn in ccl? ----- Original Message ---- From: Waylon Robertson <wrobertson1981(a)yahoo.co.nz> To: Chris Cormack <chris(a)bigballofwax.co.nz>; Arturo Ochoa <arturo8a(a)gmail.com> Cc: koha-devel(a)lists.koha.org Sent: Sat, 28 November, 2009 10:04:25 PM Subject: Re: [Koha-devel] Koha Zebra Reindexing Hi, Im back in the flow as it were, working on Koha... getting paid for it too. So, naturally, this question uncannily came up just today. Co-incidence? -shrug- Anyway, please read http://koha.org/documentation/manual/3.2/searching/guide-to-searching/index… for hints on altering the configuration. I haven't gotten as far as reindexing yet, lost connection to my devel server, but logically, It should work. ----- Original Message ---- From: Chris Cormack <chris(a)bigballofwax.co.nz> To: Arturo Ochoa <arturo8a(a)gmail.com> Cc: koha-devel(a)lists.koha.org Sent: Fri, 27 November, 2009 8:08:59 AM Subject: Re: [Koha-devel] Koha Zebra Reindexing 2009/11/27 Arturo Ochoa <arturo8a(a)gmail.com>: > Hi Guys, > > Im using MARC21 > > When i tried to reindexing with rebuild_zebra.pl, everythings looks to be > fine,but zebra is doesn't reindexing the fields 710,711 that corresponds to > a CORPO_NAME,MEETI_NAME. For example, i have a secondary author named > "Universidad Nacional de Ingenieria", and i assign it to a book in the field > 710 because it's a CORPO NAME. The link appears correctly in OPAC normal > view of the book, but when you click on it, opac tries to search "an:11143" > that isn't works and not returns any results. > > But, this works correctly with PERSO_NAME in the field 700. So, i think that > zebra isn't indexing/reindexing the fields 710,711 from a biblio record. > Then, any people can give me a solution for this? or maybe a way to change > the fields that zebra is reindexing now? (i think it's from > 'marc_subfield_structure' table). > Hi Arturo You are on the right track, but it isn't the marc_subfield_structure table you need to edit, rather you need to edit the zebra config files. etc/zebradb/marc_defs/marc21/biblios/record.abs is one, and I'm not sure if you need to edit something else. Hopefully someone more knowledgeable about zebra configs will help Chris _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel

3 2

Next general meeting, 02-Dec-2009
by tajoli 30 Nov '09

30 Nov '09

Hi to all, I have written the DevWiki page for the next general meeting. As I know the next general meeting is planned at Wednesday, 2 December 2009 at 10:00 UTC+0 Link: http://wiki.koha.org/doku.php?id=en:events:meetings:irc_meetings:meetingnot… Agenda: 1.Update on Roadmap to 3.2. 2.Update on Koha 3.0 Roadmap. 3.Follow-up on actions from General IRC Meeting, 4 November 2009. 4.Decision about documentation of DB level (Zeno Tajoli) 5.Roles on Bugzilla for 3.2.x and 3.4 ? 6.Agree times of next meetings. For the Agenda I'm only collect what I see on mailing list and chat. No problem on change it. Bye to all

1 0

3.0.5 release Date
by LAURENT Henri-Damien 30 Nov '09

30 Nov '09

Hi I have been late on my schedule. But I want to announce that 3.0.5 should be packaged released by the end of the week. I want to add and test Frederic Démians' patches on SIP and also ensure that translation are really uptodate and accurate. For the impatient, code and present day translations without those latest patches is available on git.koha.org/koha on branch 3.0.x. -- Henri-Damien LAURENT Release Maintainer

1 0

Stuck with mailing overdue notice
by nitesh rijal 29 Nov '09

29 Nov '09

Hello all I am using KOHA 3.0.3 with zebra server. I have sendmail and it sends mail from command line. I have set up a new patron with an email address and also made a lot of overdue for that patron. The fines.pl file calculates the fine very well. But when it comes to mailing the patron about the overdue then I'm stuck. I have set up the triggers and the rules for mailing as well. I have changed the /usr/share/koha/bin/cronjobs/crontab.example accordingly. This is what I did to change the crontab.example file. # crontab -u root crontab.example # crontab -u kohaadmin crontab.example # crontab -e Now I edited the file, it uses nano editor to edit the crontab entries. To save them I pressed Crtl+O and gave the path to save as /usr/share/koha/bin/cronjobs/crontab.example To exit the crontab I pressed Ctrl+X. To list the entries I used # crontab -l and it listed all my entries fine. Now I waited for the cron to run, but it didnot send the mail while it accumulated the fine. Both the fine and mail scripts are in the same crontab. So I ran the overdue_message.pl and process_message_queue.pl manually. They showed me no error neither they send the mails. What am I supposed to do now ???? I'm pretty much stucked. Please Help. Thankyou. -- Nitesh Rijal BE IT email: rijal.it(a)gmail.com url: http://niteshrijal.com.np facebook: http://facebook.com/openrijal twitter: http://twitter.com/openrijal +9779841458173

3 4

Koha Zebra Reindexing
by Arturo Ochoa 28 Nov '09

28 Nov '09

Hi Guys, Im using MARC21 When i tried to reindexing with rebuild_zebra.pl, everythings looks to be fine,but zebra is doesn't reindexing the fields 710,711 that corresponds to a CORPO_NAME,MEETI_NAME. For example, i have a secondary author named "Universidad Nacional de Ingenieria", and i assign it to a book in the field 710 because it's a CORPO NAME. The link appears correctly in OPAC normal view of the book, but when you click on it, opac tries to search "an:11143" that isn't works and not returns any results. But, this works correctly with PERSO_NAME in the field 700. So, i think that zebra isn't indexing/reindexing the fields 710,711 from a biblio record.*Then, any people can give me a solution for this? * or maybe a way to change the fields that zebra is reindexing now? (i think it's from 'marc_subfield_structure' table). Greetings! Sorry for my bad english. :P

3 2

about patch for bug 3482
by Zeno Tajoli 26 Nov '09

26 Nov '09

Dear David, thank you very much for your patch about bug 3482. Clearly is too big to send it in a e-mail. But I think that to send the direct link is a must for the mails to koha-patches. The direct link is: http://github.com/ptfs/Koha-PTFS/commits/Bug3482 I found quite difficult to find it. That's all and thank you again for your work. Ps: this patch is for version 3.0.x ? Because we need a new release to spread it. Cheers Zeno Tajoli Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)

1 0