[Koha] error while updating database from koha-3.06.00 to koha-3.02.00-rc
Nur Ahammad
ahammadnur59 at gmail.com
Sun Oct 24 04:09:37 NZDT 2010
Dear all ,
I got these errors when i had tried to update my database after installation
koha-3.02.00
please help me to solve these errors.
Update errors :
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Table 'hold_fill_targets' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
1969.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'item_level_request' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
1988.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'AllowRenewalLimitOverride' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2035.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'OPACDisplayRequestPriority' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2042.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'reserves-HOLD' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2049.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry '4' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2053.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry '4-sms-0' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2054.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry '4-email-0' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2055.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate key name 'issn' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2062.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Table 'branch_transfer_limits' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2098.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'UseBranchTransferLimits' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2107.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry '1-circulate_remaining_permissions' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2117.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry '1-override_renewals' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2118.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'AllowHoldPolicyOverride' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2151.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Table 'branch_item_rules' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2152.
- [Sat Oct 23 20:57:55 2010] 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.plline
2163.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'holdallowed' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2171.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'holdallowed' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2175.
- [Sat Oct 23 20:57:55 2010] 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.plline
2185.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'OPACAmazonCoverImages' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2260.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'AmazonCoverImages' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2262.
- [Sat Oct 23 20:57:55 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'smsalertnumber' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2298.
- [Sat Oct 23 20:58:01 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'ceilingDueDate' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2353.
- [Sat Oct 23 20:58:01 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'AmazonReviews' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2377.
- [Sat Oct 23 20:58:01 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'AllowNotForLoanOverride' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2395.
- [Sat Oct 23 20:58:01 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'RenewalPeriodBase' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2412.
- [Sat Oct 23 20:58:01 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'viewISBD' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2455.
- [Sat Oct 23 20:58:01 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'viewLabeledMARC' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2456.
- [Sat Oct 23 20:58:01 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'viewMARC' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2457.
- [Sat Oct 23 20:58:01 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'AWSPrivateKey' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2501.
- [Sat Oct 23 20:58:01 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'OPACFineNoRenewals' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2508.
- [Sat Oct 23 20:58:05 2010] updatedatabase.pl: DBD::mysql::db do failed:
Table 'export_format' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2681.
- [Sat Oct 23 20:58:05 2010] updatedatabase.pl: DBD::mysql::db do failed:
Table 'fieldmapping' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2695.
- [Sat Oct 23 20:58:05 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'finedays' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2752.
- [Sat Oct 23 20:58:05 2010] updatedatabase.pl: DBD::mysql::db do failed:
Table 'aqbudgets' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2937.
- [Sat Oct 23 20:58:05 2010] updatedatabase.pl: DBD::mysql::db do failed:
Unknown column 'aqbudgetid' in 'aqbudgets' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2941.
- [Sat Oct 23 20:58:05 2010] updatedatabase.pl: DBD::mysql::db do failed:
Can't create table './koha/#sql-986_5d.frm' (errno: 121) at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
2962.
- [Sat Oct 23 20:58:05 2010] 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.plline
2989.
- [Sat Oct 23 20:58:05 2010] updatedatabase.pl: DBD::mysql::db do failed:
Table 'aqorders_items' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
3109.
- [Sat Oct 23 20:58:05 2010] 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.plline
3163.
- [Sat Oct 23 20:58:09 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'deliveryplace' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
3225.
- [Sat Oct 23 20:58:11 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'billingplace' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
3274.
- [Sat Oct 23 20:58:11 2010] updatedatabase.pl: DBD::mysql::db do failed:
Table 'collections' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
3363.
- [Sat Oct 23 20:58:11 2010] updatedatabase.pl: DBD::mysql::db do failed:
Table 'collections_tracking' already exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
3373.
- [Sat Oct 23 20:58:12 2010] 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.
- [Sat Oct 23 20:58:12 2010] patroncards_upgrade.pl: DB ERROR: Table
'creator_batches' already exists
- [Sat Oct 23 20:58:12 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'csv_separator' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
3404.
- [Sat Oct 23 20:58:12 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate column name 'encoding' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
3415.
- [Sat Oct 23 20:58:12 2010] updatedatabase.pl: DBD::mysql::db do failed:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ''YesNo')' at
line 2 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/
updatedatabase.pl line 3445.
- [Sat Oct 23 20:58:12 2010] updatedatabase.pl: DBD::mysql::db do failed:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ''YesNo')' at
line 2 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/
updatedatabase.pl line 3449.
- [Sat Oct 23 20:58:12 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry 'reserves-HOLDPLACED' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
3557.
- [Sat Oct 23 20:58:12 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry '9-edit_items' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
3659.
- [Sat Oct 23 20:58:12 2010] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate entry '15-check_expiration' for key 1 at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
3668.
--
Nur Ahammad
Junior Assistant Librarian
BRAC University, Bangladesh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20101023/97794e77/attachment-0001.htm
More information about the Koha
mailing list