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

Koha Day - CGI::Carp error handling
by Mason James 02 Oct '07

02 Oct '07

Hi Koha-Devel, There has been a little talk recently on the koha-devel list about error handling in Koha. Chris and I spent some time on Friday(nz time) to work out a relatively small and tidy way, using CGI::Carp, to trap and redirect most runtime errors in Koha to the user's browser. We have made a System-Preference called DebugLevel, that has currently 3 values 0, 1 and 2. (more?) something like... ??? 0 is Quiet - For production 1 is Developer - For debugging 2 is Logging - Bug reporting , and additional package version info too, like Apache, MySQL, Perl,YAZ, Z9350::ZOOM MARC::Record/Charset.... The CGI::Carp stuff has been added near the start of Output.pm, so it's set up nice and early to handle (and output) any later errors. I committed the CGI::Carp stuff to dev_week, but if people like the idea, I'll commit it to rel_3 too... Here is the commit to Output.pm below. http://cvs.savannah.nongnu.org/viewvc/koha/C4/Output.pm? root=koha&r1=1.51.2.2.2.1&r2=1.51.2.2.2.2&pathrev=dev_week Using CGI::Carp with the DebugLevel syspref at '2', Koha now handles this example script's syntax error. ---------------------------------- #!/usr/bin/perl use C4::Output; ndjsnsjkcndjkscndjskcndjks exit; ------------------------------------ And sends Perl's error message back to he user's browser for either debugging further, or perhaps attaching to a bug report, or to the bottom of a koha-devel list email. Like this below.... ---------------------------------- debug level 2 Got an error: syntax error at /koha/dev_week/intranet/cgi-bin/misc/ carp_test.pl line 6, near "ndjsnsjkcndjkscndjskcndjks exit" Execution of /koha/dev_week/intranet/cgi-bin/misc/carp_test.pl aborted due to compilation errors. Koha 2.2.8 Perl 5.008008 MySQL mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 OS Linux arwen.metavore.com 2.6.18-4-686 #1 SMP Mon Mar 26 17:17:36 UTC 2007 i686 GNU/Linux Apache Server version: Apache/2.2.3 Server built: Jun 17 2007 20:24:06 ---------------------------------- How does this sound, Any improvements suggestions or corrections? Cheers, Mason -- Mason James mason.james(a)liblime.com Programmer www.liblime.com LibLime +64 21 542 117

3 5

need for non-SQL in updater : got it !!!
by Paul POULAIN 01 Oct '07

01 Oct '07

Kados & slef, Slef asked me "could you give me an example of something that can't be ruled only by SQL during update". I answered I had found one, but could not remember it. I have got it now ! When dealing with something that depends on language and/or MARC flavour. For example, I want to add a systempref for Reserve behaviour (to fix http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1416) If langage is french, i'll add something, otherwise i'll add something else. I add it now, but i'm afraid I won't have time to commit before the end of the day (need to merge to official branch, fix errors and send patch) -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19

2 1

OO-RDB mapper
by Rick Welykochy 01 Oct '07

01 Oct '07

Have the Koha developers given any thought to recoding the raw DBI calls in Koha with an OO-RDB mapper? There are a number of them available on CPAN. I've written these things, at varying levels of complexity and completeness, in the past and the advantages are numerous: (*) separate the Perl code from the SQL (*) rows in tables are represented by objects so no more errors like this: $row->{naem} -- instead: $row->name (*) the abstraction layer of an OO-RDB mapper can provide 99% database driver independence; Koha could suddenly be supported by MYSQL, Postgresql, oracle, sqlite, etc.etc. (*) the abstraction layer allows application-level hooks to be installed *anywhere* in the RDB transcation process and total global control of RBD operations is suddenly available (instead of scanning/editing 1000's of lines of source code to make a basic functional RDB change) (*) audit logging can be automated; all insert, updates and deletes can be caught in the abstraction layer -- do what you want with them (*) updating a row in a table becomes foolproof: $row = OORDB->fetch(criteria); $row->name("new name'); $row->debt(undef); $row->commit; The list of advantages does go on and on. cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Q: What's the difference between a software sales person and a car sales person? A: With a car sales person there is a slight chance that he actually knows how to drive.

2 1

KohaLa New Item
by Russel Garlick 28 Sep '07

28 Sep '07

Hi Everyone, I have added a news item about the upcoming KohaLa meeting to the Koha site. http://www.koha.org/about-koha/news/nr1190752450.html (Thanks to MJ for translating the french mailing list posts). If anyone has more to add to the press release, then please feel free to contact me off list. Cheers, Russel -- Russel Garlick russel.garlick(a)liblime.com General Manager - Australasia +64 21 542 188 LibLime Limited www.liblime.com

5 6

NZOSA Awards
by Russel Garlick 26 Sep '07

26 Sep '07

Hi all, Just to let you all know that Chris and Koha have both been nominated as finalists in the inaugural New Zealand Open Source Awards. I think Chris' nomination as a Contributor is fantastic recognition of all his hard work over the years. For more info see : http://www.koha.org/about-koha/news/ nr1190767600.html Congrats to Chris, and thanks to all of you who sent through nominations. Cheers, Russel -- Russel Garlick russel.garlick(a)liblime.com General Manager - Australasia +64 21 542 188 LibLime Limited www.liblime.com

1 0

More complete patron renew process
by Owen Leonard 21 Sep '07

21 Sep '07

Right now the method for renewing a patron (updating their expiration date), is a javascript: link that upon confirmation redirects back to moremember.pl with a reregistration=y parameter. In order to make this possible without javascript, the logical thing to do would be to make it a real URL: <a href="/cgi-bin/koha/members/moremember.pl?reregistration=y&borrowernumber=" onclick="confirm_reregistration(); return false;">Renew</a> This should work fine, but leaves out the confirmation step. Is the confirmation necessary? Also: Should there be feedback passed back to moremember.pl to let the user know that the patron's expiration date has been updated? Right now a bug prevents the expiration date from even showing up on moremember.pl after the renewal link has been clicked, but even with that bug fixed perhaps there should be a message: "This account has been renewed until xxxx-xx-xx" That's probably doable in the template alone. Is there ever a time when a renewal will fail? Should there be code for passing such an error back to the screen? -- Owen

1 0

I solicit to participate in the development of koha and to contribute
by Roxana Luz Fleipaz 20 Sep '07

20 Sep '07

Hello to all the companions of Hispanic speech. I communicate to suggest to the community on the existence of the readaptado Koha and that this working very well apparently. The contact and author are Chrsitian Jhonny Jahuira Street. They can see its access and characteristic in: http://kantaita.blogspot.com Koha-Bolivia The best thing of this is than I recibi a gratuitous copy of of this system and I am it perfectly. The mail of Chrsitian J. Jahuira Street is: christianjcj(a)gmail.com Now I am publicitando it. I hope serves east message A Warm greeting Roxana Luz F. Hola a todos los compañeros de habla hispana.. Me comunico para sugerir a la comunidad sobre la existencia del Koha readaptado y que esta funcionando muy bien al parecer. El contacto y autor es Chrsitian Jhonny Calle Jahuira. Pueden ver su acceso y caracteristicas en: http://kantaita.blogspot.com Koha-Bolivia Lo mejor de esto es que yo recibi una copia gratuita de de este sistema y lo estoy perfectamente. El correo de Chrsitian J. Calle Jahuira es: christianjcj(a)gmail.com Ahora lo estoy publicitando. Espero sirva este mensaje Un saludo Cordial Roxana Luz F.

2 1

System pref search
by Owen Leonard 20 Sep '07

20 Sep '07

A long time ago the System Preferences page had a search form: <form action=/cgi-bin/koha/admin/systempreferences.pl method=post> <input type=text name=searchfield value=""> <input type=reset name=reset value="clr"> </form> I'm assuming it worked at some point, but at some point it stopped, and now the form isn't in the template anymore. Is the search handling stuff still in the script? Can someone take a look at see if it can be revivied? Thanks, Owen

2 2

Notices (Letters) and Overdues
by Joshua M. Ferraro 19 Sep '07

19 Sep '07

Hi folks, I spent a few minutes today trying to figure out the new 'Letters' feature in 3.0. First, I renamed it to 'Notices' in the English. Specifically, I'm wondering how to get what appears to be the start of a nice workflow engine to actually work. I'm referring to /cgi-bin/koha/tools/overduerules.pl It appears like it should allow you to set up triggers for sending specific notices, and setting patron statuses upon certain events. There doesn't appear to be a form that can be filled out. Does it require some specific inputs be filled out beforehand? Are there a set of back-end cron utilities to support this stuff? Any light anyone can shed would be greatly appreciated. Thanks, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

1 0

Una readaptacion util de koha para latinos
by Roxana Luz Fleipaz 14 Sep '07

14 Sep '07

Hola a todos los compañeros de habla hispana.. Me comunico para sugerir a la comunidad sobre la existencia del Koha readaptado y que esta funcionando muy bien al parecer. El contacto y autor es Chrsitian Jhonny Calle Jahuira. Pueden ver su acceso y caracteristicas en: http://kantaita.blogspot.com Koha-Bolivia Lo mejor de esto es que yo recibi una copia gratuita de de este sistema y lo estoy perfectamente. El correo de Chrsitian J. Calle Jahuira es: christianjcj(a)gmail.com Ahora lo estoy publicitando. Espero sirva este mensaje Un saludo Cordial Roxana Luz F.

1 0