- Koha - lists.katipo.co.nz

ERROR in OPAC-ERROR_LOG.FILE in opac-error_log.file
by rahayu rms 14 Jul '03

14 Jul '03

Hello.. I have installed koha v 1.2.3 on windows and successfully run but I still don't undersatand there are so many errors in this file.This are some of the errors.Anybody can explain to me what does it mean and how to solve it? I hope somebody can help me... Thanks... [Tue Jun 24 09:08:03 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 49, <KC> line 32. [Tue Jun 24 09:08:03 2003] [error] [client 127.0.0.1] attempt to invoke directory as script: C:/usr/koha123/opac/cgi-bin/koha/, referer: http://localhost/cgi-bin/koha/opac-main.pl [Tue Jun 24 09:08:12 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect, <KC> line 40., referer: http://localhost/cgi-bin/koha/opac-main.pl [Tue Jun 24 09:08:18 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 49, <KC> line 40., referer: http://localhost/cgi-bin/koha/opac-user.pl [Tue Jun 24 09:08:19 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 55, <KC> line 48., referer: http://localhost/cgi-bin/koha/opac-user.pl [Tue Jun 24 09:08:19 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 56, <KC> line 56., referer: http://localhost/cgi-bin/koha/opac-user.pl [Tue Jun 24 09:08:19 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at C:/usr/koha123/opac/cgi-bin/koha/opac-user.pl line 26, <KC> line 64., referer: http://localhost/cgi-bin/koha/opac-user.pl [Tue Jun 24 09:08:19 2003] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Unknown column 'itemtypes.publictype' in 'field list' at c:/usr/koha123/intranet/modules/C4/Circulation/Circ2.pm line 1529, <KC> line 80., referer: http://localhost/cgi-bin/koha/opac-user.pl [Tue Jun 24 09:08:19 2003] [error] [client 127.0.0.1] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at c:/usr/koha123/intranet/modules/C4/Circulation/Circ2.pm line 1531, <KC> line 80., referer: http://localhost/cgi-bin/koha/opac-user.pl [Tue Jun 24 09:09:01 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 49, <KC> line 32. [Tue Jun 24 09:09:01 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 55, <KC> line 40. [Tue Jun 24 09:09:01 2003] [error] [client 127.0.0.1] attempt to invoke directory as script: C:/usr/koha123/opac/cgi-bin/koha/, referer: http://localhost/cgi-bin/koha/opac-main.pl [Tue Jun 24 09:09:01 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 56, <KC> line 48. [Tue Jun 24 09:10:04 2003] [error] [client 127.0.0.1] Premature end of script headers: opac-main.pl _________________________________________________________________ Are you in love? Find a date on MSN Personals http://match.msn.com.my/

1 0

ADD ITEM PROBLEM
by rahayu rms 14 Jul '03

14 Jul '03

hello, 1. I am using koha v1.2.3. I try to add item using ISBN number.When I try to search the item its working but the item count for that item is 0. So user cannot make a request for the item because it is not reservable. Anybody know what happened? 2. Koha also cannot calculate the overdue charges.I hope somebody can help me. Thanks.. _________________________________________________________________ Using a handphone prepaid card? Reload your credit online! http://www.msn.com.my/reloadredir/default.asp

2 1

Pre-2.0 perl dependencies question
by Michael Rudmin 12 Jul '03

12 Jul '03

Hi, I remember this being on the list back in 1.9.0, but I don't see it recently, and I can't find the answer. Anyhow, I'm going to be uninstalling my current version of Koha, and installing 2.0.0 [I've already zapped my mysql databases, and will uninstall other things as need be.] But my question is, when it is time to install the perl modules, such as Marc::Record, or Net::Z3950, some versions work and some versions don't. Which versions work, and where can I get them? __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com

2 1

How do I log into the intranet for the first time?
by Ben Hall 12 Jul '03

12 Jul '03

All and sundry, I've just setup Koha for the first time. My opac system is running ok but when I access the koha (intranet) system I get stuck at the koha login page. In the installation notes it mentions that I should "add some users to the users table in the koha database". I have done this but I still can't log in. Is the password encrypted using md5 hashes or something? Also, the installation notes mention using "AuthenDBI" and "editing your apache conf file" to get the authentication working. I've searched the internet for some help on setting up "AuthenDBI" for apache but I couldn't find anything. Could someone send me an example apache conf that uses the "AuthenDBI" and maybe a related insert statement for the mysql users table? Any help would be very much appreciated. Ben Hall

2 1

ADD ITEM PROBLEM
by rahayu rms 12 Jul '03

12 Jul '03

hello, 1. I am using koha v1.2.3. I try to add item using ISBN number.When I try to search the item its working but the item count for that item is 0. So user cannot make a request for the item because it is not reservable. Anybody know what happened? 2. Koha also cannot calculate the overdue charges.I hope somebody can help me. Thanks.. _________________________________________________________________ Download the latest MSN Messenger http://messenger.msn.com.my

1 0

Error in opac-error_log.file
by rahayu rms 12 Jul '03

12 Jul '03

Hello.. I have installed koha v 1.2.3 on windows and successfully run but I still don't undersatand there are so many errors in this file.This are some of the errors.Anybody can explain to me what does it mean and how to solve it? I hope somebody can help me... Thanks... [Tue Jun 24 09:08:03 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 49, <KC> line 32. [Tue Jun 24 09:08:03 2003] [error] [client 127.0.0.1] attempt to invoke directory as script: C:/usr/koha123/opac/cgi-bin/koha/, referer: http://localhost/cgi-bin/koha/opac-main.pl [Tue Jun 24 09:08:12 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect, <KC> line 40., referer: http://localhost/cgi-bin/koha/opac-main.pl [Tue Jun 24 09:08:18 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 49, <KC> line 40., referer: http://localhost/cgi-bin/koha/opac-user.pl [Tue Jun 24 09:08:19 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 55, <KC> line 48., referer: http://localhost/cgi-bin/koha/opac-user.pl [Tue Jun 24 09:08:19 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 56, <KC> line 56., referer: http://localhost/cgi-bin/koha/opac-user.pl [Tue Jun 24 09:08:19 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at C:/usr/koha123/opac/cgi-bin/koha/opac-user.pl line 26, <KC> line 64., referer: http://localhost/cgi-bin/koha/opac-user.pl [Tue Jun 24 09:08:19 2003] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Unknown column 'itemtypes.publictype' in 'field list' at c:/usr/koha123/intranet/modules/C4/Circulation/Circ2.pm line 1529, <KC> line 80., referer: http://localhost/cgi-bin/koha/opac-user.pl [Tue Jun 24 09:08:19 2003] [error] [client 127.0.0.1] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at c:/usr/koha123/intranet/modules/C4/Circulation/Circ2.pm line 1531, <KC> line 80., referer: http://localhost/cgi-bin/koha/opac-user.pl [Tue Jun 24 09:09:01 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 49, <KC> line 32. [Tue Jun 24 09:09:01 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 55, <KC> line 40. [Tue Jun 24 09:09:01 2003] [error] [client 127.0.0.1] attempt to invoke directory as script: C:/usr/koha123/opac/cgi-bin/koha/, referer: http://localhost/cgi-bin/koha/opac-main.pl [Tue Jun 24 09:09:01 2003] [error] [client 127.0.0.1] Database handle destroyed without explicit disconnect at c:/usr/koha123/intranet/modules/C4/Auth.pm line 56, <KC> line 48. [Tue Jun 24 09:10:04 2003] [error] [client 127.0.0.1] Premature end of script headers: opac-main.pl _________________________________________________________________ Download the latest MSN Messenger http://messenger.msn.com.my

1 0

MARC RECORD PROBLEM
by rahayu rms 11 Jul '03

11 Jul '03

Hello.. Hello, I have installed koha V1.2.3 on windows and successfully run.But I have problem to import 5000 marc record into koha from my old database library system.I would like to test koha using our data.Anybody know how to transfer data using marc record.These are sample data.I need some help.What should I do? Rec stat: n Entered: 20021020 Replaced: 20021020 Type: a ELvl: 1 Srce: a Audn: Ctrl: Lang: eng BLvl: m Form: Conf: 0 Biog: MRec: Ctry: xxk Cont: GPub: Fict: 0 Indx: 0 Desc: a Ills: Fest: 0 DtSt: e Dates: 2002, ÿ040 ßc KUI ÿ020 0471126500 ÿ050 HG4751 ßb .C36 2002 ÿ090 HG4751 ßb .C36 2002 ÿ049 KUIM ÿ100 1 Camp, Justin J. ÿ245 10 Venture capital due diligence ßb a guide to making smart investment choices and increasing your portfolio returns ßc Justin J. Camp ÿ260 New York : ßb John wiley : ßc 2002 ÿ300 xi, 258p. : ßc 24cm ÿ504 Includes bibliographical references and index ÿ650 0 Venture capital Ü650 0 Rate of return Ü999 000010424 OCLC: NEW Rec stat: n Entered: 20021020 Replaced: 20021020 Type: a ELvl: 1 Srce: a Audn: Ctrl: Lang: eng BLvl: m Form: Conf: 0 Biog: MRec: Ctry: xxk Cont: GPub: Fict: 0 Indx: 0 Desc: a Ills: Fest: 0 DtSt: e Dates: 2002, ÿ040 ßc KUI ÿ020 0471126500 ÿ050 HG4751 ßb .C36 2002 ÿ090 HG4751 ßb .C36 2002 ÿ049 KUIM ÿ100 1 Camp, Justin J. ÿ245 10 Venture capital due diligence ßb a guide to making smart investment choices and increasing your portfolio returns ßc Justin J. Camp ÿ260 New York : ßb John wiley : ßc 2002 ÿ300 xi, 258p. : ßc 24cm ÿ504 Includes bibliographical references and index ÿ650 0 Venture capital Ü650 0 Rate of return Ü999 000010424 OCLC: NEW Rec stat: n Entered: 20021020 Replaced: 20021020 Type: a ELvl: 1 Srce: a Audn: Ctrl: Lang: eng BLvl: m Form: Conf: 0 Biog: MRec: Ctry: xxk Cont: GPub: Fict: 0 Indx: 0 Desc: a Ills: Fest: 0 DtSt: e Dates: 2002, ÿ040 ßc KUI ÿ020 0471126500 ÿ050 HG4751 ßb .C36 2002 ÿ090 HG4751 ßb .C36 2002 ÿ049 KUIM ÿ100 1 Camp, Justin J. ÿ245 10 Venture capital due diligence ßb a guide to making smart investment choices and increasing your portfolio returns ßc Justin J. Camp ÿ260 New York : ßb John wiley : ßc 2002 ÿ300 xi, 258p. : ßc 24cm ÿ504 Includes bibliographical references and index ÿ650 0 Venture capital Ü650 0 Rate of return Ü999 000010424 OCLC: NEW Rec stat: n Entered: 20021020 Replaced: 20021020 Type: a ELvl: 1 Srce: a Audn: Ctrl: Lang: eng BLvl: m Form: Conf: 0 Biog: MRec: Ctry: xxk Cont: GPub: Fict: 0 Indx: 0 Desc: a Ills: Fest: 0 DtSt: e Dates: 2002, ÿ040 ßc KUI ÿ020 0471126500 ÿ050 HG4751 ßb .C36 2002 ÿ090 HG4751 ßb .C36 2002 ÿ049 KUIM ÿ100 1 Camp, Justin J. ÿ245 10 Venture capital due diligence ßb a guide to making smart investment choices and increasing your portfolio returns ßc Justin J. Camp ÿ260 New York : ßb John wiley : ßc 2002 ÿ300 xi, 258p. : ßc 24cm ÿ504 Includes bibliographical references and index ÿ650 0 Venture capital Ü650 0 Rate of return Ü999 000010424 OCLC: NEW Rec stat: n Entered: 20021020 Replaced: 20021020 Type: a ELvl: 1 Srce: a Audn: Ctrl: Lang: eng BLvl: m Form: Conf: 0 Biog: MRec: Ctry: xxk Cont: GPub: Fict: 0 Indx: 0 Desc: a Ills: Fest: 0 DtSt: e Dates: 2002, ÿ040 ßc KUI ÿ020 0471126500 ÿ050 HG4751 ßb .C36 2002 ÿ090 HG4751 ßb .C36 2002 ÿ049 KUIM ÿ100 1 Camp, Justin J. ÿ245 10 Venture capital due diligence ßb a guide to making smart investment choices and increasing your portfolio returns ßc Justin J. Camp ÿ260 New York : ßb John wiley : ßc 2002 ÿ300 xi, 258p. : ßc 24cm ÿ504 Includes bibliographical references and index ÿ650 0 Venture capital Ü650 0 Rate of return Ü999 000010424 _________________________________________________________________ Using a handphone prepaid card? Reload your credit online! http://www.msn.com.my/reloadredir/default.asp

2 1

ERROR 500
by rahayu rms 11 Jul '03

11 Jul '03

Hello.. I have installed koha on windows 1.2.3 but I have a problem to update Record.This are the error: Server error! The server encountered an internal error and was unable to complete your request. Error message: Premature end of script headers: opac-userupdate.pl If you think this is a server error, please contact the webmaster. Error 500 Anybody can help me? _________________________________________________________________ Download ringtones, logos and picture messages from MSN Malaysia http://www.msn.com.my/mobile/ringtones/default.asp

2 1

Re: [Koha] import question
by Derek Dresser 10 Jul '03

10 Jul '03

Quoting Dan Weeks <Dan(a)bibliofiche.com>: > FYI: > > Typicly 852a would hold a "homebranch" and 852b the "holdingbranch": this is > not always > consistant but never-the-less defined as part of he 852 holding structure. > Once you place > a barcode on a book you need no acsession number (which is what I assume you > mean by "Item > number"). The barcode IS the item number. Thanks Dan, actually, the itemnumber I am referring to is the koha items.itemnumber It can't be NULL, nor can items.barcode. (I think) It seems like I could either make the items.itemnumber just a sequence of unique numbers, or I could make them the same as the barcode, but koha won't seem to let me map two koha fields to the same MARC subfield. I could manually stick the data into the "items" table in the database, but I'm hoping to figure out the "right" way to do this during import so it will be useful for others. Thanks, Derek > > All 900 fields are "user defined" and not part of any marc definition. Many > combinations > have been used and accepted through the years but 852 is the defined area for > a holding. > (A "holding" is specific to the individual item, as opposed the the Biblio > which defines > the title and author and publishing data. i.e. One "biblio" of a popular > title could have > many "holdings" in the library. This is also why the barcode of the book > becomes the only > "item" number you need.) > > Here is the LC definition of 852. > http://www.loc.gov/marc/bibliographic/ecbdhold.html#mrcb852 > > Dan > > ----- Original Message ----- > From: "Derek Dresser" <Derek.Dresser(a)gouldacademy.org> > To: "paul POULAIN" <paul.poulain(a)free.fr> > Sent: Thursday, July 10, 2003 11:31 AM > Subject: Re: [Koha] import question > > > > > >Paul ... any ideas? > > > > > > > > > > > Of course yes :-) > > > If you want import to put items into items table, you have to tell Koha > > > where are hidden your items in your MARC datas... > > > Let me explain : > > > Koha supports any MARC flavour. And each MARC flavour hides items in a > > > different place (for example in UNIMARC, it's 995. For NPL, that uses > > > MARC21, it's 952) > > > * Go to parameter section of Koha, MARC parameters tables. > > > * Search for the field where items are hidden (for example 947) > > > * Open subfields of field 947. > > > * "map" each 947 subfield to a items.something field. > > > * Put each subfield you've mapped to tab "items". > > > * go back to main parameter page > > > * run "checkmarc". If it reports no errors, you've win. > > > * import again, using delete flag to empty your database during the > > process. > > > > > > Hope This Helps > > > > Hi, I've got a few questions and some more info. First of all, my data is > > in MicroLIF format, which is apparently basically USMARC from what I > > understand. I am using the MARC21 parameters at install time. I looked > at > > the MARC records in Winnebago, and it seems that > > the "hidden" data is in the 852 field. However, it appears that the only > > data in that field is the call number and bar code, while the MARC Check > > requires that I map itemnumber, barcode, homebranch and holdingbranch at a > > minimum I think (and all within the 852 field). > > > > It seems like the import works fine for the biblios and biblioitems. > Should > > I just extract the barcode and call number afterwards and populate the > items > > table separately? If so, should I use the barcode number for the item > > number, or just start with 1 and go up sequentially? How can I solve this > > problem so it will be the most useful for others in the long run? Does it > > make sense to have another import type "MicroLIF", or "Winnebago"? Thanks > > in advance for any ideas. I have included a small piece of my data again, > > in case it is useful. > > > > Thanks, > > Derek > > > > 00623pam 2200181 a > > > 450000100130000000800410001302000150005405000210006908200140009010000350010424500860013926 > 00066002253000026002915040065003176500030003828520023004129610006004\35^^ > > 85023778 ^^851129s1986 nyu b 00010 eng ^^ ^_a0025003402^^0 > > ^_aAZ221^_b.A35 1986^^0 ^_a001.2^_219^^10^_aAdler, Mortimer > > Jerome,^_d1902-^^12^_aA guidebook to le\arning :^_bfor a lifelong pursuit > of > > wisdom /^_cMortimer J. Adler.^^0 ^_aNew York :^_bMacmillan ;^_aLondon > > :^_bCollier Macmillan,^_cc1986.^^ ^_axii, 163 p. ;^_c22 cm.^^ ^_a"Som\e > > books that may be helpful to autodidacts": p. 161-163.^^ 0^_aLearning and > > scholarship.^^1 ^_h001.2 Ad59g^_p10001^^WL^_t6^^^]00600pam 2200205 a > > > 45000010013000000080041000130200\022000540200022000760500024000980820017001221000020001392 > 450064001592500012002232600038002353000035002735040039003086500016003478520025003639610006 > 00388^^ > > 84028794 ^^841231s198\5 nyua b 00110 eng ^^ ^_a0716717174 > > (pbk.)^^ ^_a071671695X (hard)^^0 ^_aQA276.12^_b.M66 1985^^0 > > ^_a001.4/22^_219^^10^_aMoore, David S.^^10^_aStatistics :^_bconcepts \and > > controversies /^_cDavid S. Moore.^^ ^_a2nd ed.^^0 ^_aNew York :^_bW.H. > > Freeman,^_cc1985.^^ ^_axvii, 350 p. :^_bill. ;^_c24 cm.^^ ^_aIncludes > > bibliographies and index.^^ 0^\_aStatistics.^^1 ^_h001.422 > > M782s^_p10002^^WL^_t6^^^] > > > > > > > > Note : the main constraint is that all MARC subfields mapped to item > > > field MUST be in the same field (you can't have a part of an item into > > > 947 & 2nd part in 935). If you have, then the only solution is to > > > "rewritte" your MARC data before importing. We have a problem with > > > itemtypes, that is not in items in Koha but seems to have it's place in > > > there, that's what we will speak during today IRC meeting. > > > > > > -- > > > Paul POULAIN > > > Consultant indépendant en logiciels libres > > > responsable francophone de koha (SIGB libre http://www.koha-fr.org) > > > > > > > > > > > > -- > > Derek Dresser > > http://network.gouldacademy.org/ > > Gould Academy > > Bethel, ME 04217 > > (207)824-7700 > > > > "Nothing endures but change" > > --Heraclitus > > > > > > ------------------------------------------------- > > This mail sent through IMP: http://horde.org/imp/ > > > > > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > -- Derek Dresser http://network.gouldacademy.org/ Gould Academy Bethel, ME 04217 (207)824-7700 "Nothing endures but change" --Heraclitus ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/

2 1

[Koha-win32] Koha 2.0.0pre2 is out for Windows (fwd)
by Pat Eyler 10 Jul '03

10 Jul '03

Good news for all of you windows based Koha users. -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 ---------- Forwarded message ---------- Date: Thu, 10 Jul 2003 17:26:13 -0500 From: robweir(a)alum.drexel.edu To: koha-win32 Mail List <koha-win32(a)lists.sourceforge.net> Subject: [Koha-win32] Koha 2.0.0pre2 is out for Windows A Windows install package for Koha 2.0.0pre2 is now available. Visit the KohaOnWindows section of the Koha wiki at http://www.saas.nsw.edu.au/wiki/index.php?page=KohaOnWindows for download links and several pages of information and instructions for installing and running Koha on Windows. There is also a link for an updated install of Koha V1.2.3. Both of these installs now include the latest versions of all required Perl modules for both Active State Perl V5.6.x and V5.8.x. In addition, both installs have been tested and tweaked to run with either MySQL V3 or the new MySQL V4. Both installs include both a set of sample data and a set of blank data (these aren't perfect - they need some work). Note that you must download and install the Apache Webserver, MySQL database, and Active State Perl as pre-requisites before running these Koha installs, but that download links and full instructions are given at the above mentioned wiki pages. The V1.2.3 is a stable release, but lacks support for MARC. Koha 2.0.0pre2 is a test pre-release, meaning it still has some bugs and features that do not work. It is provided so you can start testing and preparing for a stable V2 release in the near future. I would welcome suggestions for how to improve these Windows install packages for future versions. I would also greatly appreciate if someone could contribute a better set of sample data to include in future installs. Or perhaps someone could clean up and fix up the current set of sample data and then send me a copy. Please address any suggestions or questions to koha-win32(a)lists.sourceforge.net Rob ------------------------------------------------------- This SF.Net email sponsored by: Parasoft Error proof Web apps, automate testing & more. Download & eval WebKing and get a free book. www.parasoft.com/bulletproofapps1 _______________________________________________ Koha-win32 mailing list Koha-win32(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-win32

1 0