[Koha] Further adventures with Koha update to 16.xxx

[David Whelchel]

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 at pullman.com<mailto:whelchel at pullman.com>

http://www.dlwa.com