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

RC11 searching, more comments.
by rbrown64＠csc.com.au 13 Sep '02

13 Sep '02

MySql seems to be robust with respect to unbackslashed apostrophe ' characters. According to the SQL standard, you quote apostrophe characters by doubling them up - I don't have the mysql documentation handy to know whether backslashing should work. I haven't added an entry to check that searching for something like "It's isn't" would find anything. (This is testing with the librarian interface - assuming that the public interface is the same). The searches don't seem to guard the input string except to require it to be non-blank. This means that searches like "%" or "_" as SQL wildcards will select all rows and single letter searches would select all rows on which a searched column contains a word beginning with that letter. Similar single common words "the", .... could give large result sets. This could be slow and expensive on large databases. On the sample database, when the list of results wouldn't fit on one page, moving to the next pageful with the right-arrow worked fine - but trying to jump to a particular page using the numbers gave a nothing found page. (I'm running on Debian so this could be associated with MySQL version if it isn't repeatable).

4 4

Re: [Koha-devel] Koha on CD
by COURYHOUSE＠aol.com 11 Sep '02

11 Sep '02

where can we get the cd? this is fantastic. > Subj:[Koha-devel] Koha on CD > Date:9/11/2002 1:34:30 PM US Mountain Standard Time > From:<A HREF="mailto:tonnesen@cmsd.bc.ca">tonnesen(a)cmsd.bc.ca</A> > To:<A HREF="mailto:koha-devel@lists.sourceforge.net">koha-devel(a)lists.sourceforge.net</A> > Sent from the Internet > > > > > I've created a bootable CD that boots linux with Koha installed directly > off the CD. I'm hoping this might be useful for: > > 1. Demo'ing Koha at trade shows and the like > 2. Demo'ing Koha to librarians at their library > 3. Interested parties who are not familiar with installing Linux > 4. Actually running a production server with data stored on a hard drive > and all other files running off of the CD. > > > Some of the 'gotchas' with KohaCD: > > 1. Requires a computer that is CD-bootable > 2. Requires a second computer networked to the first for actually running > a browser to access Koha. It's technically possible to put X and > Mozilla on the CD but that's a task I'm not up to at the moment. > > > I've created a page on the wiki documenting some of this. > > > Steve. > > > > ------------------------------------------------------- > In remembrance > www.osdn.com/911/ > _______________________________________________ > Koha-devel mailing list > Koha-devel(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/koha-devel Please check our web site at <A HREF="http://www.smecc.org/">http://www.smecc.org</A> to see other engineering fields, communications and computation stuff we buy, and by all means when in Arizona drop in and see us. address: coury house / smecc 5802 w palmaire ave glendale az 85301 thanks Ed Sharpe archivist for SMECC

2 1

CVS or 1.3RC's?
by Ambrose Li 11 Sep '02

11 Sep '02

Hi, if I want to look at the MARC code (the library I work with uses MARC; it wouldn't make sense for me to look at something that doesn't use it), should I look at the CVS version, or should I look at the 1.3RC's? I'm a bit lost here because I did look at CVS, but the tarballs have a different directory structure than the CVS, and it is not obvious how to make a proper installation using the CVS version. If CVS is the way to go (for people who are willing to dab into the Perl code and stuff) and no one is working on installation docs, I'd be happy to update the installation docs for CVS; but if I shouldn't be looking at CVS, I'd be happy if someone told me I should look at the 1.3RC's instead. Is there a place I can look for lists of things like which parts of CVS (or the 1.3RC's) are working, and which parts are not working? Or which parts have people working on them? Sorry for asking so many questions. Many thanks in advance, -- Ambrose Li <a.c.li(a)ieee.org> http://trends.ca/~acli/ http://www.cccgt.org/ DRM is theft - We are the stakeholders

2 1

Koha on CD
by Tonnesen Steve 11 Sep '02

11 Sep '02

I've created a bootable CD that boots linux with Koha installed directly off the CD. I'm hoping this might be useful for: 1. Demo'ing Koha at trade shows and the like 2. Demo'ing Koha to librarians at their library 3. Interested parties who are not familiar with installing Linux 4. Actually running a production server with data stored on a hard drive and all other files running off of the CD. Some of the 'gotchas' with KohaCD: 1. Requires a computer that is CD-bootable 2. Requires a second computer networked to the first for actually running a browser to access Koha. It's technically possible to put X and Mozilla on the CD but that's a task I'm not up to at the moment. I've created a page on the wiki documenting some of this. Steve.

1 0

1.2.3RC11: Minor comments
by rbrown64＠csc.com.au 11 Sep '02

11 Sep '02

Minor comments from a quick look at the code. A number of the files have a large number of trailing blanks - as though they've been editted with a line editor that leaves files as fixed width. Please consider trimming trailing blanks for the release - when they push the line length over 80-bytes as they do in a number of cases they make it harder to read. find . -name '*.p[lm]*' -print | xargs egrep -l ' *$' /dev/null Within modules/C4/Search.pm the code to escape apostrophes should be doing a global replace. $search->{'keyword'}=~ s/'/\\'/; should be $search->{'keyword'}=~ s/'/\\'/g; For smaller search SQL the search subroutines could deduplicate key words so that 'The cat sat on the mat' doesn't look for 'the' twice. It would make sense to generalize the 'NZ' <=> 'New Zealand' abbreviation expansion. I'm not sure whether the current implementation adequately uses the restrictions on other keywords. (ie whether 'New Zealand Birds' gets you everything with NZ in it). The code after the call to modules/C4/Search.pm:itemcount in the following files is quite similar. intranet-cgi/acqui/newbasket2.pl intranet-cgi/subjectsearch.pl opac-cgi/subjectsearch.pl Consider providing an alternative method in Search.pm that gives the formatted counts for On Loan, Levin, Foxton ... as a string with a parameter for the extra stuff in newbasket2 (Lost, Mending, In Transiit (sp?) if ($transit > 0){ $stuff[5]=$stuff[5]."In Transiit"; if ($transit >1 ){ $stuff[5]=$stuff[5]." ($transit)"; } $stuff[5].=" "; } I would have been tempted to write this as if ($translit > 0) { $stuff[5] .= 'In Transiit ' . (($transit > 1) ? "($transit) " : ''); } or even $stuff[5] .= 'In Transiit ' . (($transit > 1) ? "($transit) " : '') if $translit > 0; but the latter is a bit write only. The CheckDigit Excel spreadsheet http://developer.koha.org/HLT2.xls is inaccessable. "Forbidden You don't have permission to access /HLT2.xls on this server." The best reference I've seen on check digits is Error Detecting Decimal Digits, Neal R Wagner and Paul S Putter, Comm. ACM Jan 1989 Vol 32 No 1 pg 106-110. Hope this is useful. Regards,

1 0

call for contributions
by Pat Eyler 10 Sep '02

10 Sep '02

Hello all, I'm putting together this weeks 'From the Kaitiaki' note right now. I'd appreciate it if you could send me a quick blurb on anything you'd like to me to put into the newsletter. thanks, -pate 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

RE: Koha
by Pat Eyler 10 Sep '02

10 Sep '02

On Tue, 10 Sep 2002, Anthony W. Youngman wrote: > Hi Pat, > > sorry to take a while to get back. I've been marshalling my thoughts > somewhat (I'd asked Brian for a contact e-addy and wasn't quite expecting > him to forward my details to you, not that I'm unhappy he did...). Actually, I asked him for your email address when he said that you were trying to get in touch with me. > > Were Dynix a Pick licencee? The name sounds familiar, but I'm not sure > whether that's why. I'm pleased to know you know MV - shame you don't seem > such a fanatic as me :-) Dynix used Unidata (at least while I was there, I'd assume that they're now UniVerse users). > > "Custom database". Where I saw it - in your FAQ, namely "What record formats > does Koha support?". Hmm, that's not terribly clear (although it's aimed at librarians, not developers). It would better read, "We're currently using a custom database schema to organize our records in a MySQL database.", or something like that. > > Which is why I thought Pick might be an excellent fit for Koha - seeing as a > library database is heavily text oriented, and Pick is 100% text based ... > :-) Looking at the MARC layout, it seems an even better fit. Obviously, > seeing as you know MV, you'll know what I'm getting at, but I'd store one > MARC record per Pick record. Together with hefty indexing, I'd expect that > to blow MySQL out of the water for speed of retrieval. Unfortunately, what > with the speed of disks and the amount of RAM modern computers have, being > 500% faster probably doesn't count for much :-( > > I know the biggest impediment to switching to an underlying MV database is > "it's different", and I well understand your concerns, but surely it can't > be that hard... :-) bearing in mind so many Pick sites have users writing > very functional code ... :-) although I heartily concur with you wanting > programmers to keep in control of things! I've cleaned up too many messes in > my time created by people who didn't understand the basics :-( Oh well, > that's life. > > By the way, MaVerick will sit on top of MySQL - when we get a working TCL in > place (it might well be here by now) we should be able to define DICTs and > read Koha files directly in MaVerick ... so it might well be possible to > make the back ends interchangeable. But to argue that using MaVerick would > make a massive speed difference on a 16Mb 486 wouldn't cut much ice, even > though it's true :-) > > I'll look at oss4lib and see what's there, and I'll hunt up my code. But if > you want to pick up some interesting stuff on how Pick does (and MaVerick > will) handle fast native text retrieval, go to www.oliver.com, into mailing > lists, files, and look at a couple of papers that are there. One is called > "Litwin", I think, and the other is called dynamic_hash_coding. Well, you keep working on MaVerick, we'll keep working on Koha, and maybe at some point things will merit another look. In the meantime, do get involved with OSS4Lib, it's a good list and, who knows, you might end up convincing a few people that MV is in fact the way to go. BTW, I'm CC:ing the koha-devel list just so that the discussion can hit a few more eyes and ears. -pate > > Cheers, > Wol > > -----Original Message----- > From: Pat Eyler [mailto:pate@eylerfamily.org] > Sent: 08 September 2002 00:55 > To: Anthony W. Youngman > Subject: Re: Koha > > > On Sat, 7 Sep 2002, Anthony W. Youngman wrote: > > > In message <Pine.LNX.4.44.0209052116510.1556-100000(a)petrol.whirlycott.co > > m>, Pat Eyler <pate(a)eylerfamily.org> writes > > >Anthony, > > >Brian Profitt said that I should drop you a line about Koha. He > mentioned > > >that you had some ideas that could benefit the project. What's on your > > >mind? > > > > > > 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. > >

1 0

[Bug 92] Koha may not work with non-Apache webservers
by bugzilla-daemon＠wilbur.katipo.co.nz 10 Sep '02

10 Sep '02

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=92 ------- Additional Comments From a.c.li(a)ieee.org 2002-09-10 18:55 ------- Created an attachment (id=7) Update to the INSTALL file ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 92] New: Koha may not work with non-Apache webservers
by bugzilla-daemon＠wilbur.katipo.co.nz 10 Sep '02

10 Sep '02

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=92 Summary: Koha may not work with non-Apache webservers Product: Koha Version: CVS Platform: All OS/Version: All Status: NEW Severity: trivial Priority: P2 Component: Installation AssignedTo: tonnesen(a)cmsd.bc.ca ReportedBy: a.c.li(a)ieee.org QAContact: koha-devel(a)lists.sourceforge.net The SSI "INCLUDE VIRTUAL" directive used by Koha does not work with Roxen. The INSTALL file should probably be updated to reflect this fact. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 91] installer.pl does not work with CVS version
by bugzilla-daemon＠wilbur.katipo.co.nz 10 Sep '02

10 Sep '02

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=91 ------- Additional Comments From a.c.li(a)ieee.org 2002-09-10 18:35 ------- Created an attachment (id=6) Proposed patch to fix/workaround the reported problems ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0