[Koha-bugs] [Bug 8002] Can't add patron attribute type in newer installation

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

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

Frédéric Demians <frederic at tamil.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|P5 - low                    |P2
                 CC|                            |frederic at tamil.fr

--- Comment #8 from Frédéric Demians <frederic at tamil.fr> ---
WARNING:

This patch borrower_attribute_types by truncating category_code content.

Those lines:

`category_code` VARCHAR(1) NULL DEFAULT NULL,-- defines a category for an
attribute_type

$DBversion = "3.08.00.XXX";
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
    $dbh->do("ALTER TABLE borrower_attribute_types CHANGE category_code
category_code VARCHAR( 1 ) NULL DEFAULT NULL");
    print "Upgrade to $DBversion done. (Bug 8002: Update patron attribute types
table to allow NULL category_code)\n";
    SetVersion($DBversion);
}

are wrong. category_code length is 10 not 1! It means that after update,
attributes by category don't work anymore, and configuration is lost.

-- 
You are receiving this mail because:
You are watching all bug changes.