[Koha] error while updating database from koha-3.06.00 to koha-3.02.00-rc
Ian Walls
ian.walls at bywatersolutions.com
Sun Oct 24 08:10:49 NZDT 2010
Nur Ahammad,
Many of those errors are just warnings that you've already got the new
tables, columns or rows installed, which is normal when upgrading from 3.0.x
to 3.2. I do see a couple more serious errors in there, but I don't have my
tools with me to do a more thorough diagnosis. But just so you know, not
all of them are a problem.
Cheers,
-Ian
2010/10/23 Nur Ahammad <ahammadnur59 at gmail.com>
> 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.plline 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.plline 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
>
>
> _______________________________________________
> Koha mailing list http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
--
Ian Walls
Lead Development Specialist
ByWater Solutions
Phone # (888) 900-8944
http://bywatersolutions.com
ian.walls at bywatersolutions.com
Twitter: @sekjal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20101023/45a24e95/attachment-0001.htm
More information about the Koha
mailing list