<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello list ...<br>
<br>
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)
...<br>
<br>
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...<br>
<br>
And it did... almost.<br>
<br>
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.<br>
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):<br>
<br>
<ul>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
</ul>
<br>
<br>
Following I paste the errors reported by the updater (a little long
list)<br>
<br>
Thanks in advance<br>
<br>
<ul>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
<li class="update_error">[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.</li>
</ul>
<br>
<br>
<pre class="moz-signature" cols="72">--
Ing. J. Martin Longo
Depto. Gestion Informatica
SID - UNCuyo
<a class="moz-txt-link-freetext" href="http://sid.uncu.edu.ar">http://sid.uncu.edu.ar</a>
</pre>
</body>
</html>