Upgrading from 3.0.6 to 3.2
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
2010/11/3 Martin Longo <jmlongo@uncu.edu.ar>:
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) ...
It looks like you are actually upgrading to the current HEAD rather than the 3.02.00.004 release based on the last error thrown by updatedatabase.pl
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.
These is a bug and should be reported. It appears that the path/file should be quoted ($value in the lines referenced) and is not.
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
<snip> All of the lines complaining about already existing rows, duplicate keys, etc. can probably be safely ignored.
[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.
This is a bug and has been fixed. Kind Regards, Chris
En su momento, Chris Nighswonger escribió:
2010/11/3 Martin Longo <jmlongo@uncu.edu.ar>:
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) ...
It looks like you are actually upgrading to the current HEAD rather than the 3.02.00.004 release based on the last error thrown by updatedatabase.pl
Yep .. you were right. Switched now my branch to origin/3.2.x and tried to upgrade again, now to 3.02.00.005 updatedatabase.pl reported a lot less errors, all related to duplicated keys and already present tables. Now I'm testing and it seems that everything works as it should... and better :) Thanks a lot Martin -- Ing. J. Martin Longo Depto. Gestion Informatica SID - UNCuyo http://sid.uncu.edu.ar
Can you tell me where to find 3.02.005 on the koha-community download page? It seems all I get so far is 3.02.004. Thanks, Marty --- On Thu, 11/4/10, Martin Longo <jmlongo@uncu.edu.ar> wrote: From: Martin Longo <jmlongo@uncu.edu.ar> Subject: Re: [Koha] Upgrading from 3.0.6 to 3.2 To: "Chris Nighswonger" <cnighswonger@foundations.edu> Cc: koha@lists.katipo.co.nz Received: Thursday, November 4, 2010, 9:31 AM En su momento, Chris Nighswonger escribió:
2010/11/3 Martin Longo <jmlongo@uncu.edu.ar>:
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) ...
It looks like you are actually upgrading to the current HEAD rather than the 3.02.00.004 release based on the last error thrown by updatedatabase.pl
Yep .. you were right. Switched now my branch to origin/3.2.x and tried to upgrade again, now to 3.02.00.005 updatedatabase.pl reported a lot less errors, all related to duplicated keys and already present tables. Now I'm testing and it seems that everything works as it should... and better :) Thanks a lot Martin -- Ing. J. Martin Longo Depto. Gestion Informatica SID - UNCuyo http://sid.uncu.edu.ar _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
On Mon, Nov 15, 2010 at 9:03 AM, Marty <ontariowolf64@yahoo.com> wrote:
Can you tell me where to find 3.02.005 on the koha-community download page? It seems all I get so far is 3.02.004.
I think you mean you have 3.02.00.004... You will have to get 3.02.00.005 from the main git repo. You can download a tarball snapshot of it here: http://git.koha-community.org/gitweb/?p=koha.git;a=snapshot;h=9e75dd58ff5fe2... The next 3.2.x release to show up on the download site will be 3.02.01.000 on Nov. 22, 2010. Kind Regards, Chris
participants (3)
-
Chris Nighswonger -
Martin Longo -
Marty