Re: [Koha] Rebuild-zebra stops working very often...

2012-07-21 Thread Sonia P .

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...

2012-07-21 Thread Sonia P .

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?

2012-07-21 Thread Sonia P .

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

2012-07-21 Thread ShaneGreen
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

2012-07-21 Thread Jared Camins-Esakov
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

2012-07-21 Thread Mirko
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