http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13565 Bug ID: 13565 Summary: Several "DBD::mysql::db do failed" during upgrade from 3.14.x to 3.18.x Change sponsored?: --- Product: Koha Version: 3.14 Hardware: All OS: Linux Status: NEW Severity: normal Priority: P5 - low Component: Database Assignee: gmcharlt@gmail.com Reporter: rolando.isidoro@gmail.com QA Contact: testopia@bugs.koha-community.org When performing an upgrade from Koha 3.14.10 to 3.18.02 using packages in a Debian server I got these database occurrences: DBD::mysql::db do failed: Duplicate key name 'surname_idx' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7841. Upgrade to 3.15.00.006 done (Bug 11249 - Add DB indexes on borrower names) DBD::mysql::db do failed: Unknown column 'ctId' in 'collections_tracking' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7863. Upgrade to 3.15.00.008 done (Bug 11384) - change name of collections_tracker.ctId column) DBD::mysql::db do failed: Can't DROP 'marc'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7881. Upgrade to 3.15.00.010 done (Bug 6331: remove obsolete column in deleteditems.marc) DBD::mysql::db do failed: Duplicate entry 'SelfCheckReceiptPrompt' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7940. Upgrade to 3.15.00.014 done (Bug 11415: add system preference for automatic self checkout receipt printing) DBD::mysql::db selectcol_arrayref failed: Table 'koha_fct.roadtype' doesn't exist at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7988. Upgrade to 3.15.00.019 done (Bug 11256: Add system preference OpacMaxItemsToDisplay) DBD::mysql::db do failed: Can't DROP 'timestamp'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 8035. Upgrade to 3.15.00.021 done (Bug 3445: Add indexes to action_logs table) DBD::mysql::db do failed: Duplicate entry 'OPACMySummaryNote' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 8129. Upgrade to 3.15.00.030 done (Bug 12052: Add OPACMySummaryNote syspref) None of them seem problematic, as they result of attempts to perform actions that were already done previously. Nevertheless they should be fixed so the upgrade performs with a clean log. Rolando Isidoro -- You are receiving this mail because: You are watching all bug changes.