Hi Michael,
if you have set the CurrencyFormat system preference to 'FR' the display
format will be 0,00, but if the wrong format is in the database it will
also display as 0,00. So it can hide the problem. If you set it to a
CurrencyFormat with decimal ., the problem could become easier to spot.
Hope this helps,
Katrin
On 08.01.24 10:53, Michael Kuhn wrote:
Hi Katrin and Magnus
Many thanks for your answers!
It is not possible to change the value to "0.00" via Koha menu
"Administration > Defining circulation and fine rules for all
libraries" - even wehn savin "0.00" it will still show "0,00".
We have eight rules there - all of them show value "0,00" in column
"Overdue fines cap (amount)". But in table "circulation_rules" I found
the following:
MariaDB [koha_bibliothek]> SELECT * FROM circulation_rules WHERE
rule_name="overduefinescap";
+-----+------------+--------------+----------+-----------------+------------+
| id | branchcode | categorycode | itemtype | rule_name | rule_value
+-----+------------+--------------+----------+-----------------+------------+
| 4 | NULL | NULL | NULL | overduefinescap | |
| 34 | NULL | NULL | BUCH | overduefinescap | 0.00 |
| 67 | NULL | NULL | CD | overduefinescap | 0.00 |
| 94 | NULL | NULL | ZSS | overduefinescap | 0.00 |
| 136 | NULL | PT | BUCH | overduefinescap | |
| 170 | NULL | HB | BUCH | overduefinescap | 0.00 |
| 182 | NULL | NULL | KONV | overduefinescap | |
| 214 | NULL | NULL | DVD | overduefinescap | |
+-----+------------+--------------+----------+-----------------+------------+
8 rows in set (0,000 sec)
So I changed just the values actually containing "0,00" as follows:
MariaDB [koha_bibliothek]> UPDATE circulation_rules SET rule_value =
'0.00' WHERE rule_value = '0,00';
Thus table "circulation_rules" now shows:
MariaDB [koha_bibliothek]> SELECT * FROM circulation_rules WHERE
rule_name="overduefinescap";
+-----+------------+--------------+----------+-----------------+------------+
| id | branchcode | categorycode | itemtype | rule_name |
rule_value |
+-----+------------+--------------+----------+-----------------+------------+
| 4 | NULL | NULL | NULL | overduefinescap | |
| 34 | NULL | NULL | BUCH | overduefinescap | 0.00 |
| 67 | NULL | NULL | CD | overduefinescap | 0.00 |
| 94 | NULL | NULL | ZSS | overduefinescap | 0.00 |
| 136 | NULL | PT | BUCH | overduefinescap | |
| 170 | NULL | HB | BUCH | overduefinescap | 0.00 |
| 182 | NULL | NULL | KONV | overduefinescap | |
| 214 | NULL | NULL | DVD | overduefinescap | |
+-----+------------+--------------+----------+-----------------+------------+
8 rows in set (0,000 sec)
However, even after restarting Koha ( memcached apache2 koha-common )
Koha menu "Administration > Defining circulation and fine rules for
all libraries" still shows the value "0,00" in column "Overdue fines
cap (amount)" for all eight rules as before.
I will now wait and see what happens after the next run of
"/etc/cron.daily/koha-common".
Best wishes: Michael
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
