[Koha] account lines table truncated by mistake

Indranil Das Gupta indradg at gmail.com
Fri Aug 27 23:32:19 NZST 2021


On Fri, 27 Aug, 2021, 4:29 pm Arunkumar Sampath, <arunkumars.3189 at gmail.com>

> Hello all,
> without current backup mistakenly truncated accountlines table, therefore
> lost all fine data,
> is it possible to populate fine information for existing issued items.

Yes, using the fines.pl cron job

See https://koha-community.org/manual/21.05/en/html/cron_jobs.html#fines

You should

1. backup your current database for safety

2. switch to your koha instance system account using koha-shell

3. Run the fines.pl cron job

Caveat: check the status of your account offsets table before and after,
it's linked to the accountlines table.

Indranil Das Gupta
L2C2 Technologies

> Thanks in advance
> --
> *with regards *
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list