- Koha - lists.katipo.co.nz

Status of item = Checked out ...and waiting?
by Chad Roseburg 03 Jan '14

03 Jan '14

Wondering what scenario would result in the following: * Patron places hold on item * Item arrives at branch ...placed on holds shelf * Patron arrives at branch and checks out item Item status for the last week appears as follows in the staff interface: "Checked out to JOE D PATRON : due 01/04/2014 23:59 Waiting for JOE D PATRON at RANDOM COMMUNITY LIBRARY since 12/18/2013" It also shows on the branch's expired holds list. Ideas? Thank you ~ -- Chad Roseburg Automation Dept. North Central Regional Library

1 0

Re: [Koha] Importing Koha Database to a new install
by Robin Sheat 03 Jan '14

03 Jan '14

Please reply to the list, so that other people with the same problem in the future can see information on it. Phillip Ponchot schreef op do 02-01-2014 om 15:48 [-0800]: > After I install Koha and do everything mentioned before importing my > database, do I log into the staff koha web interface and setup the > database like set language to en, choose marc21 records etc. No, I always start from a clean database and import my database directly into there. > all one line: > (I assume this is clearing the database) > mysql -u koha_library -p xxxxxxxxxxxxxx -Nse 'show tables' > koha_library | while read table; do mysql -u koha_library > -p xxxxxxxxxxxxxxxxxxxx -e "drop table $table" koha_library ; done That will go some way to clearing the database, but I would expect you get a lot of errors about foreign relationships, if so, run it multiple times until you get no errors. Best just start from an empty database though. > (the data imports just fine) > 5. sudo koha-mysql library < backedup.sql This will abort if there is any error, so that it doesn't is a good sign. However, you say that it imports just fine. How do you know? That there are no errors isn't good enough. Did you look in the tables and count the records to make sure the right number are there? Did you have a look in backedup.sql to make sure that it's got the right data in it? Did you compare some things between them. I think that there is something going wrong around here. > (seems to work but does this extremely fast, I figured it would take > longer) > 6. sudo koha-upgrade-schema library It should _definitely_ take some time. I think the fact that it's not is the primary symptom of the issue. Is there any output at all? There should be heaps of it, stuff like "Upgrade to version 3.12.34 done (Add widget to foobar)" type things. At this point, what I think is happening is that you are adding sample data into the database, and when you think you are importing your real data over the top of it, you actually aren't. I don't know where it's going, your steps look correct, but I suspect that the reason that it's going fast is because it's looking at the database and saying "oh, already at the latest version, let's do nothing" because you have your sample data still there rather than real data. > (if I run this I get a complaint that ean and agerestriction is not in > biblioitems. If I create these tables in biblioitems, it takes about > an hour so upgrade all 37400 records. > 7. sudo koha-upgrade-to-3.4 library Yeah, it'll be expecting a more modern schema. For 37,400 records, I would consider an hour to be roughly right. It's been a long while since I've had to run that though. ean and agerestriction came in in 3.09, so that they're not there suggests that something before this step is definitely wrong. > (during the upgrade zebra rebuild is run, but I've run it just in case > since it is in the instructions) > 8. ran zebra rebuild - koha-rebuild-zebra -v -f library My rule of thumb is to run this after anything significant has happened. It doesn't hurt, and is the first port of call when something weird is happening. > I try to login to the web interface as the old staff user (in the > database) but it does not work. Don't say "doesn't work." What actually happens? What I would expect, given the apparent failure of step 6, is that it redirects you do the web installer and says "upgrading to version 3.12.whatever" or something along those lines. If it says that, what does it actually say? If it doesn't say that, what does it actually say? Details are vital here. I would fully expect that login to not work in this case though, you should be using the database username/password for the schema upgrade. > I log into the web interface with the koha_library account and I can > get into Koha but there is just mylibrary and several other samples. So, are these the samples you created when you installed it the first time? > After I install Koha, do I immediate login as Koha_library with the > supplied password do the setup (set english, set marc21) etc. No. > After I import data, fix the schema, upgrade to 3.4 and rebuild zebra, > how to I setup the web interface to see the my library's data. You don't, it just works. Provide the result of doing all this with the "script" command, there may be clues in there. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF

1 0

Re: [Koha] Importing Koha Database to a new install
by David Nind 02 Jan '14

02 Jan '14

Hi Phillip. I've not upgraded from a pre-3.04 version of Koha before, so can only go on what is on the wiki/install instructions. Someone else on the list may be able to confirm, or not, whether this is the correct way.. You would do this after you have loaded the old database into your new server i.e. you've setup the new version and it is working, delete the database (or rename), load in the database dump from your old version. I think the script is run after you have accessed the administration site (the intranet) for the first time, as it needs to run some other database updates. The instructions mentioned are here: http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=INSTALL;hb=HEAD It also looks like there is a handy script to do this for you when you have installed by packages - *koha-upgrade-to-3.4* . See: http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Upgrade_Instr… http://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_package… On 23 December 2013 09:03, Phillip Ponchot <pponchot(a)live.com> wrote: > David, > > I'm new to Koha and to the Koha site so I can't seem to find the > instructions from 3.0 to 3.4. My question would be how I would do these > steps. > > One question I have is should I load the old database into the new version > and then run the steps in 101 and 102 or do I do this before I export the > database? > > Could you send me the link to the instructions that you found below? > > ------------------------------ > Date: Mon, 23 Dec 2013 07:58:35 +1300 > Subject: Re: [Koha] Importing Koha Database to a new install > From: david.nind(a)gmail.com > To: pponchot(a)live.com > CC: koha(a)lists.katipo.co.nz > > > Hi Phillip. > > I think I've figured out what's up. I managed to determine that the Koha > database is from Koha version 3.00.00.107 and the version that I've > installed by default is 3.14.00.000. This means that the database is > extremely out of date and can not be "imported" without transforming some > of the data. > > > From the manual installation instructions when updating from a 3.0-3.3 to > version 3.4 or later: > > 96 Koha 3.4.x or later no longer stores items in biblio records. > 97 If you are upgrading from an older version ou will need to do the > 98 following two steps, they can take a long time (several hours) to > 99 complete for large databases > 100 > 101 misc/maintenance/remove_items_from_biblioitems.pl --run > 102 misc/migration_tools/rebuild_zebra.pl -b -r > > http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=INSTALL;hb=HEAD > > Also see 8-): > http://lists.katipo.co.nz/pipermail/koha/2013-December/038228.html > -- David Nind | david.nind(a)gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098

4 4

Does anybody know?
by Phillip Ponchot 02 Jan '14

02 Jan '14

I've built a new Koha 3.12 Ubuntu Server and have transferred the old Koha 3.0 database to the new Koha 3.12 server. Since the database is so old, I've tried to upgrade it to 3.4 after I've used mysql to import the database into Koha 3.12 so that it will be recognized by the new Koha 3.12 server. I've run the "upgrade-to-Koha-3.4" command to try to bring the 3.0 Koha database to the 3.4 level but all I get is pages of "mysql failed - fetch () without execute() at /usr/share/koha/lib/C4/context.pm line 1030". I can't log in as the a staff user of the old database and if I use the "signin" given by the new install, Koha 3.12 just wants to recreate the koha_library database and wipe out all the information that I've imported. I've read countless blogs, messages etc but nothing suggested or tried has worked. Does any have any idea how to move an old database to such a new koha 3.12 install? I've tried countless directions but nothing is working! Do I need to hire someone to "transform" the old database so it will work on the new server? Any help is appreciated. Cheers. Phillip

2 1

Koha Community Newsletter: December 2013
by Chad Roseburg 02 Jan '14

02 Jan '14

Fellow Koha users: The Koha Community Newsletter for December 2013 is here: http://koha-community.org/koha-community-newsletter-december-2013/ About the [ new ] editors: ------- Chad Roseburg is Systems Librarian at North Central Regional Library. NCRL migrated to Koha from SirsiDynix in 2011. Joanne Dillon is Digital Services Lead for the Horowhenua Library Trust. -------- Much thanks to Daniel Grobani for his help and advice while we were getting started with the newsletter. Your previous work as editor is an excellent template we hope to maintain. -- Chad Roseburg Automation Dept. North Central Regional Library

1 0

searching
by rocky bang 02 Jan '14

02 Jan '14

Hi, I am using koha 3.08 and in OPAC the masthead file contains the drop down box for the searches with option like keyword,title,author,accession number. But while searching with keyword such as "a" fetches results from all the fields like publication,author,title etc. I want the keyword should fetch result only from title,subject or note field not from all the fields. How should i do this. Thanks in advance.

2 1

Regarding Error - make: *** [blib/ZEBRA_CONF_DIR/etc/passwd] Error 2 while installing KOHA
by Nazneen 01 Jan '14

01 Jan '14

Hi, I did read the previous post around this error. Tried the solution given too, but it did not work. When I run perl Makefile.PL, all the steps are completed successfully. <http://koha.1045719.n5.nabble.com/file/n5782635/Screen_Shot_2014-01-02_at_1…> All the other directories are created successfully, like ZEBRA_DATA_DIR, KOHA_CONF_DIR, but ZEBRA_CONF_DIR does not get created. Therefore when I run make, I get the above error. The command make clean did not work. Please let me know if I am missing some steps. Help will be highly appreciated. Thanks in advance. -- View this message in context: http://koha.1045719.n5.nabble.com/Regarding-Error-make-blib-ZEBRA-CONF-DIR-… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Upgrade from 3.10 to 3.14x
by Karam Qubsi 01 Jan '14

01 Jan '14

Hi , I have 2 servers: server *A* and server *B *. server A has koha 3.10 installation ( packages ) server B has koha 3.14 installation (packages ) . I take the backup files from (/var/spool/koha/library ) from server A . and restore them on server B . after that I get an error message : ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'koha_library'@ '%' I make the upgrade schema after that. koha-upgrade-schema library . no errors . and Koha is working, it seems that there is no problem . but I don't know what is that error message means ? please let me know if I miss something . or that is normal . Many Thanks :) . -- *Karam Qubsi*

2 1

sms configure with koha
by vinod kumar 31 Dec '13

31 Dec '13

Hi all how to enable sms service with koha please suggest me

3 3

Re: [Koha] koha search
by Koustubha Kale 31 Dec '13

31 Dec '13

Hi The question has a better chance of getting proper answer if its directed to the Koha mailing list. Please subscribe to the lists at http://koha-community.org/support/koha-mailing-lists/ I have copied my reply to the list. All the best.. Regards, Koustubha Kale On Tue, Dec 31, 2013 at 12:19 PM, rocky bang <rockybang0(a)gmail.com> wrote: > Hii, > > I am using koha 3.8 and doing research on koha searching using zebra for > my library. > > Recently I got requirement to customize the koha keyword and title search > so that the results should be fetch from customize fields. > i.e title search should fetch result from title only. > > From the study i nte down that there are three main files which are > responsible for searching > bib1.att > ccl.properties > record.abs > > What changes should i do to these files to be able to customize according > to requirement. >

1 0