Summary: | items.itemnotes_nonpublic not created during upgrade | ||
---|---|---|---|
Product: | Koha | Reporter: | jaker <jaker> |
Component: | Installation and upgrade (command-line installer) | Assignee: | Galen Charlton <gmcharlt> |
Status: | CLOSED INVALID | QA Contact: | Testopia <testopia> |
Severity: | normal | ||
Priority: | P5 - low | CC: | tomascohen |
Version: | 3.20 | ||
Hardware: | Other | ||
OS: | Linux | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: |
Description
jaker@mvwsd.org
2015-06-18 15:21:10 UTC
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. 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. |