[Koha-bugs] [Bug 11623] New: Errors with upgrade from 3.00.00.070 to 3.14.02.000

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

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

            Bug ID: 11623
           Summary: Errors with upgrade from 3.00.00.070 to 3.14.02.000
 Change sponsored?: ---
           Product: Koha
           Version: 3.14
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Installation and upgrade (web-based installer)
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: dswhite42 at yahoo.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com

There are a number of database upgrade errors that take place when upgrading
from 3.00.00.070 to 3.14.02.000

* A number of upgrades expect the tables to have foreign keys and be in InnoDB
format.  In 3.00.00.070, MyISAM (and no foreign keys) is the standard.  With no
testing to see if the keys exist, these commands fail with (errno: 152)

Problem examples:
ALTER TABLE issues DROP FOREIGN KEY `issues_ibfk_1`
ALTER TABLE issues DROP FOREIGN KEY `issues_ibfk_2`
ALTER TABLE `message_transports` DROP FOREIGN KEY `message_transports_ibfk_3`
ALTER TABLE patronimage DROP FOREIGN KEY patronimage_fk1


* In updatedatabase.pl, in the section for DBVersion 3.00.00.091, there are
references to the @sql_scripts
"installer/data/mysql/en/optional/sample_notices_message_attributes.sql" and
"installer/data/mysql/en/optional/sample_notices_message_transports.sql" . 
These should be
"installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql" and
"installer/data/mysql/en/mandatory/sample_notices_message_transports.sql"


* Even when that's corrected, the sample_notices_message_transports.sql script
fails because it references foreign keys to the "letters" table that have not
been created yet.  The reserves/HOLD combo isn't created until the 3.01.00.05
section of the updatedatabase.pl script, and circulation/CHECKIN and
circulation/CHECKOUT are not created until the 3.01.00.013 section.

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