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

Upgrade to HTML::Template::Pro 0.69 needed
by Chris Nighswonger 06 Mar '08

06 Mar '08

I am planning to submit a patch to picture-upload.tmpl that implements the TMPL_ELSIF tag new to Template::Pro 0.69. The installer has already been updated to check for 0.69 as a prerequisite, but for those running a developer install this will not catch that. So if templates begin misbehaving, check the version of Template::Pro installed. Regards, Chris -- Chris Nighswonger Faculty Member Network & Systems Director Foundations Bible College & Seminary www.foundations.edu www.fbcradio.org

1 0

Suggesting a change to the developers wiki page: Encoding and Character Sets in Koha
by Michael Hafen 05 Mar '08

05 Mar '08

There is a section: Changing Default Character Sets for MARC21 libraries using UTF-8 Looks like kados added it. The second instruction is: alter table marc_subfield_table modify subfieldvalue BINARY(255); I've tried this and had less than satisfactory results. In MySQL there is a VARBINARY data type that provides better results with this operation. Someone with a login on the wiki please change BINARY(255) to VARBINARY(255) on that line? I'm to lazy to register for an account. :) Also I thought some people on the list would like to know about the VARBINARY thing. This type has the same properties as BINARY with the exception of the variable length instead of fixed length. Following the instructions as I found them I ended up with the subfieldvalue column being null padded to 255 characters. To correct this I had to "update marc_subfield_table set subfieldvalue = TRIM( BOTH UNHEX('00') FROM subfieldvalue )" to get the column back to the way I wanted. That query took a little while to run. :) Have a nice day. -- Mike Hafen

1 0

Koha Hosting
by C W Nel 05 Mar '08

05 Mar '08

I am using different Koha databases on the same server, and need to run scripts on each via Crontab. How to tell the script what Database to access? With other words how to handle context in this situation? Thanks for any advice..

2 1

Nomenclature s/Catalogue/Search/ in the Global Nav
by Joshua Ferraro 05 Mar '08

05 Mar '08

Hi folks, I've gotten several requests from folks that complain that 'Catalogue' and 'Cataloguing' are too close to both exist in the global navigation, and it's been suggested that we change 'Catalogue' to 'Search' ... any objections? Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE CEO migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

2 1

Patron Images Database update didn't hit
by Michael Hafen 04 Mar '08

04 Mar '08

Maybe it's just me, but when I pulled down the patron images patch with the database create table it didn't hit the installer page to do the database update. I looked at the updatedatabase.pl file, and it seems that the patronimages update ended up with the same DBversion as the previous update. Maybe something should be done to make sure that doesn't happen. It seems like a tough problem to handle though. Could just skip a version number or two to leave space for other developers, but then the installer would have to check to make sure that previous updates were run for sure. That wouldn't be trivial to implement. Maybe have to leave things the way they are.

4 3

Sample Data is Permanent?
by Ramon Andinach 04 Mar '08

04 Mar '08

Hi All, When installing Koha 3.00 alpha, I let it install some optional data (patron types and libraries etc.) so that I could see what they looked like while adding my own information. I'm finding that some of them are can not be removed. Is this normal? For instance some of the branches, appear to delete normally but stay on the list regardless (e.g. Springfield and Maryland). And some of the patron types already appear to be in use, so I'm not allowed to delete them. Can the sample data be removed so it doesn't get in the way of the real data? Thanks, ramon.

2 1

A Quite Fright of Soft Nightmare in the "Oh my God!" Doubt... (biblioitems is ko and items is ok?)
by Ignacio Javier 03 Mar '08

03 Mar '08

Hi all! Speaking of Koha 3... Are items and biblioitems tables modern and old version of the same "what we want" thing, respectively, or are they complementary tables and both must exist in Koha 3? The doubt comes after purging (truncating, really) biblioitems table, and constating I obtain same resultset in detail.pl script.... Is a doubt that has me very catched in the cathing essence of the doubt, Anyone can tell?, Thanks in advance and greetings, Ignacio Javier Gómez Rodríguez Analista - Programador Tfno: 902905590 - Fax: 981571425 ignacio.gomez(a)coremain.com www.coremain.com

2 1

Re: [Koha] Install on Debian Etch
by harry wykman 03 Mar '08

03 Mar '08

Thanks Josh for your help. I am posting to the devel list. As you know, still having the error below when using standard install. Harry Hi Harry, Please post any questions you have to the main koha-devel mailing list, or the koha user list ... that way other users will have a chance to respond to the question and others who may have the same issue will see the solution, etc. Thanks, Joshua On 3/1/08, harry wykman <harrybw(a)iinet.net.au> wrote: > > > > Hi Joshua. > > > > I implemented your suggestions with success. I am still getting the > > error below however. I am attempting to install a standard system. I > > don't get this error for a single system. > > > > Any thoughts, > > > > > > Harry > > > > > > >> Then when I run 'make install' I get: > > >> > > >> biblio:/home/harry/Desktop/koha-3.00.00-alpha# make install > > >> /usr/bin/perl "-Iblib/arch" "-Iblib/lib" fix-perl-path.PL blib > > >> chown: `koha:koha': invalid user > > >> make: *** [set_koha_ownership] Error 1 > > >> > > > Are you working from the alpha or from a git repo with the latest snapshot? > > > Which target did you try to install from (standard, single, dev?) > > > > > > > > Hi Harry, I'd suggest we move this question to the koha developer's list (CCed). Comments below: On 2/20/08, harry wykman <harrybw(a)iinet.net.au> wrote: > > I am running Debian ETCH. > > > > I have followed the install instructions as well as installing requisite > > items using CPAN. I cannot, however, install the last couple. Having > > run 'perl Makefile.PL', at the end I get: > > > > [Mon Feb 18 21:43:35 2008] Makefile.PL: Warning: prerequisite DBD::mysql > > 4.004 not found. We have 3.0008. > > [Mon Feb 18 21:44:05 2008] Makefile.PL: Warning: prerequisite > > XML::LibXSLT 1.59 not found. > > Writing Makefile for koha > > > > > > > > In attempting to install these in CPAN I get the following errors: > > > > cpan> install DBD::mysql > > Running install for module DBD::mysql > > Running make for C/CA/CAPTTOFU/DBD-mysql-4.006.tar.gz > > Is already unwrapped into directory /root/.cpan/build/DBD-mysql-4.006 > > Makefile.PL returned status 512 > > Running make test > > Make had some problems, maybe interrupted? Won't test > > Running make install > > Make had some problems, maybe interrupted? Won't install > DBD::mysql most certainly has some unfulfilled dependencies if you install it from CPAN. I would work from the INSTALL.debian file, rather than the INSTALL file for your Koha installation, it has specific instructions for how to prepare the dependencies on Debain Etch -- in short, you need to install the package maintainers version of DBD::mysql (apt-get install libdbd-mysql-perl) > > AND > > > > make: *** [blib/arch/auto/XML/LibXSLT/LibXSLT.so] Error 1 > > /usr/bin/make -- NOT OK > > Running make test > > Can't test without successful make > > Running make install > > make had returned bad status, install seems impossible > The same applies here ... you really need to install the package maintainer's version of XML::LibXSLT and XML::LibXML, etc. The INSTALL.debian has some special instructions for this set of modules. > > Then when I run 'make install' I get: > > > > biblio:/home/harry/Desktop/koha-3.00.00-alpha# make install > > /usr/bin/perl "-Iblib/arch" "-Iblib/lib" fix-perl-path.PL blib > > chown: `koha:koha': invalid user > > make: *** [set_koha_ownership] Error 1 > Are you working from the alpha or from a git repo with the latest snapshot? Which target did you try to install from (standard, single, dev?) Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE CEO migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at

2 2

Koha.org-based Listserve
by Joshua Ferraro 03 Mar '08

03 Mar '08

Hi gang, Henri-Damien visited the US this week for the Code4libCon conference in Portland and we had a chance to touch base for a few hours. One of the topics we discussed was the need that's arising for additional Koha mailing lists, particularly for non-English users of Koha. I've had several requests now from other language communities for a language-specific list that the community provides to that language community. BibLibre has graciously offered to host a Mailman installation for such lists, so the question arises, what domain shall we use? For instance, we could have lists.koha.org, with all of our community mailing lists (e.g., koha-devel(a)lists.koha.org) ... or we could stick with the simpler convention koha-devel(a)koha.org. On IRC, Paul made a good point that it's useful to distinguish between user accounts (ie, patches) and lists (ie, koha-devel). Any other opinions? Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE CEO migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

2 1

ZOOM 1.16 vs. 1.21
by Galen Charlton 01 Mar '08

01 Mar '08

Hi, Koha currently requires version 1.16 of the Perl module ZOOM. I've submitted a patch to fix a use of a method that wasn't introduced until version 1.19, but it occurred to me that we might as well just require the most recent version, 1.21. Does anybody have any objection to doing this? Regards, Galen -- Galen Charlton Koha Application Developer LibLime galen.charlton(a)liblime.com p: 1-888-564-2457 x709

3 2