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