- Koha - lists.katipo.co.nz

Not able to edit Marc21 subfields
by Amarnauth Seegobin 13 Aug '07

13 Aug '07

Hello, Please give me your advice: Setting up Koha parameters: When i go to parameters and click biblio framework and after adding a framework, i then click on marc structure. The tag page showed up and after clicking on a subfields link, i have the subfield page. The problem is not being able to edit the subfield (by clicking on the folder icon at the bottom). We got the server error message. The error log shows the following: can't opendir c:\\usr\\koha228\\intranet/value_builder: No such file or directory at C:/usr/koha228/intranet/cgi-bin/koha/admin/marc_subfields_structure.pl line 143., referer: http://intranet/cgi-bin/koha/admin/marctagstructure.pl Thanks for patience. --------------------------------- Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.

2 1

Newbie - first question
by Jorge de Cardenas 12 Aug '07

12 Aug '07

I have alot of questions but I'll start with this: Are all errors reported in koha-error_log actually errors? I have a fresh install of Koha 2.2.9 on a debian linux box, with MySql5.0. I cannot add books. The first error in the process seems to be a sql query but I have manually performed the the query in MySql and it does not produce an error just zero items selected. In the process of adding a book this is the first error after Catalogue>Add Biblio>Enter ISBN> *******start******* [Sat Aug 11 17:08:27 2007] [error] [client 192.168.0.3] Q : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_subfield_table as m1 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.subfieldvalue like '0596000480%' and concat(m1.tag,m1.subfieldcode) in ('020a')) order by biblio.title ASC at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 277., referer: http://192.168.0.4:8080/cgi-bin/koha/acqui.simple/addbooks.pl Note: These tables get populated: biblio bilioitems bibliosutitle additionalauthors bibliosubject catalogueentry these are empty: items marc_word marc_biblio marc_subfield_table Hope you can help as to where to start looking. Jorge

1 0

Koha installation: which hardware and OS?
by Roger Hart 12 Aug '07

12 Aug '07

I'd like recommendations on which hardware and OS to choose to most easily, reliably, and economically run Koha, and only Koha? I've been doing some volunteer work installing Koha at my daughter's school. I've installed Koha on my old Apple PowerBook G4, and gotten it to work just fine, but it is much too slow. We also have an older Dell Server. We have tried to install Koha on Ubuntu, CentOS, Windows 2000 Server, and each time run into considerable problems. So many problems, in fact, that I have decided it might be easiest just to purchase and donate a machine to the school. We don't need a very powerful server: our library is small, about 10,000 books; we have about 35 students. So I would very much appreciate it if someone would let me know what hardware and OS Koha "expects", that is: (1) what hardware will give us the least trouble in setting up Koha, and please be as specific as possible, such as a Dell [model, CPU, etc.]; and (2) what OS running on that hardware will require the least troubleshooting, etc., to get everything running, and again please be specific as possible, such as Ubuntu N.n, etc.? In sum, what is the most standard hardware and OS configuration for Koha? We really need to get this up and running as soon as possible. We have spent so much time with installing different versions of perl modules, yaz, etc., or finding drivers for various hardware, etc. What we really need now is a machine and OS that will allow us a clean install without a lot of debugging and troubleshooting. Thanks very much, Roger Hart Asst. Professor in History, University of Texas at Austin -- View this message in context: http://www.nabble.com/Koha-installation%3A-which-hardware-and-OS--tf4250042… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

MARC links
by Grant Johnson 11 Aug '07

11 Aug '07

What are the defaults for: biblio/biblionumber and biblioitems/biblioitemnumber biblioitems/biblionumber I have changed values to 050 and 090 and am unable to run misc/rebuildnonmarc.pl and am stupid!!!!! I can't remember what it was initially. Back to default and rebuild would be fine! Thanks in advance. -- F. Grant Johnson Systems Coordinator Robertson Library, UPEI fgjohnson(a)upei.ca

2 1

Compatible Koha and LAMP versions?
by Linda R 10 Aug '07

10 Aug '07

Hello, I think my question is similar to the last person's. Which versions of Koha and its main components (OS, MySQL, Apache, Perl) work well together? I am trying to decide which version of Koha and Fedora Core or Debian to install. It seems like the version of the OS determines which versions of MySQL, Apache, and Perl to use, because running something like "yum update" on Fedora Core updates to the latest current versions. But I still don't know which version of Koha to use. Perhaps the latest versions of Koha will not work with old versions of Fedora Core? Thanks, Linda --------------------------------- Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.

1 0

Apache2 Fu
by exaurdon 09 Aug '07

09 Aug '07

I've tried everything with Apache2 on Deb and I can't figure out how to get koha to load. koha-httpd and apache2.conf enclosed. http://www.nabble.com/file/p12065240/apache2.conf apache2.conf http://www.nabble.com/file/p12065240/koha-httpd.conf koha-httpd.conf I've tried everything I can think of. Apache refuses to do anything with 8080 or 8000 Matt -- View this message in context: http://www.nabble.com/Apache2-Fu-tf4240211.html#a12065240 Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 6

Another installation question.
by Roger Horne 09 Aug '07

09 Aug '07

The old saying is "do not look a gift-horse in the teeth" and it plainly applies in relation to PD software. So I put forward the next bit with some diffidence. I installed Koha some years ago but for various reasons (including the need to add all the books manually, there being no electronic catalogue of any sort) stopped using it. The computer then died and I could not be bothered to search out the relevant backups but decided to reinstall it on a new machine. So I downloaded koha-s.9.9.tar.gz and unpacked it and started looking at the files. I was somewhat startled to find that most of the text files were totally out of date: The most recent entry in the changelog is 2004-11-17 INSTALL claims that it is for release 2.0.1 (28 August 2004) News lists the changes made since v 1.1.1 (and not much later) README is for v 2.0.2.17 Nov 2004 TODO sets out the changes to be made in the future, culminating with v.1.5.0 INSTALL suggests that: The perl modules required are: DBI, Date::Manip, DBD::mysql, HTML::Template, Digest::MD5, MARC::Record, Mail::Sendmail, Event Optionally, we can also use: Net::Z3950 However install.pm suggests a rather larger number of modules and substitutes ZOOM for Net::Z3950 (as does http://search.cpan.org/src/MIRK/Net-Z3950-ZOOM-1.19/README ) It was presumably intended that the docs directory would contain docs about installation and running Koha. but it is empty. Surely there should at least be a link to kohadocs.org (especially since the docs on that site make it plain that Koha must be configured manually before being run) ? This next bit is more in the way of a bug report/question and concerns installation. I should say first that I am aware that Koha does not claim to be compatible with MySQL 5 although the latest version says that it does work partially. (It is unlikely that any distribution other than Debian now includes MySQL 4.) I tried installing - I have not got as fae as trying to run it - on a computer using Suse 10.2 and MySQL 5. I ran installer.pl and it produced the usual list of missing modules. There were, however, at least two modules which were not followed by the CPAN software and caused a listed module to fail to install. (I am afraid the bit of paper I wrote the names on has disappeared ...) But more importantly the installer does not refer to yaz without which ZOOM will not install. I use Suse but the machine in question did not have yaz installed. So I added it using Yast (and a remote repository). But, as someone else has reported, the version installed was too old. So I had to install from the indexdata.dk site. (The simplest way I found was go to "source" for yaz, download, unpack, cd in a shell to the directory, su, then ./configure, make, make install. This installed yaz v3: whether that will work with Koha is not clear from the documents.) Once everything was installed I re-ran installer.pm . It requires to be run as root (since it requires access to /etc). So I su'ed to root and continued. Several times. Because if you accidentally give the wrong answer to a question as the result of a typo there is no way of correcting it (even before pressing enter). So you have to stop the installer and start again. (I seem to remember mentioning this several years ago and being told that it would be corrected.) Eventually everything worked until I got to the Database stage. Under Database Name I entered Chamslib (instead of Koha). Under DATABASE HOST I accepted the default of localhost. The next entry is Database User. I tried first using my name (lowercase, no spaces). I then gave a pw at Database Password. (And later I entered the correct MySQL root password.) The installer crashed. It reported (approx wording) that it could not use roger @ localhost with password YES. It had, however, created the database which I had called Chamslib. I had to log onto MySQL as root and delete it before I could try again. So I tried again, this time accepting the default database user of kohaadmin. The result was the same: crash, and similar error message. So I deleted the Chamslib db again and tried again. This time I used as Database user root and as database pw the MySQL root password which, unsurprisingly, worked. Since the installer was able to create the db Chamslib, presumably it was correctly using each time MySQL -u root and the correct passord to do so. But presumably it was not granting the relevant permissions to the koha database user and so not uploading the relevant tables. (As you can see, my knowledge of MySQL is pretty slim.) When I used root as the the Database User and the MySQL pw as the Database Password I still got some error messages (including uninitialized values). In particular under creating database I got: DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at scripts/updater/updatedatabase line 1717. DBD::mysql::st execute failed: Invalid default value for 'id' at scripts/updater/updatedatabase line 1717. I have tried installation twice, once on each of two more or less identical computers, each running Suse 10.2, with the same results. I am now about to try on a different machine running Debian Sarge. Roger -- Roger Horne

1 1

Newbie install questions
by Linda R 09 Aug '07

09 Aug '07

Hi, I'm trying to install Koha on FC3, following Joshua Ferraro's 1/9/2005 document, "Installing Koha 2.2 on Fedora Core (1, 2, 3)." I had some problems installing yaz. At first it installed fine for fc3/yaz-2.1.8-1. But then, on "perl -MCPAN -e 'install Net::Z3950'", it said, "ZOOM-Perl requires at least version 2.1.50 of Yaz but you only have version 2.1.8". So I see in the YAZ repository that 2.1.50 is in the FC5 directory. Well, I think this won't work well with FC3, but I try it any way. So, I install YAZ, this time 2.1.50-1(of FC5), but now it says "Failed dependencies: libc.so.6, libcrypto.so.6, libssl.so.6. So a nice young man in the koha IRC chat suggests downloading the yaz-2.1.50-1 tar file and installing it by configure and make. So eventually that worked, and I was able to install the remaining Perl modules. MySQL was already installed. Now I'm about to try starting MySQL. If I have any more problems, do you think it would be best to upgrade to FC4, or 5, or 6, or 7? Should I use the Which version of Fedora Core are most people using? What is the latest FC that works with Koha? Would anyone strongly recommend changing to Debian, provided I could keep the current /home partition? Thank you, Linda --------------------------------- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.

1 0

koha opac-detail.pl not showing the amazon content
by Lewis Satini 09 Aug '07

09 Aug '07

I do the search and on the opac-searchresults.pl it show the cover book from the amazon, but when i click to go for detail it doesn't show and the image said no image and the data is not correctly show i need help ASAP thanks _________________________________________________________________ Find a local pizza place, movie theater, and more….then map the best route! http://maps.live.com/default.aspx?v=2&ss=yp.bars~yp.pizza~yp.movie%20theate…

1 0

Marc tag structure administration - Newbie question
by José Lagoas 08 Aug '07

08 Aug '07

Can anybody tell me, please, the difference between "Search also" and "link to field" in Edit MARC subfields constraints for Biblio framework(MARC structure)? Thanks in advance. José Lagoas

1 0