[Koha] Impossible to renew items

Marc VĂ©ron veron at veron.ch
Thu Aug 3 03:09:07 NZST 2017


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.000000;;0.000000;3;;0;0;0;;;10;10;14;days;;-1;10;7;;0;;;0;0;*;;0;1;N;no
> M;*;;0.000000;;0.000000;0;;0;0;0;;;;;;days;;-1;0;0;;0;;;0;0;AbtSchil;;0;1;N;no
> S;*;;0.000000;;0.000000;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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha



More information about the Koha mailing list