Date index for Aug 2002
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [achievo] Stuck in "Insert Jail"
Ivo,
When I set the config_debug=2, the problem is immediately visible:
THE INSERT FOR THE AUTO_INCREMENT is incorrect.
The SQL is assembled as:
error: Duplicate entry '1' for key 1 (errno: 1062)
error: Invalid SQL: INSERT INTO Technology_SubClasses
(Technology_SubClass_ID,Technology_ParentClass_ID,Technology_SubClass_De
sc) VALUES ('1','3','test')
My script has the AUTO_INCREMENT/Technology_SubClass_ID hidden, while I
(temporarily) input the other two values.
When I input 3 and 'test', I think it should produce:
VALUES (0,3,'test')
but instead, as per the error above, it shows:
VALUES ('1','3','test')
That would seem to be something from the baseline Achievo, right?
TIA.
Dave
> Hi,
>
> Dave Nuttall wrote:
>
> > Is there something "unusual" due to the pair of int fields? For
> > example, if I take out the Technology_ParentClass_ID field, the
scripts
> > will work.
>
> Your database definition looks alright. If you put config_debug to 2,
in
> atkconf.inc, do you get any errors on the screen after trying to
insert
> the second record?
>
> Greetings,
> Ivo
>
> --
> Ivo Jansch <ivo dot
> ibuildings.nl BV - information technology
> http://www.ibuildings.nl
>
>
>
> [ Achievo mailing list - http://www.achievo.org/ ]
> [ to unsubscribe send an e-mail to achievo-unsubscribe dot
>
>