[Koha] Database update errors

[Perch]

Upon updating koha to the latest version I got these error when running
database update:

    [Mon Dec 12 13:04:03 2011] updatedatabase.pl: DBD::mysql::db do failed:
Table 'hold_fill_targets' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
1983.
    [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'AllowRenewalLimitOverride' for key 'PRIMARY' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2049.
    [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'reserves-HOLD' for key 'PRIMARY' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2063.
    [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry '4' for key 'PRIMARY' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2067.
    [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry '4-sms-0' for key 'PRIMARY' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2068.
    [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry '4-email-0' for key 'PRIMARY' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2069.
    [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate key name 'issn' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2076.
    [Mon Dec 12 13:04:06 2011] updatedatabase.pl: DBD::mysql::db do failed:
Table 'branch_transfer_limits' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2112.
    [Mon Dec 12 13:04:07 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry '1-override_renewals' for key 'PRIMARY' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2132.
    [Mon Dec 12 13:04:08 2011] updatedatabase.pl: DBD::mysql::db do failed:
Table 'branch_item_rules' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2166.
    [Mon Dec 12 13:04:08 2011] updatedatabase.pl: DBD::mysql::db do failed:
Table 'default_branch_item_rules' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2177.
    [Mon Dec 12 13:04:10 2011] updatedatabase.pl: DBD::mysql::db do failed:
Table 'item_circulation_alert_preferences' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2199.
    [Mon Dec 12 13:04:11 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'ccode' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2238.
    [Mon Dec 12 13:04:12 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'OPACAmazonCoverImages' for key 'PRIMARY' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2274.
    [Mon Dec 12 13:04:12 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'AmazonCoverImages' for key 'PRIMARY' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2276.
    [Mon Dec 12 13:04:12 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'smsalertnumber' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2312.
    [Mon Dec 12 13:04:13 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'AmazonReviews' for key 'PRIMARY' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2391.
    [Mon Dec 12 13:04:13 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'AllowNotForLoanOverride' for key 'PRIMARY' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2409.
    [Mon Dec 12 13:04:14 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'RenewalPeriodBase' for key 'PRIMARY' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2426.
    [Mon Dec 12 13:04:20 2011] updatedatabase.pl: DBD::mysql::db do failed:
Table 'export_format' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2695.
    [Mon Dec 12 13:04:20 2011] updatedatabase.pl: DBD::mysql::db do failed:
Table 'fieldmapping' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2709.
    [Mon Dec 12 13:04:20 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'finedays' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2766.
    [Mon Dec 12 13:04:24 2011] updatedatabase.pl: DBD::mysql::db do failed:
Table 'aqbudgets' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2951.
    [Mon Dec 12 13:04:24 2011] updatedatabase.pl: DBD::mysql::db do failed:
Unknown column 'aqbudgetid' in 'aqbudgets' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2955.
    [Mon Dec 12 13:04:24 2011] updatedatabase.pl: DBD::mysql::db do failed:
Can't DROP 'startdate'; check that column/key exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
3003.
    [Mon Dec 12 13:04:25 2011] updatedatabase.pl: DBD::mysql::db do failed:
Table 'aqorders_items' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
3123.
    [Mon Dec 12 13:04:26 2011] updatedatabase.pl: DBD::mysql::db do failed:
Can't DROP 'budget_amount_sublevel'; check that column/key exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
3177.
    [Mon Dec 12 13:04:27 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'deliveryplace' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
3239.
    [Mon Dec 12 13:04:28 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'billingplace' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
3288.
    [Mon Dec 12 13:04:31 2011] updatedatabase.pl: DBD::mysql::db do failed:
Table 'collections' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
3377.
    [Mon Dec 12 13:04:31 2011] updatedatabase.pl: DBD::mysql::db do failed:
Table 'collections_tracking' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
3387.
    [Mon Dec 12 13:04:35 2011] patroncards_upgrade.pl: DBD::mysql::db do
failed: Table 'creator_batches' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/patroncards_upgrade.pl
line 149.
    [Mon Dec 12 13:04:35 2011] patroncards_upgrade.pl: DB ERROR: Table
'creator_batches' already exists
    [Mon Dec 12 13:04:35 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'csv_separator' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
3418.
    [Mon Dec 12 13:04:35 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'encoding' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
3429.
    [Mon Dec 12 13:04:48 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'privacy' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
3997.
    [Mon Dec 12 13:04:48 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'privacy' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
3998.
    [Mon Dec 12 13:04:51 2011] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'freedeliveryplace' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
4251.
    [Mon Dec 12 13:04:58 2011] updatedatabase.pl: DBD::mysql::db do failed:
Table 'need_merge_authorities' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
4535.

Will these be a problem or is it safe to just ignore them? Most of them seem
to be related to data already existing in the database with this exception:

    [Mon Dec 12 13:04:24 2011] updatedatabase.pl: DBD::mysql::db do failed:
Unknown column 'aqbudgetid' in 'aqbudgets' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
2955.

--
View this message in context: http://koha.1045719.n5.nabble.com/Database-update-errors-tp5068234p5068234.html
Sent from the Koha-general mailing list archive at Nabble.com.