koha-common 23.11.00-1 upgrading database schema for library Upgrade to 23.06.00.010 [01:00:16]: Bug 33028 - Fix wrongly formatted values for monetary values in circulation rules ERROR - {UNKNOWN}: Circulation rules contain invalid monetary values: Rule ID: 419 (All-TE-BK) Rule: overduefinescap Value: 1,000.00 Rule ID: 2150 (All-GL-BK) Rule: overduefinescap Value: 1,000.00 Rule ID: 2464 (EMEACL-GL-BK) Rule: overduefinescap Value: 1,000.00 Please fix these before you restart the update. at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/db_revs/230600010.pl line 33. at /usr/share/koha/lib/C4/Installer.pm line 741
Hi Naseel, this is not a bug, it's supposed to help you fix your configuration. When you go into your circulation rules, you need to fix the overdue amount through editing for the listed combinations. The , in the format is not valid. Remove it and things should be ok to continue.
I have fun into this several times when upgrading. I have solved it by logging into the database and running queries like these: UPDATE circulation_rules SET rule_value = '0.00' WHERE rule_value = '0,00'; You will have to replace the numbers with the actual numbers that are problematic in your databse. Then resume the upgrade with: sudo apt-get (dist-)upgrade