Re: [Koha] Koha sets due date to current date when checking out
Hi Michael Today you wrote:
I saw your email on the Koha list serv about the difficulties with a patron due date. We had a similar issue earlier this year, and it turned out that it was related to the Koha calendar. There were closed dates set that were messing up our normal return dates.
It's a long shot, and you've probably already thought of that, but I wanted to share it with you just in case. :-)
Thanks for the hint, but yes, I thought of that - in our case the calendar does not define any kind of holidays. So this can't be the reason for Koha's abnormal behaviour. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
Hi Michael, this one is really puzzling. Would you mind sharing your configuration from the circulation_rules table? I wonder if something got "stuck" there. SELECT * from circulation_rules; Katrin On 08.12.21 18:24, Michael Kuhn wrote:
Hi Michael
Today you wrote:
I saw your email on the Koha list serv about the difficulties with a patron due date. We had a similar issue earlier this year, and it turned out that it was related to the Koha calendar. There were closed dates set that were messing up our normal return dates.
It's a long shot, and you've probably already thought of that, but I wanted to share it with you just in case. :-)
Thanks for the hint, but yes, I thought of that - in our case the calendar does not define any kind of holidays. So this can't be the reason for Koha's abnormal behaviour.
Best wishes: Michael
Hi Katrin You wrote:
this one is really puzzling. Would you mind sharing your configuration from the circulation_rules table? I wonder if something got "stuck" there.
SELECT * from circulation_rules;
No problem, you'll find the output of the SELECT statement below. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch MariaDB [koha_fir]> SELECT * from circulation_rules; +----+------------+--------------+----------+----------------------------------+------------+ | id | branchcode | categorycode | itemtype | rule_name | rule_value | +----+------------+--------------+----------+----------------------------------+------------+ | 1 | NULL | NULL | NULL | maxissueqty | 50 | | 2 | FIR | PT | NULL | maxonsiteissueqty | 100 | | 3 | FIR | PT | NULL | maxissueqty | 100 | | 4 | NULL | NULL | NULL | maxonsiteissueqty | | | 5 | FIR | CH | NULL | maxissueqty | 150 | | 6 | FIR | CH | NULL | maxonsiteissueqty | 150 | | 7 | NULL | NULL | NULL | restrictedtype | | | 8 | FIR | CH | NULL | restrictedtype | | | 9 | FIR | PT | NULL | restrictedtype | | | 13 | NULL | NULL | NULL | fine | 0.000000 | | 14 | FIR | CH | NULL | fine | 0.000000 | | 15 | FIR | PT | NULL | fine | 0.000000 | | 16 | NULL | NULL | NULL | finedays | | | 17 | FIR | CH | NULL | finedays | | | 18 | FIR | PT | NULL | finedays | | | 19 | NULL | NULL | NULL | maxsuspensiondays | | | 20 | FIR | CH | NULL | maxsuspensiondays | | | 21 | FIR | PT | NULL | maxsuspensiondays | | | 22 | NULL | NULL | NULL | suspension_chargeperiod | 1 | | 23 | FIR | CH | NULL | suspension_chargeperiod | 1 | | 24 | FIR | PT | NULL | suspension_chargeperiod | 1 | | 25 | NULL | NULL | NULL | firstremind | | | 26 | FIR | CH | NULL | firstremind | | | 27 | FIR | PT | NULL | firstremind | | | 28 | NULL | NULL | NULL | chargeperiod | | | 29 | FIR | CH | NULL | chargeperiod | | | 30 | FIR | PT | NULL | chargeperiod | | | 31 | NULL | NULL | NULL | chargeperiod_charge_at | 0 | | 32 | FIR | CH | NULL | chargeperiod_charge_at | 0 | | 33 | FIR | PT | NULL | chargeperiod_charge_at | 0 | | 34 | NULL | NULL | NULL | accountsent | | | 35 | FIR | CH | NULL | accountsent | | | 36 | FIR | PT | NULL | accountsent | | | 37 | NULL | NULL | NULL | issuelength | 1643 | | 38 | FIR | CH | NULL | issuelength | | | 39 | FIR | PT | NULL | issuelength | | | 40 | NULL | NULL | NULL | lengthunit | days | | 41 | FIR | CH | NULL | lengthunit | days | | 42 | FIR | PT | NULL | lengthunit | days | | 43 | NULL | NULL | NULL | hardduedate | | | 44 | FIR | CH | NULL | hardduedate | | | 45 | FIR | PT | NULL | hardduedate | | | 46 | NULL | NULL | NULL | hardduedatecompare | -1 | | 47 | FIR | CH | NULL | hardduedatecompare | -1 | | 48 | FIR | PT | NULL | hardduedatecompare | -1 | | 49 | NULL | NULL | NULL | renewalsallowed | 10 | | 50 | FIR | CH | NULL | renewalsallowed | 0 | | 51 | FIR | PT | NULL | renewalsallowed | 0 | | 52 | NULL | NULL | NULL | renewalperiod | 200 | | 53 | FIR | CH | NULL | renewalperiod | | | 54 | FIR | PT | NULL | renewalperiod | | | 55 | NULL | NULL | NULL | norenewalbefore | | | 56 | FIR | CH | NULL | norenewalbefore | | | 57 | FIR | PT | NULL | norenewalbefore | | | 58 | NULL | NULL | NULL | auto_renew | 0 | | 59 | FIR | CH | NULL | auto_renew | 0 | | 60 | FIR | PT | NULL | auto_renew | 0 | | 61 | NULL | NULL | NULL | no_auto_renewal_after | | | 62 | FIR | CH | NULL | no_auto_renewal_after | | | 63 | FIR | PT | NULL | no_auto_renewal_after | | | 64 | NULL | NULL | NULL | no_auto_renewal_after_hard_limit | | | 65 | FIR | CH | NULL | no_auto_renewal_after_hard_limit | | | 66 | FIR | PT | NULL | no_auto_renewal_after_hard_limit | | | 67 | NULL | NULL | NULL | reservesallowed | 0 | | 68 | FIR | CH | NULL | reservesallowed | 0 | | 69 | FIR | PT | NULL | reservesallowed | 0 | | 70 | NULL | NULL | NULL | holds_per_record | 1 | | 71 | FIR | CH | NULL | holds_per_record | 0 | | 72 | FIR | PT | NULL | holds_per_record | 0 | | 73 | NULL | NULL | NULL | holds_per_day | | | 74 | FIR | CH | NULL | holds_per_day | | | 75 | FIR | PT | NULL | holds_per_day | | | 76 | NULL | NULL | NULL | onshelfholds | 1 | | 77 | FIR | CH | NULL | onshelfholds | 2 | | 78 | FIR | PT | NULL | onshelfholds | 2 | | 79 | NULL | NULL | NULL | opacitemholds | N | | 80 | FIR | CH | NULL | opacitemholds | N | | 81 | FIR | PT | NULL | opacitemholds | N | | 82 | NULL | NULL | NULL | overduefinescap | | | 83 | FIR | CH | NULL | overduefinescap | | | 84 | FIR | PT | NULL | overduefinescap | | | 85 | NULL | NULL | NULL | cap_fine_to_replacement_price | 0 | | 86 | FIR | CH | NULL | cap_fine_to_replacement_price | 0 | | 87 | FIR | PT | NULL | cap_fine_to_replacement_price | 0 | | 88 | NULL | NULL | NULL | article_requests | no | | 89 | FIR | CH | NULL | article_requests | no | | 90 | FIR | PT | NULL | article_requests | no | | 91 | NULL | NULL | NULL | note | | | 92 | FIR | CH | NULL | note | | | 93 | FIR | PT | NULL | note | | | 94 | NULL | NULL | NULL | decreaseloanholds | | | 95 | NULL | NULL | NULL | unseen_renewals_allowed | | +----+------------+--------------+----------+----------------------------------+------------+ 92 rows in set (0.046 sec)
Hi Michael, It looks like there are 3 rules defined for issuelength, one for 'All libraries' and 2 for the branchcode 'FIR'. Could it be that the rules for FIR are used? If the empty issuelength was interpreted as 0 that could explain the behavior. Katrin On 10.12.21 10:51, Michael Kuhn wrote:
Hi Katrin
You wrote:
this one is really puzzling. Would you mind sharing your configuration from the circulation_rules table? I wonder if something got "stuck" there.
SELECT * from circulation_rules;
No problem, you'll find the output of the SELECT statement below.
Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
MariaDB [koha_fir]> SELECT * from circulation_rules; +----+------------+--------------+----------+----------------------------------+------------+
| id | branchcode | categorycode | itemtype | rule_name | rule_value | +----+------------+--------------+----------+----------------------------------+------------+
| 1 | NULL | NULL | NULL | maxissueqty | 50 | | 2 | FIR | PT | NULL | maxonsiteissueqty | 100 | | 3 | FIR | PT | NULL | maxissueqty | 100 | | 4 | NULL | NULL | NULL | maxonsiteissueqty | | | 5 | FIR | CH | NULL | maxissueqty | 150 | | 6 | FIR | CH | NULL | maxonsiteissueqty | 150 | | 7 | NULL | NULL | NULL | restrictedtype | | | 8 | FIR | CH | NULL | restrictedtype | | | 9 | FIR | PT | NULL | restrictedtype | | | 13 | NULL | NULL | NULL | fine | 0.000000 | | 14 | FIR | CH | NULL | fine | 0.000000 | | 15 | FIR | PT | NULL | fine | 0.000000 | | 16 | NULL | NULL | NULL | finedays | | | 17 | FIR | CH | NULL | finedays | | | 18 | FIR | PT | NULL | finedays | | | 19 | NULL | NULL | NULL | maxsuspensiondays | | | 20 | FIR | CH | NULL | maxsuspensiondays | | | 21 | FIR | PT | NULL | maxsuspensiondays | | | 22 | NULL | NULL | NULL | suspension_chargeperiod | 1 | | 23 | FIR | CH | NULL | suspension_chargeperiod | 1 | | 24 | FIR | PT | NULL | suspension_chargeperiod | 1 | | 25 | NULL | NULL | NULL | firstremind | | | 26 | FIR | CH | NULL | firstremind | | | 27 | FIR | PT | NULL | firstremind | | | 28 | NULL | NULL | NULL | chargeperiod | | | 29 | FIR | CH | NULL | chargeperiod | | | 30 | FIR | PT | NULL | chargeperiod | | | 31 | NULL | NULL | NULL | chargeperiod_charge_at | 0 | | 32 | FIR | CH | NULL | chargeperiod_charge_at | 0 | | 33 | FIR | PT | NULL | chargeperiod_charge_at | 0 | | 34 | NULL | NULL | NULL | accountsent | | | 35 | FIR | CH | NULL | accountsent | | | 36 | FIR | PT | NULL | accountsent | | | 37 | NULL | NULL | NULL | issuelength | 1643 | | 38 | FIR | CH | NULL | issuelength | | | 39 | FIR | PT | NULL | issuelength | | | 40 | NULL | NULL | NULL | lengthunit | days | | 41 | FIR | CH | NULL | lengthunit | days | | 42 | FIR | PT | NULL | lengthunit | days | | 43 | NULL | NULL | NULL | hardduedate | | | 44 | FIR | CH | NULL | hardduedate | | | 45 | FIR | PT | NULL | hardduedate | | | 46 | NULL | NULL | NULL | hardduedatecompare | -1 | | 47 | FIR | CH | NULL | hardduedatecompare | -1 | | 48 | FIR | PT | NULL | hardduedatecompare | -1 | | 49 | NULL | NULL | NULL | renewalsallowed | 10 | | 50 | FIR | CH | NULL | renewalsallowed | 0 | | 51 | FIR | PT | NULL | renewalsallowed | 0 | | 52 | NULL | NULL | NULL | renewalperiod | 200 | | 53 | FIR | CH | NULL | renewalperiod | | | 54 | FIR | PT | NULL | renewalperiod | | | 55 | NULL | NULL | NULL | norenewalbefore | | | 56 | FIR | CH | NULL | norenewalbefore | | | 57 | FIR | PT | NULL | norenewalbefore | | | 58 | NULL | NULL | NULL | auto_renew | 0 | | 59 | FIR | CH | NULL | auto_renew | 0 | | 60 | FIR | PT | NULL | auto_renew | 0 | | 61 | NULL | NULL | NULL | no_auto_renewal_after | | | 62 | FIR | CH | NULL | no_auto_renewal_after | | | 63 | FIR | PT | NULL | no_auto_renewal_after | | | 64 | NULL | NULL | NULL | no_auto_renewal_after_hard_limit | | | 65 | FIR | CH | NULL | no_auto_renewal_after_hard_limit | | | 66 | FIR | PT | NULL | no_auto_renewal_after_hard_limit | | | 67 | NULL | NULL | NULL | reservesallowed | 0 | | 68 | FIR | CH | NULL | reservesallowed | 0 | | 69 | FIR | PT | NULL | reservesallowed | 0 | | 70 | NULL | NULL | NULL | holds_per_record | 1 | | 71 | FIR | CH | NULL | holds_per_record | 0 | | 72 | FIR | PT | NULL | holds_per_record | 0 | | 73 | NULL | NULL | NULL | holds_per_day | | | 74 | FIR | CH | NULL | holds_per_day | | | 75 | FIR | PT | NULL | holds_per_day | | | 76 | NULL | NULL | NULL | onshelfholds | 1 | | 77 | FIR | CH | NULL | onshelfholds | 2 | | 78 | FIR | PT | NULL | onshelfholds | 2 | | 79 | NULL | NULL | NULL | opacitemholds | N | | 80 | FIR | CH | NULL | opacitemholds | N | | 81 | FIR | PT | NULL | opacitemholds | N | | 82 | NULL | NULL | NULL | overduefinescap | | | 83 | FIR | CH | NULL | overduefinescap | | | 84 | FIR | PT | NULL | overduefinescap | | | 85 | NULL | NULL | NULL | cap_fine_to_replacement_price | 0 | | 86 | FIR | CH | NULL | cap_fine_to_replacement_price | 0 | | 87 | FIR | PT | NULL | cap_fine_to_replacement_price | 0 | | 88 | NULL | NULL | NULL | article_requests | no | | 89 | FIR | CH | NULL | article_requests | no | | 90 | FIR | PT | NULL | article_requests | no | | 91 | NULL | NULL | NULL | note | | | 92 | FIR | CH | NULL | note | | | 93 | FIR | PT | NULL | note | | | 94 | NULL | NULL | NULL | decreaseloanholds | | | 95 | NULL | NULL | NULL | unseen_renewals_allowed | | +----+------------+--------------+----------+----------------------------------+------------+
92 rows in set (0.046 sec)
Hi Katrin
It looks like there are 3 rules defined for issuelength, one for 'All libraries' and 2 for the branchcode 'FIR'. Could it be that the rules for FIR are used? If the empty issuelength was interpreted as 0 that could explain the behavior.
Ha - yes indeed! As soon as I entered a loan period of 1643 for the two patron categories in the (somewhat hidden) branch rules the problem was gone. The representation of the circulation conditions was always confusing for me since you first need to select the library to see the actual rules of the various branches. Especially if a library has in fact just one branch but is entering some rules for "all libraries" and some more for their branch.... it's too easy to forget about these other sets of rules behind the "select a library" button. Thanks so much for the hint! Best wishes & a happy weekend: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
On 10.12.21 10:51, Michael Kuhn wrote:
Hi Katrin
You wrote:
this one is really puzzling. Would you mind sharing your configuration from the circulation_rules table? I wonder if something got "stuck" there.
SELECT * from circulation_rules;
No problem, you'll find the output of the SELECT statement below.
Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
MariaDB [koha_fir]> SELECT * from circulation_rules; +----+------------+--------------+----------+----------------------------------+------------+
| id | branchcode | categorycode | itemtype | rule_name | rule_value | +----+------------+--------------+----------+----------------------------------+------------+
| 1 | NULL | NULL | NULL | maxissueqty | 50 | | 2 | FIR | PT | NULL | maxonsiteissueqty | 100 | | 3 | FIR | PT | NULL | maxissueqty | 100 | | 4 | NULL | NULL | NULL | maxonsiteissueqty | | | 5 | FIR | CH | NULL | maxissueqty | 150 | | 6 | FIR | CH | NULL | maxonsiteissueqty | 150 | | 7 | NULL | NULL | NULL | restrictedtype | | | 8 | FIR | CH | NULL | restrictedtype | | | 9 | FIR | PT | NULL | restrictedtype | | | 13 | NULL | NULL | NULL | fine | 0.000000 | | 14 | FIR | CH | NULL | fine | 0.000000 | | 15 | FIR | PT | NULL | fine | 0.000000 | | 16 | NULL | NULL | NULL | finedays | | | 17 | FIR | CH | NULL | finedays | | | 18 | FIR | PT | NULL | finedays | | | 19 | NULL | NULL | NULL | maxsuspensiondays | | | 20 | FIR | CH | NULL | maxsuspensiondays | | | 21 | FIR | PT | NULL | maxsuspensiondays | | | 22 | NULL | NULL | NULL | suspension_chargeperiod | 1 | | 23 | FIR | CH | NULL | suspension_chargeperiod | 1 | | 24 | FIR | PT | NULL | suspension_chargeperiod | 1 | | 25 | NULL | NULL | NULL | firstremind | | | 26 | FIR | CH | NULL | firstremind | | | 27 | FIR | PT | NULL | firstremind | | | 28 | NULL | NULL | NULL | chargeperiod | | | 29 | FIR | CH | NULL | chargeperiod | | | 30 | FIR | PT | NULL | chargeperiod | | | 31 | NULL | NULL | NULL | chargeperiod_charge_at | 0 | | 32 | FIR | CH | NULL | chargeperiod_charge_at | 0 | | 33 | FIR | PT | NULL | chargeperiod_charge_at | 0 | | 34 | NULL | NULL | NULL | accountsent | | | 35 | FIR | CH | NULL | accountsent | | | 36 | FIR | PT | NULL | accountsent | | | 37 | NULL | NULL | NULL | issuelength | 1643 | | 38 | FIR | CH | NULL | issuelength | | | 39 | FIR | PT | NULL | issuelength | | | 40 | NULL | NULL | NULL | lengthunit | days | | 41 | FIR | CH | NULL | lengthunit | days | | 42 | FIR | PT | NULL | lengthunit | days | | 43 | NULL | NULL | NULL | hardduedate | | | 44 | FIR | CH | NULL | hardduedate | | | 45 | FIR | PT | NULL | hardduedate | | | 46 | NULL | NULL | NULL | hardduedatecompare | -1 | | 47 | FIR | CH | NULL | hardduedatecompare | -1 | | 48 | FIR | PT | NULL | hardduedatecompare | -1 | | 49 | NULL | NULL | NULL | renewalsallowed | 10 | | 50 | FIR | CH | NULL | renewalsallowed | 0 | | 51 | FIR | PT | NULL | renewalsallowed | 0 | | 52 | NULL | NULL | NULL | renewalperiod | 200 | | 53 | FIR | CH | NULL | renewalperiod | | | 54 | FIR | PT | NULL | renewalperiod | | | 55 | NULL | NULL | NULL | norenewalbefore | | | 56 | FIR | CH | NULL | norenewalbefore | | | 57 | FIR | PT | NULL | norenewalbefore | | | 58 | NULL | NULL | NULL | auto_renew | 0 | | 59 | FIR | CH | NULL | auto_renew | 0 | | 60 | FIR | PT | NULL | auto_renew | 0 | | 61 | NULL | NULL | NULL | no_auto_renewal_after | | | 62 | FIR | CH | NULL | no_auto_renewal_after | | | 63 | FIR | PT | NULL | no_auto_renewal_after | | | 64 | NULL | NULL | NULL | no_auto_renewal_after_hard_limit | | | 65 | FIR | CH | NULL | no_auto_renewal_after_hard_limit | | | 66 | FIR | PT | NULL | no_auto_renewal_after_hard_limit | | | 67 | NULL | NULL | NULL | reservesallowed | 0 | | 68 | FIR | CH | NULL | reservesallowed | 0 | | 69 | FIR | PT | NULL | reservesallowed | 0 | | 70 | NULL | NULL | NULL | holds_per_record | 1 | | 71 | FIR | CH | NULL | holds_per_record | 0 | | 72 | FIR | PT | NULL | holds_per_record | 0 | | 73 | NULL | NULL | NULL | holds_per_day | | | 74 | FIR | CH | NULL | holds_per_day | | | 75 | FIR | PT | NULL | holds_per_day | | | 76 | NULL | NULL | NULL | onshelfholds | 1 | | 77 | FIR | CH | NULL | onshelfholds | 2 | | 78 | FIR | PT | NULL | onshelfholds | 2 | | 79 | NULL | NULL | NULL | opacitemholds | N | | 80 | FIR | CH | NULL | opacitemholds | N | | 81 | FIR | PT | NULL | opacitemholds | N | | 82 | NULL | NULL | NULL | overduefinescap | | | 83 | FIR | CH | NULL | overduefinescap | | | 84 | FIR | PT | NULL | overduefinescap | | | 85 | NULL | NULL | NULL | cap_fine_to_replacement_price | 0 | | 86 | FIR | CH | NULL | cap_fine_to_replacement_price | 0 | | 87 | FIR | PT | NULL | cap_fine_to_replacement_price | 0 | | 88 | NULL | NULL | NULL | article_requests | no | | 89 | FIR | CH | NULL | article_requests | no | | 90 | FIR | PT | NULL | article_requests | no | | 91 | NULL | NULL | NULL | note | | | 92 | FIR | CH | NULL | note | | | 93 | FIR | PT | NULL | note | | | 94 | NULL | NULL | NULL | decreaseloanholds | | | 95 | NULL | NULL | NULL | unseen_renewals_allowed | | +----+------------+--------------+----------+----------------------------------+------------+
92 rows in set (0.046 sec)
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Katrin Fischer -
Michael Kuhn