account lines table truncated by mistake
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. Thanks in advance -- *with regards * *S.ARUNKUMAR*
Hi, On Fri, 27 Aug, 2021, 4:29 pm Arunkumar Sampath, <arunkumars.3189@gmail.com> wrote:
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. Regards Indranil Das Gupta L2C2 Technologies
Thanks in advance --
*with regards *
*S.ARUNKUMAR* _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Arunkumar Sampath -
Indranil Das Gupta