Re: [Koha] Impossible to renew items
It seems that you defined rules for a library 'AbtSchil'. They take precedence over rules for 'All libraries'. In staff client, can you see the rules for 'AbtSchil'? - You have to select the library in the drop down above the table to make them visible. BTW: The wording 'All libraries' is a little bit confusing. It means something like: 'Rules that apply (to all libraries) if no matching rule for a specific library is found'. Am 01.08.2017 um 17:09 schrieb mpw: I'm groping around in the dark when it comes to SQL but I think I was able to find that answers to your questions. AllowRenewalIfOtherItemsAvailable is "Don't allow". In Reports > Create from SQL I created a report as follows: Report group: Select none SQL: SELECT * FROM issuingrules; I get the following results when I run the report: categorycode;itemtype;restrictedtype;rentaldiscount;reservecharge;fine;finedays;maxsuspensiondays;firstremind;chargeperiod;chargeperiod_charge_at;accountsent;chargename;maxissueqty;maxonsiteissueqty;issuelength;lengthunit;hardduedate;hardduedatecompare;renewalsallowed;renewalperiod;norenewalbefore;auto_renew;no_auto_renewal_after;no_auto_renewal_after_hard_limit;reservesallowed;holds_per_record;branchcode;overduefinescap;cap_fine_to_replacement_price;onshelfholds;opacitemholds;article_requests *;*;;0.00;;0.00;3;;0;0;0;;;10;10;14;days;;-1;10;7;;0;;;0;0;*;;0;1;N;no M;*;;0.00;;0.00;0;;0;0;0;;days;;-1;0;0;;0;;;0;0;AbtSchil;;0;1;N;no S;*;;0.00;;0.00;0;;0;0;0;;days;;-1;0;0;;0;;;0;0;AbtSchil;;0;1;N;no Thus it looks like I have three rows in the table. The question now, I guess, is how do I get rid of them? -- View this message in context: http://koha.1045719.n5.nabble.com/Impossible-to-renew-items-tp5941578p5941789.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Impossible to renew items
OK, I figured it out. At first I wasn't able to see three circulation rules even though the report showed there were three. I then discovered the *"Select a library" dropdown menu * on the "Defining circulation rules ..." page. I was able to delete all three of the old rules: one for all libraries, and two for my particular instance. I then created a new rule and now everything is working. -- View this message in context: http://koha.1045719.n5.nabble.com/Impossible-to-renew-items-tp5941578p5941885.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Impossible to renew items
I'm groping around in the dark when it comes to SQL but I think I was able to find that answers to your questions. AllowRenewalIfOtherItemsAvailable is "Don't allow". In Reports > Create from SQL I created a report as follows: Report group: Select none SQL: SELECT * FROM issuingrules; I get the following results when I run the report: categorycode;itemtype;restrictedtype;rentaldiscount;reservecharge;fine;finedays;maxsuspensiondays;firstremind;chargeperiod;chargeperiod_charge_at;accountsent;chargename;maxissueqty;maxonsiteissueqty;issuelength;lengthunit;hardduedate;hardduedatecompare;renewalsallowed;renewalperiod;norenewalbefore;auto_renew;no_auto_renewal_after;no_auto_renewal_after_hard_limit;reservesallowed;holds_per_record;branchcode;overduefinescap;cap_fine_to_replacement_price;onshelfholds;opacitemholds;article_requests *;*;;0.00;;0.00;3;;0;0;0;;;10;10;14;days;;-1;10;7;;0;;;0;0;*;;0;1;N;no M;*;;0.00;;0.00;0;;0;0;0;;days;;-1;0;0;;0;;;0;0;AbtSchil;;0;1;N;no S;*;;0.00;;0.00;0;;0;0;0;;days;;-1;0;0;;0;;;0;0;AbtSchil;;0;1;N;no Thus it looks like I have three rows in the table. The question now, I guess, is how do I get rid of them? -- View this message in context: http://koha.1045719.n5.nabble.com/Impossible-to-renew-items-tp5941578p5941789.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Impossible to renew items
Hi, What is the value of AllowRenewalIfOtherItemsAvailable? And the result of SELECT * FROM issuingrules; Regards, Jonathan On Mon, 31 Jul 2017 at 10:07 mpw wrote: > I'm running Koha version 17.05.01 on Debian 8.8. > > I'm setting up a new library. I have checked out eight books. In the > renewable column they are all listed as "Not renewable (0 of 0 renewals > remaining)". > > Several people have suggested removing all the circulation and fine rules > and creating a single rule the holds for all patron types and all item > types. For example here: > > > > http://koha.1045719.n5.nabble.com/All-items-quot-not-renewable-quot-td5925467.html#none > > I've tried that several times but none of the tries ever made any > difference. Right now I only have one rule: > Patron category - All > Item type - All > Current checkouts allowed - 20 > Renewals allowed - 3 > Renewal period - 14 > Automatic renewal - no > > Since somebody in the above mentioned thread said that this might be a bug, > I opened a bug report but they referred me back to this list because it's > supposedly just a configuration problem. > > I have set the option that enables the "Override renewal limit" checkbox so > I can trick the system into renewing books, but that's just a workaround > and > I'd like to get to the root of the problem. > > I've been going around in circles here for well over a week. Can anybody > point me in the right direction? > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Impossible-to-renew-items-tp5941578.html > Sent from the Koha-general mailing list archive at Nabble.com. > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Impossible to renew items
Hi Matthew I tried to reproduce the issue (on current master), however no luck. Is it possible to check the MySQL table issuingrules? Is there only one row? What are the values? For the records: Bug 18997 - Everything listed as "not renewable" https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18997 Marc Am 31.07.2017 um 15:07 schrieb mpw: I'm running Koha version 17.05.01 on Debian 8.8. I'm setting up a new library. I have checked out eight books. In the renewable column they are all listed as "Not renewable (0 of 0 renewals remaining)". Several people have suggested removing all the circulation and fine rules and creating a single rule the holds for all patron types and all item types. For example here: http://koha.1045719.n5.nabble.com/All-items-quot-not-renewable-quot-td5925467.html#none I've tried that several times but none of the tries ever made any difference. Right now I only have one rule: Patron category - All Item type - All Current checkouts allowed - 20 Renewals allowed - 3 Renewal period - 14 Automatic renewal - no Since somebody in the above mentioned thread said that this might be a bug, I opened a bug report but they referred me back to this list because it's supposedly just a configuration problem. I have set the option that enables the "Override renewal limit" checkbox so I can trick the system into renewing books, but that's just a workaround and I'd like to get to the root of the problem. I've been going around in circles here for well over a week. Can anybody point me in the right direction? -- View this message in context: http://koha.1045719.n5.nabble.com/Impossible-to-renew-items-tp5941578.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Impossible to renew items
I'm running Koha version 17.05.01 on Debian 8.8. I'm setting up a new library. I have checked out eight books. In the renewable column they are all listed as "Not renewable (0 of 0 renewals remaining)". Several people have suggested removing all the circulation and fine rules and creating a single rule the holds for all patron types and all item types. For example here: http://koha.1045719.n5.nabble.com/All-items-quot-not-renewable-quot-td5925467.html#none I've tried that several times but none of the tries ever made any difference. Right now I only have one rule: Patron category - All Item type - All Current checkouts allowed - 20 Renewals allowed - 3 Renewal period - 14 Automatic renewal - no Since somebody in the above mentioned thread said that this might be a bug, I opened a bug report but they referred me back to this list because it's supposedly just a configuration problem. I have set the option that enables the "Override renewal limit" checkbox so I can trick the system into renewing books, but that's just a workaround and I'd like to get to the root of the problem. I've been going around in circles here for well over a week. Can anybody point me in the right direction? -- View this message in context: http://koha.1045719.n5.nabble.com/Impossible-to-renew-items-tp5941578.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha