- Koha - lists.katipo.co.nz

Restoring the koha database
by Sandeep Bhavsar 01 Feb '14

01 Feb '14

Respected All I have taken the backup of our school library database in sql from koha ver 3.07.00.017 and installed koha 3.12 now. When I am restoring the database I am getting the error in rebuild_zebra.pl line 539 for few records. Is it the error of mysql database structure, Please help me to solve this problem. -- *Regards * *Sandeep Bhavsar* B.com, M.Lib.I.Sc SET, M.Phil, American Library Association - FERA 2011 fellow Librarian Dr. V N Bedekar Institute of Management Studies Thane (W) 400601 Mumbai INDIA Mobile : 9987049099 www.vpmthane.org

2 1

Re: [Koha] Upgrading from 3.02.02 (tarball install) to latest
by Steven Nickerson 31 Jan '14

31 Jan '14

THANK YOU Robin!!! That worked and did exactly what I needed it to and was now able to successfully complete my upgrade. I really appreciate the help! Steve -----Original Message----- Date: Fri, 31 Jan 2014 11:31:12 +1300 From: Robin Sheat <robin(a)catalyst.net.nz> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Upgrading from 3.02.02 (tarball install) to latest (package install) Message-ID: <1391121072.890.1.camel@zarathud> Content-Type: text/plain; charset="UTF-8" On do, 2014-01-30 at 17:07 -0500, Steven Nickerson wrote: > So, > when I run the 'koha-create' on the new system the DB schema isn't > named the > same as the one contained in the MySQL backup that is restored in the > next > step and I therefore don't have any data in the "new" version. Anyone > have > any suggestions on how to resolve this properly? Oh, easy. Where the instructions say: $ sudo koha-mysql <instancename> < mybackup.sql instead do: $ sudo koha-mysql <instancename> ... mysql> \. mybackup.sql This will mean the whole thing doesn't run in a transaction, and the CREATE DATABASE and USE lines will fail, but this won't abort the whole import like it does the first way. -- Robin Sheat Catalyst IT Ltd. ? +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF

1 0

Upgrading from 3.02.02 (tarball install) to latest (package install)
by Steven Nickerson 30 Jan '14

30 Jan '14

Hi everyone, I'm managing an older, running 3.02.02 install that was done via tarball install and I'd like to both move to the package install and upgrade to the latest 3.14.x version. I've tried following the instructions at http://wiki.koha-community.org/wiki/Moving_an_installation_from_a_regular_in stall_to_the_Debian_packages to migrate from tarball to package installs but find that my DB schema in MySQL doesn't seem to follow the current naming "standards" and is named 'kohadb' instead of 'koha_<sitename>'. So, when I run the 'koha-create' on the new system the DB schema isn't named the same as the one contained in the MySQL backup that is restored in the next step and I therefore don't have any data in the "new" version. Anyone have any suggestions on how to resolve this properly? I also then received errors during the "sudo koha-upgrade-schema <instancename>" step, but I'm pretty sure that was because of the issue with the schema names. Sound familiar to anyone (has anyone upgraded from 3.02.02 directly to some fairly recent version or have most people done "incremental" upgrades along the way so they didn't have this issue? Thanks for any help anyone can offer! Steve

2 1

Duplicate checks in acquisitions module
by Manos PETRIDIS 30 Jan '14

30 Jan '14

Hi people, just a question on duplicate checks: Trying to use koha bit by bit, I've been lately adding my Amazon wishlists to koha suggestions. The other day I bought a book from my suggestions list and marked the suggestion as accepted. Upon the book's arrival, I entered it in koha. Then, some days later, I decided to use the acquisitions module for the first time, taking this last book as an example. Well, to make a short story shorter, koha let me enter a duplicate entry, at least as ISBN is concerned. https://dl.dropboxusercontent.com/u/22465174/20140125_koha_a.JPG https://dl.dropboxusercontent.com/u/22465174/20140125_koha_b.JPG https://dl.dropboxusercontent.com/u/22465174/20140125_koha_c.JPG https://dl.dropboxusercontent.com/u/22465174/20140125_koha_d.JPG Koha usually checks for similar entry attempts, but apparently not when one does it via acquisitions. Is this normal, do I miss something? I use the latest koha packages, on debian, and have only a single library defined. Kind regards, Manos PETRIDIS http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8631

1 0

Re: [Koha] barcode
by Sina Stewart 30 Jan '14

30 Jan '14

no i did't think so , the field null in myql Date: Thu, 30 Jan 2014 20:29:01 +0530 Subject: Re: [Koha] barcode From: shiv.mail(a)gmail.com To: sina_sina1984(a)live.com it may be a blank space before the barcode On 30 January 2014 18:44, Sina Stewart <sina_sina1984(a)live.com> wrote: still not working , the field of barcode in items NULL , not saving any data ! Date: Thu, 30 Jan 2014 15:05:24 +0530 Subject: Re: barcode From: vishal.patil(a)osslabs.biz To: sina_sina1984(a)live.com CC: koha(a)lists.katipo.co.nz Reindex the zebra using/misc/migrationtools/rebuild_zebra.pl -b -r -v -x Then start zebra using, zebrasrv -f /koha/etc/koha-conf.xml & hope this work for you!!!!!!!!! On Thu, Jan 30, 2014 at 2:58 PM, Sina Stewart <sina_sina1984(a)live.com> wrote: i'm using koha V.3.14 , Ubuntu 12.04 ,latest V. of zebra , there are a big problem for me , i can't search by barcode , i have 3.8 and no problem with barcode indexing , any help -- Regards, Vishal Patil Landline number:02232080161 E-Mail: vishal_wpatil(a)nucsoft.co.in vishal.patil(a)osslabs.biz. _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Shivendra 9815526163 IMPORTANT NOTICE: This e-mail and any attachments may contain confidential or sensitive information which is, or may be, legally privileged or otherwise protected by law from further disclosure. It is intended only for the addressee. If you received this in error or from someone who was not authorized to send it to you, please do not distribute, copy or use it or any attachments. Please notify the sender immediately by reply e-mail and delete this from your system. Thank you for your cooperation

1 0

barcode
by Sina Stewart 30 Jan '14

30 Jan '14

i'm using koha V.3.14 , Ubuntu 12.04 ,latest V. of zebra , there are a big problem for me , i can't search by barcode , i have 3.8 and no problem with barcode indexing , any help

2 2

koha problem
by Wa3ed Shatnawi 29 Jan '14

29 Jan '14

Hi all.. I need your help please. is there a place where we can set parameters to search by an exactbarcode? For purposes of quality control, we would like our cataloguers to search an exactbarcode and to get the exact record matching that barcode. And thanks in advance.

2 1

barcode
by Sina Stewart 29 Jan '14

29 Jan '14

Hi everybody i have a problem in koha 3.14 , i can't search by barcode , any help thank's

1 0

Vote for Location of Koha Users Meeting in North America
by Nora Blake 28 Jan '14

28 Jan '14

Hello all, Two organizations have put together proposals to host a meeting of North American Koha Users. A survey has been put together to gather votes of interest in these two proposals. You can read the content of the proposals from links on the survey site and then you can vote for your preference. The poll will be closed on February 17, so make sure you vote soon! The poll: http://survey.web2learning.net/limesurvey/index.php/171389/lang-en Thanks, Nora ________________________ Nora Blake MassCat Manager Massachusetts Library System P.O. Box 609 South Deerfield, MA 01373-0241 508-357-2121 x123 866-627-7228 Email: nblake(a)masslibsystem.org AIM: noraatmls

1 0

Koha & Self-check system dropping out
by Catherine Kerrigan 28 Jan '14

28 Jan '14

Hi folks! We're installing an RFID/self-check system from FE Technologies but are having a problem in that the self-check kiosk keeps disconnecting from Koha. FE Technologies thinks it might be either a network or Koha problem, so whilst I check with our IT people re the network, I thought I would put the question to the community as well. We have installed verions 3.12.03.000 on Ubuntu. Many thanks. Catherine Catherine Kerrigan ::: Librarian T 08 8299 7300 ::: F 08 8172 0504 Adelaide Central School of Art ::: PO Box 225 Fullarton SA 5063 7 Mulberry Road Glenside SA 5065 ::: (adjacent to the Adelaide Film Studios) www.acsa.sa.edu.au<http://www.acsa.sa.edu.au/> Library news<http://www.acsalibrary.blogspot.com.au/> _________________________ Adelaide Central School of Art is now located adjacent to the Adelaide Film Studios in the Glenside Cultural Precinct. Please call to book a tour of our new facilities. In the School Summer School commences 16 January- Enrol now<http://www.acsa.sa.edu.au/fileadmin/public/pdfs/Summer_School_2014_20.11.13…> Support the School by clicking here.<http://www.givenow.com.au/adelaidecentralschoolofart> In the Gallery Uncharted Territory – 2013 Bachelor of Visual Art Graduate Exhibition 14 December 2013 – 10 January 2014 Open 9am – 5pm week days Bachelor of Visual Art (Honours): Lily Ahlefeldt, Caroline Georgiou, Irene Kontakos, Roger Myles, Lisa Nguyen, Jess Nolan, Courtney Rodgers and Jess Taylor. Bachelor of Visual Art: Cassie Broad, Nicholas Hanisch, Dominique Keeley, Bonnie Lawson, Monika Morgenstern, Margaret Moy, Cheryl Nolan, Paul Perry, Carol Robinson, Caroline Taylor, Robyn Tonkin, Ash Tower, Rosemary White and Ruth Wilson. Preview the works online here<http://www.acsa.sa.edu.au/the-gallery/exhibitions/uncharted-territory/> Watch video interviews with our graduates and staff by Sasha Grbich at http://vimeo.com/centralschool

1 0