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

[Katrin Fischer]

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