[nag] Upgrade from 1.1 -> 2.0

[Toby Schaefer]

New code gave 0 errors and appears to be working with some dummy data.
Thanks for the quick response!

Toby

-----Original Message-----
From: nag-bounces at lists.horde.org [mailto:nag-bounces at lists.horde.org] On
Behalf Of Jan Schneider
Sent: Wednesday, December 08, 2004 2:43 PM
To: nag at lists.horde.org
Subject: Re: [nag] Upgrade from 1.1 -> 2.0

Zitat von Toby Schaefer <toby-list at mail.nixa.k12.mo.us>:

> Hello all,
>
>
>   We are currently in the process of upgrading our horde configuration
from
> 1.1 to 2.0 on two separate mail servers.  I have been able to upgrade most
> of the user files for kronolith, mneno, etc; however, nag seems to
complain
> when I try to upgrade it.  When the script is run  (mysql --user=root -p
> horde < 1.1_to_2.0.mysql.sql) it will return
>
> ERROR 1062 at line 22: Duplicate entry '0' for key 1
>
> There are two primary keys in our 1.1 database, task_owner and task_id.
> With task_id having a default value of 0.   Is this a problem in the
upgrade
> script, or a unique problem?  Any help would be appreciated!

Can you try if what I committed works:
http://cvs.horde.org/co.php/nag/scripts/upgrades/1.1_to_2.0.mysql.sql?r=1.5

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/
-- 
Nag mailing list - Join the hunt: http://horde.org/bounties/#nag
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: nag-unsubscribe at lists.horde.org