- Koha - lists.katipo.co.nz

A problem inserting
by Emiliano Marmonti 28 Nov '02

28 Nov '02

Hi everybody, We´re testing the use of Koha over Solaris 8. After re-installing Perl and other modules I think it´s working. Now we have a problem when trying to insert a new branch. Everything looks well but no new branch is inserted. When I see the Koha_error log it says the following: DBD::mysql::st execute failed: No Database Selected at /var/apache/cgi- bin/koha/admin/branches.pl line 176, <KC> line 4. DBD::mysql::st execute failed: No Database Selected at /var/apache/cgi- bin/koha/admin/branches.pl line 36, <KC> line 4. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/apache/cgi-bin/koha/admin/branches.pl line 39, <KC> line 4. DBD::mysql::st execute failed: No Database Selected at /var/apache/cgi- bin/koha/admin/branches.pl line 36, <KC> line 4. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/apache/cgi-bin/koha/admin/branches.pl line 39, <KC> line 4. DBD::mysql::st execute failed: No Database Selected at /var/apache/cgi- bin/koha/admin/branches.pl line 176, <KC> line 4. DBD::mysql::st execute failed: No Database Selected at /var/apache/cgi- bin/koha/admin/branches.pl line 36, <KC> line 4. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/apache/cgi-bin/koha/admin/branches.pl line 39, <KC> line 4. It looks like no Database is selected but in /etc/koha.conf is correctly specified. Also I´ve tested that the user could insert, select, etc via mysql command line... Any suggestions? Thanks a lot Emiliano Marmonti. ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/

2 2

Z39.50 search tool
by Silvia Hernandez M. 27 Nov '02

27 Nov '02

Hi, I hope you can help me, I have installed koha 1.2.2 from the installer.pl included with the software. Then, I started with the test-drive sited in the page http://opac.mysite:8080/cgi-bin/koha/acqui.simple/addbooks.pl I entered a ISBN number and then when I followed the link Z39.50 search tool, and I was taken to the page http://opac.mysite:8080/cgi-bin/koha/acqui.simple/marcimport.pl?z3950queue=… 50&test=testvalue&rand=45846498.4121782&query=9688809055&type=isbn&S-1=on&manualz3950 server=otherserver%3A210%2FDATABASE where I got the following error: No Z39.50 search daemon running: no file /var/log/koha/processz3950queue.pid. There is a launcher for the Z39.50 client daemon in your intranet installation directory under ./scripts/z3950daemon/z3950-daemon-launch.sh. This script should be run as root, and it will start up the program running with the privileges of your apache user. Ideally, this script should be started from a system init directory so that is running after the machine starts up. How can I launch the z3950-daemon? and what should I do to make the script starts from the system init directory each time my pc starts up? Silvia Hernandez-M. INAOE, Mexico.

2 1

Re: [Koha] Can't modify records
by Jim Thomas 27 Nov '02

27 Nov '02

> > We are seeing two problems with the box. First, the koha web pages take > > a loooong time to load. I suspect this is a DNS problem, but I'm not > > sure. I'm usre now. I removed bind from the system and made it just use our regular DNS server. The slowness problem went away. > > > > The second problem is enough to make my wife question the feasibility of > > using Koha - after she enters a new book into the catalog, she cannot > > modify it to correct any typos. She finds the modify page OK, but the > > machine just ignores the modify button. The cursor doesn't change when > > she positions it over the button - it's as if shes clicking a > > non-button. Rachel Hamilton-Williams wrote: > > Hi Jim > > As always it's a bit tricky to figure this out without being able to see it - > but is there a chance if we can't have access to the box that your wife could > do some screen shots so we know were she "is" when it stops working? Here are the steps we can take to see the problem: Bring up the admin page (/usr/local/koha/intranet/htdocs) Search for a book in the "Catalog" box by typing in a keyword and pressing enter. Click on a book title. That brings me to a page that has non-functional Modify and Delete buttons: /usr/local/koha/intranet/cgi-bin/koha/detail.pl? I have omitted the search criteria following the "detail.pl?" because I doubt that it's relevant. > > I'm assuming she is using simple acquisitions to get stuff into the system? I dunno. How could I tell? -- Jim Thomas Principal Applications Engineer Bittware, Inc jthomas(a)bittware.com http://www.bittware.com (703) 779-7770 There's a fine line between clever and stupid

4 5

Some kind of Table Problem?
by Veronica Lencinas 26 Nov '02

26 Nov '02

Hello, thank you for the help with Acquisitions. My systems parameters are now set. But there seems to be more trouble. As we install the sampledata we had the following problems: 1. "Biblio" table (as installed by Koha) seems to miss one column. Actual installation has: biblionumber author title unititle notes serial seriestitle copyrightdate timestamp 2. some other tables seems to be missing (ethnicity, shelfcontents, bookshelf) I have some trouble to complete the whole acquisition process with the "normal" interface and also with the Catalogue Search (at the librarians interface). Should I install Koha again? Veronica Lencinas Errorlog: [Tue Nov 26 18:15:48 2002] [error] [client 200.16.22.190] script not found or unable to stat: /u sr/local/koha/intranet/cgi-bin/acqui/whitcoulls.html DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Search.pm line 877, <KC> line 20. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/mo dules/C4/Search.pm line 880, <KC> line 20. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 9 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 138, <KC> line 10. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 150, <KC> line 20. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 161, <KC> line 30. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 9 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 138, <KC> line 10. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 150, <KC> line 20. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 161, <KC> line 30. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 231, <KC> line 40. DBD::mysql::st execute failed: You have an error in your SQL syntax near ')' at line 2 at /usr/l ocal/koha/intranet/modules/C4/Biblio.pm line 238, <KC> line 40. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Search.pm line 760, <KC> line 10. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/mo dules/C4/Search.pm line 763, <KC> line 10. DBD::mysql::st execute failed: You have an error in your SQL syntax near 'and biblioitems.biblio number=' at line 7 at /usr/local/koha/intranet/modules/C4/Search.pm line 841, <KC> line 20. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/mo dules/C4/Search.pm line 842, <KC> line 20. Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/sms.html

2 1

koha under solaris or Mac OS X?
by Christopher L Brown-Syed 26 Nov '02

26 Nov '02

Has anyone experimented with running Koha under Sun's Solaris or Apple's version of Linux? Please reply off-list, thanks. cbs -- Christopher Brown-Syed, PhD <clb24(a)buffalo.edu> or <cbrownsyed(a)cogeco.ca> Visiting Assistant Professor, School of Informatics, Univ. at Buffalo

2 1

Acquisitions interface
by Veronica Lencinas 25 Nov '02

25 Nov '02

Hello, we are installing Koha and have some problems with the acquisitions of Koha. At the Test Drive on the Koha site the script is http://hlt.katipo.co.nz/cgi-bin/koha/acqui.simple/addbooks.pl where I can add new items to the library. But the acquisition script installed in my computer is just http://my.host/acquisitions/ where I can make orders, but not catalog. My Kohaversion is 1.2.2 What's wrong, or what kind of errors did I made? Thank you very much. Veronica Lencinas Cordoba, Argentina Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/sms.html

2 1

Authentication problem
by biswanath＠drtc.isibang.ac.in 24 Nov '02

24 Nov '02

I need some help from you. I installed koha-1.2.3RC23. When I installed it I made it as Basic Authentication. But I want to convert it into Cookies Based-authentication. So how I can do that? Because I am facing a lot of problem due to that. So please as soon as possible help me. Bisu

2 1

copying databases?
by David Bucknell 24 Nov '02

24 Nov '02

Dear Koha Kurus, I have discovered that _something_ went wrong with the original school we set up and so have added a "branch." The old one didn't accept data correctly; the new one does. Assuming the data was input correctly (I know that's a question), is there a way to export the data we've input from the original to the new branch? TIA, David -- http://www.iteachnet.org http://members.iteachnet.org/webzine * http://opensourceschools.org * http://schoolforge.net * http://www.over-seas.com * http://www.rose-marie.ac.th * ------------------------------------------------ http://members.iteachnet.org/ http://www.opensourceschools.org/

2 1

Authentication problem
by biswanath＠drtc.isibang.ac.in 24 Nov '02

24 Nov '02

I need some help from you. I installed koha-1.2.3RC23. When I installed it I made it as Basic Authentication. But I want to convert it into Cookies Based-authentication. So how I can do that? Because I am facing a lot of problem due to that. So please as soon as possible help me. Bisu

1 0

News and Release Notes has been updated
by kea-notify＠katipo.co.nz 24 Nov '02

24 Nov '02

News and Release Notes has been updated. The revised page is available at: http://www.koha.org/news/index.html

1 0