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

Re: [Koha-devel] db from 3.8.5 to 3.8.10
by Paul 08 Mar '13

08 Mar '13

At 04:46 PM 3/7/2013 -0300, Tomas Cohen Arazi wrote: >Paul, we've been through 3.8.0 to 3.8.10 without any issues. Doing a full >rebuild should make your registers appear. rebuild_zebra.pl is just not a >fullrebuild, but an incremental one. Thanks for the reply. Yes, as I said (below), a full c/l re-index -a -r -v and -b -r -v -x solves the problem: $ su koha $ cd usr/share/koha $ ./bin/migration_tools/rebuild_zebra.pl -a -r -v $ ./bin/migration_tools/rebuild_zebra.pl -b -r -v -x but I'm trying to avoid an hourly (or more frequent) cronjob on our production server (3.8.5.) I've got it set up at 30 min intervals on the sandbox (3.8.10) and it's not too painful in low usage, but am truly looking for a programmatic solution for "real life." Although -r is given as "reset", I thought it was equivalent to "rebuild" as compared to -z "process_zebraqueue" which is truly incremental. Certainly given the CPU time and the "verbose" output, it looks as though -r is not just incremental but a complete rewrite. But I'll also freely admit that <http://www.indexdata.com/zebra/doc/> is a challenging "read" in Koha context. Best - Paul >Regards >To+ > > > >On Thu, Mar 7, 2013 at 3:53 PM, Paul <paul.a(a)aandc.org> wrote: >At 12:04 PM 3/7/2013 -0500, Jared Camins-Esakov wrote: >Paul, > >[snip] >The standard CRON job runs successfully. > >[snip] >A full c/l re-index -a -r -v and -b -r -v -x solves the problem. As I can >reproduce this behaviour (by restoring the same dump) is there anything >helpful that I could look into? Ã Could this be related to Bug 9511? The >fix does not appear to work for me, I've just updated bugzilla. > > >This doesn't sound like a bug. When restoring a dump you *must* completely >reindex from the command line. Always. There are no exceptions. > > >Sorry, I wasn't clear. After restoring the dump and running 'installer', >the -z -x CRON functions with 99% [???] accuracy. What I'm looking at is >any possible "similarity" of Zebra behaviour to try and get the CRON >working in 3.8.10 which is reported on bugzilla 9511 to be functional for >two libraries that have updated from 3.8.5, but does not (for me) resolve >the problem of deleted biblios, nor of overwriting an existing biblio with >a Z39.50 import. > >I've been chasing around after a solution for a couple of days (part time) >with no success whatsoever. Maybe I'm grasping at straws? > >Our volunteers are adding 150-200 biblios per day, 7/7, many of which are >Z39.50 "overwriting" of embryonic data from previously importing >spreadsheets into 3.4.6, and regrouping items (particularly serials) under >a single biblio. Â I find that I'm asked about once an hour on average to >"completely re-index" and am somewhat desperate to find a programmatic >solution. > >I appreciate any/all suggestions. > >Best - Paul

1 0

Re: [Koha-devel] db from 3.8.5 to 3.8.10
by Paul 07 Mar '13

07 Mar '13

At 12:04 PM 3/7/2013 -0500, Jared Camins-Esakov wrote: >Paul, [snip] >>The standard CRON job runs successfully. [snip] >>A full c/l re-index -a -r -v and -b -r -v -x solves the problem. As I can >>reproduce this behaviour (by restoring the same dump) is there anything >>helpful that I could look into? Â Could this be related to Bug 9511? The >>fix does not appear to work for me, I've just updated bugzilla. > >This doesn't sound like a bug. When restoring a dump you *must* completely >reindex from the command line. Always. There are no exceptions. Sorry, I wasn't clear. After restoring the dump and running 'installer', the -z -x CRON functions with 99% [???] accuracy. What I'm looking at is any possible "similarity" of Zebra behaviour to try and get the CRON working in 3.8.10 which is reported on bugzilla 9511 to be functional for two libraries that have updated from 3.8.5, but does not (for me) resolve the problem of deleted biblios, nor of overwriting an existing biblio with a Z39.50 import. I've been chasing around after a solution for a couple of days (part time) with no success whatsoever. Maybe I'm grasping at straws? Our volunteers are adding 150-200 biblios per day, 7/7, many of which are Z39.50 "overwriting" of embryonic data from previously importing spreadsheets into 3.4.6, and regrouping items (particularly serials) under a single biblio. I find that I'm asked about once an hour on average to "completely re-index" and am somewhat desperate to find a programmatic solution. I appreciate any/all suggestions. Best - Paul

2 1

db from 3.8.5 to 3.8.10
by Paul 07 Mar '13

07 Mar '13

I found a [minor?] problem with the 3.8.10 tarball on Ubuntu 12.04.2 LTS on my sandbox after restoring a 3.8.5 mysql dump from our production box, at which point 'installer' does its magic. All the biblios appear to transfer correctly ('mysql> select biblionumber from biblio;' gave identical results; same with author, etc.) The standard CRON job runs successfully. Problem: a small number of biblios "went missing" in 3.8.10. It *seemed* to be limited to 'serials' but I can't be sure, as I could only find them on a 'hit or miss basis' -- in fact I only found the first one accidentally: e.g. a biblio and three items for the serial Flugsport could not be found by title, by author, by Barcode, by author in authorities ... even "No results match your search for 'biblionumber=19762' in NMA Catalog." Yet, run a Koha report: SELECT * FROM biblioitems, biblio, items WHERE biblio.biblionumber=19762 AND biblioitems.biblionumber=19762 AND items.biblionumber=19762 and everything was there, including the blobs, MARC, XML ... A full c/l re-index -a -r -v and -b -r -v -x solves the problem. As I can reproduce this behaviour (by restoring the same dump) is there anything helpful that I could look into? Could this be related to Bug 9511? The fix does not appear to work for me, I've just updated bugzilla. Thanks - Paul

2 1

reserveconstraints
by Marcel de Rooy 06 Mar '13

06 Mar '13

Hi, I stumbled over some code involving reserveconstraints. I just assume that it is an old table from before 3.0. Am I correct? Can we remove associated code? Is there a scenario that someone comes from 2.X with records in that table that should still be considered somehow? Note that it looks like records in there will never be deleted anymore, so if that is true, we should just get rid of them? BTW Funny to see that update22to30 even creates the table with only field reservedate, if it was not there.. Thx for your response if you know some more details. Marcel

1 0

Will you do a presentation at California Library Association Annual Conference?
by Lori Bowen Ayre 05 Mar '13

05 Mar '13

Hi All, Anyone interested in doing a program at the California Library Association's annual conference? It will be in Long Beach, CA November 3-5 and I've done some kind of session on Open Source every year for the last few years but it would be great to get some new perspectives. Submit a proposal! We need Evergreen represented! http://conference.cla-net.org/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-= Lori Bowen Ayre // Library Technology Consultant / The Galecia Group (707) 763-6869 // Lori.Ayre(a)galecia.com Availability: http://doodle.com/loriayre <Lori.Ayre(a)galecia.com>Specializing in open source software solutions, RFID, filtering, workflow optimization, and materials handling =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

2 1

3.8.10 on Ubuntu 12.04.2 LTS
by Paul 04 Mar '13

04 Mar '13

Just finished a brand new (sandbox) install from tarball of 3.8.10 on a 64-bit Ubuntu 12.04.2 (note last digit) LTS server. All seems good, but have not had much time yet to play with it -- install went smoothly, no problems, 1 hour 35 mins from partitioning to fully functional copy of production db including our customizations. One question that I have not yet had time to fully look into, so I'm looking for pointers/suggestions, please. dpkg (ubuntu.12.04.packages) asks for libdbd-sqlite2-perl which is no longer available (except in the "unsupported" Universe repository), replaced by libdbd-sqlite3-perl which I installed. koha_perl_deps.pl -m gives the "2" version as "missing - not required" but after install <About><Perl modules> highlights DBD::SQLite2 in bright pink! I haven't yet found any lack of functionality, but could one of you suggest a "test" that specifically calls this module? Or does the "not required" mean "not in production machines"? In which case the bright pink highlighting might be a "bug - enhancement - low priority." Many thanks and best regards - Paul

2 2

Deletion of changelanguage.pl and opac-changelanguage.pl
by Tomas Cohen Arazi 04 Mar '13

04 Mar '13

Working on Bug 9735 [1] I ended up writing C4::Templates::getlanguagecookie and hooking C4::Auth::get_template_and_user in a way that the language can be changed using URL parameters, and the corresponding is properly set. Using this new code, the language selection could be simplified by using JavaScript + document.location to generate the links to languages. What do u think? Regards To+ [1] http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9735

3 3

(no subject)
by Ashok Mishra 04 Mar '13

04 Mar '13

I am trying to install and configure KOHA for my institute. My server is on a private network and the Internet is accessible only throw PROXY. I am not able to search throw z39.50 servers in KOHA application. Please help Ashok mishra bansal college of pharmacy,bhopal m.p. -- Ashok Mishra *Librarian* Bansal College of Pharmacy, Bhopal

2 1

Old bugs to check
by MJ Ray 04 Mar '13

04 Mar '13

Would you check some of these rather old bugs to suggest what to do, please? Maybe some can be RESOLVED FIXED by now or need a question. Ideally, tell irc.oftc.net #koha know that you're looking at a bug. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5302 Replace current call number splitting code with a plug-in system based on classification source http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5085 Funds summary ignores quantityreceived http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4236 Create Claims Returned and stop charging fines on those items http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5388 Circulation of related/requiring items (like Book and CD sets) http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5434 More granular hold rules http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5937 Subtle differences in columns between installed db and upgraded db http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4164 Way to Clone Keyword Mapping to other Frameworks http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3147 call to ModZebra in DelAuthority fails (fatal error) if record previously deleted but still exists in index http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5956 Highlight holds on check-in http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4304 autoBarcode should increment from user defind value http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4115 print a batch of patron cards from an import http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4488 OPAC reports incorrect hold limit in warning. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5800 Hold Policy "home library only" incompatible with CircControl "patron home library" http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4148 Advanced Search not sorting by author http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5614 patron prefs not in categories http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5404 C4::Koha::subfield_is_koha_internal_p no longer serves a purpose http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4480 MARC21 033 tag and Zebra date indexing http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4457 Improve serials acquisitions link http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3645 Specify Duedate as part of item type -- Email robot driven by MJ Ray (slef), member of www.software.coop, http://koha-community.org supporter, web and library systems developer. Available for hire (including development) at http://www.software.coop/

1 0

My talk on Live DVD blue print
by Vimal Kumar V. 02 Mar '13

02 Mar '13

Dear Friends, I am in a sad situation. When I try to click on edit button of Koha wiki page, it ask to download a index.php file. So, I could not add the suggestion in Talk page. Please consider my suggestions and add in talk page. 1. Inclusion of too many materials (e.g. Video tutorials) make the DVD big. Inclusion of manual is OK. It will take too much time for download. 2. Addition of Offline client is a nice suggestion. Need to add any other useful small tools (e.g. glabel) ? 3. Chris mentioned about GUI for backup from Koha staff client. This feature available in Koha 3.12 version? 4. We can create a new framework for customized fields. Upgrade to new version shatter this framework? 5. In my opinion Remastersys is good for creating a clone of the system. Simplicity is the main feature. Users can make ISO of the system as a backup using remastersys. Its backup mechanism can retain user settings and the exact environment of the master PC. Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

3 2