[Bug 14411] New: items.itemnotes_nonpublic not created during upgrade
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@gmail.com Reporter: jaker@mvwsd.org QA Contact: testopia@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.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14411 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |In Discussion CC| |tomascohen@gmail.com --- Comment #1 from Tomás Cohen Arazi <tomascohen@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.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14411 --- Comment #2 from Jon Aker <jaker@mvwsd.org> --- Thanks. It must have failed on my install due to the problems I had with the UTF8 conversion of the item table. I checked my deleteditems table and it does have that field. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14411 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|In Discussion |RESOLVED -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org