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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha