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

Chris Cormack chrisc at catalyst.net.nz
Thu Jan 19 15:29:08 NZDT 2017


* David Whelchel (dlwhelchel at outlook.com) wrote:
>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.

Apart from this email you mean?

https://lists.katipo.co.nz/pipermail/koha/2017-January/047055.html

I guess you missed that??

>
>Well I have fixed the problem. Is anyone interested in the solution?
>
Perhaps, will it also be delivered with derision?

Chris


>Thanks
>
>Dave
>
>From: David Whelchel
>Sent: Saturday, January 14, 2017 8:04 PM
>To: 'koha at lists.katipo.co.nz' <koha at 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 at pullman.com<mailto:whelchel at pullman.com>
>
>http://www.dlwa.com
>
>
>_______________________________________________
>Koha mailing list  http://koha-community.org
>Koha at lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <https://lists.katipo.co.nz/pipermail/koha/attachments/20170119/6606167c/attachment-0001.sig>


More information about the Koha mailing list