updatedatabase errors
I've just been taking a database from 3.01.00.61 to 3.01.00.107. (That's HEAD prior to Galen's last big pile of patches to the current biblibre community 3.2. Enroute updatedatebase throws a lot of errors due to duplication, incorrect sequencing of updates etc. As the may be of interest elsewhere (I'm sure someone said they were looking at these problems) I've uploaded a branch to my github: git@github.com:colinsc/koha.git called dbupgrade3.2 which contains the changes I needed to make to get updatedatabase run error-free. Cheers Colin -- Colin Campbell Chief Software Engineer, PTFS Europe Limited Content Management and Library Solutions +44 (0) 208 366 1295 (phone) +44 (0) 7759 633626 (mobile) colin.campbell@ptfs-europe.com skype: colin_campbell2 http://www.ptfs-europe.com
Hi Colin, On Mon, Jan 25, 2010 at 10:35 AM, Colin Campbell <colin.campbell@ptfs-europe.com> wrote:
I've just been taking a database from 3.01.00.61 to 3.01.00.107. (That's HEAD prior to Galen's last big pile of patches to the current biblibre community 3.2. Enroute updatedatebase throws a lot of errors due to duplication, incorrect sequencing of updates etc. As the may be of interest elsewhere (I'm sure someone said they were looking at these problems) I've uploaded a branch to my github: git@github.com:colinsc/koha.git called dbupgrade3.2 which contains the changes I needed to make to get updatedatabase run error-free.
Checkout Bug 4046... http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4046 I'm not sure if this addresses all of the issues you found or not. Kind Regards, Chris
On 25/01/10 16:18, Chris Nighswonger wrote:
Hi Colin,
On Mon, Jan 25, 2010 at 10:35 AM, Colin Campbell <colin.campbell@ptfs-europe.com> wrote:
I've just been taking a database from 3.01.00.61 to 3.01.00.107. (That's HEAD prior to Galen's last big pile of patches to the current biblibre community 3.2. Enroute updatedatebase throws a lot of errors due to duplication, incorrect sequencing of updates etc. As the may be of interest elsewhere (I'm sure someone said they were looking at these problems) I've uploaded a branch to my github: git@github.com:colinsc/koha.git called dbupgrade3.2 which contains the changes I needed to make to get updatedatabase run error-free.
Checkout Bug 4046... http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4046
I'm not sure if this addresses all of the issues you found or not.
Thanks Chris. Actually the issues I found were in a system with this patch already applied and were less syntax errors than operations carried out in an invalid sequence or twice. Cheers Colin -- Colin Campbell Chief Software Engineer, PTFS Europe Limited Content Management and Library Solutions +44 (0) 208 366 1295 (phone) +44 (0) 7759 633626 (mobile) colin.campbell@ptfs-europe.com skype: colin_campbell2 http://www.ptfs-europe.com
Are we talking about these error messages: Update errors : * [Tue Jan 26 12:05:32 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '9-edit_catalogue' for key 1 at /home/nengard/kohaclone/installer/data/mysql/updatedatabase.pl line 3316. * [Tue Jan 26 12:05:32 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '13-moderate_tags' for key 1 at /home/nengard/kohaclone/installer/data/mysql/updatedatabase.pl line 3323. * [Tue Jan 26 12:05:33 2010] patroncards_upgrade.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 'USING BTREE, * [Tue Jan 26 12:05:33 2010] patroncards_upgrade.pl: KEY `branch_fk_constraint` (`branch_code`), * [Tue Jan 26 12:05:33 2010] patroncards_upgrade.pl: KEY `item_f' at line 9 at /home/nengard/kohaclone/installer/data/mysql/patroncards_upgrade.pl line 38. * [Tue Jan 26 12:05:33 2010] patroncards_upgrade.pl: DB ERROR: 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 'USING BTREE, * [Tue Jan 26 12:05:33 2010] patroncards_upgrade.pl: KEY `branch_fk_constraint` (`branch_code`), * [Tue Jan 26 12:05:33 2010] patroncards_upgrade.pl: KEY `item_f' at line 9 If so - I too got them today when I did a rebase from the newly updated HEAD. Thanks Nicole On Mon, Jan 25, 2010 at 12:02 PM, Colin Campbell <colin.campbell@ptfs-europe.com> wrote:
On 25/01/10 16:18, Chris Nighswonger wrote:
Hi Colin,
On Mon, Jan 25, 2010 at 10:35 AM, Colin Campbell <colin.campbell@ptfs-europe.com> wrote:
I've just been taking a database from 3.01.00.61 to 3.01.00.107. (That's HEAD prior to Galen's last big pile of patches to the current biblibre community 3.2. Enroute updatedatebase throws a lot of errors due to duplication, incorrect sequencing of updates etc. As the may be of interest elsewhere (I'm sure someone said they were looking at these problems) I've uploaded a branch to my github: git@github.com:colinsc/koha.git called dbupgrade3.2 which contains the changes I needed to make to get updatedatabase run error-free.
Checkout Bug 4046... http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4046
I'm not sure if this addresses all of the issues you found or not.
Thanks Chris. Actually the issues I found were in a system with this patch already applied and were less syntax errors than operations carried out in an invalid sequence or twice.
Cheers Colin
-- Colin Campbell Chief Software Engineer, PTFS Europe Limited Content Management and Library Solutions +44 (0) 208 366 1295 (phone) +44 (0) 7759 633626 (mobile) colin.campbell@ptfs-europe.com skype: colin_campbell2
http://www.ptfs-europe.com _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
Hi Nicole, On Tue, Jan 26, 2010 at 7:41 PM, Nicole Engard <nengard@gmail.com> wrote:
Are we talking about these error messages:
Update errors :
<snip>
If so - I too got them today when I did a rebase from the newly updated HEAD.
These could come from the updatedatabase.pl script being out of sync due to differences in the branches being merged today. Kind Regards, Chris
On Mon, Jan 25, 2010 at 12:02 PM, Colin Campbell <colin.campbell@ptfs-europe.com> wrote:
On 25/01/10 16:18, Chris Nighswonger wrote:
Hi Colin,
On Mon, Jan 25, 2010 at 10:35 AM, Colin Campbell <colin.campbell@ptfs-europe.com> wrote:
I've just been taking a database from 3.01.00.61 to 3.01.00.107. (That's HEAD prior to Galen's last big pile of patches to the current biblibre community 3.2. Enroute updatedatebase throws a lot of errors due to duplication, incorrect sequencing of updates etc. As the may be of interest elsewhere (I'm sure someone said they were looking at these problems) I've uploaded a branch to my github: git@github.com:colinsc/koha.git called dbupgrade3.2 which contains the changes I needed to make to get updatedatabase run error-free.
Checkout Bug 4046... http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4046
I'm not sure if this addresses all of the issues you found or not.
Thanks Chris. Actually the issues I found were in a system with this patch already applied and were less syntax errors than operations carried out in an invalid sequence or twice.
Cheers Colin
-- Colin Campbell Chief Software Engineer, PTFS Europe Limited Content Management and Library Solutions +44 (0) 208 366 1295 (phone) +44 (0) 7759 633626 (mobile) colin.campbell@ptfs-europe.com skype: colin_campbell2
http://www.ptfs-europe.com _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
Hi, On Mon, Jan 25, 2010 at 10:35 AM, Colin Campbell <colin.campbell@ptfs-europe.com> wrote:
I've just been taking a database from 3.01.00.61 to 3.01.00.107. (That's HEAD prior to Galen's last big pile of patches to the current biblibre community 3.2. Enroute updatedatebase throws a lot of errors due to duplication, incorrect sequencing of updates etc. As the may be of interest elsewhere (I'm sure someone said they were looking at these problems) I've uploaded a branch to my github: git@github.com:colinsc/koha.git called dbupgrade3.2 which contains the changes I needed to make to get updatedatabase run error-free.
I've merged this branch in with thanks. Regards, Galen -- Galen Charlton gmcharlt@gmail.com
participants (4)
-
Chris Nighswonger -
Colin Campbell -
Galen Charlton -
Nicole Engard