I did check the db, and mine is set to auto increment, however I still get
the following also. I will try to investigate further when time allows.
db_ping(mysql) Connection to DB Restored... db_ping(mysql) Connection to DB
Restored... db_ping(mysql) Connection to DB Restored... db_ping(mysql)
Connection to DB Restored... db_ping(mysql) Connection to DB Restored...
Query Failed - table_insert(severity) - insert into severity
(severity,bgcolor,fgcolor) VALUES ('New Severity','000000','FFFFFF') -
Duplicate entry '127' for key 1
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 4:17 PM
To: Javier Szyszlican
Cc: [EMAIL PROTECTED]
Subject: Re: [jffnms-users] database problem
Yes, 0.7.9, but I get the same error(ERROR 1062: Duplicate entry '127' for
key 1) wether I try 3,4 or 5 fields.
Jeff
> Hi Jeff,
>
> Are you running 0.7.9 ?
>
> it seems the SQL query is lacking the level field.
> In the mean time, you can add it manually via mysql.
>
> Javier
>
> [EMAIL PROTECTED] wrote:
>> Hello,
>>
>> I am experiencing a problem in trying to add a "severity". When I click
>> "add", a database error is returned;
>>
>> db_ping(mysql) Connection to DB Restored... db_ping(mysql) Connection to
>> DB Restored... db_ping(mysql) Connection to DB Restored...
>> db_ping(mysql)
>> Connection to DB Restored... db_ping(mysql) Connection to DB Restored...
>> Query Failed - table_insert(severity) - insert into severity
>> (severity,bgcolor,fgcolor) VALUES ('New Severity','000000','FFFFFF') -
>> Duplicate entry '127' for key 1
>>
>> I get this error when I try to add a second severity, that is to say,
>> the
>> first attempt appears to complete successfully but the second entry
>> fails.
>>
>> I've tried repairing the severity table, both internally and by shutting
>> down the database and doing the repair from the command line.
>>
>> I get the same error when I try to do a manual insert in the database.
>>
>>
>> Jeff
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
>> Use IT products in your business? Tell us what you think of them. Give
>> us
>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out
>> more
>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>> _______________________________________________
>> jffnms-users mailing list
>> [EMAIL PROTECTED]
>> https://lists.sourceforge.net/lists/listinfo/jffnms-users
>
> --
> -=-=-=-=-=-=-=-=-
> Javier Szyszlican
> [EMAIL PROTECTED]
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
> Use IT products in your business? Tell us what you think of them. Give us
> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out
> more
> http://productguide.itmanagersjournal.com/guidepromo.tmpl
> _______________________________________________
> jffnms-users mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jffnms-users
>
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
jffnms-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jffnms-users
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
jffnms-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jffnms-users
