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

[Bug 11010] Useless column purchaseordernumber in aqorders table
by bugzilla-daemon＠bugs.koha-community.org 06 Feb '24

06 Feb '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11010 Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=36002 -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 11010] Useless column purchaseordernumber in aqorders table
by bugzilla-daemon＠bugs.koha-community.org 06 Feb '24

06 Feb '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11010 Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |m.de.rooy(a)rijksmuseum.nl --- Comment #5 from Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> --- (In reply to Jonathan Druart from comment #4) > Since bug 4456 will use this field, this bug report is invalid. Bug 4456 died prematurely. I opened 36002 to resurrect removal of this confusing column. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 35074] New: Add --patron_category to writeoff_debts.pl
by bugzilla-daemon＠bugs.koha-community.org 06 Feb '24

06 Feb '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35074 Bug ID: 35074 Summary: Add --patron_category to writeoff_debts.pl Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs(a)lists.koha-community.org Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz Depends on: 27049 It would be helpful to allow limiting by patron category in the writeoff_debts script. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27049 [Bug 27049] Add a script to bulk writeoff debts -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 26

[Bug 35999] New: Incorrect warning about "Port" when creating a new Z39.50 server
by bugzilla-daemon＠bugs.koha-community.org 06 Feb '24

06 Feb '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35999 Bug ID: 35999 Summary: Incorrect warning about "Port" when creating a new Z39.50 server Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: jonathan.druart+koha(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Depends on: 11795 "Port: Please add amount in valid format: 0.00 Required" Port is a number, not an amount. To recreate: Go to http://localhost:8081/cgi-bin/koha/admin/z3950servers.pl?op=add&type=zed Type "foo" for "Port" Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11795 [Bug 11795] Use validation plugin when creating new Z39.50 server -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 0

[Bug 11795] Use validation plugin when creating new Z39.50 server
by bugzilla-daemon＠bugs.koha-community.org 06 Feb '24

06 Feb '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11795 Jonathan Druart <jonathan.druart+koha(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |35999 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35999 [Bug 35999] Incorrect warning about "Port" when creating a new Z39.50 server -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 31732] New: 880 titles missing from OPAC checkout summary
by bugzilla-daemon＠bugs.koha-community.org 06 Feb '24

06 Feb '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31732 Bug ID: 31732 Summary: 880 titles missing from OPAC checkout summary Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: dcook(a)prosentient.com.au QA Contact: testopia(a)bugs.koha-community.org We're showing 880 $6245 values on the search results and the detail page, so we should show them on the OPAC user checkout summary page too. -- You are receiving this mail because: You are watching all bug changes.

1 6

[Bug 14180] Make "Always show checkouts immediately" a global setting
by bugzilla-daemon＠bugs.koha-community.org 05 Feb '24

05 Feb '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14180 --- Comment #30 from Lucas Gass <lucas(a)bywatersolutions.com> --- (In reply to Andrew Fuerste-Henry from comment #29) > This looks like maybe it should have been set to Signed Off when Kelly > tested it 1/26. As of today, the patch doesn't apply. Due to patches from Bug 35506 being pushed to master. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 35998] New: Add the ability to email a patron invoice
by bugzilla-daemon＠bugs.koha-community.org 05 Feb '24

05 Feb '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35998 Bug ID: 35998 Summary: Add the ability to email a patron invoice Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: esther.melander(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com The transactions tab on a patron account currently has the ability to print an invoice. It would be nice to add the ability to email a patron invoice. This would be useful in many settings, but especially an academic setting. A use case exists where students may not be physically on the campus and have to be billed for charges via email. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 0

[Bug 35966] New: Koha should not strip limits from SQL queries
by bugzilla-daemon＠bugs.koha-community.org 05 Feb '24

05 Feb '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35966 Bug ID: 35966 Summary: Koha should not strip limits from SQL queries Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: andrewfh(a)dubcolib.org QA Contact: testopia(a)bugs.koha-community.org CC: nick(a)bywatersolutions.com Koha removes LIMIT from queries in some cases, which can cause incorrect results. For example, consider this report to give the 5 oldest items in the collection, sorted into callnumber order: SELECT * FROM ( SELECT itemnumber, cn_sort, dateaccessioned FROM items ORDER BY dateaccessioned LIMIT 5 ) foo ORDER BY cn_sort That query should get all the items, put them in dateaccessioned order, drop all but the first 5, and then put those 5 in cn_sort order. But Koha processes that by dropping the LIMIT and then re-applying it at the end: SELECT * FROM ( SELECT itemnumber, cn_sort, dateaccessioned FROM items ORDER BY dateaccessioned ) foo ORDER BY cn_sort LIMIT 5 That makes the query get all the items, put them in dateaccessioned order, then put them in cn_sort order, then drop all but the first 5. It changes the query hugely. It only does this in queries without a WHERE, so that first query can be made to work by editing it to: SELECT * FROM ( SELECT itemnumber, cn_sort, dateaccessioned FROM items ORDER BY dateaccessioned LIMIT 5 ) foo WHERE 1=1 ORDER BY cn_sort -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 35995] New: Real time holds queue jobs for the same record should run in serial, never parallel
by bugzilla-daemon＠bugs.koha-community.org 05 Feb '24

05 Feb '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35995 Bug ID: 35995 Summary: Real time holds queue jobs for the same record should run in serial, never parallel Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com As described in bug 34596 there are times when multiple jobs to rebuild the holds queue for a single job will run where the first job as the last to execute ( or at least the last to finish ). We need to force these jobs to run in serial, and only the newest job for a given record *needs* to run, older jobs can exit early. To this end, I propose a "holds queue job lock" table. The table will have rows for the record id, and the timestamp of job initiation. When a job begins processing, it will attempt to insert a row into this table. If that insert succeeds, the job will process then remove the lock from the table. If the insert fails, it means another job has already written a lock. The blocked job can then read the row in the table. If the queued time for the job that got the lock is newer than the time queued for the blocked job that is checking it, that job can exit as it is obsolete. If the queue time for the job that got the lock is older than the time queue for the blocked job, that job needs to reinsert itself into the job queue before exiting so it may try again in the future. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 0