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

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Jun 18 17:21:10 CEST 2015


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

            Bug ID: 14411
           Summary: items.itemnotes_nonpublic not created during upgrade
 Change sponsored?: ---
           Product: Koha
           Version: 3.20
          Hardware: Other
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Installation and upgrade (command-line installer)
          Assignee: gmcharlt at gmail.com
          Reporter: jaker at mvwsd.org
        QA Contact: testopia at bugs.koha-community.org

I recently upgraded our Koha install to 3.20 using the Debian packages. During
the upgrade I received the following message:

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)

Which seems pretty straightforward, however, the itemnotes_nonpublic field does
not exist in my items table. I also receive a template error when checking out
an item. Manually creating the itemnotes_nonpublic column resolves the template
error on checkout.

I upgraded two different servers and the column was not created on either
server. I did have some problems with the items table during the upgrade. It
was related to the change to the utf8_unicode collation so I am not sure if the
field was not created in my items table because of those errors. I did not see
any errors related to the itemnotes_nonpublic column during the upgrade.

Also, I upgraded from 3.16 directly to 3.20 and I am running Debian Jessie

It may be just an issue with my install but I wanted to report it in case it
was a widespread issue.

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


More information about the Koha-bugs mailing list