[Koha] Impossible to renew items

mpw wyneken at physik.uni-freiburg.de
Wed Aug 2 03:09:43 NZST 2017


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.


More information about the Koha mailing list