- Koha - lists.katipo.co.nz

mysql error
by Danabalou Mohanassoundarame 28 Mar '06

28 Mar '06

Hello/Bonjour, I got a problem to create this table in mysql-5.0.18 any idea CREATE TABLE issues( borrowernumber int( 11 ) NOT NULL default '0', itemnumber int( 11 ) NOT NULL default '0', date_due date default NULL , branchcode char( 4 ) default NULL , issuingbranch char( 18 ) default NULL , returndate date default NULL , lastreneweddate date default NULL , RETURN char( 4 ) default NULL , renewals tinyint( 4 ) default NULL , timestamptimestamp( 14 ) NOT NULL , KEY issuesborridx( borrowernumber ) , KEY issuesitemidx( itemnumber ) , KEY bordate( borrowernumber, timestamp ) ) TYPE = MYISAM ; *MySQL a répondu:*Documentation <http://dev.mysql.com/doc/refman/5.0/en/error-returns.html> | #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'return char(4) default NULL, renewals tinyint(4) default NULL, timestamp t' at line 9 cordialement |

3 2

Join Us In Paris For KohaCon 2006
by Russel Garlick 28 Mar '06

28 Mar '06

MEDIA RELEASE: Join Us In Paris For KohaCon 2006 27 March 2006 The Koha community is excited to announce the first ever Koha Conference to be held in Paris France May 2nd and 3rd 2006. We'd like to extend an invitation to libraries, developers, media and library supporters to attend our first conference. This event is the first formal gathering of the wider Koha community, including developers, users and supporters, since version 1.0 of the world's first Open Source Integrated Library System (ILS), was released in 2000. It provides an opportunity to join together to celebrate achievements to date, and discover more about the Koha ILS. Many of the presentations will focus on what Koha 3.0 will offer the community. The conference will be held over two days in Paris, France. DAY ONE - DISCOVER KOHA May 2nd 2006, Paris The Discover Koha day will include talks on what is Koha and open source software, what does this mean for libraries along with a presentation of the new features in Koha 3.0 and some background on what is involved in moving to Koha from another ILS. DAY TWO - KOHA USER GROUP (Europe) May 3rd 2006, Paris The User Group day will be more hands on and provides existing Koha users with an opportunity to discover more about the current system and learn about what is coming in the future released. There will demonstrations of new functionality. WHO SHOULD ATTEND? If you are already a Koha user, or perhaps you have been interested in Koha and want to find out more, then you should attend KohaCon 2006. A large number of Koha developers from around the world will be there, and this is your chance to meet with them. They include, amongst others: * Chris Cormack, Version 1.X Release Manager, Katipo Communications, New Zealand. * Paul Poulain , Version 2.2 Release Manager, Independent Koha Consultant, France. * Joshua Ferraro, Version 3.0 Release Manager, Liblime, United States of America A full programme outline speakers and topics will be published on http://www.koha.org website. For more information about KohaCon 2006, please go to http://www.koha.org/community/conferences/ REGISTRATION IS FREE, BUT ESSENTIAL This is a free event, but if you would like to attend you will need to register. You can register online at http://www.koha.org/community/conferences/registration.html. Once you have registered, you will be contacted by the conference organising committee with further details. The Koha community would like to thank Ecole Nationale Suprieure des Mines de Paris (ENSMP) for providing a venue for KohaCon in Paris. KOHA DEVELOPERS WEEK May 8th-12th 2006, Marseille Following on from the conference, a group of core Koha developers will be meeting in Marseille to work on Koha 3.0. If you are a Koha developer who is interested in contributing, then please attend a Koha Project IRC meeting. Meetings are held every Monday at 20:00 GMT. See http://www.koha.org/community/irc.html for IRC channel information. Space is limited at the Development Week venue. If you would like to attend, please ensure that you are at a project meeting in the next two weeks. The Koha community would like to thank Bibliotheque du Centre de Mathematiques et Informatique (CMI) at the Universite de Provence for providing a venue for the Developers Week in Marseille. ABOUT KOHA Koha is a full-featured Open Source library management system first deployed in January 2000 at Horowhenua Library Trust. It is currently maintained by a team of software providers and library technology staff from around the globe. Several companies around the world support Koha, providing libraries with a full array of vendor services including installation, migration assistance, data integrity testing, staff training, software maintenance, support and customization. To learn more about Koha, please visit http://www.koha.org/. -- Russel Garlick Operations Manager Katipo Communications Ph: +64 4 934 1285 Fax: +64 4 934 1286 Mob: +64 27 537 1377 Skype: russelgarlick Web http://www.katipo.co.nz

1 0

z3950 working well, thanks
by Marty Jongepier 27 Mar '06

27 Mar '06

I am kind of answering my own questions here now, but it might be useful for someone else. The reason my z3950 server didn't behave properly seems that in my imported biblio there were some author names with quotation marks around them and some that had not. (Don't ask me why, I have no clue) I removed all quotation marks and re-imported my list, and it works well now. Pretty cool, I would say. Only one thing; I still have to start it manually. Is it supposed to start when Koha starts, or when you start a search? Marty Jongepier

2 1

Marc Framework
by Nitin Madhavan 27 Mar '06

27 Mar '06

I am using Koha on Windows. I only have one, the default MARC framework. On checking the MARC structure, it has the tags I require like 852$c, 952, 037$n, etc. However, when adding biblio or editing the Marc values of any book, these Marc fields are not displayed. Only some of the fields from the MARC framework are available for editing. How do I get the required Marc fields for editing and adding data? Thanx Nitin

1 0

New material in the Koha usersguide
by Stephen Hedges 27 Mar '06

27 Mar '06

Chapter 3, "Circulation Tasks," has been added to the Koha Users Guide. The Guide is the first document on www.kohadocs.org. -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com

1 0

Installing on Debian sarge
by Nitin Madhavan 26 Mar '06

26 Mar '06

I have been using Koha on windows for a few weeks to check it out and have been very impressed. Since the z3950 feature is not available in the windows version, I am installing it on Linux (debian sarge). I am a newbie to linux and need all the help I can get. I have read up the guidelines for installation on woody and need the following clarifications : 1. I do not have a internet connection yet. Is there any way of downloading the required packages ( the perl modules and Yaz toolkit) on another computer and then copying them on to the hard drive of my comp for installation using apt? If yes, i would appreciate the exact procedure, the folder to copy into, etc. 2. The exact procedure for installing on Sarge for a linux-illiterate, if possible i also have a few queries reagrding Koha. Here goes 1. Can I check what books are there in the reservoir? 2. How does the auto barcode feature work? I have activated it in the system administartion page. But it still asks for a barcode when I add a new book. If i leave it blank and continue, it gives an error message asking me to enter the barcode. Thanks Nitin

1 0

RE: [Koha] z3950 questions
by Marty Jongepier 26 Mar '06

26 Mar '06

Thanks Tom, It seems it was indeed a matter of file permissions, also for the z3950-daemon-launch.sh file. I have imported one book with z3950, not much, but at least it seemed to work ok, although I had to start the daemon manually, and it gave an error on the 2nd I tried. But we'll work on that. Marty Jongepier On Tue, Mar 21, 2006 at 09:59:09PM -0500, Marty Jongepier wrote: > Hi all, First, your log directory permissions have to be set so that the name the z3590 daemon is running under has write permission. The koha install script doesn't set this. > > First of all, thanks, Stephen, for your fast and helpful responses. > > I am tackling my problems one by one,as I meet them > I tried to do a Z39.50 search, but I had some trouble, and I am > clueless as how to solve this. > > -Question 1, do I have to set up something to make the Z39.50 start > automatically? I started it manually (basically because I was not > convinced it was running) but if I try to do a cat on a log file, my > computer says it doesn't exist or just returns to the command > prompt(see below) does that mean they are empty? I was a bit puzzled > (not uncommon for me, but even so, I like things to work) > > -Question 2, the logs that do return something give this output, > again, see below. Anybody can give me a hint or help where to go from > here? > > And thanks once again, > > Marty Jongepier > > >

1 1

RE: [Koha] New document on kohadocs.org (Installing on Debian)
by Morgan, John D. 25 Mar '06

25 Mar '06

Hello, Thanks for this information. I have the version of Debion that I got from hear: http://www.debian.org/CD/netinst/ Will the directions work for this version? Thanks, Derek -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Stephen Hedges Sent: Thursday, March 23, 2006 12:56 PM To: koha(a)lists.katipo.co.nz; koha-devel(a)nongnu.org Subject: [Koha] New document on kohadocs.org (Installing on Debian) Joshua Ferraro has revised his document about installing Koha on Debian to accommodate Koha version 2.2.6 and Debian sarge (3.1). Find it on www.kohadocs.org under "System Administration." If you still need to know how to install older versions of Koha on Debian woody, those documents are still available, too -- substitute "Woody" (capital W) for "sarge" in the url for each type of document. -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Koha on Mac OS X? Seeking more info
by Ann Sawusch 24 Mar '06

24 Mar '06

Hello. I am a newbie to this list. Could you point me to more information on using Koha in a Mac OS X environment? I found and read Stephen Hedges doc Installing Koha on Mac OS X.(2006) I am working with a group with no budget and a donated Mac (nice, running 10.3.?). Is it possible to establish a stable production Koha on OS X? What doesn't work or breaks with the absence of the Net::Z3950 module "and some other limitations"? I would be very interested in learning details of cons of Mac OS X. It will be a hardsell to strip out the OS X and rebuild in Linux. Folks have a comfort level with OS X (security, updating, network configuration...)and want to understand 'why not'. Thanks in advance for any assistance. Ann Sawusch asawusch at mac dot com

3 3

Entry Errors with large forms.
by GLBT Library 23 Mar '06

23 Mar '06

I have a problem with Koha. When I attempt to alter a biblio entry that has a field with enough data in it to cause it show up with the memo entry form component then it moves all the data around in the final biblio database entry. Nothing saves properly, which makes it very difficult for me to deal with situations where I find there are errors that should be a sinch to correct in biblio entries with long abstracts or statements of responsibility. If anyone has seen this error and knows how to fix it, or knows of a way to stop Koha from using the long memo format form entry I would greatly appreciate the advice. -- Victor J Kinzer Gay, Lesbian, Bisexual, Transgender Student Support Services Indiana University 705 E. 7th Street Bloomington, IN 47408 PH: 812-855-4252 FX: 812-855-4465 Email: glbtlib(a)indiana.edu URL: http://www.indiana.edu/~glbtlib/ For a listing of events at IU and surrounding area please check out our web page calendar: http://www.indiana.edu/~glbt/

1 0