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

Koha hackfest in 2013 in Marseille, (proposing a date)
by Paul Poulain 15 Nov '12

15 Nov '12

Hello koha-devel, As in 2011 and 2012, BibLibre is planning to organize a Koha hackfest next year in Marseille. Last year, we choose a date where some were not available due to important library conferences. So, this year, I ask a long time before the date, to be sure there won't be any problem: Is there something that should prevent us from organizing the 3rd european Hackfest in Marseille from feb, 18th to feb, 22th ? -- Paul POULAIN - BibLibre http://www.biblibre.com Free & Open Source Softwares for libraries Koha, Drupal, Piwik, Jasper

4 3

Trouble with Auth.pm on current master?
by Marcel de Rooy 14 Nov '12

14 Nov '12

Anyone else having this kind of problems? [Wed Nov 14 16:18:47 2012] [error] [client 82.173.53.17] [Wed Nov 14 16:18:47 2012] mainpage.pl: Use of uninitialized value $pki_field in string eq at /usr/share/koha/testclone/C4/Auth.pm line 741., [Wed Nov 14 16:18:47 2012] [error] [client 82.173.53.17] [Wed Nov 14 16:18:47 2012] mainpage.pl: Use of uninitialized value $retuserid in string ne at /usr/share/koha/testclone/C4/Auth.pm line 777.,

2 4

Koha and MariaDB - lets switch and start testing
by Mason James 13 Nov '12

13 Nov '12

hi Folks i am just sending out an email to encourage Koha developers to switch to MariaDB for their Koha dev/testing/QA work why? its highly probable MariaDB will be the database Koha switches to when MySQL explodes, (which might be quite soon, according to some) so… lets prepare for that situation by starting to testing Koha/MariaDB now, rather than later... by using Koha on MariaDB as we do our everyday work, we are also testing Koha on MariaDB for no extra effort fyi: 6 weeks ago, i switched to MariaDB for my dev and QA work, so far - ZERO problems :)

6 11

Call for news for the November newsletter
by Daniel Grobani 13 Nov '12

13 Nov '12

Dear Koha kommunitarians, I'm harvesting news for this month's newsletter. Please send me by the 20th 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

Seeking users of Syndetics and LibraryThing to test Bug 8952
by Owen Leonard 12 Nov '12

12 Nov '12

Bug 8952, "Add http:// to url in social media links on opac-detail" (http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8952) makes changes to the way links to Syndetics and LibraryThing are formed in the template. In order to give the patch a proper sign-off it should really be tested by someone who can test those services. I don't have credentials to test either one. Does anyone else? Thanks, Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 0

update Koha download pages, with some info for beginners
by Mason James 12 Nov '12

12 Nov '12

hi Folks can we get some info the following 2 pages, recommending beginners to install Koha using the 'packages' method http://koha-community.org/download-koha/ http://download.koha-community.org/ it seems to me, these 2 pages are the first pages a beginner hits, when attempting to install Koha if we can put some info recommending beginners to install Koha using the 'packages' method there, we can save everyone much wasted effort (i would, but i don't have edit permissions, afaict) so… is this a good idea, or not?

4 3

[QA] 2 short QA questions
by Jonathan Druart 12 Nov '12

12 Nov '12

Hi all (and particularly QAers) I have 2 questions for the QA team. 1/ About bug 8687, a proposed patch ( http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=12713&action=diff) removes perlcritic warnings. This way of doing is particularly brutal, it completely removes the code :) So we have 2 solutions : - To propose a patch to replace ALL eval { require "$FindBin::Bin/../kohalib.pl" }; with my $lib = "$FindBin::Bin/../kohalib.pl" eval { require $lib}; in the misc scripts. Like this, perlcritic is happy... - We add a prerequisite for the misc scripts : the PERL5LIB environment variable has to be set with the koha path and we delete these lines. 2/ Recently I suggested a followup (to fix QA issues) for a bug (bug 7067) and I switched the status to 'passed qa'. I thought it was easier to let the RM review a simple patch instead of asking for a new sign off and another QA. I understand that we don't want to have patches without review and test. But in this case (and in most cases when I suggest a new patch while passing QA) it is a simple patch and starting again a new iteration (SO + QA) burn off energy and/or could block a patch for several weeks in this status. Maybe this point is a non-problem and will be fixed with new status :) For discussion, Jonathan

2 2

New Version of LibLiveCD - DSpace, Koha & Drupal
by SANDEEP BHAVSAR 12 Nov '12

12 Nov '12

Dear all, We are happy to inform about the new release of LibLiveCD version 1.3. This version of CDROM is made available on http://sourceforge.net/ projects/liblivecd/files/ Version-1.3<http://sourceforge.net/projects/liblivecd/files/Version-1.3> <http://sourceforge.net/projects/liblivecd/files/Version-1.3> <http://sourceforge.net/projects/liblivecd/files/Version-1.3> <http://sourceforge.net/projects/liblivecd/files/Version-1.3> The current version of LibLiveCD contains LUbuntu 12.04 LTS, DSpace-1.8.2, Koha-3.8.6 & Drupal-7.16. All these three software are pre-configured and pre-installed on a livecd. The total size of the LibLiveCD is 696 MB. Drupal Content Management Open Source Software is added considering the requirements of libraries to create their library websites with dynamic look. Along with DSpace, Koha & Drupal the CD also contains following server related software preinstalled and pre configured such as :Apache2 Web Server, OpenSSH Server, VSFTP Server, MySQL Server, PostGreSQL Server, Dovecot/Exim4 Mail Server, SquirrelMail Web Mail Client and Minimum desktop environment. To input multilingual data in DSpace/Koha, IBUS input method is also installed on the CD. Teamviewer 7 is pre installed to share desktop, Abiword for editing/reading word documents, gnumeric for using spread sheets, vim/medit/gedit for text editing and epdfview for reading PDF files. Openoffice/Libreoffice and multimedia related softwaer are excluded from the CD and these can easily be installed by running “System Tools-Synaptic Package Manager”. If the synaptic “reload” does not work try chaning repositories links to http://archives.ubuntu.com/ ubuntu<http://archives.ubuntu.com/ubuntu> instead of http://in.archives.ubuntu.com/ ubuntu<http://in.archives.ubuntu.com/ubuntu> and then search and install any other application. LUbuntu operating system (Lightweight Operating System) is chosen considering requirements from libraries where libraries have low configuration desktops in their libraries but still wish to initiate their library web sites, complete library automation as well as wish to create digital libraries. Please follow proper installation steps to install livecd if you wish to have dual boot i.e. windows as well as linux installation on your machines. If you are installing livecd on a machine which is running under proxy and if you are unable to browse Internet then on every boot you will have to manually set current date and time. To set current date and time manually run the following command on every boot to set systems current date and time. root@localhost:date -s "09 NOV 2012 03:35:00" We would greatly appreciate your valuable feedback. Please write to dlrg(a)drtc.isibang.ac.in ; ard(a)drtc.isibang.ac.in ; sunitabarve(a)gmail.com for any comments/suggestions. With regards, Sunita Barve, Ph. D. Senior Technical Officer National Chemical Laboratory Dr, Homi Bhaba Road Pune 411008, INDIA Email :sunitabarve@gmail.com ; sa.barve(a)ncl.res.in

1 0

Field 001 auto-increment problem in 3.8.5
by Paul 11 Nov '12

11 Nov '12

Our cataloguing frameworks (default, books) for tag 001 have under Constraints / Other Options / Plugin a script [callnumber_rev3.pl, one line changed from the Koha "standard" callnumber.pl] which includes this snippet: # If the textbox is empty, we return a simple incremented controlnumber [was callnumber] if ( $code eq "" ) { - my $sth = $dbh->prepare("SELECT MAX(CAST(itemcallnumber AS SIGNED)) FROM items"); + my $sth = $dbh->prepare("SELECT MAX(CAST(EXTRACTVALUE(marcxml,'//controlfield[\@tag=\"001\"]') AS SIGNED)) from biblioitems"); $sth->execute; if ( my $max = $sth->fetchrow ) { $template->param( return => $max+1, ); } The need for this change is that marcxml,'//controlfield[\@tag=\"001\"]' correctly returns 39029463224 (mysql output below my sig.) LoC, BL, LAC, etc all *occasionally* have alpha suffixes - hence the "EXTRACTVALUE". BUT -- when cataloguing, using the plugin for a blank 001 input, it gets stuck on 39029463221 and therefore produces duplicates. I've even tried return => $max+5 but no change ... it still produces $max-3. Rebooting, no change ;-{ A numeric sort of the marcxml 001 tags appears normal: .../ 39029463218 39029463219 39029463220 39029463221 39029463222 39029463223 39029463224 I've spent a couple of hours trying to chase this one down and would really appreciate help. Thanks and br -- Paul mysql> SELECT MAX(CAST(EXTRACTVALUE(marcxml,'//controlfield[@tag="001"]')AS SIGNED)) FROM biblioitems; +------------------------------------------------------------------------+ | MAX(CAST(EXTRACTVALUE(marcxml,'//controlfield[@tag="001"]')AS SIGNED)) | +------------------------------------------------------------------------+ | 39029463224 | +------------------------------------------------------------------------+ 1 row in set, 307 warnings (0.14 sec) ### These warnings are for $ rather than numeric entries

1 0

using mysql dump of 3.9 in 3.8.6
by Mohamed zalabany 11 Nov '12

11 Nov '12

i need to make down grade from 3.9 to 3.8.6 can i use the MySQL dump of data base to replace it in 3.8.6 or there will be differences between tow version in data base structure and what the important things i need to do or take care about when i does this operationthanks Mohamed El ZalabanyIntegrated library systems consultant Zalabany Knowledge Systems Team© For Libraries and Information systems Development and support mh_zalabany(a)hotmail.com Mobile: 0111291444

1 0