March 2011 - Koha-bugs - lists.koha-community.org

[Bug 3315] Aggregate SQL clauses break pagination in guided reports
by bugzilla-daemon＠bugs.koha-community.org 28 Mar '11

28 Mar '11

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3315 --- Comment #2 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> 2011-03-28 10:22:47 UTC --- I think I found the place in the code, but I get lost trying to understand it: guided_reports.pl 487 my $total = select_2_select_count_value($sql) || 0; Guided.pm 402 sub select_2_select_count_value ($) { 403 my $sql = shift or return; 404 my $countsql = select_2_select_count($sql); 405 $debug and warn "original query: $sql\ncount query: $countsql\n"; 406 my $sth1 = C4::Context->dbh->prepare($countsql); 407 $sth1->execute(); 408 my $total = $sth1->fetchrow(); 409 $debug and warn "total records for this query: $total\n"; 410 return $total; 411 } 412 sub select_2_select_count ($) { 413 # Modify the query passed in to create a count query... (I think this covers all cases -crn) 414 my ($sql) = strip_limit(shift) or return; 415 $sql =~ s/\bSELECT\W+(?:\w+\W+){1,}?FROM\b|\bSELECT\W\*\WFROM\b/SELECT count(*) FROM /ig; 416 return $sql; 417 } Is there perhaps a better way to find out the number of results of a sql query? -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 0

[Bug 4018] Coins support problems and xslt
by bugzilla-daemon＠bugs.koha-community.org 28 Mar '11

28 Mar '11

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4018 Chris Cormack <chris(a)bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |5584 Patch Status|--- |Needs Signoff -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 0

[Bug 4276] "Related subjects" search doesn't work with XSLT on and chained subject terms
by bugzilla-daemon＠bugs.koha-community.org 27 Mar '11

27 Mar '11

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4276 Chris Cormack <chris(a)bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Signed Off |Patch Pushed --- Comment #7 from Chris Cormack <chris(a)bigballofwax.co.nz> 2011-03-27 20:56:44 UTC --- Pushed please test -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 0

[Bug 4393] Searching with scan indexes and sort by title fails
by bugzilla-daemon＠bugs.koha-community.org 27 Mar '11

27 Mar '11

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4393 Jared Camins-Esakov <jcamins(a)cpbibliography.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jcamins(a)cpbibliography.com AssignedTo|gmcharlt(a)gmail.com |jcamins(a)cpbibliography.com -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 0

[Bug 5954] New: 490$a not placed in link to search serials when XSLT defined
by bugzilla-daemon＠bugs.koha-community.org 27 Mar '11

27 Mar '11

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5954 Bug #: 5954 Summary: 490$a not placed in link to search serials when XSLT defined Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_2 Platform: All OS/Version: All Status: NEW Severity: minor Priority: P5 Component: MARC Bibliographic data support AssignedTo: gmcharlt(a)gmail.com ReportedBy: ruth(a)bywatersolutions.com QAContact: koha-bugs(a)lists.koha-community.org CC: ian.walls(a)bywatersolutions.com In both intranet and OPAC XSLT, if a record contains a (now MARC-standard) 490 instead of the (now obsolete) 440, the series search link in the biblio detail page uses (the undefined-in-MARC) $t to create the link to search in serials, rather than the $a, which is what it is correctly displaying. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 5

[Bug 1962] Add fine notification during check-in
by bugzilla-daemon＠bugs.koha-community.org 27 Mar '11

27 Mar '11

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1962 Chris Cormack <chris(a)bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Signed Off |Patch Pushed --- Comment #15 from Chris Cormack <chris(a)bigballofwax.co.nz> 2011-03-27 08:20:36 UTC --- Pushed, please test -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 0

[Bug 3670] Why is DUE all caps on enhanced messages
by bugzilla-daemon＠bugs.koha-community.org 27 Mar '11

27 Mar '11

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3670 Chris Cormack <chris(a)bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Signed Off |Patch Pushed --- Comment #10 from Chris Cormack <chris(a)bigballofwax.co.nz> 2011-03-27 08:20:31 UTC --- Follow up patch pushed, test -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 0

[Bug 1962] Add fine notification during check-in
by bugzilla-daemon＠bugs.koha-community.org 26 Mar '11

26 Mar '11

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1962 Nicole C. Engard <nengard(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Needs Signoff |Signed Off -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 0

[Bug 1962] Add fine notification during check-in
by bugzilla-daemon＠bugs.koha-community.org 26 Mar '11

26 Mar '11

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1962 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Patch Pushed |Needs Signoff -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 0

[Bug 1962] Add fine notification during check-in
by bugzilla-daemon＠bugs.koha-community.org 26 Mar '11

26 Mar '11

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1962 --- Comment #14 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> 2011-03-26 19:03:27 UTC --- Created attachment 3438 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=3438 Patch adding new syspref FineNotifyAtCheckin This patch adds a new syspref FineNotifyAtCheckin. With syspref ON there will be a message when checking in books from a patron with outstanding fines. With syspref OFF (default) no message will be shown. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 0