[Koha] Upgrading from 3.0.6 to 3.2
Martin Longo
jmlongo at uncu.edu.ar
Thu Nov 4 05:26:23 NZDT 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20101103/a460a9c0/attachment.htm
More information about the Koha
mailing list