- Koha - lists.katipo.co.nz

Re: [Koha] Koha 3.02.00.004 to 3.06.3 database upgrade fails
by Dhiru Kholia 24 Feb '12

24 Feb '12

On Fri, Feb 24, 2012 at 6:50 PM, Chris Nighswonger <cnighswonger(a)foundations.edu> wrote: > On Fri, Feb 24, 2012 at 7:02 AM, Dhiru Kholia <dhiru.kholia(a)gmail.com> > How did you do your installation of 3.6.3? I followed instructions at: http://wiki.koha-community.org/wiki/Backing_up_Koha http://wiki.koha-community.org/wiki/Koha_on_Ubuntu For backing up 3.02 database I ran "mysqldump -u kohaadmin -p --ignore-table koha.sessions --ignore-table koha.zebraqueue koha > mydatadump.sql" command. I then installed a Koha 3.06.3 on a fresh machine. Before importing mydatadump.sql I dropped and re-created koha database on the fresh machine. >> After database upgrade is done, I get the following error in web browser: >> >> Software error: >> >> Can't call method "delete" on an undefined value at >> /usr/share/koha/lib/C4/Auth.pm line 717. >> > > This is unrelated to the above. It appears that there is no session object > or something is otherwise broken about the session. Perhaps clearing > cookies, flushing browser cache, or truncating the sessions table would > help. This error is now gone :-). This time I didn't drop and re-create koha database on the fresh machine. I imported 3.02's mydatadump.sql on top of existing 3.06.3's new database. I suspect " --ignore-table koha.sessions" bit might be the reason for the above error. I also used a different browser after importing the database. Maybe this part helped to fix the error. Thanks for help Chris! -- Cheers, Dhiru

2 1

Koha 3.02.00.004 to 3.06.3 database upgrade fails
by Dhiru Kholia 24 Feb '12

24 Feb '12

Hi, I tried upgrading database created under Koha version 3.02.00.004 to version 3.06.3 and I get the following errors. Update errors : * [Fri Feb 24 11:52:26 2012] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3997. * [Fri Feb 24 11:52:26 2012] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3998. ... After database upgrade is done, I get the following error in web browser: Software error: Can't call method "delete" on an undefined value at /usr/share/koha/lib/C4/Auth.pm line 717. ... Any tips to solve this issues would be greatly appreciated. Thanks! -- Cheers, Dhiru

2 1

Signing On
by Steve Campbell 23 Feb '12

23 Feb '12

Greetings. As suggested in the list's welcome message, I am introducing myself as a new subscriber to the list. My name is Steve Campbell, and I am a trustee of the Converse Free Library in Lyme, New Hampshire, in the US. We are a small public library: about 1,400 patrons and 25,000 items in our catalog. We have a full-time director, two part-time assistants, and a couple dozen volunteers. We also host the school library for our town's K-8 public school. We are open 6 days a week for a total of 36 hours per week. We are in the process of migrating from InfoCentre, hosted on our own server, to Koha 3.6.2, hosted by Bywater Solutions. We are currently learning Koha on a test system set up by Bywater. We plan to go live in June. My own background is in Unix computer system administration and network management. I retired a few years ago. I am a believer in the principals of open source. I do not have a background in library science (but I'm learning!). In addition to my normal duties as a trustee, I spend a lot of time at the library managing the eight public computers (we pay a Windows professional to support the server and staff desktops), troubleshooting any computer or network problems, and generally being the available to answer questions. During the migration to Koha, I have been busy learning the system and helping the staff explore and configure it for our needs. I look forward to contributing to this community when I can and asking for help when I must. Steve

2 1

Re: [Koha] online libraries
by Howell, Lynda 23 Feb '12

23 Feb '12

Aman, Thanks, that's helpful. I hadn't thought about the idea of using digital repository software. Our records all start out in MARC - we've got about 90000 books, 6000 dissertations/theses, and a handful of other stuff, but definitely bibliographic records to resources hosted elsewhere (ebrary, ProQuest, EBSCO, etc.) rather than locally hosted content. We do original cataloging and host the undergraduate- and masters- level theses, but that's a small percentage. But I do think it might be helpful for us to look outside the ILS box. Thanks for the suggestion! Lynda. From: amandeep.kapila(a)aol.in [mailto:amandeep.kapila@aol.in] Sent: Thursday, February 23, 2012 1:52 PM To: Howell, Lynda Subject: Re: [Koha] online libraries Hello, I think you don't want to manage a collection of bibliographic records (for which ILSs specialize) but want to create a digital repository of electronic/digital content. You have two options, 1. You can use a ILS like KOHA with MARC21 field 856 to provide a link to the electronic content so that when a user clicks it the electronic document will open. I managed managed a big project (9.5 hundard thousand press clippings for JNU, New Delhi) on VTLS product Virtua when I worked for the company. I have checked it on KOHA also and it works the same way and works fine. The drawback is you have to catalogue every document/resource in MARC21(which is a tedious job compared to DC) and have to upload each file to the server (for which you may need the help from either the Administrator or a developer who will have to create a system for you to upload files) and then input the link to the file at field 856. The plus point is KOHA will meet more or less your advanced search requirements. 2. The second option is you can use a repository management software like dspace, greenstone or fedora etc. These specialize in creating and managing digital repositories. They use DC for metadata. They allow you to upload the electronic files in many different formats directly without any help from the administrator or developers. We have a repository running on Dspace available at http://www.egyankosh.ac.in. Another option can be using some CMS but that will take a lots of customization and hard work and won't be required if you are not intending to create some fancy stuff. Keep in mind your budget, the volume of your collection and the kind of user you are expecting before making any decision. Best of Luck. Cheers ------------------------ Aman, (Amandeep kapila), MA(Eng.), MLIS, PGDLAN, DBM, New Delhi-110065. INDIA -----Original Message----- From: Howell, Lynda <Lynda.Howell(a)myunion.edu> To: 'koha(a)lists.katipo.co.nz' <koha(a)lists.katipo.co.nz> Sent: Thu, Feb 23, 2012 11:35 pm Subject: [Koha] online libraries I'm interested in hearing from anyone using Koha in an online (only) library. The whole concept of circulation (patrons, # of copies, due dates, holds, availability, fines, etc.) isn't relevant to us, and 1-click access to full text from the search results page is essential. Being able to limit searches to particular subsets (or to exclude particular subsets) is also important to us. We're starting to explore open-source options for replacing our current ILS. Is anyone using Koha in this kind of environment? What kinds of customization did you do initially, and how much on-going work are you finding it takes to keep up with upgrades? What other ILS/OPACs did you consider before choosing Koha , and what made you go with Koha ? Thanks for any insights you can give. Lynda Howell -------------------------------- Lynda Howell Systems Librarian Union Institute & University 62 Ridge Street, Suite 2 Montpelier, Vermont 05602 (802) 828-8618 lynda.howell(a)myunion.edu _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

3.6.2 - System preferences cannot be updated
by Tom Hanstra 23 Feb '12

23 Feb '12

I'm running into a problem with changing System Preferences values. When I attempt to make a change, I get these errors in the message log Message Log * Error; your data might not have been saved * You need to log in again, your session has timed out The session has not actually timed out as I can continue to go to other screens and navigate the Staff Client. I've checked permissions on files and database access and these are not a problem. Does anyone have an idea on what might be happening? Anyone else seen such problems? I'm seeing this on two different instances of 3.6.2. Thanks, Tom -- ----------------------------------------------------------------------------- Tom Hanstra Systems Administrator University Libraries of Notre Dame Phone: (574)631-4686 213 Hesburgh Library Email: tom(a)nd.edu Notre Dame, IN 46556 Time flies like an arrow. Fruit flies like a banana. -----------------------------------------------------------------------------

2 2

online libraries
by Howell, Lynda 23 Feb '12

23 Feb '12

I'm interested in hearing from anyone using Koha in an online (only) library. The whole concept of circulation (patrons, # of copies, due dates, holds, availability, fines, etc.) isn't relevant to us, and 1-click access to full text from the search results page is essential. Being able to limit searches to particular subsets (or to exclude particular subsets) is also important to us. We're starting to explore open-source options for replacing our current ILS. Is anyone using Koha in this kind of environment? What kinds of customization did you do initially, and how much on-going work are you finding it takes to keep up with upgrades? What other ILS/OPACs did you consider before choosing Koha , and what made you go with Koha ? Thanks for any insights you can give. Lynda Howell -------------------------------- Lynda Howell Systems Librarian Union Institute & University 62 Ridge Street, Suite 2 Montpelier, Vermont 05602 (802) 828-8618 lynda.howell(a)myunion.edu

1 0

Novelist
by vtl＠scls.lib.wi.us 22 Feb '12

22 Feb '12

Hi, Is any library using the Novelist integration that was included with the 3.6.0 Koha upgrade? I would like to see what this looks like. Vicki -- Vicki Teal Lovely Helping our 53 member libraries provide the best possible service to the public. ILS Project Manager South Central Library System Madison, WI vtl(a)scls.lib.wi.us (608)242-4713 ILS Help Desk (608)242-4720 Twitter: vickiteal Blog: http://scls.typepad.com/link2koha/

2 2

Updating ebook records in Koha - what happens to adjusted biblio records?
by Hartman, David W. - GBTS Library 22 Feb '12

22 Feb '12

My library subscribes to Books24x7 and Safari Books online. When I update my collection to have the latest book records from these providers, I assume I should REVERT the last batch input and IMPORT the latest records. If I took an existing Safari biblio record and added a print (second copy) to this existing record, would the print item (second copy) and biblio record disappear when I REVERT the Safari record, or would the biblio and item record remain for the one print copy? Let me know .. I do not want to start the updating process without understanding its impact to revert and import updates.

2 1

How to display fields in OPAC
by Richa Srivastava 22 Feb '12

22 Feb '12

Where can I find xslt styelsheet to change the field display in normal view in OPAC? Is this wise to touch the xslt style sheet as a library staff? Can it be accessed through staff-client interface? -- Best wishes ऋचा Richa Srivastava

2 1

The Picture Box
by Hal Bright 22 Feb '12

22 Feb '12

Does any public library use the "picture" option? We have been contemplating it for some time now. Questions...do you use it for teens adults or kids only? Does the picture go away when the patron is deleted (i.e. is the picture connected to the patron file)? Have any privacy issues arisen? Harold Bright Director of Information Services Farmington Libraries - 6 Monteith Drive Farmington, CT 06032 - hbright(a)farmingtonlibraries.org<mailto:hbright@farmingtonlibraries.org> W 860-673-6791 x 204 - F 860-675-7148 http://www.farmingtonlibraries.org

2 1