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

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

23 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

Opac-error_log for above problem:)
by Joshua Ferraro 23 Jun '03

23 Jun '03

[Mon Jun 23 08:05:39 2003] [error] [client 66.190.36.66] File does not exist: /u [Sun Jun 22 17:01:15 2003] [error] [client 24.93.101.142] attempt to invoke dire ctory as script: /usr/local/koha/opac/cgi-bin [Sun Jun 22 17:01:19 2003] [error] [client 24.93.101.142] attempt to invoke dire ctory as script: /usr/local/koha/opac/cgi-bin [Sun Jun 22 19:59:22 2003] [error] [client 24.93.101.142] attempt to invoke dire ctory as script: /usr/local/koha/opac/cgi-bin [Mon Jun 23 08:05:39 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/scripts/root.exe [Mon Jun 23 08:05:39 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/MSADC/root.exe [Mon Jun 23 08:05:39 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/c/winnt/system32/cmd.exe [Mon Jun 23 08:05:40 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/d/winnt/system32/cmd.exe [Mon Jun 23 08:05:40 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/scripts/..%5c../winnt/system32/cmd.exe [Mon Jun 23 08:05:40 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/_vti_bin/..%5c../..%5c../..%5c../winnt/system32/cmd.ex e [Mon Jun 23 08:05:40 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/_mem_bin/..%5c../..%5c../..%5c../winnt/system32/cmd.ex e [Mon Jun 23 08:05:40 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/msadc/..%5c../..%5c../..%5c/..\xc1^\../..\xc1^\../..\x c1^\../winnt/system32/cmd.exe [Mon Jun 23 08:05:40 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/scripts/..\xc1^\../winnt/system32/cmd.exe [Mon Jun 23 08:05:40 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/scripts/..\xc0\xaf../winnt/system32/cmd.exe [Mon Jun 23 08:05:41 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/scripts/..\xc1\x9c../winnt/system32/cmd.exe [Mon Jun 23 08:05:41 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/scripts/..%5c../winnt/system32/cmd.exe [Mon Jun 23 08:05:41 2003] [error] [client 66.190.36.66] File does not exist: /u sr/local/koha/opac/htdocs/scripts/..%2f../winnt/system32/cmd.exe [Mon Jun 23 08:36:59 2003] [error] [client 66.213.78.102] attempt to invoke dire ctory as script: /usr/local/koha/opac/cgi-bin [Mon Jun 23 09:07:53 2003] [error] [client 66.213.78.102] attempt to invoke dire ctory as script: /usr/local/koha/opac/cgi-bin type = loose at /usr/local/koha/intranet/modules/C4/Search.pm line 858. type = loose at /usr/local/koha/intranet/modules/C4/Search.pm line 858. DBD::mysql::st execute failed: You have an error in your SQL syntax near 'group by biblio.biblionumber order by title' at line 1 at /usr/local/koha/intranet/mod ules/C4/Search.pm line 1085. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/ koha/intranet/modules/C4/Search.pm line 1089. [Mon Jun 23 09:18:39 2003] [error] [client 66.213.78.102] attempt to invoke dire ctory as script: /usr/local/koha/opac/cgi-bin

1 0

Errors on my Installation (premature script header...)
by Joshua Ferraro 23 Jun '03

23 Jun '03

Hi everyone, We just did our second data transfer (500 biblio items) and everything seemed to go smoothly except for a few minor interface problems (the subject still does not display in the opac). However, I am having some trouble with a few perl scripts (modules?). From the main intranet page the circulation link does not work (http://koha.athenscounty.lib.oh.us:8080/cgi-bin/koha/circ/circulation.pl) also, the Marc link (http://koha.athenscounty.lib.oh.us:8080/cgi-bin/koha/loadmodules.pl?module=…) does not work either. For both of these the browser shows an Internal Server error. The only change that I am aware of is that I recently (yesterday) started using symlinks from my CVS working copy to the installation directory as per the wiki page. Any suggestions? I will be on IRC all day. Here is the koha-error_log: [Mon Jun 23 09:07:40 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/circ/circulation.pl [Mon Jun 23 09:07:46 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif [Mon Jun 23 09:07:50 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif [Mon Jun 23 09:16:15 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291 [Mon Jun 23 09:16:21 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/circ/circulation.pl [Mon Jun 23 09:16:23 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif [Mon Jun 23 09:18:52 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291 [Mon Jun 23 09:18:54 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/circ/circulation.pl HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291 [Mon Jun 23 09:07:46 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif [Mon Jun 23 09:07:50 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif [Mon Jun 23 09:16:15 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291 [Mon Jun 23 09:16:21 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/circ/circulation.pl [Mon Jun 23 09:16:23 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif [Mon Jun 23 09:18:52 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291 [Mon Jun 23 09:18:54 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/circ/circulation.pl HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291 [Sun Jun 22 16:24:27 2003] [error] [client 24.93.101.142] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif [Sun Jun 22 16:31:11 2003] [error] [client 24.93.101.142] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif HERE at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 129. ==>select m1.bibid from marc_subfield_table as m1 where (m1.subfieldvalue = 'buc k' and m1.tag=100 and m1.subfieldcode='c') at /usr/local/koha/intranet/modules/ C4/SearchMarc.pm line 135. HERE at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 129. ==>select m1.bibid from marc_subfield_table as m1 where (m1.subfieldvalue = 'buc k' and m1.tag=245 and m1.subfieldcode='a') at /usr/local/koha/intranet/modules/ C4/SearchMarc.pm line 135. [Mon Jun 23 08:37:10 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif [Mon Jun 23 08:37:46 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/loadmodules.pl [Mon Jun 23 08:37:55 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/loadmodules.pl [Mon Jun 23 08:38:24 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/loadmodules.pl [Mon Jun 23 08:38:53 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/loadmodules.pl [Mon Jun 23 08:39:00 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/loadmodules.pl ==> 300 / 2 / itemtypes at /usr/local/koha/intranet/cgi-bin/admin/checkmarc.pl l ine 94. HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291 [Mon Jun 23 09:07:40 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/circ/circulation.pl [Mon Jun 23 09:07:46 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif [Mon Jun 23 09:07:50 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif [Mon Jun 23 09:16:15 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291 [Mon Jun 23 09:16:21 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/circ/circulation.pl [Mon Jun 23 09:16:23 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif [Mon Jun 23 09:18:52 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291 [Mon Jun 23 09:18:54 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/circ/circulation.pl HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291 [Mon Jun 23 09:19:13 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/circ/circulation.pl [Mon Jun 23 09:20:22 2003] [error] [client 66.213.78.102] script not found or un able to stat: /usr/lib/cgi-bin/circ HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291 [Mon Jun 23 09:20:40 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/circ/circulation.pl [Mon Jun 23 09:22:44 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291 [Mon Jun 23 09:23:21 2003] [error] [client 66.213.78.102] Premature end of scrip t headers: /usr/local/koha/intranet/cgi-bin/circ/circulation.pl [Mon Jun 23 09:27:53 2003] [error] [client 66.213.78.102] File does not exist: / usr/local/koha/intranet/htdocs/img/ding.gif HTML::Template::param() : attempt to set parameter 'todayissues' with an array r ef - parameter is not a TMPL_LOOP! at /usr/local/koha/intranet/cgi-bin/circ/circ ulation.pl line 291

1 0

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

2 1

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