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.h... Sent from the Koha-general mailing list archive at Nabble.com.