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

[Bug 23267] New: Database change from bug 9834 breaks database update from older versions
by bugzilla-daemon＠bugs.koha-community.org 05 Jul '19

05 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23267 Bug ID: 23267 Summary: Database change from bug 9834 breaks database update from older versions Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: Database Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org Depends on: 9834 Mirko posted on bug 9834: (In reply to Mirko Tietgen from comment #21) > I assume this breaks upgrading the Koha DB schema at DB revision 16.12.00.032 > > >[…] > >Upgrade to 16.12.00.030 done (Bug 16344 - Add a circ rule to limit the auto renewals given a specific date) > >Upgrade to 16.12.00.031 done (Bug 15108: OAI-PMH provider improvements) > >DBD::mysql::st execute failed: Unknown column 'me.item_level_hold' in 'field list' [for Statement "SELECT `me`.`reserve_id`, `me`.`borrowernumber`, `me`.`reservedate`, `me`.`biblionumber`, `me`.`branchcode`, `me`.`notificationdate`, `me`.`reminderdate`, `me`.`cancellationdate`, `me`.`reservenotes`, `me`.`priority`, `me`.`found`, `me`.`timestamp`, `me`.`itemnumber`, `me`.`waitingdate`, `me`.`expirationdate`, `me`.`lowestPriority`, `me`.`suspend`, `me`.`suspend_until`, `me`.`itemtype`, `me`.`item_level_hold` FROM `reserves` `me` WHERE ( ( `found` = ? AND `priority` = ? ) )" with ParamValues: 0='W', 1=0] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. > >DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.item_level_hold' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 209 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9834 [Bug 9834] Reverting a waiting hold should lead to the former hold type (item or biblio level) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 9834] Reverting a waiting hold should lead to the former hold type (item or biblio level)
by bugzilla-daemon＠bugs.koha-community.org 05 Jul '19

05 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9834 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |23265 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23265 [Bug 23265] Update to DB revision 16.12.00.032 fails: Unknown column 'me.item_level_hold' -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 9834] Reverting a waiting hold should lead to the former hold type (item or biblio level)
by bugzilla-daemon＠bugs.koha-community.org 05 Jul '19

05 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9834 --- Comment #22 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- (In reply to Mirko Tietgen from comment #21) > I assume this breaks upgrading the Koha DB schema at DB revision 16.12.00.032 > > >[…] > >Upgrade to 16.12.00.030 done (Bug 16344 - Add a circ rule to limit the auto renewals given a specific date) > >Upgrade to 16.12.00.031 done (Bug 15108: OAI-PMH provider improvements) > >DBD::mysql::st execute failed: Unknown column 'me.item_level_hold' in 'field list' [for Statement "SELECT `me`.`reserve_id`, `me`.`borrowernumber`, `me`.`reservedate`, `me`.`biblionumber`, `me`.`branchcode`, `me`.`notificationdate`, `me`.`reminderdate`, `me`.`cancellationdate`, `me`.`reservenotes`, `me`.`priority`, `me`.`found`, `me`.`timestamp`, `me`.`itemnumber`, `me`.`waitingdate`, `me`.`expirationdate`, `me`.`lowestPriority`, `me`.`suspend`, `me`.`suspend_until`, `me`.`itemtype`, `me`.`item_level_hold` FROM `reserves` `me` WHERE ( ( `found` = ? AND `priority` = ? ) )" with ParamValues: 0='W', 1=0] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. > >DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.item_level_hold' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 209 Filed a new bug for this: bug 23267 -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 9834] Reverting a waiting hold should lead to the former hold type (item or biblio level)
by bugzilla-daemon＠bugs.koha-community.org 05 Jul '19

05 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9834 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |23267 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23267 [Bug 23267] Database change from bug 9834 breaks database update from older versions -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 6815] Capture member photo via webcam
by bugzilla-daemon＠bugs.koha-community.org 05 Jul '19

05 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6815 Mason James <mtj(a)kohaaloha.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mtj(a)kohaaloha.com -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 6815] Capture member photo via webcam
by bugzilla-daemon＠bugs.koha-community.org 05 Jul '19

05 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6815 M. Tompsett <mtompset(a)hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|In Discussion |Needs Signoff -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug.

1 0

[Bug 6815] Capture member photo via webcam
by bugzilla-daemon＠bugs.koha-community.org 05 Jul '19

05 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6815 M. Tompsett <mtompset(a)hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #91302|0 |1 is obsolete| | --- Comment #29 from M. Tompsett <mtompset(a)hotmail.com> --- Created attachment 91303 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=91303&action=ed… Bug 6815: Add a 'Take Patron Image' ability This does not just click in place, which would be nice. But it does take the picture, download to a file, and then let's the user use the existing upload functionality to add the photo. If wording or formating is ugly, feel free to tweak. TEST PLAN --------- 1) the 'patronimages' system preference in Patrons system preferences must be set to 'Allow'. 2) apply the patch 3) go to any patron 4) click the 'Take' button. -- it is in the text area on the right, and not the hover over the image area. Adding here would require CSS changes, which are now difficult and ugly to do. -- new tab should open. If you have a working webcam, you should see it playing 'live'. 5) click the "Take the Patron's Picture" button -- this should download a photo SamplePhoto.jpg or some variation of that. 6) close this tab, and click the 'Edit' or 'Add' button for the patron image. 7) click 'Choose File' and choose the file that was created 8) click 'Upload' -- the webcam photo should now be used. 9) run koha qa test tools -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug.

1 0

[Bug 6815] Capture member photo via webcam
by bugzilla-daemon＠bugs.koha-community.org 05 Jul '19

05 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6815 M. Tompsett <mtompset(a)hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #38518|0 |1 is obsolete| | --- Comment #28 from M. Tompsett <mtompset(a)hotmail.com> --- Created attachment 91302 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=91302&action=ed… Bug 6815: Add a 'Take Patron Image' ability This does not just click in place, which would be nice. But it does take the picture, download to a file, and then let's the user use the existing upload functionality to add the photo. If wording or formating is ugly, feel free to tweak. TEST PLAN --------- 1) the 'patronimages' system preference in Patrons system preferences must be set to 'Allow'. 2) apply the patch 3) go to any patron 4) click the 'Take' button. -- it is in the text area on the right, and not the hover over the image area. Adding here would require CSS changes, which are now difficult and ugly to do. -- new tab should open. If you have a working webcam, you should see it playing 'live'. 5) click the "Take the Patron's Picture" button -- this should download a photo SamplePhoto.jpg or some variation of that. 6) close this tab, and click the 'Edit' or 'Add' button for the patron image. 7) click 'Choose File' and choose the file that was created 8) click 'Upload' -- the webcam photo should now be used. 9) run koha qa test tools -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.

1 0

[Bug 14287] Preserve valid ISBN-13 identifiers if they start with something else than 978
by bugzilla-daemon＠bugs.koha-community.org 04 Jul '19

04 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14287 --- Comment #14 from M. Tompsett <mtompset(a)hotmail.com> --- (In reply to M. Tompsett from comment #13) > So, how are we supposed to grab Amazon covers? Related to this whole mess take a look at: line 389 of koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/results.tt The lack of normalized_isbn (13 to 10 makes it empty or undef, not sure which) means that it knows not to try to get the book cover. Look what I get when I use the ASIN? :) https://images-na.ssl-images-amazon.com/images/P/B006MV70GS Just some further thoughts. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15497] Limit Item Types by Branch
by bugzilla-daemon＠bugs.koha-community.org 04 Jul '19

04 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15497 Agustín Moyano <agustinmoyano(a)theke.io> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED -- You are receiving this mail because: You are watching all bug changes.

1 0