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

Re: [Koha-devel] [Koha-patches] [PATCH] When searching the catalogue, if I get no results then hit the Z39.50 search the title field in the pop up window is populated with what I searched for.
by Frère Sébastien Marie 30 Jun '11

30 Jun '11

Hi, Please use placeholders in SQL statement. Your patch could result SQL injection if user may change C4::Branch::mybranch return value or result SQL error if branchname contains "'" (quote) character. The 'safe' way should be: $bsth =$dbh->prepare("SELECT branchcode,branchname FROM branches WHERE branchcode = ?"); $bsth->execute(C4::Branch::mybranch()); As here the 'prepare' is in if-clause, the 'execute' should be too (as parameters are dependant of placeholders), resulting something like: my $bsth; if ( C4::Context->preference("searchMyLibraryOnly") ) { $bsth = $dbh->prepare("SELECT branchcode,branchname FROM branches WHERE branchcode = ?"); # FIXME : use C4::Branch::GetBranches $bsth->execute(C4::Branch::mybranch()); } else { $bsth = $dbh->prepare("SELECT branchcode,branchname FROM branches"); $bsth->execute(); } Thanks. -- Frère Sébastien Marie Abbaye Notre Dame de La Trappe 61380 Soligny-la-Trappe Tél: 02.33.84.17.00 Fax: 02.33.34.98.57 Web: http://www.latrappe.fr/ On Wed, Jun 29, 2011 at 05:44:21PM +0100, Peter Lorimer wrote: > If I search for a valid ISBN number and hit the Z39.50 search, the title field > is populated with the ISBN number I searched for. This number should populate > the ISBN field and not the title field. > --- > C4/Search.pm | 34 +++++++++++++++++++++++++++++----- > 1 files changed, 29 insertions(+), 5 deletions(-) [...] >+ my $bsth; >+ if ( C4::Context->preference("searchMyLibraryOnly") ) >+ { >+ $bsth =$dbh->prepare("SELECT branchcode,branchname FROM branches WHERE branchcode = '". C4::Branch::mybranch() ."' >+"); # FIXME : use C4::Branch::GetBranches >+ } >+ else >+ { >+ $bsth =$dbh->prepare("SELECT branchcode,branchname FROM branches "); >+ } > $bsth->execute(); [...]

1 0

mandatory & default value ignored when adding items
by Cindy Murdock Ames 29 Jun '11

29 Jun '11

Hi all, I sent the message below the the main mailing list last week, but didn't get a response, so I'm CC'ing here as well in the hopes that someone can answer my question. Thanks! Cindy -------- Original Message -------- Subject: [Koha] mandatory & default value ignored when adding items Date: Fri, 24 Jun 2011 10:11:08 -0400 From: Cindy Murdock Ames <cmurdock(a)ccfls.org> To: koha <koha(a)lists.katipo.co.nz> Hi all, I just noticed yesterday on an install (from git, on debian squeeze) of 3.4 that when I add an item not only does it ignore the "hidden" property (bug 6439: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6439) but it also ignores the default values that I've set for some fields as well as the "mandatory" setting. Am I missing something in the configuration, is it a bug, or is it just me? Cheers! Cindy -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS http://meadvillelibrary.org | http://ccfls.org _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 2

Debian installer
by Fridolyn SOMERS 29 Jun '11

29 Jun '11

Hie, I'm looking for documentation about the Koha's debian installer. I've looked at wiki but I can't find sripts "koha-*" description. Thanks, -- Fridolyn SOMERS ICT engineer PROGILONE - Lyon - France fridolyn.somers(a)gmail.com

5 9

Koha 3.4.2 is now available
by Chris Nighswonger 29 Jun '11

29 Jun '11

It is with pleasure that I announce the release of Koha 3.4.2. The package can be retrieved from: http://download.koha-community.org/koha-3.04.02.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.04.02.tar.gz.MD5 http://download.koha-community.org/koha-3.04.02.tar.gz.MD5.asc http://download.koha-community.org/koha-3.04.02.tar.gz.sig Release notes for 3.4.2 are below. Come and get it! RELEASE NOTES FOR KOHA 3.4.2 - 27 June 2011 ======================================================================== 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.4.2 can be downloaded from: http://download.koha-community.org/koha-3.04.02.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.4.2 is a bugfix/maintenance release. Highlights of 3.4.2 ====================== 6518 blocker XSS vulnerabilities in the OPAC 2246 critical Label printing doesn't work with Unicode characters 4993 critical ldap search always anonymous when using auth_by_bind 5658 critical can't delete subfields in frameworks 5683 critical link_bibs_to_authorities.pl can corrupt records 5860 critical Adding duplicate stocknumber will fail silently 6343 critical Label Creator not working, Current Branch: NULL 6395 critical cannot create routing list - template error? 6472 critical HidePatronName no longer works as stated 6525 critical hold filled emails not going out 3140 major It is possible to email someone else's private list 4319 major waiting items cannot be reserved 5094 major auth_by_bind authentication can fail even if given a correct password and userid 5918 major When AddPatronLists is set to "general" and EnhancedMessagingPreferences is set, messaging prefs not copied from defaults 6258 major Guided reports wizard 'Build new' brings up empty page 6300 major can't get to other pages of marc import 6340 major Pagination bar on guided reports result page broken 6351 major Cannot delete library-specific circulation rules 6370 major news showing that it's for the opac when it's for the librarian interface 6452 major Missing SQL placeholders 6497 major MARC URLs not showing up in both OPAC and staff client Details page under non-XSLT view Bugs fixed in 3.4.2 ====================== 5509 Packaging scripts get upset when there's an LDAP configuration in the koha_conf.xml 5653 default new label layout and sample data have broken call number placeholder 5684 Z3950 search on OCLC pulls in items (tag 952) 5868 Subject indexes do not search most 6xx fields 6031 koha-rebuild-zebra doesn't allow XML and verbose indexing 6067 When Add Duplicate changing framework would lose data 6103 Many MARC21 fields not searched with CCL indexes due to misconfiguration 6131 (unimarc only) improper index name for personal-name 6170 'More options' in advanced search broken 6306 It is not possible edit news 6337 Variable scope errors in staff client cart print view 6338 Datepickers on OPAC hold form does not work 6342 Help link doesn't popup anymore contextual help page 6353 Erroneous prefixes before the singleBranchMode preference 6355 Late orders report shows cancelled orders 6363 The "Item Location" selectbox in inventory.pl doesn't appear when the default MARC framework is the only one avaiable. 6364 Display of item availability broken on OPAC detail screen 6365 Missing information about tab number when mandatory fields unfilled 6402 Lists sorted by year appear to be empty 6408 column alignment off on the patron categories admin 6409 pagination bar for guided report output does not work if report has parameters 6417 Template variable errors in Guided Reports 6436 Don't allow deletion of an itemtype used in items.itype 6444 Encoding problems with vendor names in subscription-add.pl 6446 batch item deletion interface problems 6463 Authorities browsing error when using auth. plugins 6487 No error explanation if patron expiration date is missing 6510 "Sort by" in intranet search alters search and number of hits 6512 Time missing from Item circulation history table 6521 Editing a patron fails with blank cardnumber 5268 Language Issue: Debarred 5714 Unescaped ampersands in OPAC facets 6091 Remove undeclared syspref OPACAdvSearchInputCount 6357 Items (un)availability not displayed correctly (OPAC) 6367 'Preview MARC' hover button does not show correct MARC record 6375 Markup and style corrections for overdue report 6377 fines should be red on patron search 6378 Misaligned columns on tags approval page 6388 Broken pager images in branch_transfer_limits.tt 6389 Administration menu like Tools menu 6397 Mis-named variable in .TT causes table cell shift 6442 opacnav pref explained wrong 6453 The "Compare barcodes list to results" functionnality of inventory.pl can't find barcodes 6462 Authority type is not displayed in OPAC 5020 on patron record sex should be gender 6332 missing 'clear date' link 6350 Bug for tracking updates to the history file 6401 Give Ian Walls credit in the history file. 6459 Needless call to C4::Context->dbh in C4::Templates::themelanguage() 5929 Use branch admin email for advance_notice.pl emails 6050 GetItemsInfo ignores second parameter 6294 Add {BIBLIONUMBER} parsing support to SearchForTitleIn syspref 6347 Bug in opac-reserve.pl stopping item level holds 6362 Fix MARC display in OPAC 6415 Can't make a patron card batch 6429 Updating development team in about 6433 rebuild_zebra.pl does not handle MARC::Record exceptions gracefully 6464 Add inconsistence check for '%s' count in tmpl_process3.pl 6491 Add Div in privacy page System requirements ====================== Changes since 3.2: * Template::Toolkit 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://koha-community.org/documentation/3-4-manual/ 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: * Chinese * Danish * English (New Zealand) * English (USA) * French (France) * French (Canada) * German * Greek * Hindi * Italian * Norwegian * Portuguese * Spanish * Turkish 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.4 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> Release Maintainer (3.2.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.4.x): Chris Nighswonger <cnighswonger(a)foundations.edu> QA Manager: Colin Campbell Credits ====================== We thank the following individuals who contributed patches to Koha 3.4.2. Tomas Cohen Arazi Alex Arnaud D Ruth Bavousett Jared Camins-Esakov Colin Campbell FrÃ©dÃ©rick Capovilla Galen Charlton Chris Cormack Jeremy Crabtree Elliott Davis FrÃ©dÃ©ric Demians Nicole C. Engard Magnus Enger Katrin Fischer Srdjan JankoviÄ‡ Janusz Kaczmarek Owen Leonard FrÃ¨re SÃ©bastien Marie Ricardo Dias Marques Chris Nighswonger Dobrica Pavlinusic Ian Walls MJ Ray Liz Rea Marcel de Rooy Robin Sheat Fridolyn Somers 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 Koha 3.4.x (i.e., this version of Koha and future bugfix releases) is 3.4.x. The next major feature release of Koha will be Koha 3.6.0. 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

Access URL from opac-results.tt
by Zachary Spalding 28 Jun '11

28 Jun '11

In koha 3.2 I used to be able to access the 856$u filed with the  variable in the opac-results.tmpl file. Can someone give me a hint on how I can access it in 3.4, in the opac-results.tt file? Thanks -- Zachary Spalding Systems Manager Southeastern NY Library Resources Council 21 S. Elting Corners Rd Highland, NY 12528 Phone: 845-883-9065x11 Fax: 845-883-9483 Email: spalding(a)senylrc.org

2 1

Re: [Koha-devel] [Koha] Hackfest at ALA
by Chris Cormack 26 Jun '11

26 Jun '11

2011/6/20 Chris Cormack <chrisc(a)catalyst.net.nz>: > > When we know the hotel room, we'll send out another invite. But please > if possible do come along. It should be a bunch of fun and who knows > we might even fix a bug or two and create some new features. > Hi All Hackfest is on tomorrow starting at 4pm (New Orleans time), at the Hampton Inn across the road from the convention centre. Room 413. Come one, come all, there will be talking, coding, testing and pizza Chris

1 0

Official Koha Newsletter : Volume 2, Issue 6: June 2011
by Nicole Engard 25 Jun '11

25 Jun '11

Below is the text of the newsletter, for active links please visit the Koha site: http://koha-community.org/koha-newsletter-volume-2issue-6-june-2011/ Official Koha Newsletter (ISSN 2153-8328) Volume 2, Issue 6: June 2011 Table of Contents Koha Developments Koha 3.2.10 Available Koha 3.4.2 Coming Soon Koha Community Koha website: Announcing the Comments Policy What Colour Am I? Wiki Open For Contributors Again Koha Events Global Sign Off Day 15.06.2011 Symposium Koha – Lyon (France) 2011 Koha General Meeting: 6 July 2011 Koha Developments Koha 3.2.10 Available by Chris Nighswonger Note: This is potentially the final release of the 3.2.x branch. Please act accordingly with new implementations and upgrades. The package can be retrieved from: http://download.koha-community.org/koha-3.02.10.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.02.10.tar.gz.MD5 http://download.koha-community.org/koha-3.02.10.tar.gz.MD5.asc http://download.koha-community.org/koha-3.02.10.tar.gz.sig Come and get it! Read More. Koha 3.4.2 Coming Soon by Chris Nighswonger The monthly 3.4.x release is a few days behind schedule. As of 0000 UTC 20 June 2011, 3.4.x is in a string freeze. 27 June 2011 will be the date of the 3.4.2 release. At this point the only patches that touch strings which will be accepted are blocker and security fixes. Non-string patches will still be applied up to the date of the release. Koha Community Koha website: Announcing the Comments Policy by MJ Ray The Koha website now has a comments policy. The policy is described at http://koha-community.org/about/comments-policy/ It basically summarises the recent practice and adds a suggestion that people should appeal to a general meeting if there is a dispute. What Colour Am I? by Brooke Johnson Chris Cormack world renowned SLS strikes again. This time, he brought us a very cool bug visualisation. http://bugs.koha-community.org/cgi-bin/bug_status.pl We know we’re well behind on signoffs if we’re in the red. As I wrote this, thanks to Global Sign Off Day, I’m looking at a glorious yellow 46. It was wonderful to watch how motivational this was. Developers threw down just to get the colour to change and the number to decrease. Wouldn’t this be neat as a widget? Wiki Open For Contributors Again by MJ Ray The Koha wiki is one of the simplest places for users to collaborate on documentation about Koha, how to use it, how it’s been used and a lot of other topics. The wiki can send out email again now, which means that new contributors can register and actually validate their email address, which means they can edit pages. If you registered during the recent problems, please visit http://wiki.koha-community.org/wiki/Special:Preferences to log in and request a new validation email. If you would like to register, please visit http://wiki.koha-community.org/w/index.php?title=Special:OpenIDLogin with your social media account from WordPress, Livejournal, Yahoo, Google or any other OpenID-enabled site, or http://wiki.koha-community.org/w/index.php?title=Special:UserLogin&type=sig… to register with an email address. Please help us improve the documentation by registering with the wiki and editing some pages. Koha Events Global Sign Off Day 15.06.2011 by Brooke Johnson How great are our developers? Wonderful, of course! Magnus Enger, Katrin Fischer, and Chris Cormack proved once again that cool things happen on IRC! 07:36 magnuse maybe we should declare a global signing off day before summer? (drawn from http://stats.workbuffer.org/irclog/koha/2011-06-07) and just days later, it happened. 22 lovely bug contestants were sent on through to the next stage, including a critical and a major. Alas, 7 failed QA, but they’ll be back for our second chance round after a retool. For a blow by blow description, visit the wiki: http://wiki.koha-community.org/wiki/Global_sign_off_day,_2011-06-15 We couldn’t have done this without everyone’s help. Thank you all. This is a great example of just how quickly things can progress when folks get together and roll up their sleeves. Nau te rourou, naku te rourou, ka ora ai te tangata. Symposium Koha – Lyon (France) 2011 by Pascale Nalon, president of KohaLa association University libraries of Lyon 2, Lyon 3 and Saint-Etienne (together representing approximately 80,000 students and 900,000 items) have switched from their proprietary software to Koha in 2010-2011. In this context of re-computerization, the third Koha symposium was organized by University Lyon 2 for May 26 and 27. During the two days, 130 participants from public or private libraries joined conferences about open source and open data, the history of Koha, the experience of Inter-Universities, cooperation for implementation of Koha in libraries, work reorganization and other workshops (Birt and JasperReports, SQL, XSLT, install party). These conferences and workshops hosted by french companies providing services around Koha and other softwares (Progilone, Tamil and Biblibre) and some librarians of different institutions. Students of “CoLibre”, bachelor of communication and open source software, participated to the organisation. The new thing about this symposium, was the presence of open source exhibitors (free music, associations promoting Open Source and enterprises). Articles, videos and podcasts are available online. Koha General Meeting: 6 July 2011 by MJ Ray There will be a general meeting in the #koha IRC channel (IRC server irc.oftc.net) on 6 July 2011 at 10:00 UTC+0. As well as discussing the future development of the Koha software, it will also consider when to end free support for the 3.2 version (it will remain available, but no new releases will be made) and discuss the Koha Conferences. You can read the agenda and register your intentions or apologies at http://wiki.koha-community.org/wiki/General_IRC_Meeting,_6_July_2011. Newsletter edited by Nicole C. Engard, Koha Documentation Manager.

1 0

Request for interviewees - qualitative study on women and open source
by D Ruth Bavousett 23 Jun '11

23 Jun '11

I received this on the LinuxChix announcements list--some of the ladies here might be interested in this, in particular, though she is calling for some men, as well: >*snip!* Hello LinuxChix! My name is Sarah Riggs and I am a Master's Degree seeking candidate at the School of Information and Library Science at UNC Chapel Hill. I am conducting research which addresses the large gender gap in the open source community. In 2006, a team of researchers sought to capture an image of women contributors to open source software, as it was clear that women made up a very small minority of participants (Nafus, Leach, & Kriegar, 2006). Several proactive members of your community then implemented programs aimed at increasing the number of women in open source; however, little research has been done since this study. By conducting qualitative interviews, my intention is to collect narratives about the experiences of open source participants. I will ask questions about your experiences joining and participating in the open source community. Your answers will be used to to identify ways in which more women can feel comfortable joining the community and contributing to open source software development. I would like to hear thoughts from women as well as men who are open source contributors. Please consider participating whether you are just starting out, or have been contributing to open source for many years. It is important for this research to obtain a diverse group of respondents with varied backgrounds so this research constructs a representative narrative of experience. I will be conducting interviews through July 20th, 2011, and I will be happy to meet you at a time and date at your convenience. Those volunteers who are selected will be allowed to decide the method of participation, and phone calls, face-to-face interaction, or Internet Relay Chat are valid means of communication. Exhaustive efforts will be made to ensure that any information you give me is confidential, and you are always free to stop the interview at any time. Please don't hesitate to contact me if you have any further questions. I can be best reached by e-mail, smriggs at email dot unc dot edu** Thank you for your time, Sarah Riggs Principal Investigator Research Approved by IRB, UNC-Chapel Hill* University of North Carolina at Chapel Hill, School of Information and Library Science <http://sils.unc.edu/>* Reference: Nafus, D., Leach, J. & Kriegar, B. (2006). *Gender: Integrated Report of Findings* (Deliverable -- 16).* *Retrieved from Free/Libre/Open Source Software: Policy Support,* http://www.flosspols.org/deliverables/FLOSSPOLS-D16-Gender_Integrated_Repor… * >*snip!* -- *D Ruth Bavousett* Lead Migration Specialist ByWater Solutions Support and Consulting for Open Source Software VISIT US AT ALA: BOOTH 732 Headquarters: Santa Barbara, CA Office: Washington, DC Phone/Fax (888)900-8944 http://bywatersolutions.com ruth(a)bywatersolutions.com

1 0

Koha 3.4.1 upgarde - failed: Access denied for user 'kohaadmin'@'localhost' (using password: YES)
by ISM KIS 23 Jun '11

23 Jun '11

I am still in the process of upgrading our Koha from 3.00.06 to 3.4.1 Installation is ok. I could import the data from 3.0.6 and did the database update from the :8080 interface. But then when I run the script to remove the biblioitems I get the following error message: koha34:/opt/kohaclone/misc/maintenance # perl remove_items_from_biblioitems.pl --run DBI connect('dbname=koha;host=localhost;port=3306','kohaadmin',...) failed: Access denied for user 'kohaadmin'@'localhost' (using password: YES) at /opt/kohaclone/koha-tmpl/lib/C4/Context.pm line 692 Access denied for user 'kohaadmin'@'localhost' (using password: YES) at /opt/kohaclone/koha-tmpl/lib/C4/Context.pm line 692. What does that mean? ( By the way: I' m able to access mysql -ukohaadmin -pxxxxx ) Any ideas? Rudy Wuthrich Kodaikanal International School

3 3

Re: [Koha-devel] [Koha] Date and time of next Kohacon11 volunteers meeting
by Koustubha Kale 23 Jun '11

23 Jun '11

On Sat, Jun 11, 2011 at 5:38 PM, MJ Ray <mjr(a)phonecoop.coop> wrote: > > Koustubha Kale wrote: > > I had to miss the last scheduled volunteers meeting and since there were > > only two attendees they decided to postpone the meeting. > > > > Attendance at Kohacon11 volunteers meeting in the #koha irc channel has been > > poor. So here I am requesting the community to discuss & decide over email > > exchange, the date and timing of the next meeting so that as many as > > possible people may attend. > > The key thing is to get you or others on-site to attend, so could > you please pick some times you can make and then put up a poll? > > We've sometimes used m.doodle.com for that, Ok. here we go. I have tried to cover the bases a bit here. Poll "Kohacon11 : Date and time of next volunteers meeting" http://doodle.com/28um6kk9c2d2r2qw Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2

3 5