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

[Bug 212] New: OPAC Search fails in 1.9.0 when searching by subject
by bugzilla-daemon＠wilbur.katipo.co.nz 20 Feb '03

20 Feb '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=212 Summary: OPAC Search fails in 1.9.0 when searching by subject Product: Koha Version: CVS Platform: PC Status: NEW Severity: normal Priority: P2 Component: OPAC AssignedTo: chris(a)katipo.co.nz ReportedBy: mwhansen(a)hmc.edu QAContact: koha-devel(a)lists.sourceforge.net The opac-error_log reports type = subject at /usr/local/koha/intranet/modules/C4/Search.pm line 857. select dewey,subclass,publishercode from biblioitems where biblionumber= at /usr/local/koha/intranet/modules/C4/Search.pm line 1114. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/local/koha/intranet/modules/C4/Search.pm line 1116. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Search.pm line 1122. Can't use string ("1") as a HASH ref while "strict refs" in use at /usr/local/koha/intranet/modules/C4/Search.pm line 1124. [Thu Feb 20 16:57:38 2003] [error] [client 127.0.0.1] Premature end of script headers: /usr/local/koha/opac/cgi-bin/opac-searchresults.pl ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

Re: QA testing Koha
by Pat Eyler 20 Feb '03

20 Feb '03

On Thu, 20 Feb 2003, E. Naeher wrote: > In your most recent Koha newsletter you mentioned that you are looking for > Koha QA testers. What's involved with this? Would one have to run Koha in > a real operating library environment, or just play with it locally and try > to break it? Tell me more. Hi Eli, This is a great question, so I'd like to answer it to a wider audience. There are actually several levels of opportunity here. The simplest (and least organized) would be to just play with a local installation and try to break things then make bug reports at bugs.koha.org. The next step up would be to be an 'acceptance tester', basically this means that you'd be following (and helping to develop) a testing 'script' which you'd follow on each release candidate. This work would be coordinated by a single individual who would be responsible for letting us turn a release candidate into a 'real' release. On the development side, we also need experienced testers to help write code level functional and unit tests for a 'regression test suite'. The plan is that this suite is run at least daily against the Koha code base to ensure that we're not introducing new bugs, or re-opening old ones while we make changes and additions to Koha. We also need to find a single person who's interested (and capable) of coordinating/managing all of these functions. He or she doesn't need to be a programmer, but it certainly wouldn't hurt. I've had a couple of people contact me about various parts of this. I'm currently treading water ... I don't want to move too agressively until we've got a QA manager in place. I hope this answers your questions. -pate > > Thanks, > > --Eli Naeher > Lower Cape Fear Historical Society >

1 0

he panui Koha [20 Feb 2003]
by Pat Eyler 20 Feb '03

20 Feb '03

He Panui Koha 20 Feb 2003 Hello everyone, It's been quite a while since I've put one of these out, so I thought I'd better knuckle down and send something out this week. There's been a lot of activity since the New Year and not all of it has gotten the attention it deserves. In the world of Koha 1.2, Chris and Steve have put out a 1.2.3 release which is seeing a good deal of interest with over 1300 downloads from sourceforge! If you're using Koha and haven't upgraded yet, you might want to check out 1.2.3. Paul has been busy with Koha 2.0 as well. He released 1.9.0 at the beginning of February. This release hase been downloaded nearly 350 times already -- not bad for a beta release! It also looks like a 1.9.1 version is coming up quickly so if you've grabbed a copy of 1.9.0 and not let people know about problems, you should get right on it. Speaking of problems, I'm not sure how many of you know about the Koha bugzilla tool. You can see the tool by looking at http://bugs.koha.org -- you can submit bugs (or feature requests there too). There are currently 47 bugs/feature requests against the development (pre 2.0) version ... Should we have a bug stomping day to try and knock these down? Language support is continuing to move along. I had a request from some Koha users interested in organizing a translation into Breton. If anyone is interested in helping out, please contact me. We've also seen more work on French, Spanish, and Chinese. Koha is getting international notice as well. Nicolas Morin wrote to say: "Koha is getting good publicity in France. In it's Feb 2003 issue, the French monthly periodical ARCHIMAG [www.archimag.com] which is widely read among french librarians and also among "documentation centers" people in businesses, features a 3 pages article on Open Source solutions in this sector. Koha figures quite prominantly and positively in the article, alongside such general purpose softwares as Zope. The article goes into a bit of history, mentionning the beginning of the adventure with Horowhenua and Katipo, back in 2000, it then describes the current features and those that will be available in the upcoming 2.0 release (MARC support), and finally deals with the growing Koha community among french speaking librarians." Linux Journal published an article about Koha in their February issue too. A third article is available at: http://www.linuxworld.com.au/index.php?id=1466489879 (sorry for the long URL, but I thought is was better than making you search for it.) If you see interesting articles about Koha, or are interested in writing one, please let me know. One last project related note. We're trying to find some QA testers to join the development effort. If you're interested, please get in touch with me. thanks, Pat Eyler kaitiaki(a)koha.org

1 0

another nice link
by Pat Eyler 20 Feb '03

20 Feb '03

http://www.securityfocus.com/infocus/1667 This one covers mysql and security Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org

1 0

MARC - Koha DB mapping
by Larry Currie 17 Feb '03

17 Feb '03

What do I need to do before I can use the Links koha - MARC DB link on the Koha Admin page to do my mapping of MARC fields to Koha database table fields? Right now this link produces when accessing the page http://libcat.calacademy.org:8080/cgi-bin/koha/admin/koha2marclinks.pl. Larry Currie -- Lawrence W. Currie User Services Librarian California Academy of Sciences Golden Gate Park San Francisco, CA 94118 lcurrie(a)calacademy.org (415) 750-7108 (415) 750-7106 fax http://www.calacademy.org/research/library/

1 0

notforloan field in table itemtypes
by Larry Currie 17 Feb '03

17 Feb '03

The field notforloan has been added to the table itemtypes in more recent versions of Koha. What is the significance of this field and what are the possible values for this field and their meaning? Larry Currie -- Lawrence W. Currie User Services Librarian California Academy of Sciences Golden Gate Park San Francisco, CA 94118 lcurrie(a)calacademy.org (415) 750-7108 (415) 750-7106 fax http://www.calacademy.org/research/library/

1 0

RE: [Koha-devel] Re: [Koha] Due dates
by Anthony W. Youngman 17 Feb '03

17 Feb '03

Something else to think about ... What if the due date falls on a holiday? It's all very well saying "you've got two weeks" or whatever it is, but especially over the New Year period the due date could be the last day of a five-day break so the borrower is almost a week short of their allotted time. I was going to say "you should add ten working days", but for a library that's probably irrelevant. What you probably need to do is add an "extend a holiday to the next working day" module. Cheers, Wol -----Original Message----- From: Chris Cormack [mailto:chris@katipo.co.nz] Sent: 16 February 2003 00:07 To: Erik Stainsby Cc: koha-devel(a)lists.sourceforge.net; scraig(a)deepthought.org Subject: [Koha-devel] Re: [Koha] Due dates On Fri, Feb 14, 2003 at 09:00:57PM -0800, Erik Stainsby said: > Chris, > > I'm curious how you would choose to approach this issue, strategically. > Would you go at it this by adding a separate alternate routine for calculating > due-times as opposed to due-dates? Or replace all due dates with hourly > durations, then divide out the majority by whole days? I suppose the third > choice might be to make hourly calcs the product of days divided by hourly > period currently in effect ... > > Choices, choices ... Love to hear your thoughts. > Hi Erik Ive shifted this over to the devel list as it seems to fit better there :) My initial thought was, currently due dates are calculated by taking the current date and adding an offset. This currently is just a number of days. But using the Date::Manip module it shouldnt be too hard to make this days and minutes/hours eg $date=&DateCalc("today","+ 3hours 12minutes 6 seconds",\$err); For items that have a today + some number of days offset due date, we just set to be the closing time of the library that day. The trick then becomes setting the rules for overdues etc. Currently its set like this | categorycode | itemtype | restrictedtype | rentaldiscount | reservecharge | fine | firstremind | chargeperiod | accountsent | chargename | A | ART | NULL | NULL | 1.000000 | 1.000000 | 7 | 7 | 28 | Fine | Where the firstremind tells us that after 7 days we apply our first charge. This will need to be changed so it handles minutes/hours as well as days. Im still just mulling it over at this stage, It wont be making it into the 2.0 release (Paul has called for a feature freeze). But I think we could get it into one of the 2.1.x releses Any other suggestions gratefully accepted Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris(a)katipo.co.nz www.katipo.co.nz ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.

2 1

Re: [Koha] Due dates
by Chris Cormack 15 Feb '03

15 Feb '03

On Fri, Feb 14, 2003 at 09:00:57PM -0800, Erik Stainsby said: > Chris, > > I'm curious how you would choose to approach this issue, strategically. > Would you go at it this by adding a separate alternate routine for calculating > due-times as opposed to due-dates? Or replace all due dates with hourly > durations, then divide out the majority by whole days? I suppose the third > choice might be to make hourly calcs the product of days divided by hourly > period currently in effect ... > > Choices, choices ... Love to hear your thoughts. > Hi Erik Ive shifted this over to the devel list as it seems to fit better there :) My initial thought was, currently due dates are calculated by taking the current date and adding an offset. This currently is just a number of days. But using the Date::Manip module it shouldnt be too hard to make this days and minutes/hours eg $date=&DateCalc("today","+ 3hours 12minutes 6 seconds",\$err); For items that have a today + some number of days offset due date, we just set to be the closing time of the library that day. The trick then becomes setting the rules for overdues etc. Currently its set like this | categorycode | itemtype | restrictedtype | rentaldiscount | reservecharge | fine | firstremind | chargeperiod | accountsent | chargename | A | ART | NULL | NULL | 1.000000 | 1.000000 | 7 | 7 | 28 | Fine | Where the firstremind tells us that after 7 days we apply our first charge. This will need to be changed so it handles minutes/hours as well as days. Im still just mulling it over at this stage, It wont be making it into the 2.0 release (Paul has called for a feature freeze). But I think we could get it into one of the 2.1.x releses Any other suggestions gratefully accepted Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris(a)katipo.co.nz www.katipo.co.nz

1 0

[Bug 203] detailed view does not work
by bugzilla-daemon＠wilbur.katipo.co.nz 15 Feb '03

15 Feb '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=203 vhuhtala(a)paju.oulu.fi changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Additional Comments From vhuhtala(a)paju.oulu.fi 2003-02-16 07:10 ------- detail.pl from cvs works. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

RE: NACO Normalization in perl. (fwd)
by Pat Eyler 14 Feb '03

14 Feb '03

This might be of wider interest here. -pate ---------- Forwarded message ---------- Date: Fri, 14 Feb 2003 08:31:14 -0400 From: Brian Cassidy <brian(a)nald.ca> To: 'Rhyno Art' <arhyno(a)server.uwindsor.ca> Cc: pate(a)eylerfamily.org Subject: RE: NACO Normalization in perl. > -----Original Message----- > From: Rhyno Art [mailto:arhyno@server.uwindsor.ca] > Sent: Thursday, February 13, 2003 6:09 PM > To: brian(a)nald.ca > Subject: Re: NACO Normalization in perl. > > You know, the koha folks would also be interested in this. Would you > be interested in sharing this with them as well? One of the great > strengths of Perl is that it is a far more welcome environment for most > library staff. I felt tied to java because of enterprise java beans and > cocoon, but it definitely has dampened the enthusiasm of my co- > conspirators. Pat Eyler is a good contact for koha <pate(a)eylerfamily.org>, > I have been blown away by the support they are getting. Sure, I've copied Pat Eyler on this reply. Attached is a snippet of code to deal with normalizing values. I've tried to follow the NACO rules (http://lcweb.loc.gov/catdir/pcc/naco/normrule.html) as closely as possible. Of course, it's not perfect (mainly the Latin1 fallback). You can use this however you want... I hope it can be of some use :) -Brian Cassidy (brian(a)nald.ca) http://www.gordano.com - Messaging for educators.

1 0