Re: [Koha] Impossible to renew items

[Marc Véron]

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

[mpw]

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

[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

Re: [Koha] Impossible to renew items

[Jonathan Druart]

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

[Marc Véron]

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