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

koha-3.00.00 make fails
by Rick Welykochy 28 Dec '13

28 Dec '13

Hi all, I have downloaded http://download.koha.org/koha-3.00.00.tar.gz and began installing it on Debian/etch (in a Linux vserver environment). 0. FINE: cd koha-3.00.00 1. FINE: perl Makefile.PL 2. FAIL: make : : : Manifying blib/man3/C4::UploadedFile.3pm Manifying blib/man3/C4::BackgroundJob.3pm Manifying blib/man3/opac::opac-dictionary.3pm Manifying blib/man3/serials::member-search.3pm /usr/bin/perl "-Iblib/arch" "-Iblib/lib" fix-perl-path.PL blib /usr/bin/perl "-Iblib/arch" "-Iblib/lib" rewrite-config.PL blib/KOHA_CONF_DIR/koha-conf.xml Bad arg length for Socket::inet_ntoa, length is 0, should be 4 at rewrite-config.PL line 67. make: *** [blib/KOHA_CONF_DIR/koha-conf.xml] Error 255 Any ideas what went wrong and how to fix? Aside: there were a couple of other problems with this "out of the box" debian based install of Koha 3.0 which had to be fixed along the way, e.g. seven missing perl modules and libgd not found. I'll report on the entire process from unpacking to a running Koha/3.00.00 once I get to the end. cheers rickw -- ________________________________________________________________ Rick Welykochy || Praxis Services || Internet Driving Instructor The manual said Windows XP/SP2 or better so I installed Linux.

4 5

Can't call method "append_fields"
by constantine 13 Oct '09

13 Oct '09

Yes, the previous problem was solved, indeed... I do not understand why I have so many problems installing koha,.. maybe the last years I was too used to Joomla! installations :D So the challenging koha that its concept I so much admire and embrace makes me face another problem. Trying to add a MARC record, (I retrieved its data from a z30.50 server, but that does not matter, I think) and then I am getting an error page (http://localhost:8080/cgi-bin/koha/cataloguing/additem.pl) Its contents are: " Koha error The following fatal error has occurred: Can't call method "append_fields" on an undefined value at /usr/local/share/perl/5.10.0/MARC/File/SAX.pm line 95. at /usr/local/lib/perl/5.10.0/XML/LibXML/SAX.pm line 64 at /usr/local/share/perl/5.10.0/MARC/File/XML.pm line 443 Apache Server version: Apache/2.2.9 (Debian) Server built: Jun 21 2008 10:35:35 Koha 3.00.00.094 Koha DB 3.0000094 MySQL mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 OS Linux sangre 2.6.25.9xx6-costis07 #1 SMP PREEMPT Wed Jul 2 02:35:38 EEST 2008 i686 GNU/Linux Perl 5.010000 " The laste contens of /var/log/koha/koha-error_log are [...] [error] [...] [...] addbiblio.pl: INDEXING :orignew at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :1 at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :ocip at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :20 at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :y-gencatlg at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :ddc at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :SR at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :pc15 2006-07-19 to SSCD at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :jp00 2006-07-26 CIP recd at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :jp20 2006-07-26 to subj at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :jp03 2006-07-26 at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :aa05 2006-07-27 at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :1 at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] addbiblio.pl: INDEXING :1 at /usr/share/koha/lib/C4/Biblio.pm line 2319., referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [debug] mod_deflate.c(619): [...] Zlib: Compressed 37993 to 5966 : URL /cgi-bin/koha/cataloguing/additem.pl, referer: http://localhost:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&… [...] [error] [...] [...] additem.pl: Can't call method "append_fields" on an undefined value at /usr/local/share/perl/5.10.0/MARC/File/SAX.pm line 95. at /usr/local/lib/perl/5.10.0/XML/LibXML/SAX.pm line 64, referer: http://localhost:8080/cgi-bin/koha/cataloguing/additem.pl?biblionumber=1&fr… [...] [error] [...] [...] additem.pl: at /usr/local/share/perl/5.10.0/MARC/File/XML.pm line 443, referer: http://localhost:8080/cgi-bin/koha/cataloguing/additem.pl?biblionumber=1&fr… What could I do to solve this problem? Tsardounis Constantine http://costis.name _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel

2 1

Authority in Koha 3 (English - Unimarc - NoZebra)
by Zeno Tajoli 27 Feb '09

27 Feb '09

Hi to all, I have found a but into installer data for Unimarc / English language. I'm using a NoZebra setting and I think this option is importan for this bug. The setup of Authority is based on the file installer/data/mysql/en/marcflavour/unimarc/mandatory/authorities_normal_unimarc.sql But this definition gives problems, see my e-mail "Problems on working with authority" in koha general list, 05 Jun 2008 09:14. A correct defintion is the frence definition. Probably the main problem is to insert authtypecode = '' into all records of tables auth_tag_structure and auth_subfield_structure. I think that the frence defintion could be good also for English Unimarc definition. My authority defintion (a transaltion of franch definition into english) is attached to this mail. Bye Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @) _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel

2 1

adding a model abstraction ?
by Marc Chantreux 22 Jan '09

22 Jan '09

hello guys, I just rewritten the C4::Bookseller::AddBookseller and it now looks like: sub AddBookseller { _koha_insert_and_get_id( 'aqbooksellers', shift ); } _koha_insert_and_get_id is a function where i deal with DBI and all specific DBD tricks with reuse in mind. You can see the following code. do i try to push it in koha ? and where ? It sounds like Koha::SQL package. regards sub _koha_insert_and_get_id { # Todo: implement uses of config # like exclude, defaults, ... # $tablename is a string and contains the name of the table # $data is a reference to an hash that contains column names to set as keys # optionnal $config alter default behaviour my ( $tablename, $data, $config ) = @_; my $dbh = C4::Context->dbh; # @fields to insert are all %$data (unless overwritten by $$config{fields} ) my @fields = (defined $config and exists $config->{fields}) ? @{ $config->{fields} } : keys %$data ; # build the query my $query = 'INSERT INTO ' . $tablename .' (' . join(',',@fields) . ') VALUES (' . join(',', map {'?'} @fields) . ');' ; my $sth = $dbh->prepare($query); # deal with the server $sth->execute( @$data{@fields}); if ( $sth->err ) { warn $sth->errstr; return undef; } # return the last id C4::Context->config('db_scheme') eq 'mysql' and return $dbh->{mysql_insertid}; # todo use the last_insert_id dbh function # my $id = $dbh->last_insert_id( ? ); # before give up warn 'database unable to get last inserted id'; return undef; } -- Marc Chantreux http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc

12 32

RFC: Koha : Merge biblio & biblioitems tables
by Ryan Higgins 17 Dec '08

17 Dec '08

Late entry, I know, but I would like to get rid of the clunky extra table, and merge the columns that we need from biblioitems into a new biblio table. I've listed the columns to keep on the wiki; please review and add any that are missing. http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_biblio_table -- Ryan Higgins LibLime * Open-Source Solutions for Libraries Featuring KohaZOOM ILS 888-564-2457 x704

10 34

String freeze for 3.0.1
by Henri-Damien LAURENT 07 Dec '08

07 Dec '08

Hi, I am glad to announce String Freeze for 3.0.1. Translators, you have 3 week time for translations. It should be only differences from 3.0.0 But strings Normalization sometimes did many tiny changes. Sorry about that. Chris will tell you more about Pootle site that will allow good translations. Let me know if you encounter any problem. Hopefully, christmas will bring us 3.0.1 release. ;) -- Henri-Damien LAURENT

6 7

Koha Classroom training Error
by Donna Day 05 Dec '08

05 Dec '08

We have a group project to create our own Koha library catalog, but we can't log in due to the following error message: OPAC error: Koha error The following fatal error has occurred: The format you asked for ('') is unrecognized. at /home/koha-with-class/kohaclone/opac/opac-user.pl line 52 Apache Server version: Apache/2.2.3 Server built: Jan 31 2008 08:42:27 Koha 3.01.00.002 Koha DB 3.0100002 MySQL mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (x86_64) using readline 5.2 OS Linux demo01.ec2.liblime.com 2.6.16.33-xenU #2 SMP Wed Aug 15 17:27:36 SAST 2007 x86_64 GNU/Linux Perl 5.008008 Staff Client Error: Koha error The following fatal error has occurred: The format you asked for ('') is unrecognized. at /home/koha-with-class/kohaclone/C4/NewsChannels.pm line 340 Apache Server version: Apache/2.2.3 Server built: Jan 31 2008 08:42:27 Koha 3.01.00.002 Koha DB 3.0100002 MySQL mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (x86_64) using readline 5.2 OS Linux demo01.ec2.liblime.com 2.6.16.33-xenU #2 SMP Wed Aug 15 17:27:36 SAST 2007 x86_64 GNU/Linux Perl 5.008008 I'm not sure if it's related to the following which is popping up under Local Use Field: * New Preference System preferences admin Local Use preferences Preference Explanation Value Edit Delete "us" dateformat "us"=mm/dd/yyy Edit Delete The system is not allowing us to delete this field (it acts like it is, but then pops back up). How can we get rid of this?? Thanks for any assistance you can offer! Donna

2 1

Best server Computer for Koha
by mikyas hailu 29 Nov '08

29 Nov '08

Hey All, Please inform us the best server suitable to koha. Regards,

2 1

Re: [Koha-devel] Koha-devel Digest, Vol 36, Issue 41
by vijaya kumar 28 Nov '08

28 Nov '08

I WANT TO USE KOHA SOFTWARE FOR OUR LIBRARY AUTOMATION. PLEASE SEND SHORT CUT METHOD FOR KOHA INSTALLATION. AS EARLY AS POSSIBLE. YOURS SINCERLY DR.JVK On Thu, Nov 27, 2008 at 4:30 PM, <koha-devel-request(a)lists.koha.org> wrote: > Send Koha-devel mailing list submissions to > koha-devel(a)lists.koha.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.koha.org/mailman/listinfo/koha-devel > or, via email, send a message with subject or body 'help' to > koha-devel-request(a)lists.koha.org > > You can reach the person managing the list at > koha-devel-owner(a)lists.koha.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha-devel digest..." > > > Today's Topics: > > 1. Re: Koha PEOPLE Efficiency [WAS: RFC: Koha : Merge biblio & > biblioitems tables] (Rick Welykochy) > 2. Re: mod_perl (Wojciech Zatorski) > 3. Re: [RFC ver2 4/4] DBIx::Class - Changes to C4::Members to > start using DBIx::Class (Paul POULAIN) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 27 Nov 2008 05:41:10 +1100 > From: Rick Welykochy <rick(a)praxis.com.au> > Subject: Re: [Koha-devel] Koha PEOPLE Efficiency [WAS: RFC: Koha : > Merge biblio & biblioitems tables] > To: Andrew Moore <andrew.moore(a)liblime.com> > Cc: "koha-devel(a)lists.koha.org" <koha-devel(a)lists.koha.org> > Message-ID: <492D9846.4030504(a)praxis.com.au> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Andrew Moore wrote: > > > On Tue, Nov 25, 2008 at 5:40 PM, Rick Welykochy <rick(a)praxis.com.au> > wrote: > >> <RANT> > >> > >> I am *VERY* concerned about people performance. To wit: > > > > Hi Rick - I'm thankful for your rant. Not only do I agree that we're > > suffering from some technical debt that makes contributions more > > difficult, time consuming, and laborious, but I see notes like yours > > as more of a motivational encouragement than a repetition of old > > arguments. I try to make my new code better than what came before it, > > and to make some of the surrounding code a little better, too. I hope > > you do the same and to help me and others improve. > > [SNIP] > > Thanks Andrew for taking the time to move my <RANT> forwards to suggestions > for some positive action. That is of course what we need here. > > I am taking onboard all of your recommendations ... one could become *very* > busy dipping into all of these pies. I'll see what fits my spare time and > "esprit". > > And I haven't forgotten about your ORM work and suggestions. I just have to > get that darn perl modules installed in a clean install of Koha, which > takes > finding a spare (virtual) host somewhere. > > Hrrmmm ... this brings up another topic: Koha dev environments. > But I'll leave that for another posting. > > > cheers > rickw > > > > -- > _________________________________ > Rick Welykochy || Praxis Services > > You go find out what they need and I'll start coding. > -- two geeks > > > ------------------------------ > > Message: 2 > Date: Wed, 26 Nov 2008 20:03:23 +0100 > From: Wojciech Zatorski <listy-in(a)zatorski.net> > Subject: Re: [Koha-devel] mod_perl > To: Koha-devel <koha-devel(a)lists.koha.org> > Message-ID: <405097270.20081126200323(a)zatorski.net> > Content-Type: text/plain; charset=Windows-1250 > > Hello Joe, > > Wednesday, November 26, 2008, 4:48:56 PM, you wrote: > > JA> Wojciech -- > > JA> Obviously 3 years ago would have been with a 2.2 (or perhaps > JA> earlier?) version of Koha.? Have you upgraded to 3.x under the > JA> same environment? > > yes.. version 2.2.x and no we still using 2.2.x as framework. > > JA> ? Can you also confirm that you have multiple > JA> Koha databases running concurrently on the same server? > > yes on version 2.2.x we have multiple KOHA installation (perl code > shared). > > my $r = Apache2::RequestUtil->request( ); > $conf_fname = $r->dir_config('KOHA_CONF'); > > -- > The Main Library of Szczecin University. > Computerization Department. > http://bg.univ.szczecin.pl > > > > ------------------------------ > > Message: 3 > Date: Thu, 27 Nov 2008 09:12:38 +0100 > From: Paul POULAIN <paul.poulain(a)free.fr> > Subject: Re: [Koha-devel] [RFC ver2 4/4] DBIx::Class - Changes to > C4::Members to start using DBIx::Class > To: "koha-devel(a)lists.koha.org" <koha-devel(a)lists.koha.org> > Message-ID: <492E5676.1070900(a)free.fr> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Rick Welykochy a ?crit : > > Paul POULAIN wrote: > > If by "user" you are referring to the librarian or Koha user, then > > it is up to the Koha application to intercept and process the above > > error if it does happen and take remedial action, i.e. send an indignant > > email to Koha-dev! > > > > Given that you *cannot* create invalid FK relationships in the database, > > I don't see how anything could fail using FK constraints. They are a > > Good Thing (tm) and are required to avoid orphaned child records > > amongst many other things. > > I know what is a FK done for, Rick (and in fact I'm the author of most > of the FK in the DB atm ;-) ) > What is a shame is that the librarian can enter something, enter "OK", > and ... see nothing ... the value hasn't be added due to a FK error, and > nothing on the browser : everything seems OK ! Quite annoying for the > librarian ! > > We can't ask the librarian to look in error.log ! So we need to display > something on the browser, like "Oups, something goes wrong. Ask the Koha > team and specify the following problem : "FK contraint at xxxxx.pm, line > YYY, koha version X.XX.XX.XXX" " > > Fortunatly, those errors are very uncommon, and I think I've seen them > occuring only when a part of the DB has been entered through SQL insert > & not the browser. But we should trap that anyway ! (as we should trap > any SQL error) > > > -- > Paul POULAIN > http://www.biblibre.com > Expert en Logiciels Libres pour l'info-doc > NOUVEAU TELEPHONE : 04 91 81 35 08 > > > ------------------------------ > > _______________________________________________ > Koha-devel mailing list > Koha-devel(a)lists.koha.org > http://lists.koha.org/mailman/listinfo/koha-devel > > > End of Koha-devel Digest, Vol 36, Issue 41 > ****************************************** > -- Dr.J.Vijaya Kumar Engineering College Library Andhra University Visakhapatnam- 530 003 Phones: Res : (0891) 2718711 M : 9440503562 E-Mail Address: kumarjammala(a)gmail.com kumarjammala(a)rediffmail.com jammalamadakavijayakumar(a)yahoo.com

1 0

Re: [Koha-devel] mod_perl (was: DBIx::Class stuff)
by Andrew Moore 26 Nov '08

26 Nov '08

On Sat, Nov 22, 2008 at 7:24 PM, Rick Welykochy <rick(a)praxis.com.au> wrote: > Joshua Ferraro wrote: > >> Speed is definitely a major concern here ... and I believe it's one of >> the reasons that Koha originally wasn't written with an ORM. Andy, any >> thoughts about what this choice will mean w/respect to performance? > > The use of mod_perl would speed things up by an order (and a half) > of magnitude, giving the software more leeway to use abstractions > like an OR mapper. Hi Rick - I've long suspected that Koha could benefit from using mod_perl, too. Do you know of any work done to see if it's possible or what changes would need to be made in order to allow it? Thanks, -Andy

11 19