Clean all fine amount

In certain occassions librarian need to clean entire fine amount in Koha system. Amount and outstanding fines are located in accountlines table in Koha database.

Take backup of Koha database before execute the commands,

Open Applications > Accessories > Terminal

mysqldump -uroot -p koha_library | gzip -9 > /home/koha/koha_library.sql.gz

You can apply following commands to clean entire fine amount in the table.

Open mysql account,

sudo su
mysql -uroot -p

Clean amount in table,

mysql -uroot -p   [Enter MySQL Root Password]
use koha_library;
UPDATE `accountlines` SET `amount` = '';
UPDATE `accountlines` SET `amountoutstanding` = '';
quit 


Check the change now




3 comments: