Bug 13565 - Several "DBD::mysql::db do failed" during upgrade from 3.14.x to 3.18.x
Summary: Several "DBD::mysql::db do failed" during upgrade from 3.14.x to 3.18.x
Status: CLOSED WONTFIX
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: 3.14
Hardware: All Linux
: P5 - low normal (vote)
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-12 17:58 UTC by Rolando Isidoro
Modified: 2017-06-14 22:11 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Rolando Isidoro 2015-01-12 17:58:14 UTC
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
Comment 1 Owen Leonard 2016-08-10 13:13:28 UTC
Neither 3.14.x or 3.18.x is maintained any longer.