- Koha-devel - lists.koha-community.org

Fw: WHERE CAN I FIND THE DATABASE STRUCTURE
by JAVIER RICARDO MEJIA C. 22 Jun '03

22 Jun '03

Hi, I´m Javier Where i can find the database structure of koha, i saw one time on a web site but i don´t remmember where.... sombebody can help me? thnaks javier

1 0

Re: [Koha] ANNOUNCE: Koha perl dependency RPMs for Red Hat 9
by Louella Santiago 22 Jun '03

22 Jun '03

> i might even manage an RPM package for Koha itself. <g> > > Paul hopefully, this would come to fruition. it would really help a lot of not-so-IT librarians to just install Koha without them knowing the hard work. cheers! louella

1 0

Ding, ding... koha 1.9.3 just arrived at sourceforge airport. Welcome onboard
by paul POULAIN 20 Jun '03

20 Jun '03

This release add a lot of bugfixes, a 1st z3950 support, and a script for migration from previous ILS. FEATURE FREEZE ! --------- This version is the last version with new features before 2.0. Please, report bugs on bugs.koha.org, and feel free to fix them (through patch or cvs commit) PACKAGE NEEDED : --------- Update your MARC::Record to get the latest version (1.26). Koha won't work with old versions, and bulkmarcimport.pl need MARC::Batch.pm, whichi is recent. MARC::Record 1.25 works to, but reports hundred of warnings in error_log. pls upgrage to 1.26 ! DB modifications : --------- * the marc_breeding table has been modified. A row "encoding" varchar(40) has been added. It's used to manage character encoding. * the z3950_servers table has been modified. A row "syntax" varchar(40) has been added. It's used to manage character encoding. z3950 : --------- * the z3950 script in admin part of Koha has been fixed and can be used and translated. * z3950 cataloguing : when you reach the MARC-cataloguing screen, a new link appear : z3950 search. * If you click on this link, a popup appears, and the search begins. The window is refreshed every 2 seconds, until all servers answered. * The avaible records are shown in the popup. Click on the one you want, and... the popup closes and the biblio is copied in the cataloguing screen. This works ONLY IF the z3950 daemon is launched. It's located at $kohadir/scripts/z3950daemon/ * MODIFY the scripts to fit you directory structure. * Warning : due to a small bug, processqueue is in $kohadir/cgi-bin/z3950/ directory, not in the script one. * Start daemon in a non-X shell, or launch processqueue in a shell, and KEEP IT OPEN. iso2709 file import : --------- This tools is very important and was waiting by libraries that plans to migrate from a previous ILS. VERY IMPORTANT : BEFORE using this script, take care of your MARC parameters, and check them twice. If they are wrong, you will get wrong results... It's located (in CVS tree) at $koharoot/misc/bulkmarcimport.pl It loads an iso2709 file into the ACTIVE Database. My 1st tests on sample files shows it works quite fine. Feel free to try it. How it works ? enter ./bulkmarcimport in a console, and look. KNOWN LIMIT : If the barcode of an item does not exists, the scripts report an SQL error, and continue. BUT the corresponding item is not in the non-marc db, so it can't be requested or loaned. sample file : --------- The sample file has been removed from this release, as it's buggy (no MARC datas, making it quite useless) BUG FIXED (see bugs.koha.org for more infos) ========= A lot... (around 35). Thanks to Mike that fixed a lot, Steve that fixes some, MJ Ray that upgraded the installer for non-root install, and Chris that fixed some and begins backport of non-marc stuff from 1.2 Bugs still open in bugs.koha.org ======================= A lot... (around 60. some being really trivial to fix, some being more important) TODO ===== * some GUI reordering, as planned with Rachel from Katipo and others (paul & others) * finishing backport of non-marc cataloguing & non-marc simple acquisition from 1.2 version (chris) * bug fixes (everybody) * cleaning z3950 old searches (more than 1 hour/day old ?) (paul) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

7 10

repetable fields on CVS
by paul POULAIN 20 Jun '03

20 Jun '03

I just commited partial work for repetable fields (see yesterday irc log) Near each field is a + If you click on it, it's duplicated. TODO : * cc the + to each tab (for instance, only in tab 0) * doing the french template * fixing an annoying bug : everything is stored in the same field : 200$a$b$c$a$b$c and not 200$a$b$c 200$a$b$c as expected. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 1

RE: [Koha-devel] RE:koha on pache 2
by Jones, Steven 20 Jun '03

20 Jun '03

I cant even get 1.2.3 running let alone 1.9.x! Steven -----Original Message----- From: MJ Ray [mailto:markj@cloaked.freeserve.co.uk] Sent: Thursday, 19 June 2003 9:26 PM To: koha-devel(a)lists.sourceforge.net Subject: Re: [Koha-devel] RE:koha on pache 2 Jones, Steven <sjones08(a)eds.com> wrote: > From this post I'm wondering what version of Koha I should be using on > Apache 2.x, Is 1.2.3 the right one? It depends. My installing and reinstalling is because I'm working on fixing installer bugs, not anything else. Version 1.2.3 seems to work fine with Apache 2.x and is probably the best bet if you need it in production *now* but if you're looking at deployment in a couple of months, start testing 1.9.x so you're ready for the 2.0 release and can tell us of any bugs. -- MJR/slef My Opinion Only and possibly not of any group I know. http://mjr.towers.org.uk/ jabber://slef@jabber.at Creative copyleft computing services via http://www.ttllp.co.uk/ Thought: "Changeset algebra is really difficult." ------------------------------------------------------- This SF.Net email is sponsored by: INetU Attention Web Developers & Consultants: Become An INetU Hosting Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission! INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel

2 1

Re: [Koha-devel] Re: [Koha] 3rd pre 2.0 meeting (fwd)
by COURYHOUSE＠aol.com 19 Jun '03

19 Jun '03

Your are missing the point though, his was requested along time ago. It did not seem to be documented as something on he to do list and thus did not get done. > Subj: Re: [Koha-devel] Re: [Koha] 3rd pre 2.0 meeting (fwd) > Date: 6/19/2003 2:26:25 AM US Mountain Standard Time > From: <A HREF="mailto:markj@cloaked.freeserve.co.uk">markj(a)cloaked.freeserve.co.uk</A> > To: <A HREF="mailto:koha-devel@lists.sourceforge.net">koha-devel(a)lists.sourceforge.net</A> > Sent from the Internet > > > > COURYHOUSE(a)aol.com <COURYHOUSE(a)aol.com> wrote: > >Now you are assuming that I want to learn new programming languages.... I > >don't even have time to practice the ancient art of ALGOL, SPL, FORTRAN > etc... > >retooling my brain for a new language is not an option... Besides.. > pulling 16 > >hour days leaves little time.... > > Options for you, as far as I can see: > 1. Do it yourself (you don't want to/don't have time to); > 2. Encourage someone else to do it (you can't?); > 3. Wait. > > Sorry, but that's the way it goes sometimes. Until I have a client who > must have LC in koha, I can't give it a higher priority than other work. > This flamefest helps no-one and makes it harder for you to do option 2. > > -- > MJR/slef My Opinion Only and possibly not of any group I know. > http://mjr.towers.org.uk/ jabber://slef@jabber.at > Creative copyleft computing services via http://www.ttllp.co.uk/ > Thought: "Changeset algebra is really difficult." > >

2 1

Re: [Koha-devel]+[Koha] The Rather Anxious Feature Requestor and various OT s...
by COURYHOUSE＠aol.com 19 Jun '03

19 Jun '03

please re read the last 2 days of email you will notice I stated in onne of them "See you in 6 months" > To the original feature requestor: Maybe you should go to your board of > directors and seek guidance - wait 6 months (don't quote me on that

1 0

Re: [Koha-devel] Re: [Koha] 3rd pre 2.0 meeting
by COURYHOUSE＠aol.com 19 Jun '03

19 Jun '03

shouldn't have to be a new feature, it should be there by default. as with any library automation system that is in widespread use. Remember strive to be the standard, not just sorta meet it. > I remind : > 2.0.x => improvments > 2.2 => new features > LC not being a new feature imho. >

1 0

Re: [Koha-devel] Re: [Koha] 3rd pre 2.0 meeting (fwd)
by COURYHOUSE＠aol.com 19 Jun '03

19 Jun '03

Yes, but we know serials support is coming. But at a later time. > Note, Ed, that there are some other missing features in Koha that are a > problem. For example, Serial support. > We don't say that Koha is ready for any library. Maybe you've putted too > many hopes in our project... >

1 0

Re: Koha Setup Question
by Pat Eyler 19 Jun '03

19 Jun '03

Patrick, I'm sending your message along to the koha and koha-devel mailing lists. You'll likely get better answers more quickly by going directly to these lists. thanks, -pate On Thu, 12 Jun 2003, Singer, Patrick J wrote: > I'm working with Anne Zarinnia's group on setting up a Koha testbed for > us to evaluate and test out. > > I've been using the 1.9.3 version of Koha because we wanted to get a > feel for how the newer stable version (once released) would feel. > > I followed the instructions on this page > http://koha.org/installation/quick-start.html with some minor changes > but it all looks like it is setup correctly. > > When I go to the site where I have setup the OPAC the opac-main.pl > script crashes an causes an internal server error. > > I ran the script from the command line and got the following error > message - > > HTML::Template->new() : Cannot open included file > /default/en/opac-main.tmpl : file not found. at > /usr/lib/perl5/site_perl/5.8.0/HTML/Template.pm line 1580 > > HTML::Template::_init_template('HTML::Template=HASH(0x818ba54)') > called at /usr/lib/perl5/site_perl/5.8.0/HTML/Template.pm line 1177 > > HTML::Template::_init('HTML::Template=HASH(0x818ba54)') called at > /usr/lib/perl5/site_perl/5.8.0/HTML/Template.pm line 1071 > > HTML::Template::new('HTML::Template','filename', > '/default/en/opac-main.tmpl','die_on_bad_params',0,'global_vars',1, > 'path','ARRAY(0x88218e4)',...) > called at /usr/lib/perl5/site_perl/5.8.0/C4/Output.pm line 93 > > C4::Output::gettemplate('opac-main.tmpl','opac') called at > /usr/lib/perl5/site_perl/5.8.0/C4/Auth.pm line 112 > > C4::Auth::get_template_and_user('HASH(0x806187c)') called at > ./opac-main.pl line 12 > > > I don't know if this is due to the includes listed in the > /etc/koha.conf file or if it something else. > Here is a (close to) complete configuration breakdown of the box. > > Software - > O/S - RedHat 8.0 > Kernel - 2.4.18-14 > Apache - 2.0.40-8 > mySQL - 3.23.52-3 > PERL - 5.8.0-55 > > Configuration Files - > > /etc/koha.conf > > database=Koha > hostname=localhost > user=koha > pass=<password> > includes=/var/www/koha/htdocs/opac-tmpl > > > /etc/httpd/conf/httpd.conf | section with opac configuration > > > # Koha OPAC section > ScriptAlias /cgi-bin/koha "/var/www/koha/cgi-bin/" > <Directory "/var/www/koha/cgi-bin"> > Options +Includes -FollowSymlinks -Indexes > AllowOverride None > Order allow,deny > Allow from all > </Directory> > > Alias /koha "/var/www/koha/htdocs/" > <Directory "/var/www/koha/htdocs"> > Options +Includes -FollowSymlinks -Indexes > AllowOverride None > Order allow,deny > Allow from all > </Directory> > > > Directory structure where OPAC located - > /var/www/koha/htdocs - location of index.html and directory with opac-tmpl > /var/www/koha/htdocs/opac-tmpl - location of opac templates (is this the include directory?) > /var/www/koha/cgi-bin - location of opac cgi-scripts > > I hope this is enough information to help with the given error. > > Thank you for your time and assistance. > > -Patrick Singer > > > > > > > > > > >

4 7