[Koha] double fines

[Hugo Agud]

Good morning

I have found this double fine behaviour at koha 19.05.06, I have been
digging into koha logs and tables and I guess I have a valid theory

Having finemode calculate and charge in return, If a user renew an issue
with overdue, they system charge the fine at the return and charge again at
cron

this causes a double fine

*Account table *

[image: Editar] Editar
<https://morelos.orex.es/phpmyadmin/tbl_change.php?db=koha_morelos&table=accountlines&where_clause=%60accountlines%60.%60accountlines_id%60+%3D+23476&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60accountlines%60+WHERE+%60itemnumber%60+%3D+30350+ORDER+BY+%60accountlines_id%60++DESC+&goto=sql.php&default_action=update&token=214c3252355eb7f9799bc434bcd391f5>
[image:
Copiar] Copiar
<https://morelos.orex.es/phpmyadmin/tbl_change.php?db=koha_morelos&table=accountlines&where_clause=%60accountlines%60.%60accountlines_id%60+%3D+23476&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60accountlines%60+WHERE+%60itemnumber%60+%3D+30350+ORDER+BY+%60accountlines_id%60++DESC+&goto=sql.php&default_action=insert&token=214c3252355eb7f9799bc434bcd391f5>
[image:
Borrar] Borrar
<https://morelos.orex.es/phpmyadmin/sql.php?db=koha_morelos&table=accountlines&sql_query=DELETE+FROM+%60accountlines%60+WHERE+%60accountlines%60.%60accountlines_id%60+%3D+23476&message_to_show=La+fila+se+ha+borrado.&goto=sql.php%3Fdb%3Dkoha_morelos%26table%3Daccountlines%26sql_query%3DSELECT%2B%252A%2B%2BFROM%2B%2560accountlines%2560%2BWHERE%2B%2560itemnumber%2560%2B%253D%2B30350%2BORDER%2BBY%2B%2560accountlines_id%2560%2B%2BDESC%2B%26message_to_show%3DLa%2Bfila%2Bse%2Bha%2Bborrado.%26goto%3Dsql.php%26token%3D214c3252355eb7f9799bc434bcd391f5&token=214c3252355eb7f9799bc434bcd391f5>
23476 42854 3857
<https://morelos.orex.es/phpmyadmin/sql.php?db=koha_morelos&table=borrowers&pos=0&sql_query=SELECT+%2A+FROM+%60koha_morelos%60.%60borrowers%60+WHERE+%60borrowernumber%60+%3D+3857&token=214c3252355eb7f9799bc434bcd391f5>
30350
<https://morelos.orex.es/phpmyadmin/sql.php?db=koha_morelos&table=items&pos=0&sql_query=SELECT+%2A+FROM+%60koha_morelos%60.%60items%60+WHERE+%60itemnumber%60+%3D+30350&token=214c3252355eb7f9799bc434bcd391f5>
2020-01-29 5.000000 Clinically Oriented Anatomy /  28/01/2020 11:59 PM
OVERDUE UNRETURNED *NULL* 0.000000 2020-01-30 22:25:20
*NULL* *opac* *NULL*
[image: Editar] Editar
<https://morelos.orex.es/phpmyadmin/tbl_change.php?db=koha_morelos&table=accountlines&where_clause=%60accountlines%60.%60accountlines_id%60+%3D+23472&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60accountlines%60+WHERE+%60itemnumber%60+%3D+30350+ORDER+BY+%60accountlines_id%60++DESC+&goto=sql.php&default_action=update&token=214c3252355eb7f9799bc434bcd391f5>
[image:
Copiar] Copiar
<https://morelos.orex.es/phpmyadmin/tbl_change.php?db=koha_morelos&table=accountlines&where_clause=%60accountlines%60.%60accountlines_id%60+%3D+23472&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60accountlines%60+WHERE+%60itemnumber%60+%3D+30350+ORDER+BY+%60accountlines_id%60++DESC+&goto=sql.php&default_action=insert&token=214c3252355eb7f9799bc434bcd391f5>
[image:
Borrar] Borrar
<https://morelos.orex.es/phpmyadmin/sql.php?db=koha_morelos&table=accountlines&sql_query=DELETE+FROM+%60accountlines%60+WHERE+%60accountlines%60.%60accountlines_id%60+%3D+23472&message_to_show=La+fila+se+ha+borrado.&goto=sql.php%3Fdb%3Dkoha_morelos%26table%3Daccountlines%26sql_query%3DSELECT%2B%252A%2B%2BFROM%2B%2560accountlines%2560%2BWHERE%2B%2560itemnumber%2560%2B%253D%2B30350%2BORDER%2BBY%2B%2560accountlines_id%2560%2B%2BDESC%2B%26message_to_show%3DLa%2Bfila%2Bse%2Bha%2Bborrado.%26goto%3Dsql.php%26token%3D214c3252355eb7f9799bc434bcd391f5&token=214c3252355eb7f9799bc434bcd391f5>
23472 42854 3857
<https://morelos.orex.es/phpmyadmin/sql.php?db=koha_morelos&table=borrowers&pos=0&sql_query=SELECT+%2A+FROM+%60koha_morelos%60.%60borrowers%60+WHERE+%60borrowernumber%60+%3D+3857&token=214c3252355eb7f9799bc434bcd391f5>
30350
<https://morelos.orex.es/phpmyadmin/sql.php?db=koha_morelos&table=items&pos=0&sql_query=SELECT+%2A+FROM+%60koha_morelos%60.%60items%60+WHERE+%60itemnumber%60+%3D+30350&token=214c3252355eb7f9799bc434bcd391f5>
2020-01-29 5.000000 Clinically Oriented Anatomy /  28/01/2020 11:59 PM
OVERDUE RETURNED *NULL* 0.000000 2020-01-30 22:33:49
*NULL* cron *NULL*

*Statistics*
2020-01-29 13:14:21 UM 0.0000 *renew*
30350 BK SALA4 3857 GEN


The quick solution now is block renew issues with overdue, anybody from
this mails may check if this is also the case in their ddouble fines?

kindest regards




El mié., 9 oct. 2019 a las 20:12, Katrin Fischer (<katrin.fischer.83 at web.de>)
escribió:

> Hi,
>
> this is correct. Koha doesn't 'add the new fine' it always recalculates
> it from the due date. So if you pay a fine without returning or renewing
> the item, it will be back the next day.
>
> I current development would allow to renew at the time of the payment:
>
> *Bug 23051*
> <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23051> -
> Optionally renew fine accruing items when all fines on item are paid off
>
> Hope this helps,
>
> Katrin
>
>
> On 09.10.19 03:24, mus wrote:
> > Hello,
> >
> > I have some issue almost similar. We received some complaints from staff
> > about user being double charged for fines. I notice the problem occur
> when
> > users pay for their fines without returning books. for example they have
> > 10.00 fines, they pay for the 10.00 without returning the items. Tomorrow
> > koha should charge them 0.10 (our charge 0.10/day), but what happen is
> Koha
> > start counting from 10.10. And when they return the books, they have to
> pay
> > again for the 10.00. Already test with another patron and the same result
> > happen.
> >
> >
> >
> > --
> > Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 

*Hugo Agud - Orex Digital *

*www.orex.es <http://www.orex.es>*


<http://www.orex.es/>    [image: www.orex.es/koha] <http://www.orex.es/koha>
   [image: www.orex.es/vufind] <http://www.orex.es/vufind>


Director

Passeig Comte Vilardaga, 118 3-3  08980 -Sant Feliu de Llobregat - Tel: 933
856 138   hagud at orex.es · http://www.orex.es/



No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
implica la tala de 15 árboles y el consumo de 250.000 litros de agua.



Aviso de confidencialidad
Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
está autorizado a recibirlo por el remitente), no está autorizado a copiar,
reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje
por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.