Hi All, I have been patiently waiting for an answer to the following questions and there has not been a peep. This is what I expected. There is surface help but when an update breaks because of underlying database issues I hear nothing. An update should not have these problems. Well I have fixed the problem. Is anyone interested in the solution? Thanks Dave From: David Whelchel Sent: Saturday, January 14, 2017 8:04 PM To: 'koha@lists.katipo.co.nz' <koha@lists.katipo.co.nz> Subject: Further adventures with Koha update to 16.xxx Hi all, It has been several weeks down the road, listing to good music, since my last post and I have made progress in moving from the old Koha Version 16.05.05.000 on Debian 3.2.84-1 x86_64 to Koha 16.11.01 on Debian GNU/Linux 8.6 (jessie), with a quick pass through Koha 16.05.07 on jessie to see if it would correct the errors listed below. No luck, when trying to update to 16.11.01 from either 16.05.05 or 16.05.07 I receive these errors below when going through the Web Installer- Step 3 (Updating database structure). Obviously the 16.0.05 is on a much older code base and OS but the 16.05.07 (no errors here - and I can complete the update and have a functioning system) and the 16.11.01 are on fresh installs of Debian 8.6 and the Koha Common Debian package with an import of the original production database. My questions - 1. are these errors to be expected? 2. Can some of them be ignored? 3. If the error cannot be ignored what is the proper path to move on from here? I am hesitant to make any manual changes to the underlying database as I do not know what down the road implications there might be. Thanks - sorry for the long list of errors but that is what is in red at this step in the process - but I feel that I am almost there. [Sat Jan 14 19:26:46 2017] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'updated_on' [for Statement " [Sat Jan 14 19:26:46 2017] updatedatabase.pl: ALTER TABLE borrowers [Sat Jan 14 19:26:46 2017] updatedatabase.pl: ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP [Sat Jan 14 19:26:46 2017] updatedatabase.pl: ON UPDATE CURRENT_TIMESTAMP [Sat Jan 14 19:26:46 2017] updatedatabase.pl: AFTER privacy_guarantor_checkouts; [Sat Jan 14 19:26:46 2017] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 12626. [Sat Jan 14 19:26:46 2017] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'updated_on' [for Statement " [Sat Jan 14 19:26:46 2017] updatedatabase.pl: ALTER TABLE deletedborrowers [Sat Jan 14 19:26:46 2017] updatedatabase.pl: ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP [Sat Jan 14 19:26:46 2017] updatedatabase.pl: ON UPDATE CURRENT_TIMESTAMP [Sat Jan 14 19:26:46 2017] updatedatabase.pl: AFTER privacy_guarantor_checkouts; [Sat Jan 14 19:26:46 2017] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 12632. [Sat Jan 14 19:26:46 2017] updatedatabase.pl: DBD::mysql::db do failed: Table 'refund_lost_item_fee_rules' already exists [for Statement " [Sat Jan 14 19:26:46 2017] updatedatabase.pl: CREATE TABLE `refund_lost_item_fee_rules` ( [Sat Jan 14 19:26:46 2017] updatedatabase.pl: `branchcode` varchar(10) NOT NULL default '', [Sat Jan 14 19:26:46 2017] updatedatabase.pl: `refund` tinyint(1) NOT NULL default 0, [Sat Jan 14 19:26:46 2017] updatedatabase.pl: PRIMARY KEY (`branchcode`) [Sat Jan 14 19:26:46 2017] updatedatabase.pl: ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; [Sat Jan 14 19:26:46 2017] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 12691. [Sat Jan 14 19:27:36 2017] updatedatabase.pl: DBD::mysql::db do failed: Table 'authorised_value_categories' already exists [for Statement " [Sat Jan 14 19:27:36 2017] updatedatabase.pl: CREATE TABLE authorised_value_categories ( [Sat Jan 14 19:27:36 2017] updatedatabase.pl: category_name VARCHAR(32) NOT NULL, [Sat Jan 14 19:27:36 2017] updatedatabase.pl: primary key (category_name) [Sat Jan 14 19:27:36 2017] updatedatabase.pl: ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; [Sat Jan 14 19:27:36 2017] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 13100. [Sat Jan 14 19:27:36 2017] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'BOR_NOTES' for key 'PRIMARY' [for Statement " [Sat Jan 14 19:27:36 2017] updatedatabase.pl: INSERT INTO authorised_value_categories (category_name ) [Sat Jan 14 19:27:36 2017] updatedatabase.pl: SELECT DISTINCT category FROM authorised_values; [Sat Jan 14 19:27:36 2017] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 13107. [Sat Jan 14 19:27:37 2017] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha_koha16`.`#sql-38c_3e`, CONSTRAINT `authorised_values_authorised_values_category` FOREIGN KEY (`category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON ) [for Statement " [Sat Jan 14 19:27:37 2017] updatedatabase.pl: ALTER TABLE authorised_values [Sat Jan 14 19:27:37 2017] updatedatabase.pl: ADD CONSTRAINT `authorised_values_authorised_values_category` FOREIGN KEY (`category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE; [Sat Jan 14 19:27:37 2017] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 13162. [Sat Jan 14 19:29:05 2017] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'isbn'; check that column/key exists [for Statement "ALTER TABLE biblioitems DROP INDEX isbn"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 13684. [Sat Jan 14 19:29:05 2017] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'issn'; check that column/key exists [for Statement "ALTER TABLE biblioitems DROP INDEX issn"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 13685. --Dave ------------------------------------------------------------------------------- David L. Whelchel 725 SE Derby Street Pullman, WA 99163 whelchel@pullman.com<mailto:whelchel@pullman.com> http://www.dlwa.com