[Koha-bugs] [Bug 17216] Add a new table to store authorized value categories

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17216

--- Comment #101 from Mirko Tietgen <mirko at abunchofthings.net> ---
Did an install with the latest patch added, got

Update errors :

    [Thu Nov 24 00:06:08 2016] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'updated_on' [for Statement "
    [Thu Nov 24 00:06:08 2016] updatedatabase.pl: ALTER TABLE borrowers
    [Thu Nov 24 00:06:08 2016] updatedatabase.pl: ADD COLUMN updated_on
timestamp NULL DEFAULT CURRENT_TIMESTAMP
    [Thu Nov 24 00:06:08 2016] updatedatabase.pl: ON UPDATE CURRENT_TIMESTAMP
    [Thu Nov 24 00:06:08 2016] updatedatabase.pl: AFTER
privacy_guarantor_checkouts;
    [Thu Nov 24 00:06:08 2016] updatedatabase.pl: "] at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
12626.
    [Thu Nov 24 00:06:08 2016] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'updated_on' [for Statement "
    [Thu Nov 24 00:06:08 2016] updatedatabase.pl: ALTER TABLE deletedborrowers
    [Thu Nov 24 00:06:08 2016] updatedatabase.pl: ADD COLUMN updated_on
timestamp NULL DEFAULT CURRENT_TIMESTAMP
    [Thu Nov 24 00:06:08 2016] updatedatabase.pl: ON UPDATE CURRENT_TIMESTAMP
    [Thu Nov 24 00:06:08 2016] updatedatabase.pl: AFTER
privacy_guarantor_checkouts;
    [Thu Nov 24 00:06:08 2016] updatedatabase.pl: "] at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
12632.
    [Thu Nov 24 00:06:15 2016] updatedatabase.pl: DBD::mysql::db do failed:
Can't create table 'koha_koha.#sql-2221_18d' (errno: 150) [for Statement "
    [Thu Nov 24 00:06:15 2016] updatedatabase.pl: ALTER TABLE
marc_subfield_structure
    [Thu Nov 24 00:06:15 2016] updatedatabase.pl: MODIFY COLUMN
authorised_value VARCHAR(32) DEFAULT NULL,
    [Thu Nov 24 00:06:15 2016] updatedatabase.pl: ADD CONSTRAINT
marc_subfield_structure_ibfk_1 FOREIGN KEY (authorised_value) REFERENCES
authorised_value_categories (category_name) ON UPDATE CASCADE ON DELETE SET
NULL;
    [Thu Nov 24 00:06:15 2016] updatedatabase.pl: "] at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
13175.


@Jacek: that is what you are talking about, right?

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