[Koha-devel] updatedatabase errors

[Nicole Engard]

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 at 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 at 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 at 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 at ptfs-europe.com
> skype: colin_campbell2
>
> http://www.ptfs-europe.com
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel
>