October 2014 - Koha-bugs - lists.koha-community.org

[Bug 10517] New: kohe-restore fails to create mysqluser@mysql_hostname so zebra update fails
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10517 Bug ID: 10517 Summary: kohe-restore fails to create mysqluser@mysql_hostname so zebra update fails Change sponsored?: --- Product: Koha Version: 3.12 Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Packaging Assignee: koha-bugs(a)lists.koha-community.org Reporter: John.Seymour(a)nal.gov.au CC: robin(a)catalyst.net.nz Created attachment 19284 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=19284&action=edit patch koha-restore kohe-restore fails to create mysqluser@mysql_hostname so zebra update fails. It also attempts to drop the mysqluser which does not exist causing an error. Please find attached an updated version which corrects these problems. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[Bug 8589] New: Advanced Search for itemtype and location produces some results that are not useful
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8589 Priority: P5 - low Change sponsored?: --- Bug ID: 8589 Assignee: gmcharlt(a)gmail.com Summary: Advanced Search for itemtype and location produces some results that are not useful Severity: enhancement Classification: Unclassified OS: All Reporter: melia(a)bywatersolutions.com Hardware: All Status: NEW Version: rel_3_8 Component: Searching Product: Koha When searching for a list of circulating books in New York, I can run a search specifying an item type of "circulating item" and a location of "New York" from Advanced Search. The search returns some results that look like this: Item type Location Call Number Status Book New York 500 GRA (Browse Shelf) Not for loan Book San Francisco 500 GRA (Browse Shelf) Not for loan Circulating item Atlanta 500 GRA (Browse Shelf) Not for loan Circulating item Cleveland 500 GRA (Browse Shelf) Available The last two items are circulating items, and the first item has a location of New York, but there aren't any items that are BOTH circulating AND in New York, so this is not a useful result. -- You are receiving this mail because: You are watching all bug changes.

1 4

[Bug 11223] New: Incorrect ind1 semantics for MARC21 785
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11223 Bug ID: 11223 Summary: Incorrect ind1 semantics for MARC21 785 Change sponsored?: --- Product: Koha Version: 3.12 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: drigney(a)esilibrary.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com The first indicator for MARC21 fields 76x-78x should control whether the entire field displays, not whether the $n subfield displays. To reproduce: view a record that includes a 785 field with indicator 1 set to '1' and the system preference OPACXSLTDetailsDisplay enabled. The 785 field will show up, but according to the standard no display should be generated when 785 indicator 1 is set to '1'. In the MARC21slim2intranetDetail.xsl, MARC21 field 785 are always displayed when present, and indicator 1 is used to determine whether or not to display and 785$n. This was fixed in the opac with bug id 4370. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 10167] New: payment not showing what's paid for if not an item
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10167 Bug ID: 10167 Summary: payment not showing what's paid for if not an item Classification: Unclassified Change sponsored?: --- Product: Koha Version: 3.10 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: nengard(a)gmail.com CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com When paying fines in 3.10.x it shows what was paid for if you pay for an item (something with a barcode). But if you pay for a line that you entered manually without an item it does not say what you paid for. For example: I created a manual invoice for Copier fees and then clicked 'Pay' on the line for the Copier fees and it recorded that as just 'Payment Thanks' instead of 'Payment Thanks - Copier Fees' -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 11164] New: creator_batches table uses borrower_number not borrowernumber?
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11164 Bug ID: 11164 Summary: creator_batches table uses borrower_number not borrowernumber? Change sponsored?: --- Product: Koha Version: 3.10 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Database Assignee: gmcharlt(a)gmail.com Reporter: hbraum(a)nekls.org QA Contact: testopia(a)bugs.koha-community.org The creator_batches table uses borrower_number instead of borrowernumber. All other tables use borrowernumber (discovered when I was looking at http://schema.koha-community.org/columns.byColumn.html#columns) Was this difference intentional? -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 11000] New: koha-restore not working: Koha username error
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11000 Bug ID: 11000 Summary: koha-restore not working: Koha username error Change sponsored?: --- Product: Koha Version: 3.12 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Command-line Utilities Assignee: gmcharlt(a)gmail.com Reporter: pablo.bianchi(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org koha-restore without previously removing the instance give 78 links of "ERROR: File exists:" and that’s more or less expected, but: koha-remove myInstance (OK) Then: koha-restore /var/spool/koha/myInstance/myInstance-2013-09-23.sql.gz /var/spool/koha/myInstance/myInstance-2013-09-23.tar.gz ERROR: File exists: /var/lib/koha/myInstance/ ERROR: File exists: /var/lib/koha/myInstance/.bash_history ERROR: File exists: .... [total 44 lines] ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'koha_myInstance'@'%' DBI connect('dbname=koha_myInstance;host=localhost;port=3306','koha_myInstance',...) failed: Access denied for user 'koha_myInstance'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 803 Access denied for user 'koha_myInstance'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 803. Something went wrong rebuilding biblio indexes for myInstance DBI connect('dbname=koha_myInstance;host=localhost;port=3306','koha_myInstance',...) failed: Access denied for user 'koha_myInstance'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 803 Access denied for user 'koha_myInstance'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 803. Something went wrong rebuilding authority indexes for myInstance [ ok ] Restarting web server: apache2 ... waiting . I fix this just with: GRANT ALL PRIVILEGES ON `koha_myInstance` . * TO 'koha_myInstance'@'localhost'; and running again the previous command, but is very scary to erase and not being able to restore an instance... -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 10946] New: pay fine amout showing negative value
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10946 Bug ID: 10946 Summary: pay fine amout showing negative value Change sponsored?: --- Product: Koha Version: 3.12 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: prajeeshb77(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Created attachment 21443 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=21443&action=edit pay fine negative amount When paying a fine the amount tab showing (under Finetab)negative amount. when we run the report based on the follwing SQL query the result showing negative amounts. SELECT borrowers.cardnumber,borrowers.surname,accountlines.date,accountlines.amount FROM borrowers LEFT JOIN accountlines on (borrowers.borrowernumber=accountlines.borrowernumber) WHERE DATE(timestamp) BETWEEN <<Added BETWEEN (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> AND (accounttype='PAY') is it the problem of Koha or in SQL query. Please help me. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 8511] New: display due date times in AM/PM format rather than 24hr
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8511 Priority: P5 - low Change sponsored?: --- Bug ID: 8511 CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Assignee: koha-bugs(a)lists.koha-community.org Summary: display due date times in AM/PM format rather than 24hr Severity: enhancement Classification: Unclassified OS: All Reporter: melia(a)bywatersolutions.com Hardware: All Status: NEW Version: rel_3_8 Component: Circulation Product: Koha Add another option to the dateformat sys pref to allow libraries to choose how to display the hour portion of the date: AM/PM or 24hr. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 10760] New: Street Number field is missing from the Alternate Address section
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10760 Bug ID: 10760 Summary: Street Number field is missing from the Alternate Address section Change sponsored?: --- Product: Koha Version: 3.12 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: victorp(a)netmedia.com.sg QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com The Street Number field seems to be missing from the Alternate Address section. Peeking into the borrowers table in the Koha database, there is a B_streetnumber field defined but it is not exposed in the Koha GUI interface. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 9706] New: xslt icon for artifacts isn't quite right
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9706 Bug ID: 9706 Summary: xslt icon for artifacts isn't quite right Classification: Unclassified Change sponsored?: --- Product: Koha Version: 3.8 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: nengard(a)gmail.com For the XSLT icons if leader6 = r Then it shows a film image, but that's really 'Three-dimensional artifact or naturally occurring object' which is more like regalia or a statue type icon maybe. -- You are receiving this mail because: You are watching all bug changes.

1 2