[Koha] Upgrading from 3.0.6 to 3.2

3 Nov 2010

      Hello list ...

Today I was testing around the new koha 3.2 release (very last 
3.02.00.004)... trying to upgrade our current production Koha (3.0.6) ...

I just droped the new database and loaded the old one, to see if 
updatedatabase.pl would take all the work on it's shoulders...

And it did... almost.

In step 3 I had a lot of errors and I'd like to know if someone has 
faced the same situation and have any tips on the matter.
Most of them refer to duplicated entries and already present tables 
(could I assume that that's not a big problem?) except for this two 
(that seems to be a little more troublesome):

    * [Wed Nov 3 13:10:16 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
      './koha-tmpl/opac-tmpl/prog/en/xslt/MARC21slim2OPACResults.xsl,'YesNo')'
      at line 2 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      3449.
    * [Wed Nov 3 13:10:16 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
      './koha-tmpl/opac-tmpl/prog/en/xslt/MARC21slim2OPACDetail.xsl,'YesNo')'
      at line 2 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      3453.

Following I paste the errors reported by the updater (a little long list)

Thanks in advance

    * [Wed Nov 3 13:07:34 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Table 'hold_fill_targets' already exists at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      1969.
    * [Wed Nov 3 13:07:34 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate column name 'item_level_request' at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      1988.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'AllowRenewalLimitOverride' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2035.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'OPACDisplayRequestPriority' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2042.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'reserves-HOLD' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2049.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry '4' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2053.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry '4-sms-0' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2054.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry '4-email-0' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2055.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate key name 'issn' at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2062.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Table 'branch_transfer_limits' already exists at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2098.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'UseBranchTransferLimits' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2107.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry '1-circulate_remaining_permissions' for
      key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2117.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry '1-override_renewals' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2118.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'AllowHoldPolicyOverride' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2151.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Table 'branch_item_rules' already exists at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2152.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Table 'default_branch_item_rules' already exists at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2163.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate column name 'holdallowed' at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2171.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate column name 'holdallowed' at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2175.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'OPACAmazonCoverImages' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2260.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'AmazonCoverImages' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2262.
    * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate column name 'smsalertnumber' at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2298.
    * [Wed Nov 3 13:08:33 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'ceilingDueDate' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2353.
    * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'AmazonReviews' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2377.
    * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'AllowNotForLoanOverride' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2395.
    * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'RenewalPeriodBase' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2412.
    * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'viewISBD' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2455.
    * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'viewLabeledMARC' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2456.
    * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'viewMARC' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2457.
    * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'AWSPrivateKey' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2501.
    * [Wed Nov 3 13:09:04 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Table 'fieldmapping' already exists at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2695.
    * [Wed Nov 3 13:09:04 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate column name 'finedays' at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      2752.
    * [Wed Nov 3 13:10:16 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
      './koha-tmpl/opac-tmpl/prog/en/xslt/MARC21slim2OPACResults.xsl,'YesNo')'
      at line 2 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      3449.
    * [Wed Nov 3 13:10:16 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
      './koha-tmpl/opac-tmpl/prog/en/xslt/MARC21slim2OPACDetail.xsl,'YesNo')'
      at line 2 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      3453.
    * [Wed Nov 3 13:10:16 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'reserves-HOLDPLACED' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      3561.
    * [Wed Nov 3 13:10:16 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry '9-edit_items' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      3663.
    * [Wed Nov 3 13:10:16 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry '15-check_expiration' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      3672.
    * [Wed Nov 3 13:10:19 2010] updatedatabase.pl: DBD::mysql::db do
      failed: Duplicate entry 'HomeOrHoldingBranchReturn' for key 1 at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      3754.
    * [Wed Nov 3 13:10:19 2010] updatedatabase.pl: Argument "3.0100XXX"
      isn't numeric in numeric lt (<) at
      /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line
      3803.

-- 
Ing. J. Martin Longo
Depto. Gestion Informatica
SID - UNCuyo
http://sid.uncu.edu.ar