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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
