erro 1062 when adding a new category

[gavztheouch]

Hi i've been running oscommerce for around 6 months relatively smoothly, I decided to add another Catergory today and ran into this problem, with the following message.

 

1062 - Duplicate entry '0-1' for key 1

 

insert into categories_description (categories_name, categories_htc_title_tag, categories_htc_desc_tag, categories_htc_keywords_tag, categories_htc_description) values ('Electronics', 'Electronics', 'Electronics', 'Electronics', '')

 

[TEP STOP]

 

How should I solve this problem?

 

Many thanks

Gavin

[gavztheouch]

Looking a the database it looks like the category was added with a id of zero (0)

 

Edit update: Problem solved I hope! the catergory id was set at 0 and the description at 48. I changed them both to 48 using phpmyadmin and the category is now added.