[Koha] Argument "0, 00" isn't numeric in numeric gt (>) at /usr/share/koha/lib/C4/Overdues.pm line 292.

[Michael Kuhn]

Hi Katrin and Magnus

After the mentioned changes everything works as expected. Thanks again 
for your help!

(And as suggested by Katrin I have set system preference 
"CurrencyFormat" to a format with decimal dot).

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



Am 08.01.24 um 10:53 schrieb Michael Kuhn:
> 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