[Koha-bugs] [Bug 13565] New: Several "DBD::mysql::db do failed" during upgrade from 3.14.x to 3.18.x

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

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 at gmail.com
          Reporter: rolando.isidoro at gmail.com
        QA Contact: testopia at 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.