[Koha-bugs] [Bug 14411] items.itemnotes_nonpublic not created during upgrade

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

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

Tomás Cohen Arazi <tomascohen at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |In Discussion
                 CC|                            |tomascohen at gmail.com

--- Comment #1 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
I think this one is INVALID because you can see that updatedatabase.pl (the
script run during upgrade) includes the following lines:

$DBversion = '3.19.00.027';
if ( CheckVersion($DBversion) ) {
    $dbh->do("ALTER TABLE items ADD COLUMN itemnotes_nonpublic MEDIUMTEXT AFTER
itemnotes");
    $dbh->do("ALTER TABLE deleteditems ADD COLUMN itemnotes_nonpublic
MEDIUMTEXT AFTER itemnotes");
    print "Upgrade to $DBversion done (Bug 4222: Nonpublic note not appearing
in the staff client) <b>Please check each of your frameworks to ensure your
non-public item notes are mapped to items.itemnotes_nonpublic. After doing so
please have your administrator run misc/batchRebuildItemsTables.pl </b>)\n";
    SetVersion($DBversion);
}

So your DB failed to have those columns added.

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