Re: [Koha] Rebuild-zebra stops working very often...
Hello Thanks for your help. Now I have got the proper command line (I think) and that's: perl -I /usr/share/koha/lib /usr/share/koha/bin/migration_tools/batchCheckNonIndexedBiblios.pl -c If I sudo it, I have got that error: DBI connect('dbname=koha;host=localhost;port=','',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/share/koha/lib/C4/Context.pm line 692 Access denied for user 'root'@'localhost' (using password: NO) at /usr/share/koha/lib/C4/Context.pm line 692. If I don't sudo it, I have got that error: I/O error : Permission denied I/O error : Permission denied Could not create file parser context for file /etc/koha/sites/library/koha-conf.xml: Permission denied at /usr/lib/perl5/XML/LibXML/SAX/Parser.pm line 49 BEGIN failed--compilation aborted at batchCheckNonIndexedBiblios.pl line 36. I think it's because I am not the root user... I have r rights on all these lib files, but I can't write on them. And, for some reason, I think that the way that lib and/or script works, it needs me to write things (parser?) in these files. So I have emailed the root user and asked him to do it. If that works, I will probably ask again your help with the results. If that doesn't work, well... Thanks again for your help! Cheers, Sonia. Date: Fri, 20 Jul 2012 10:48:43 +0200 From: ro...@catalyst.net.nz To: koha@lists.katipo.co.nz Subject: Re: [Koha] Rebuild-zebra stops working very often... Op 20-07-12 09:29, Sonia P. schreef: Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl.) at batchCheckNonIndexedBiblios.pl line 36. In the script line 36 is use C4::Context; We have put the script here: /usr/share/koha/bin/migration_tools/batchCheckNonIndexedBiblios.pl Does that error mean that things are not located where it should be? You didn't show what command line you're using to run it, that's the most critical thing. However the problem is simply that you're not providing the path to where the C4 directory is. I don't know your system layout, but I'm going to guess: perl -I /usr/share/koha/lib /usr/share/koha/bin/migration_tools/batchCheckNonIndexedBiblios.pl (all one line) Also, you will have to put KOHA_CONF=/path/to/koha-conf.xml at the start of it, inserting the real path. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Rebuild-zebra stops working very often...
OK, after permissions have been changed... Here is the report (it looks long but it's quite empty so I copy-paste) : 1000 done 2000 done biblionumber 2315 not indexed 3000 done 4000 done biblionumber 5230 not indexed biblionumber 5234 not indexed 5000 done 6000 done 7000 done 8000 done 9000 done 1 done 11000 done 12000 done 13000 done 14000 done 15000 done 16000 done 17000 done biblionumber 19992 not indexed biblionumber 19994 not indexed biblionumber 20030 not indexed 18000 done biblionumber 20177 not indexed biblionumber 20234 not indexed biblionumber 20316 not indexed biblionumber 20317 not indexed biblionumber 20330 not indexed biblionumber 20333 not indexed biblionumber 20384 not indexed biblionumber 20397 not indexed biblionumber 20398 not indexed biblionumber 20399 not indexed biblionumber 20400 not indexed biblionumber 20418 not indexed biblionumber 20446 not indexed biblionumber 20448 not indexed biblionumber 20491 not indexed biblionumber 20494 not indexed biblionumber 20495 not indexed biblionumber 20499 not indexed biblionumber 20500 not indexed biblionumber 20501 not indexed biblionumber 20502 not indexed biblionumber 20505 not indexed biblionumber 20590 not indexed biblionumber 20614 not indexed biblionumber 20615 not indexed biblionumber 20616 not indexed biblionumber 20617 not indexed biblionumber 20618 not indexed biblionumber 20626 not indexed biblionumber 20627 not indexed biblionumber 20628 not indexed biblionumber 20648 not indexed biblionumber 20677 not indexed biblionumber 20686 not indexed biblionumber 20849 not indexed biblionumber 20917 not indexed biblionumber 20921 not indexed biblionumber 21016 not indexed biblionumber 21039 not indexed biblionumber 21045 not indexed biblionumber 21097 not indexed biblionumber 21138 not indexed biblionumber 21141 not indexed biblionumber 21142 not indexed biblionumber 21145 not indexed 19000 done biblionumber 21810 not indexed biblionumber 21811 not indexed 2 done biblionumber 22320 not indexed biblionumber 22338 not indexed biblionumber 22386 not indexed biblionumber 22583 not indexed 21000 done biblionumber 23506 not indexed biblionumber 23507 not indexed biblionumber 23508 not indexed 22000 done 23000 done 24000 done 25000 done 26000 done 27000 done 28000 done 29000 done 3 done 31000 done 32000 done biblionumber 34273 not indexed biblionumber 34274 not indexed biblionumber 34275 not indexed biblionumber 34276 not indexed biblionumber 34277 not indexed biblionumber 34278 not indexed biblionumber 34279 not indexed biblionumber 34280 not indexed biblionumber 34281 not indexed biblionumber 34282 not indexed biblionumber 34283 not indexed biblionumber 34284 not indexed biblionumber 34285 not indexed biblionumber 34286 not indexed biblionumber 34287 not indexed biblionumber 34288 not indexed biblionumber 34289 not indexed biblionumber 34290 not indexed biblionumber 34291 not indexed biblionumber 34292 not indexed biblionumber 34293 not indexed biblionumber 34294 not indexed biblionumber 34295 not indexed biblionumber 34296 not indexed biblionumber 34297 not indexed biblionumber 34298 not indexed biblionumber 34299 not indexed biblionumber 34300 not indexed biblionumber 34301 not indexed biblionumber 34302 not indexed biblionumber 34303 not indexed biblionumber 34304 not indexed biblionumber 34305 not indexed biblionumber 34306 not indexed biblionumber 34307 not indexed biblionumber 34308 not indexed biblionumber 34309 not indexed biblionumber 34310 not indexed biblionumber 34311 not indexed biblionumber 34312 not indexed biblionumber 34313 not indexed biblionumber 34314 not indexed biblionumber 34315 not indexed biblionumber 34316 not indexed biblionumber 34317 not indexed biblionumber 34318 not indexed biblionumber 34319 not indexed biblionumber 34320 not indexed biblionumber 34321 not indexed biblionumber 34322 not indexed biblionumber 34323 not indexed biblionumber 34324 not indexed biblionumber 34325 not indexed biblionumber 34326 not indexed biblionumber 34327 not indexed biblionumber 34328 not indexed biblionumber 34329 not indexed biblionumber 34330 not indexed biblionumber 34331 not indexed biblionumber 34332 not indexed biblionumber 34333 not indexed biblionumber 34334 not indexed biblionumber 34335 not indexed biblionumber 34336 not indexed biblionumber 34337 not indexed biblionumber 34338 not indexed biblionumber 34339 not indexed biblionumber 34340 not indexed biblionumber 34341 not indexed biblionumber 34342 not indexed biblionumber 34343 not indexed biblionumber 34344 not indexed biblionumber 34345 not indexed biblionumber 34346 not indexed biblionumber 34347 not indexed biblionumber 34348 not indexed biblionumber 34349 not indexed biblionumber 34350 not indexed 138 bibliorecords not indexed I am afraid I don't know what to do from now
[Koha] SQL queries to delete records from the database?
Hi there (re: rebuild-zebra stops working very often, which is not a proper title any more... :p) I tried to edit a few records from these non-indexed records. As we speak another language, we have accent issues. So I need to make sure (again) that our librarians doesn't use any accent on the letters. So all the records which I have found from that list of non-indexed records have accent problems. On some records, I can edit the content and remove the accents. But for some records, I can't even edit the content, because then there is an error with Koha, the page doesn't show anything with something like that: Software error: Can't call method field on an undefined value at /usr/share/koha/lib/C4/Items.pm line 1421. which is just a random error because it can't find the record anymore (it finds the records on certain pages, for instance if I want to see its history, but it can't find the record on any page where it should show its title). So no way to solve the problem using the Koha interface... I guess I need a sql query to delete these records from the database, but something that would really delete everything related to that item (history, etc). Do you have any idea about that? But then I just don't understand why these problem records prevent zebra from reindexing the newly entered records... :/ Anyway, I have done the koha-rebuild-zebra -v -f library command to reindex everything. See below the new report from that new perl script, we moved from 138 non-indexed records to 56 non-indexed records, just because I have modified a few records (5?) and because I have rerun rebuild-zebra (so it indexed the newly entered records which had no accent problems anyway). Many thanks for your help! Would greatly appreciate your expertise about SQL queries to delete everything for faulty records. Sonia. 1000 done 2000 done biblionumber 2315 not indexed 3000 done 4000 done biblionumber 5230 not indexed biblionumber 5234 not indexed 5000 done 6000 done 7000 done 8000 done 9000 done 1 done 11000 done 12000 done 13000 done 14000 done 15000 done 16000 done 17000 done biblionumber 19992 not indexed biblionumber 20030 not indexed 18000 done biblionumber 20177 not indexed biblionumber 20234 not indexed biblionumber 20316 not indexed biblionumber 20317 not indexed biblionumber 20397 not indexed biblionumber 20398 not indexed biblionumber 20399 not indexed biblionumber 20400 not indexed biblionumber 20418 not indexed biblionumber 20446 not indexed biblionumber 20448 not indexed biblionumber 20491 not indexed biblionumber 20494 not indexed biblionumber 20495 not indexed biblionumber 20499 not indexed biblionumber 20500 not indexed biblionumber 20501 not indexed biblionumber 20502 not indexed biblionumber 20505 not indexed biblionumber 20590 not indexed biblionumber 20614 not indexed biblionumber 20615 not indexed biblionumber 20616 not indexed biblionumber 20617 not indexed biblionumber 20618 not indexed biblionumber 20626 not indexed biblionumber 20627 not indexed biblionumber 20628 not indexed biblionumber 20648 not indexed biblionumber 20677 not indexed biblionumber 20686 not indexed biblionumber 20849 not indexed biblionumber 20917 not indexed biblionumber 20921 not indexed biblionumber 21016 not indexed biblionumber 21039 not indexed biblionumber 21045 not indexed biblionumber 21097 not indexed biblionumber 21138 not indexed biblionumber 21141 not indexed biblionumber 21142 not indexed biblionumber 21145 not indexed 19000 done biblionumber 21810 not indexed biblionumber 21811 not indexed 2 done biblionumber 22320 not indexed biblionumber 22338 not indexed biblionumber 22386 not indexed biblionumber 22583 not indexed 21000 done biblionumber 23506 not indexed biblionumber 23507 not indexed biblionumber 23508 not indexed 22000 done 23000 done 24000 done 25000 done 26000 done 27000 done 28000 done 29000 done 3 done 31000 done 32000 done 56 bibliorecords not indexed ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Fast Cataloging framewok
Our installation of Koha doesn't seem to have the MARC framework for fast cataloging. All we have is the default. I spent an hour and a half creating a new framework and deleting out all the fields I didn't think we needed. . .only fail. Can someone export the fast add framework for me or where can I get a copy? Thanks, Shane -- View this message in context: http://koha.1045719.n5.nabble.com/Fast-Cataloging-framewok-tp5720665.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 3.6.7 released
The Koha community is proud to release Koha version 3.6.7. This is a bugfix release, and contains a number of important fixes You can obtain Koha 3.6.7 from the http://download.koha-community.org site. Debian packages will be available from the http://debian.koha-community.org shortly also. Please read the release notes below for more information RELEASE NOTES FOR KOHA 3.6.7 21 Jul 2012 Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.6.7 can be downloaded from: http://download.koha-community.org/koha-3.06.07.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.6.7 is a bugfix/maintenance release. Highlights of 3.6.7 == 7894 blocker Broken detail page for first link on page 2 from search result page in OPAC 8140 blocker Error when exporting label xml 8144 critical 775 tag in the MARC record causes display issue 8082 major The: IssuingInProcess configuration setting is working in reverse. 8201 major can't change receive date Bugs fixed in 3.6.7 == 3638 normal Status of hold not changed when item checked in via SIP2 Interface 4330 normal Copyright statements out of date 5795 normal Missing ReservesControlBranch system pref in database installer 7548 normal Missing arguments in the pagination of receptions 7599 normal Cart JavaScript contains untranslatable English strings 7604 normal Link on basket group name for closed basket groups is broken 8111 normal Language chooser display problem in self-checkout 8116 normal z3950 empty search causes silent warning in koha-error_log 8176 normal $sqlwhere is undefined in C4::Serials in GetSubscriptions 7948 minor Printing transfer slip loses barcode field focus 3521 trivial Items table in catalogue/detail.pl and cataloguing/additem.plis sorted nonsensically 7496 trivial Personally identifying information sent in opac user TITLE 6684 enhancement koha-remove should check the number of arguments it gets 7847 enhancement OPAC search dies with plack 8001 enhancement Add some styling to the tags to allow them to be distinctive 8080 enhancement login and password is pre-filled by the browser when creating a new patron 8489 enhancement Revised ubuntu-pkg-check.sh, renamed ubuntu package files, tweaked 12.04 package file, copied 12.04 package file to ubuntu.packages New sysprefs in 3.6.7 == * ReservesControlBranch System requirements == Important notes: * Perl 5.10 is required * Zebra is required Documentation == As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, only the English version of the Koha manual is available: http://manual.koha-community.org/3.6/en/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations == Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * Arabic (51%) * Chinese (China) (96%) * Chinese (Taiwan) (99%) * Danish (99%) * English (New Zealand) (97%) * English (USA) * English (United Kingdom) (64%) * French (99%) * French (Canada) (95%) * German (100%) * Greek (94%) * Italian (100%) * Norwegian BokmÃ¥l (62%) * Portuguese (Brazil) (99%) * Spanish (100%) * Tetun (52%) Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://wiki.koha-community.org/wiki/Translating_Koha for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha-community.org/ Release Team == The release team for Koha 3.6 is Release Manager:Chris Cormack chr...@catalyst.net.nz Documentation Manager: Nicole C Engard neng...@gmail.com Translation Manager:Frédéric Demians frede...@tamil.fr QA Manager: Ian Walls ian.wa...@bywatersolutions.com Bug Wranglers: MJ Ray, Marcel de Rooy, Paul Poulain, Mason James Past Release Maintainer (3.6.x): Chris Nighswonger cnighswon...@foundations.edu Release Maintainer (3.6.x): Jared Camins-Esakov jcam...@cpbibliography.com Credits == We thank the following
Re: [Koha] Fast Cataloging framewok
Hi, ShaneGreen wrote Can someone export the fast add framework for me or where can I get a copy? You can get the sql file from git. You can download it from the »marc21_fastadd_framework.sql« link here http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql;h=40180d06f1a49f0f7d0ed83d32a81fdf1678ceaa;hb=HEAD -- Mirko ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha