[Koha] Koha sets due date to current date when checking out

Michael Kuhn mik at adminkuhn.ch
Fri Dec 10 22:51:16 NZDT 2021


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 at 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)


More information about the Koha mailing list