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

an interesting idea
by Pat Eyler 01 Apr '03

01 Apr '03

(see http://www.perl.com/lpt/a/2002/10/22/phrasebook.html http://use.perl.org/~gnat/journal/11285 http://use.perl.org/~djberg96/journal/11291 for more info) I just ran across a set of articles that triggered some thinking for me. The basic idea is that we could create a phrasebook of (templated) SQL queries external to the normal modules and scripts. Whenever we need to use a specific query we can slurp it out of the phrasebook, fill in the variables, and run it. I think this might win in two ways: 1) it will be easier to maintain/improve the SQL queries if they're not strewn about in the code 2) we can work at translating the queries into other (nonMySQL) dialects of SQL if we ever decide to support them. The same tool *might* also help us maintain translations internal to our scripts (as opposed to things we've already used HTML::Template for). There might be stickiness in a couple of areas too. The biggest one that I see is that we'll have to be very careful not to break the API presented by a query (i.e., what variables it requires, what data it passes back) -- This is an excellent place for unit tests to help us. any other thoughts? -pate Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org

3 6

Internal Server Error on 1.90
by Ingrid Lacis 01 Apr '03

01 Apr '03

I don't know if this is a bug or an error on our part. In version 1.90, librarian interface, I do a search (Advanced Search) and get a list of books returned to me. /cgi-bin/koha/search.pl I click on the title and I get: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. The error log says: Tag " " is not a valid tag. at /usr/local/share/perl/5.6.1/MARC/Record.pm line 535 [Fri Mar 28 10:51:48 2003] [error] [client 192.168.0.123] Premature end of script headers: /usr/local/koha-unstable/intranet/cgi-bin/MARCdetail.pl Thanks, Ingrid _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

2 1

RE: [Koha-devel] an interesting idea
by Christensen, David A. (CHT) 31 Mar '03

31 Mar '03

Hi Al, Could you send me a copy of that as well? Thanks, David Christensen Technical Consultant Manitoba Public Library Services > -----Original Message----- > From: Al Banks [SMTP:abanks@buscominc.com] > Sent: 2003-Mar-31 7:52 AM > To: MJ Ray > Cc: koha-devel(a)lists.sourceforge.net > Subject: Re: [Koha-devel] an interesting idea > > Mark, > I've started on a PostgreSQL port of the database, but have run into > some 'real life' e.g. big project due this week. Hopefully, I'll get > back to it soon, and I'll send you a copy of the config. > > Thanks! > -Al > > > On Sat, 2003-03-29 at 08:26, MJ Ray wrote: > > Pat Eyler <pate(a)eylerfamily.org> wrote: > > > 2) we can work at translating the queries into other (nonMySQL) > dialects > > > of SQL if we ever decide to support them. > > > > Is this not still intended to be so? I would be interested in working > > on translation to postgresql. Indeed, this is part of my reason for > > subscribing to this list. It is possible to translate MySQL software > > to other SQLs, but not always the other way, it seems. At the moment, > > I have to run multiple DBMSs and that is rather annoying. > -- > Al Banks <abanks(a)buscominc.com>

2 1

[Bug 245] New: No mechanism provided for changing the Locations
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Mar '03

30 Mar '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=245 Summary: No mechanism provided for changing the Locations Product: Koha Version: CVS Platform: PC Status: NEW Severity: normal Priority: P2 Component: Parameters AssignedTo: paul.poulain(a)free.fr ReportedBy: mwhansen(a)hmc.edu QAContact: koha-devel(a)lists.sourceforge.net There should be some sort of way for the user to change the Locations presented at the memberentry page. This would most likely consist of add a table to the database and providing some page under system parameters / koha admin to allow them to add/edit/delete locations. I am not sure how we would deal with the deletion of locations that members are already assigned to, but it is an issue we probably need to deal with. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 237] Can request to reserve a book with an end reserve date in the past.
by bugzilla-daemon＠wilbur.katipo.co.nz 29 Mar '03

29 Mar '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=237 ------- Additional Comments From chris(a)katipo.co.nz 2003-03-29 16:56 ------- Which template set are you using? In the vanilla templates I dont seem to get the option to choose end reserve date ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 244] stats.pl needs to be templated
by bugzilla-daemon＠wilbur.katipo.co.nz 28 Mar '03

28 Mar '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=244 mwhansen(a)hmc.edu changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 244] stats.pl needs to be templated
by bugzilla-daemon＠wilbur.katipo.co.nz 28 Mar '03

28 Mar '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=244 mwhansen(a)hmc.edu changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Dual Log-Ins Showing in Till|stats.pl needs to be |Reconciliations |templated ------- Additional Comments From mwhansen(a)hmc.edu 2003-03-29 13:07 ------- This is happening because stats.pl includes reports-top.tmpl via startmenu() in C4::Output. The browser does not know how to handle the <TMPL> tags and so it ignores them -- what you end up with is the HTML in both the <TMPL_IF> and and in the <TMPL_ELSE> tag. This will be resolved when stats.pl gets templated. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 234] The buildrelease script or the installer script does not know how do deal with theme's images
by bugzilla-daemon＠wilbur.katipo.co.nz 28 Mar '03

28 Mar '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=234 mwhansen(a)hmc.edu changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Images missing on MARC tag |The buildrelease script or |structure admin page |the installer script does | |not know how do deal with | |theme's images ------- Additional Comments From mwhansen(a)hmc.edu 2003-03-29 12:35 ------- This is not a bug with any of the code. What is happening is that the 'default/images' folder in koha/koha-tmpl/intranet-tmpl/ is not being copied to its place in the install location under intranet/htdocs/ . I am not sure if this is a problem in the installer or in the buildrelease script or a combination of both. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 244] New: Dual Log-Ins Showing in Till Reconciliations
by bugzilla-daemon＠wilbur.katipo.co.nz 28 Mar '03

28 Mar '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=244 Summary: Dual Log-Ins Showing in Till Reconciliations Product: Koha Version: 1.9.0 Platform: PC OS/Version: Linux - Debian Status: NEW Severity: normal Priority: P2 Component: Reports AssignedTo: paul.poulain(a)free.fr ReportedBy: Ilacis(a)chillco.com QAContact: koha-devel(a)lists.sourceforge.net /cgi-bin/koha/stats.pl?time=yesterday /cgi-bin/koha/stats.pl?time=today Logged in as: [Log Out Log In to Koha ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 235] Koha login link listed twice and I'm already logged in
by bugzilla-daemon＠wilbur.katipo.co.nz 28 Mar '03

28 Mar '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=235 mwhansen(a)hmc.edu changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0