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

Koha version 3.6.8 released
by Jared Camins-Esakov 22 Aug '12

22 Aug '12

The Koha community is proud to release Koha version 3.06.08.000. This is a bugfix release, and contains a number of important fixes You can obtain Koha 3.06.08.000 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.8 22 Aug 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.8 can be downloaded from: http://download.koha-community.org/koha-3.06.08.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.8 is a bugfix/maintenance release. Highlights of 3.6.8 ====================== 7329 critical The "undo import into catalog" command deletes items onloan without checking 7834 critical order search at the top of acq does nothing 8289 critical Upgrading from 2.2 does not work anymore 2505 major enable Perl warnings in all modules and scripts 8315 major fix 'C4::Output 3.02' errors in Koha Bugs fixed in 3.6.8 ====================== 4838 normal Repeated authority headings break biblio record data entry form 6634 normal manager_id not populated when paying fines 6720 normal Saved authorities always show as 'Default' 7586 normal Search: Language restriction does NOT show expected results (no items shown) 7807 normal GetSuggestionFromBiblionumber takes only one parameter 7886 normal C4/ShelfBrowser slow SQL performance 7900 normal Link to vendor from subscription details is broken 7952 normal PDF::Reuse under plack writes to console STDOUT instead to browser 8136 normal Changes the expected lenght of 100$a in rebuild_zebra.pl 8171 normal Improper escaping of quotes during z39.50 queries leads to broken html 8197 normal Software error when you have cleaned cookies in your browser and try to past the url to opac-topissues.pl 8226 normal 'OpacFooter' markup/css improvements 8282 normal Bug in modules list in about.pl 5312 minor XHTML correction in authority summary 6141 minor html glitches causing problems to translator 6679 minor Fixing code so it passes basic Perl::Critic tests 7815 minor Order pickup library list by name rather than by code 8009 minor Item descriptive data not populated on pay.pl 8166 minor Adding new currencies & exchange rates if not fill any field it save blank record 8191 minor New value for 8 position in coded data field 100 in unimarc 8232 minor Comments in OPAC contain untranslatable javascript messages 6350 trivial Bug for tracking updates to the history file 7143 trivial Bug for tracking changes to the about page 7367 trivial General OPAC typo omnibus 7368 trivial General staff client typo omnibus 7994 trivial Syntax error in yaml (syspref) files 8222 trivial The zip code field is mandatory by default 8138 enhancement Add 773$t field to xslt 8216 enhancement Enable critic tests on SIP modules New sysprefs in 3.6.8 ====================== * BorrowerMandatoryField 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 (100%) * English (New Zealand) (100%) * 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 <chrisc(a)catalyst.net.nz> Documentation Manager: Nicole C Engard <nengard(a)gmail.com> Translation Manager: Frédéric Demians <frederic(a)tamil.fr> QA Manager: Ian Walls <ian.walls(a)bywatersolutions.com> Bug Wranglers: MJ Ray, Marcel de Rooy, Paul Poulain, Mason James Past Release Maintainer (3.6.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.6.x): Jared Camins-Esakov <jcamins(a)cpbibliography.com> Credits ====================== We thank the following individuals who contributed patches to Koha 3.6.8. 1 D Ruth Bavousett 5 Jared Camins-Esakov 3 Colin Campbell 4 Chris Cormack 1 Christophe Croullebois 2 Frédéric Demians 1 Jonathan Druart 3 Katrin Fischer 1 Amit Gupta 1 Kyle M Hall 2 Claire Hernandez 2 Mason James 1 Srdjan Jankovic 1 Owen Leonard 1 Julian Maurice 1 Matthias Meusburger 4 Sophie Meynieux 3 Dobrica Pavlinusic 1 Maxime Pelletier 4 Paul Poulain 3 Marcel de Rooy 1 Fridolyn SOMERS 1 Robin Sheat 1 Marc Veron 2 christophe croullebois We also especially thank the following individuals who tested patches for Koha 3.6.8. 51 Jared Camins-Esakov 1 François Charbonnier 41 Chris Cormack 2 Michael Davis 5 Katrin Fischer 1 Marijana Glavica 3 Kyle M Hall 1 Owen Leonard 1 Sophie Meynieux 31 Paul Poulain 2 Martin Renvoize 3 Marcel de Rooy 1 Robin Sheat 2 Marc Veron 1 Stacey Walker We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patches(a)lists.koha-community.org. Revision control notes ====================== The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of git://git.koha-community.org/koha.git The branch for this version of Koha and future bugfixes in this release line is 3.6.x. The last Koha release was 3.8.2, which was released on June 22, 2012. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Ehara taku toa i te toa takitahi, engari he toa takitini

1 0

Disappearing test cases or did another part of MySQL just become closed source? « The MariaDB Blog
by Marc Balmer 21 Aug '12

21 Aug '12

I stumbled over this blog entry: http://blog.mariadb.org/disappearing-test-cases/ It is this development of MySQL that make me so unhappy with the fact that Koha runs on MySQL only at the moment. Imo, Koha would be a much better product if it used PostgreSQL as the database system. -- Marc Balmer micro systems, http://www.msys.ch/ Tel. +41 61 383 05 10, Fax +41 61 383 05 12

5 4

koha-zebra-daemon not starting
by Paul 20 Aug '12

20 Aug '12

Koha 3.8.3 on Ubuntu 12.04 LTS server (new install, full upgrade) Everything went well on install. Data from 3.6.1 "converted" to 3.8.3 when I opened the staff-admin page; zebra reindex went well for authorities, but failed for biblios first time around: 14:27:16-19/08 zebraidx(3357) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/norm..LCK [No such file or directory] 14:27:16-19/08 zebraidx(3357) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/shadow..LCK [No such file or directory] 14:27:16-19/08 zebraidx(3357) [fatal] Could not select database biblios errCode=109 but after a reboot, rebuild_zebra.pl -b -r -v -x reported nothing fatal (single warning about a register not found, no details); cron job running normally. But neither OPAC nor staff search functions are operational. The only anomaly that I've found so far is that /etc/init.d/koha-zebra-daemon when run from the command line reports failure at line 73 (and does not create any error logs), but ps aux reports the daemon as running (well, "S+" -- sleep forground.) Anyone got any thoughts please? tnx and br - Paul

4 4

Call for News for the August Newsletter
by Daniel Grobani 16 Aug '12

16 Aug '12

Dear Koha Kommunitarians, I'm harvesting news for this month's newsletter. Please send me by the 25th anything you think your fellow community members might like to know about. "News" can be as short as a sentence or as long as a paper. I especially encourage you to send me a line or two for the gossip/society column about what you're currently working on. And if you know of a go-live not announced on the list, please be sure to let me know about it. Thanks, Daniel Grobani

1 0

KOCT translatable, please translate !
by Paul Poulain 14 Aug '12

14 Aug '12

Hello, The Koha Offline Circulation Tool, a firefox plugin, is now translatable. I just pushed a patch that add this feature and the translation to french. It's very easy to add a translation, just head here : http://git.koha-community.org/gitweb/?p=contrib/global.git;a=tree;f=koct/ch… (in koct/chrome/locale directory if you clone the git repo) cp -r en-US yourlocale-language cd yourlocale-language translate the 2 tiny files koct.dtd and koct.properties git add yourlocal-language git commit git format-patch send me the patch, I'll push it. -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

2 3

Re: [Koha-devel] gmail as smtp error
by George Mikuchadze 13 Aug '12

13 Aug '12

Dear Chris, Thanks for reply: 1. The case of the delivery failure is very strange: Message is sent from the legal gmail address, which is indicated in the process_message_queue.pl parameters (for example: process_message_queue.pl -u library(a)sciencelib.ge -p password -m LOGIN) and the failure message I get in the library(a)sciencelib.ge mailbox. What about host file, the host has not routable ip (192.168.1.xx ) - it's a test system for using gmail as mailing server. 2. What about backporting the mods I've changed process_message_queue.pl script as described in the Bug 5251. But in C4/Letters.pm module (for koha v3.0) I 've made the following changes: I've replaced the "sub _send_message_by_email()" by the one from the koha v3.2 and only after added described lines. I'm not sure that it's a correct action. Best Regards George Mikuchadze -----Original Message----- From: Chris Nighswonger [mailto:cnighswonger@foundations.edu] Sent: Saturday, August 11, 2012 7:54 PM To: George Mikuchadze Cc: chris(a)bigballofwax.co.nz; koha(a)lists.katipo.co.nz Subject: Re: gmail as smtp error Hi George, Please always include the list on your emails as you will get more eyes on the problem as well as everyone benefiting from the answers. On Sat, Aug 11, 2012 at 10:01 AM, George Mikuchadze <giamik(a)vfemail.net> wrote: > Delivery to the following recipient failed permanently: > > koha(a)localhost.localhost or root(a)localhost.localhost (localhost > means result of `hostname` command) > > > Technical details of permanent failure: > > DNS Error: Domain name not found > It looks like your hostname is not set to a resolvable domain name. I'd take a look at the host file to be sure things there are in order. localhost is definitely not going to resolve on any public network. > > As I understand koha can’t get right patrons email. > As for koha not retrieving patrons' emails correctly, I'm not sure there either. I would suggest going over the section on notices in the manual (http://manual.koha-community.org/3.6/en/cronjobsch.html#noticescron) as there are a variety of options and sysprefs related to notices which must be properly configured in order for them to work correctly. My guess is that something is not configured correctly. > > How to configure koha 3.0 (prior to 3.2) to use gmail as smtp server? > This is probably not possible without backporting the mods in this commit: http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d31c1603cca… Even then, there may be other issues which crop up. Kind Regards, Chris

2 2

is hidelostitems syspref obsolete?
by Fridolyn SOMERS 10 Aug '12

10 Aug '12

Hie, I wonder if with the 'OpacHiddenItems' system preference, you can reproduce what's managed by 'hidelostitems' system preference. For example, if LOST values are 0,1,2,3 (0 meaning not lost), you can use in OpacHiddenItems : itemslost [1, 2, 3]. So can we imagine removing 'hidelostitems' ? Best regards. -- Fridolyn SOMERS Biblibre - Pôle Support fridolyn.somers(a)biblibre.com <mailto:fridolyn.somers@biblibre.com>

3 4

Re: [Koha-devel] 3.8.3 dependencies
by Paul 09 Aug '12

09 Aug '12

Tomas and Robin, Thanks for the replies. My comments below: At 05:42 PM 8/8/2012 -0300, Tomas Cohen Arazi wrote: >Robin, >On Wed, Aug 8, 2012 at 5:23 PM, Robin Sheat <robin(a)catalyst.net.nz> wrote: > > Op 08-08-12 22:09, Paul schreef: > >> > >> WARNING: on the 64-bit Ubuntu 12.04, do not attempt an apt-get install > >> of libyaz4-dev_4.2.18-1build1_i386.deb - I ended up with a bunch of > >> files fragments to purge, found with sudo dpkg --configure -a > >> > >> Strangely, libgraphics-magick-perl did not fully install (it's also got > >> some i386 bits that 64-bit Ubuntu 12.04 won't digest) but it does get > >> far enough to (apparently) meet Koha 3.8.3 dependencies. > > > > You shouldn't be touching i386 packages on a 64-bit machine unless you > > really know what you're doing. libgraphics-magick-perl should be pure 64 > > bit. Better, don't install .deb files of things that are in your apt > > repo anyway. I don't go near i386 packages and I rarely use apt-get install -f -- I read the "missing dependencies" and look for them myself. However, it would appear that the Ubuntu/Debian apt-get *can* have ideas of its own and install bits of i386 code (presumably they're quite compatible, as it is either the 64-bit packages that install some of them, or apt-get installs them without advance warning; remember "i386|amd64" is not normally part of the command line.) A bit off-topic, but until recently the Flash player was only 32 bit, and I think Skype still is. >I found the ubuntu.packages to cause that behaviour on 64bit setups. I >also found that fixing the libyaz (and some libmysqlXX-dev) versions >fixed it. I didn't talk about it as Mark was revisiting those packages >files for several ubuntu releases and the side effect was that it got >fixed. Mark and I talked about that fixes on IRC. I have found a solution (64-bit) for GraphicsMagick -- it needs (believe it or not) the Windows MetaFile component: Add http://mirrors.us.kernel.org precise main to /etc/apt/sources list $ apt-get install libwmf0.2-7 libgraphicsmagick3 libgraphics-magick-perl These are in fact (from /var/cache/apt/archives/): libwmf0.2-7_0.2.8.4-10ubuntu1_amd64.deb libgraphicsmagick3_1.3.12-1.1build1_amd64.deb libgraphics-magick-perl_1.3.12-1.1build1_amd64.deb >I don't know if it has been pushed into master (and 3.8.x) right now >but I recommend using koha_perl_deps.pl and searching for the right >packages until the fixed files get pushed. > >Paul: try > >$ dpkg -l | grep 386 None ... Again thanks and best regards, Paul

2 1

Serials Work RFC - Storing Enumeration Data
by Kyle Hall 09 Aug '12

09 Aug '12

Hello All, I'm working with a library that is having problems running reports based on serials enumeration data, and I was hoping to get some feedback on an idea I have. Right now, we store the enumeration format in subscription.numberingmethod ( e.g. "Vol {X}, No {Y}, Issue {Z}" ). When the serial is received, the X, Y and Z are replaced with real values and this is stored in serials.serialseq and items.enumchron, I'm wondering if it would be better to store this data in separate columns instead. 1. Add columns x_description, y_description, and z_description to the table subscription. In the above example these would contain 'Vol', 'No', and 'Issue' respectively. 2. Add columns x_data, y_data and z_data to the table issues. So for "Vol 5, No 2, Issue 7", these columns would be 5, 2 and 7 respectively. 3. Retrospectively parse subscription.numberingmethod into x_description, y_description, and z_description 4. Retrospectively parse serials.serialseq into x_data, y_data and z_data At this point, we could get rid of serials.serialseq, or we could keep it alongside this new data. I would lean toward keeping it as we cannot guarantee step 4 will work right, as a librarian can modify serials.serialseq by hand when receiving the item. The question is: is this a good idea, or a stupid idea? Please let me know either way! Thanks, Kyle http://www.kylehall.info ByWater Solutions ( http://bywatersolutions.com ) Meadville Public Library ( http://www.meadvillelibrary.org ) Crawford County Federated Library System ( http://www.ccfls.org ) Mill Run Technology Solutions ( http://millruntech.com )

3 2

Re: [Koha-devel] 3.8.3 dependencies
by Paul 09 Aug '12

09 Aug '12

At 12:34 PM 8/8/2012 -0300, Tomas Cohen Arazi wrote: >On Wed, Aug 8, 2012 at 12:19 PM, Paul <paul.a(a)aandc.org> wrote: > > Looking at Koha 3.8.3 on my "desktop" (64-bit Ubuntu 12.04 server plus > Gnome > > 2.3 utilities, graphics etc) > > > > Final unmet dependencies are: > > > > Graphics::Magick 0 * 1.3.05 No > > Net::Z3950::ZOOM 0 * 1.16 Yes > > XML::LibXSLT 0 * 1.59 Yes > > > > The last two are problematic. As far as I can see after a fair amount of > > trying (CPAN, Debian and Ubuntu repositories) they both, via yaz, are > > dependant on libyaz-dev which in turn allows libxml2-dev. The most > > promising source appears to be libyaz4-dev_4.2.18-1build1_i386.deb -- but > > this fails miserably (despite "force install" and apt-get -f) as the 64-bit > > system refuses these particular i386 packages, ultimately with: >Just >$ apt-get install libyaz4 libyaz4-dev > > Does any one have pointers to a 64 bit package for Net::Z3950::ZOOM and > > XML::LibXSLT (or another workaround)? >and: >$ apt-get install libnet-z3950-zoom-perl libxml-libxslt-perl >libgraphics-magick-perl Thank you Tomas (and Robin, Mike and Mark), koha_perl_deps.pl -m -u is now giving no missing dependencies. However: WARNING: on the 64-bit Ubuntu 12.04, do not attempt an apt-get install of libyaz4-dev_4.2.18-1build1_i386.deb - I ended up with a bunch of files fragments to purge, found with sudo dpkg --configure -a Strangely, libgraphics-magick-perl did not fully install (it's also got some i386 bits that 64-bit Ubuntu 12.04 won't digest) but it does get far enough to (apparently) meet Koha 3.8.3 dependencies. I'll try and get full notes written up later and look into the koha-communities repository (off to a meeting now ...) Again, thanks to all, Paul --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

4 3