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

Zebra Indexing is not working properly!
by Muahmmad Wasim 17 Apr '09

17 Apr '09

hi, We have installed koha 3.1 and when we insert some records after fresh installation, the indexing works properly. But when we import our records and then enter any record it doesn't come in search results. When we use rebuild_zebra.pl, the records come in search and after entering one record (that comes in search as well), entering the second record has the same problem, that is after rebuiling zebra only one record is entered proplery the second record is not shown in search results.. Please help, Thanks, Muhammad Wasim Research Associate KICS, UET, Lahore

3 2

z39.50 error on Koha 2.2.8
by Karen Myers 17 Apr '09

17 Apr '09

Hi I am running Koha 2.2.8 on Win XP with Apache 2.0.59, Perl 5.8 and MySql 4.0.1 When attempting to undertake a z39.50 search I get a general error 500 message. The error log reads: [Fri Apr 17 13:16:06 2009] [error] [client 127.0.0.1] Premature end of script headers: search.pl, referer: http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl [Fri Apr 17 13:16:06 2009] [error] [client 127.0.0.1] Can't load 'C:/usr/site/lib/auto/Net/Z3950/ZOOM/ZOOM.dll' for module Net::Z3950::ZOOM: load_file:The specified procedure could not be found at C:/usr/lib/XSLoader.pm line 70., referer: http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl [Fri Apr 17 13:16:06 2009] [error] [client 127.0.0.1] at C:/usr/site/lib/Net/Z3950/ZOOM.pm line 12, referer: http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl [Fri Apr 17 13:16:06 2009] [error] [client 127.0.0.1] Compilation failed in require at C:/usr/site/lib/ZOOM.pm line 6., referer: http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl [Fri Apr 17 13:16:06 2009] [error] [client 127.0.0.1] BEGIN failed--compilation aborted at C:/usr/site/lib/ZOOM.pm line 6., referer: http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl [Fri Apr 17 13:16:06 2009] [error] [client 127.0.0.1] Compilation failed in require at C:/usr/koha228/intranet/cgi-bin/koha/z3950/search.pl line 30., referer: http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl [Fri Apr 17 13:16:06 2009] [error] [client 127.0.0.1] BEGIN failed--compilation aborted at C:/usr/koha228/intranet/cgi-bin/koha/z3950/search.pl line 30., referer: http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl Anyone know how can I solve this error? BTW I have searched lists including this posting for answer but no luck: http://www.nabble.com/Z39.50-won't-work-td8889632.html cheers Karen Myers Advisor - East Timor Library Association _________________________________________________________________ View photos of singles in your area Click Here http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fdating%2Eninemsn%2Ecom%2Eau…

1 0

override button for halting a fine checkout?
by scott 16 Apr '09

16 Apr '09

I am a little confused on how the structure works with koha. I have so far when you try to check a book out to someone with a fee it halts displays the errors and then creates a button called Override and an error message to allow the librarian to continute to check out. I am using OPAC and i think this is where its confusing me, im trying to get the button to post to an override.pl which is basically the circulation.pl but without it checking to see if it meets any criteria and then i made a override.tmpl which is just like the circulation.tmpl now my problem is when i click the button it cant find the .pl file right now they are sitting in /koha/intranet/cgi-bin/circ/override.pl and the tmpl in the koha/intranet/intranet-tmpl/prog/en/modules/circ/override.tmpl I've changed the files so they work with each other, meaning the override.pl uses the override.tmpl, so now why doesnt it show in the url i enter? is it because im using OPAC and i need to do something in there? thanks for those who answer :) _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel

2 2

New Bugzilla component: browser compatibility
by Galen Charlton 15 Apr '09

15 Apr '09

Hi, I've added a new component to bugs.koha.org called "browser compatibility" for bugs that have to do with failures in staff intranet and OPAC that depend on the particular web browser being used. This is primarily motivated by a project for a LibLime client to squelch issues with using the staff client in IE7 and (as much as possible) IE6, but can apply to any bug that is dependent on the user agent. The default assignee is Joe, as he'll be working on those issues for now, but please let me know if you want to be added to the CC list for this component. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton(a)liblime.com p: 1-888-564-2457 x709 skype: gmcharlt

2 2

Fwd: [Koha-translate] mail list for pt_BR group
by MJ Ray 13 Apr '09

13 Apr '09

Hi - I'm not sure who I should ask about this mailing list creation, so I bring it to devel. If there's some reason not to host it at lists.koha.org, let me know and I can host it at software.coop somewhere. -- MJR -------- Original Message -------- Date: Thu, 9 Apr 2009 00:38:08 -0300 Message-ID: <c6240f9a0904082038m13d0c36br62a0f1dba3ed6afb(a)mail.gmail.com> From: Kemel Zaidan <kemelzaidan(a)gmail.com> Subject: [Koha-translate] mail list for pt_BR group I am trying to rally a group of people and create a Koha community here at Brazil. I wanna see if I can get some help on the Koha translation and for that I would like to know if a mailing list for this purpose could be set. I've talked to chris on IRC, and he told me to write to henridamien.laurent(a)biblibre.com and ask for one, but I had no answer from him. I am going to give a speech on a local open source event next week, so I would like to have the wiki and the mail list set by that, so I could talk about it and ask some people to join. Thanks Kemel Zaidan

2 2

Authority UsageCount returns 0
by Eric Bégin 13 Apr '09

13 Apr '09

Hi there, I have a problem with authorities that are actually refered in some biblios but the UsageCount returns 0 when searching those authorities. I checked the biblios and their $9 field are correctly set to the authid. Does anybody experience the same problem? FYI: I'm using Zebra. Thanks, Eric Bégin 514.777.6572 Eric.Begin(a)inLibro.com <mailto:Eric.Begin@inLibro.com> inLibro POUR ESPRIT LIBRE <www.inLibro.com> <www.inLibro.com>

1 0

Re: [Koha-devel] [Koha] null itemnumbers and borrowernumbers in issues table
by Chris Cormack 11 Apr '09

11 Apr '09

2009/4/11 Joe Atzberger <ohiocore(a)gmail.com>: > > > On Fri, Apr 10, 2009 at 11:19 AM, Jeffrey LePage <jeffrey_lepage(a)yahoo.com> > wrote: >> >> Greetings, >> >> We've just discovered 4 records in the issues table that have nulls where >> there should never be nulls. Specifically, 2 records with null >> borrowernumber and 2 records with null itemnumber. As a result, there are >> two overdue books checked out to a NULL patron and two patrons who've >> checked out NULL books. >> >> I notice that the issues table is constructed thus: >> mysql> desc issues; >> +-----------------+-------------+------+-----+-------------------+-------+ >> | Field | Type | Null | Key | Default | Extra | >> +-----------------+-------------+------+-----+-------------------+-------+ >> | borrowernumber | int(11) | YES | MUL | NULL | | >> | itemnumber | int(11) | YES | MUL | NULL | | >> | date_due | date | YES | | NULL | | >> | branchcode | varchar(10) | YES | | NULL | | >> | issuingbranch | varchar(18) | YES | | NULL | | >> | returndate | date | YES | | NULL | | >> | lastreneweddate | date | YES | | NULL | | >> | return | varchar(4) | YES | | NULL | | >> | renewals | tinyint(4) | YES | | NULL | | >> | timestamp | timestamp | NO | | CURRENT_TIMESTAMP | | >> | issuedate | date | YES | | NULL | | >> +-----------------+-------------+------+-----+-------------------+-------+ >> >> Notice that borrowernumber and itemnumber are NULL'able. >> Isn't this a _bad_ idea? I don't know why/how the null itemnumbers and >> borrowernumbers got into the database, but it seems that making them >> non-nullable would be a good idea. >> >> Comments? > > This is a known issue, basically a compromise to allow offline circulation > to work in 3.0 (where the borrowernumber or itemnumber might not actually > exist when the insertions are done). But in short, yes, I agree DB > constraints need to be imposed for itemnumber and borrowernumber in issues. Shifting to the devel list. Shouldn't we store the offline circs in their own table, with nullable fields if they need it. Then reconcile them into the issues table? That way we can put the constraints back on the issues table. Chris

2 1

Re: [Koha-devel] Working on patch, need translation to french for system preference.
by Michael Hafen 10 Apr '09

10 Apr '09

Thank you Nicolas. I'll use this translation then. On another note, I'm wondering about the single quote. The SQL doesn't like it in "l'interface". To work in the SQL should that be "l''interface"? I ask because I see something similar on another line of the unimarc_standard_systempref.sql file, line 15. It's about the autoBarcode sys. pref. On Fri, 2009-04-10 at 18:50 +0200, Nicolas Morin wrote: > On Fri, Apr 10, 2009 at 6:15 PM, Michael Hafen <mdhafen(a)tech.washk12.org> wrote: > > The confusion is a flaw in my description. There is a page load when > > the 'Edit' link is clicked. With the sys. pref. off the link doesn't > > appear. The link directs to a separate page which also checks the sys. > > pref. for security sake. > > > > Managing fines with this off should be as normal, hence the sys. pref. > > defaulting to off. This patch is for people who don't care about proper > > accounting practices. :) > > OK, so my translation is NOT good after all. > Francis' better, expect we chose globally to translate patrons as > "adhérents" rather than "emprunteurs". So that would be : "Autorise la > modification des lignes de compte des adhérents" > > Nicolas > -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha

2 2

Working on patch, need translation to french for system preference.
by Michael Hafen 10 Apr '09

10 Apr '09

I'm working on a feature controlled by a sys pref. ( It will default to off ). Can someone translate this text to French for inclusion in the sysprefs.sql. Thanks. 'If ON Patron account lines can be changed in the staff client' -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://koha-dev.washk12.org or git://koha-dev.washk12.org/koha

2 5

sh: mysql: command not found
by Anas Ghrab 10 Apr '09

10 Apr '09

Hi, I could install the last version of koha (koha-3.00.01-stable) on Mac os x 10.5.5. But in the third step of the web installation, I get this error : sh: mysql: command not found That is strange as it could connect to the database in the step 2 : Connection established. Database koha exists. User kohaadmin has all required privileges on database koha. This error appears only in the step three while trying to "create the database tables and fill them with some default data" Thanks for yours help, --- Anas

2 1