May 2008 - Koha-bugs - lists.koha-community.org

[Bug 2084] overdues.pl hangs when much data
by bugzilla-daemon＠pippin.metavore.com 20 May '08

20 May '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2084 rch(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|FIXED | ------- Comment #4 from rch(a)liblime.com 2008-05-19 21:43 ------- This is not fixed. One should not be allowed to run this kind of report on a production server during up hours, imo. At least not without a confirm dialog ( 'This is a processor-intensive report that should not be run on a production server. Click here to continue'). Even better would be to actually fix the query or indexes so we're not copying to tmp table. here's show full processlist after running this report: | 354 | dbadmin | localhost | koha_db | Query | 60732 | Sending data | SELECT GROUP_CONCAT(accountlines.accounttype ORDER BY accountlines.date DESC SEPARATOR ' ') as l_accounttype, GROUP_CONCAT(description ORDER BY accountlines.date DESC SEPARATOR ' ') as l_description, GROUP_CONCAT(round(amountoutstanding,2) ORDER BY accountlines.date DESC SEPARATOR ' ') as l_amountoutstanding, GROUP_CONCAT(accountlines.date ORDER BY accountlines.date DESC SEPARATOR ' ') as l_date, GROUP_CONCAT(accountlines.itemnumber ORDER BY accountlines.date DESC SEPARATOR ' ') as l_itemnumber, count(*) as cnt, max(accountlines.date) as maxdate, round(sum(amountoutstanding),2) as sum_amount, borrowers.borrowernumber as borrowernumber, borrowers.surname as surname, borrowers.firstname as firstname, borrowers.email as email, borrowers.phone as phone, accountlines.itemnumber, description, accountlines.date as accountdate FROM borrowers, accountlines WHERE accountlines.borrowernumber = borrowers.borrowernumber AND accountlines.amountoutstanding <> 0 AND accountlines.borrowernumber IN (SELECT borrowernumber FROM accountlines where borrowernumber >= 0 AND date <= '2008-05-19' GROUP BY accountlines.borrowernumber HAVING sum(amountoutstanding) >= '25' ) AND accountlines.borrowernumber NOT IN (SELECT borrowernumber FROM accountlines where borrowernumber >= 0 AND date < '2007-05-19' GROUP BY accountlines.borrowernumber HAVING sum(amountoutstanding) >= '25' ) GROUP BY accountlines.borrowernumber HAVING sum(amountoutstanding) >= '25' ORDER BY surname, firstname | | 3364 | dbadmin | localhost | koha_db | Sleep | 17 | | NULL the bad one: copying to tmp table :: | 3365 | dbadmin | localhost | koha_db | Query | 17 | Copying to tmp table | SELECT date_due,concat(surname,' ', firstname) as borrower, borrowers.phone, borrowers.email,issues.itemnumber, items.barcode, biblio.title, biblio.author,borrowers.borrowernumber,biblio.biblionumber,borrowers.branchcode FROM issues LEFT JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber ) LEFT JOIN items ON (issues.itemnumber=items.itemnumber) LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=items.biblioitemnumber) LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber ) WHERE 1=1 && date_due<'2008-05-20' ORDER BY date_due,borrower ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 2045] Network Printers Setting Does Nothing?
by bugzilla-daemon＠pippin.metavore.com 20 May '08

20 May '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2045 rch(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|FIXED | ------- Comment #2 from rch(a)liblime.com 2008-05-19 21:23 ------- imo, there is a real reason to remove it. Its presence distracts people from the default behaviour of Koha as a web app. The default behaviour is to print through the browser, as any other web app does. This should only be visible where it is used; without another interface to configure network devices, it makes people think they can configure their printers through Koha, which without customization of the code, they cannot. Any system preference that requires custom coding should not be present without explicit instructions on how to make it work. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 2135] Cannot Delete MARC Records
by bugzilla-daemon＠pippin.metavore.com 20 May '08

20 May '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2135 oleonard(a)myacpl.org changed: What |Removed |Added ---------------------------------------------------------------------------- Platform|PC |All Version|unspecified |HEAD ------- Comment #3 from oleonard(a)myacpl.org 2008-05-19 18:21 ------- I'm now guessing you couldn't delete the record because there were items attached? There are some conflicting things going on in the template: The action on the menu item is disabled because there is an item count. The menu item doesn't look disabled because of a style conflict. There also some javascript that ran before we had the template disable the menu item altogether: Before, clicking 'delete' would give you a js alert that said "There are X item(s) attached to this record.You must delete all items before deleting this record." You never see this now because the menu item is disabled. So: Is it enough to see the "delete" link is greyed out? Does that make it clear you can't delete (but still not know why)? Is it better to try the delete and get a full explanation? Or both: looks disabled, and when you click you get the message? ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1976] Home>Cataloguing New Record does not visbily expand
by bugzilla-daemon＠pippin.metavore.com 20 May '08

20 May '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1976 ------- Comment #5 from jmf(a)liblime.com 2008-05-19 18:18 ------- Did you install the mandatory and optional frameworks? ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 2078] RSS Icon on OPAC
by bugzilla-daemon＠pippin.metavore.com 20 May '08

20 May '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2078 jmf(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|minor |major ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1958] Amazon reviews include HTML tags
by bugzilla-daemon＠pippin.metavore.com 20 May '08

20 May '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1958 jmf(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Comment #1 from jmf(a)liblime.com 2008-05-19 18:17 ------- Fixed ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1990] patron image upload should scale images
by bugzilla-daemon＠pippin.metavore.com 20 May '08

20 May '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1990 jmf(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Comment #1 from jmf(a)liblime.com 2008-05-19 18:07 ------- done, uses image magick ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 2007] add additional ID fields to borrower record
by bugzilla-daemon＠pippin.metavore.com 20 May '08

20 May '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2007 jmf(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Comment #1 from jmf(a)liblime.com 2008-05-19 18:07 ------- This has been solved with the new Patron Attributes feature. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1007] Add additional functionality to inventory
by bugzilla-daemon＠pippin.metavore.com 20 May '08

20 May '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1007 jmf(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Add fonctions for inventory |Add additional functionality | |to inventory ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1656] Internationalisation of Nomenclature
by bugzilla-daemon＠pippin.metavore.com 20 May '08

20 May '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1656 jmf(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID ------- Comment #1 from jmf(a)liblime.com 2008-05-19 18:02 ------- Solution here is to create translations for each language and extension set, but the templates needs to stabilize or this will be a maddening process for a translator. Marking INVALID as there's already a solution to this issue. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0