[Koha-bugs] [Bug 6163] patron messaging form screwy in multiple places

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6163

--- Comment #1 from Owen Leonard <oleonard at myacpl.org> 2011-04-11 19:05:44 UTC ---
There was an error in the database update affecting patron messaging:

$DBversion = "3.03.00.051";
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
    print "Upgrade to $DBversion done (Remove spaces and dashes from
message_attribute names)\n";
    $dbh->do("UPDATE message_attributes SET message_name = 'Item_Due' WHERE
message_name='Item Due'");
    $dbh->do("UPDATE message_attributes SET message_name = 'Advance_Notice'
WHERE message_name='Advance_Notice'");
    $dbh->do("UPDATE message_attributes SET message_name = 'Hold_Filled' WHERE
message_name='Hold Filled'");
    $dbh->do("UPDATE message_attributes SET message_name = 'Item_Check_in'
WHERE message_name='Item Check-in'");
    $dbh->do("UPDATE message_attributes SET message_name = 'Item_Checkout'
WHERE message_name='Item Checkout'");    
    SetVersion ($DBversion);
}

That second update should have been:

    $dbh->do("UPDATE message_attributes SET message_name = 'Advance_Notice'
WHERE message_name='Advance Notice'");

If I manually change the message_name in my database to 'Advance_Notice' it
seems to fix the problem.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.