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.
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
use koha_library;
UPDATE `accountlines` SET `amount` = '';
UPDATE `accountlines` SET `amountoutstanding` = '';
quit
Check the change now
very useful Vimal! Congratulations.
ReplyDeleteHi Vimal, welldone!
ReplyDeleteThis comment has been removed by the author.
ReplyDelete