- Koha - lists.katipo.co.nz

Database update error on upgrade from 3.2.6 to 3.2.7 using debian package
by John Seymour 27 Apr '11

27 Apr '11

Hi When I upgraded our Koha install from 3.2.6 to 3.2.7. I had the following error messages are they important? DBD::mysql::db do failed: Can't DROP 'itemsstocknumberidx'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4020. DBD::mysql::db do failed: Duplicate key name 'itemstocknumberidx' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4021. yours John

2 1

Remove koha and mysql to try again
by padraic 27 Apr '11

27 Apr '11

Hi folks, I am currently trying to install koha on my ubuntu computer at home. i was following the instructions over on http://wiki.koha-community.org/wiki/Koha_on_Ubuntu but have run into problems where I cannot access mysql. I'm not 100% sure but reckon that my problem is probably that I previously configured accounts on mysql for other applications and no longer have the details. I would love to just clear mysql and the koha installation I already have. Would deleting the koha folder in my home directory and apt-get uninstalling lamp server remove everything or cause more problems. I guess I could do a fresh install of Ubuntu but would prefer not to. Any help would be greatly appreciated! -- View this message in context: http://koha.1045719.n5.nabble.com/Remove-koha-and-mysql-to-try-again-tp4340… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Unable to see patron address change
by sheldon_tappin 26 Apr '11

26 Apr '11

Hi All, We are currently using Koha 3.0.6. We're carrying out final tests on the system and observed that a patron change their address information from the OPAC interface but we cannot see the changes in the Staff Interface. Can you please tell me if this is a problem in Koha 3.0.6. We do plan on upgrading to Koha 3.2.x. If this is a problem in koha 3.0.6 please tell me if this problem is corrected in koha 3.2.x. Sheldon -- View this message in context: http://koha.1045719.n5.nabble.com/Unable-to-see-patron-address-change-tp434… Sent from the Koha - Discuss mailing list archive at Nabble.com.

3 2

Fwd: Re: Index build - even without zebra?
by Tom Hanstra 26 Apr '11

26 Apr '11

Chris or others, Did I miss something in the install? I tried adding things to the environment as suggested, but where things are choking are with the perl include locations: ./bin/migration_tools/rebuild_nozebra.pl Can't locate C4/Context.pm in @INC (@INC contains: /shared/perl/5.10.1/lib/5.10.1/x86_64-linux-thread-multi /shared/perl/5.10.1/lib/5.10.1 /shared/perl/5.10.1/lib/site_perl/5.10.1/x86_64-linux-thread-multi /shared/perl/5.10.1/lib/site_perl/5.10.1 .) at ./bin/migration_tools/rebuild_nozebra.pl line 3. BEGIN failed--compilation aborted at ./bin/migration_tools/rebuild_nozebra.pl line 3. I can see that it is not looking in /shared/koha/soft/lib for the proper location for C4, but how do I best update the software so that the @INC path is properly set up? Thanks, Tom On 04/25/2011 08:38 PM, Chris Cormack wrote: > > > On 26 Apr 2011 10:05, "Tom Hanstra" <tom(a)nd.edu <mailto:tom@nd.edu>> > wrote: > > > > What exactly are the C4 modules? Both rebuild_nozebra.pl > <http://rebuild_nozebra.pl> and > > rebuild_zebra.pl <http://rebuild_zebra.pl> call for C4 modules, so > it seems that neither will work > > until I resolve these perl modules. > > > > I'll work on my Zebra setup, but it seems like I also have to resolve > > these errors. > > The C4 modules are what everything in Koha uses, so they will be > there. If you are getting an error it will be because you haven't > defined the path to the modules on the command line. > > You can do this lots of ways, the INSTALL file lists a few, but its > probably easiest to run > export PERL5LIB=/path/to/where/the/C4/dir > export KOHA_CONF=/path/to/ > > Check your koha-httpd.conf for the values you need > > Chris > > > > Thanks, > > Tom > > > > On 04/25/2011 05:25 PM, Galen Charlton wrote: > > > Hi, > > > > > > On Apr 25, 2011, at 3:57 PM, Tom Hanstra wrote: > > > > > >> OK, I have loaded some data from another database into my local > Koha. I don't have Zebra up and going yet, but I thought I could get > a jump start by changing the parameters so that it would not use Zebra. > > >> > > > NoZebra mode is deprecated in 3.4.0 and is not necessarily > well-supported before then. > > > > > > > > >> But, there must be some other data rebuild or step I've missed. > I know that there are records out there because there are some > pre-created lists which produce results. But every search I do > results in no records found, including a basic wildcard search. > > >> > > >> No Result found! > > >> > > >> No results match your search for “kw,wrdl: * ” > > >> > > > Maybe run rebuild_nozebra.pl <http://rebuild_nozebra.pl>? But > ultimately, the real answer is to go ahead and finish getting Zebra up > and running. > > > > > > Regards, > > > > > > Galen > > > -- > > > Galen Charlton > > > VP, Data Services > > > Equinox Software, Inc. / Your Library's Guide to Open Source > > > email: gmc(a)esilibrary.com <mailto:gmc@esilibrary.com> > > > direct: +1 352-215-7548 > > > skype: gmcharlt > > > web: http://www.esilibrary.com/ > > > > > > > > > > -- > > > > > > > ----------------------------------------------------------------------------- > > Tom Hanstra Systems Administrator > > Hesburgh Libraries of Notre Dame Phone: (574)631-4686 > > 213 Hesburgh Library Email: tom(a)nd.edu > <mailto:tom@nd.edu> > > Notre Dame, IN 46556 > > > > Any idiot can face a crisis, it is this day-to-day living that wears > > you out. > > Anton Chekhov > > > ----------------------------------------------------------------------------- > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > > http://lists.katipo.co.nz/mailman/listinfo/koha > -- ----------------------------------------------------------------------------- Tom Hanstra Systems Administrator Hesburgh Libraries of Notre Dame Phone: (574)631-4686 213 Hesburgh Library Email:tom@nd.edu Notre Dame, IN 46556 Any idiot can face a crisis, it is this day-to-day living that wears you out. Anton Chekhov ----------------------------------------------------------------------------- -- ----------------------------------------------------------------------------- Tom Hanstra Systems Administrator Hesburgh Libraries of Notre Dame Phone: (574)631-4686 213 Hesburgh Library Email: tom(a)nd.edu Notre Dame, IN 46556 Any idiot can face a crisis, it is this day-to-day living that wears you out. Anton Chekhov -----------------------------------------------------------------------------

2 3

Block checkout if overdues
by dschust＠tx.rr.com 26 Apr '11

26 Apr '11

We are using the sco - pac self checkout - and I have been asked if there is a way to BLOCK checkouts to patrons who have overdue books - but do NOT have the maximum number out yet. -- David Schuster Library Technology Coordinator Plano ISD

1 0

About authorities list
by Mohamed Megahed 26 Apr '11

26 Apr '11

Hi all I had installed koha 3.2 on ubuntu 10 and upload my data file with stage marc record and all ok and search anything i find it, my question how to make authorities to this records. thnks MOHAMED MEGAHED Librarian & Technical support Misr International University Library Tel : +2 010 - 22 – 97 - 962 Tel : +2 010 - 49 – 49 - 096

1 0

Index build - even without zebra?
by Tom Hanstra 26 Apr '11

26 Apr '11

OK, I have loaded some data from another database into my local Koha. I don't have Zebra up and going yet, but I thought I could get a jump start by changing the parameters so that it would not use Zebra. But, there must be some other data rebuild or step I've missed. I know that there are records out there because there are some pre-created lists which produce results. But every search I do results in no records found, including a basic wildcard search. *No Result found!* No results match your search for "kw,wrdl: * " What might still be missing? Thanks, Tom -- ----------------------------------------------------------------------------- Tom Hanstra Systems Administrator Hesburgh Libraries of Notre Dame Phone: (574)631-4686 213 Hesburgh Library Email: tom(a)nd.edu Notre Dame, IN 46556 Any idiot can face a crisis, it is this day-to-day living that wears you out. Anton Chekhov -----------------------------------------------------------------------------

3 3

reports function
by Caitlin McGurk 25 Apr '11

25 Apr '11

When commanding a report to run, Koha asks me to "Enter parameters for report Cataloged Books:", with a bar below it that says "itype:" and has an empty scroll bar with no choices to pick from. When I click run, nothing happens. Anyone know what this means or how to fix it? Also, is there a way to export reports in any format other than a .csv or .tab? Neither of these are viewable on my machine. Thanks! Caitlin McGurk -- Caitlin McGurk Librarian The Schulz Library The Center for Cartoon Studies McGurk(a)cartoonstudies.org

2 3

Installation/upgrade questions
by Tom Hanstra 25 Apr '11

25 Apr '11

I am attempting to properly upgrade from Koha 3.2.2 to Koha 3.2.6 on RedHat 5.5. For internal reasons, I have installed Koha on a common SAN disk in the directory /shared/koha/soft with a shared perl version on /shared/perl. All modules were up to date for this perl version. However, when I install and start Koha, I'm getting errors which look as if the incorrect version of Perl is being used. Koha starts and is accessible, but when I try to update the system preferences, I receive an error: Internal Server Error, please reload the page and see the following errors in the koha-error.log file: [Mon Apr 25 12:41:31 2011] [error] [client 10.41.63.254] [Mon Apr 25 12:41:31 2011] systempreferences: Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/Net/Z3950/ZOOM/ZOOM.so' for module Net::Z3950::ZOOM: libyaz.so.3: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/XSLoader.pm line 70., referer: http://koha.library.nd.edu:8080/cgi-bin/koha/admin/preferences.pl?tab=logs [Mon Apr 25 12:41:31 2011] [error] [client 10.41.63.254] [Mon Apr 25 12:41:31 2011] systempreferences: at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Net/Z3950/ZOOM.pm line 10, referer: http://koha.library.nd.edu:8080/cgi-bin/koha/admin/preferences.pl?tab=logs [Mon Apr 25 12:41:31 2011] [error] [client 10.41.63.254] [Mon Apr 25 12:41:31 2011] systempreferences: Compilation failed in require at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/ZOOM.pm line 4., referer: http://koha.library.nd.edu:8080/cgi-bin/koha/admin/preferences.pl?tab=logs [Mon Apr 25 12:41:31 2011] [error] [client 10.41.63.254] [Mon Apr 25 12:41:31 2011] systempreferences: BEGIN failed--compilation aborted at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/ZOOM.pm line 4., referer: http://koha.library.nd.edu:8080/cgi-bin/koha/admin/preferences.pl?tab=logs [Mon Apr 25 12:41:31 2011] [error] [client 10.41.63.254] [Mon Apr 25 12:41:31 2011] systempreferences: Compilation failed in require at /shared/koha/soft/lib/C4/Context.pm line 85., referer: http://koha.library.nd.edu:8080/cgi-bin/koha/admin/preferences.pl?tab=logs [Mon Apr 25 12:41:31 2011] [error] [client 10.41.63.254] [Mon Apr 25 12:41:31 2011] systempreferences: BEGIN failed--compilation aborted at /shared/koha/soft/lib/C4/Context.pm line 85., referer: http://koha.library.nd.edu:8080/cgi-bin/koha/admin/preferences.pl?tab=logs [Mon Apr 25 12:41:31 2011] [error] [client 10.41.63.254] [Mon Apr 25 12:41:31 2011] systempreferences: Compilation failed in require at /shared/koha/soft/intranet/cgi-bin/svc/config/systempreferences line 24., referer: http://koha.library.nd.edu:8080/cgi-bin/koha/admin/preferences.pl?tab=logs [Mon Apr 25 12:41:31 2011] [error] [client 10.41.63.254] [Mon Apr 25 12:41:31 2011] systempreferences: BEGIN failed--compilation aborted at /shared/koha/soft/intranet/cgi-bin/svc/config/systempreferences line 24., referer: http://koha.library.nd.edu:8080/cgi-bin/koha/admin/preferences.pl?tab=logs What am I missing? Why is the system version of perl being called in some cases? And what are the C4 errors which I am seeing? Note that I cannot verify that this had been working with the 3.2.2 version since I upgraded without really doing much testing. It could be a base installation problem from the beginning. Thanks, Tom -- ----------------------------------------------------------------------------- Tom Hanstra Systems Administrator Hesburgh Libraries of Notre Dame Phone: (574)631-4686 213 Hesburgh Library Email: tom(a)nd.edu Notre Dame, IN 46556 Any idiot can face a crisis, it is this day-to-day living that wears you out. Anton Chekhov -----------------------------------------------------------------------------

2 2

Error 404
by Vimal Kumar 25 Apr '11

25 Apr '11

Dear Friends, My Koha version 3.06 shown an error seaarching a particular record(Acc. No: G4818), it is coming this error, what is the problem * An Error has Occurred! Error 404* * * This error means that the link was broken and that the page doesn't exist * To report this error, you can email the Koha Administrator. * Use top menu bar to navigate to another part of Koha.* Thanks, -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: http://www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

6 5