The original DB update for bug 22563 incorrectly mapped CR to
LOST_RETURNED as aposed to LOST_RETURN. This patch catches such cases
and updates them in the update for bug 23805
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
);
}
+ # Catch LOST_RETURNED cases from original bug 22563 update
+ $dbh->do(
+ qq{
+ UPDATE accountlines
+ SET accounttype = 'LOST_RETURN'
+ WHERE accounttype = 'LOST_RETURNED'
+ });
+
# Linking credit_type_code in accountlines to code in account_credit_types
unless ( foreign_key_exists( 'accountlines', 'accountlines_ibfk_credit_type' ) ) {
$dbh->do(