January 2015 - Koha-bugs - lists.koha-community.org

[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

[Bug 8661] New: break out additional authors in opac like in staff
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8661 Priority: P5 - low Change sponsored?: --- Bug ID: 8661 Assignee: oleonard(a)myacpl.org Summary: break out additional authors in opac like in staff Severity: minor Classification: Unclassified OS: All Reporter: nengard(a)gmail.com Hardware: All Status: NEW Version: rel_3_8 Component: OPAC Product: Koha Created attachment 11718 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11718&action=edit staff display When XSLT is on the additional authors show next to 'by' on the OPAC and next to 'additional authors' in the staff client. They should be next to 'additional authors' in the OPAC as well. -- You are receiving this mail because: You are watching all bug changes.

1 37

[Bug 10518] New: Relevance option for non-Latin scripts
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10518 Bug ID: 10518 Summary: Relevance option for non-Latin scripts Change sponsored?: --- Product: Koha Version: 3.8 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: gmcharlt(a)gmail.com Reporter: tigran(a)flib.sci.am In Koha system (versions 3.08, 3.10, 3.12) for multi script records (e.g. titles are in Latin, in Cyrillic, in Armenian)after search, when from relevance drop down menu selecting 'Title (A-Z)' the display for non-Latin records is not in correct order. If for Latin records they are displayed in correct alphabetical order, Armenian and Cyrillic records are mixed, between the records with Armenian titles starting with the letter 'A' you can see records for which the title is starting with the letters 'M', 'H', then again 'A', then Cyrillic records are coming, and after those again records with Armenian letters. Is this a Zebra problem? Any ideas? thanks Tigran -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 10397] New: link_bibs_to_authorities.pl fails when gets to bibs linked to deleted authority records
by bugzilla-daemon＠bugs.koha-community.org 06 Jan '15

06 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10397 Bug ID: 10397 Summary: link_bibs_to_authorities.pl fails when gets to bibs linked to deleted authority records Classification: Unclassified Change sponsored?: --- Product: Koha Version: 3.10 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: danielle(a)bywatersolutions.com CC: m.de.rooy(a)rijksmuseum.nl When running the link_bibs_to_authorities.pl script it fails when it encounters bibs linked to deleted authorities in subfield $9. -- You are receiving this mail because: You are watching all bug changes.

1 1