Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / SQL Duplicate Entry Adding New Products and Categories

SQL Duplicate Entry Adding New Products and Categories

Views: 1,335

Results 1 to 5 of 5
21 Sep 2010, 3:27 AM
#1
gee38l avatar

gee38l

Zen Follower

Join Date:
Jul 2008
Posts:
362
Plugin Contributions:
0

SQL Duplicate Entry Adding New Products and Categories

I have had my store for about two years and all of the sudden im getting the following errors.

Creating a new product:

1062 Duplicate entry '0-147' for key 1
in:
[insert into products_to_categories (products_id, categories_id) values ('0', '147')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Also a similar error when creating a new product.

Everything was working fine yesterday afternoon.

Any assistance would be great

21 Sep 2010, 3:59 AM
#2
gee38l avatar

gee38l

Zen Follower

Join Date:
Jul 2008
Posts:
362
Plugin Contributions:
0

Re: SQL Duplicate Entry Adding New Products and Categories

I just had a quick look at my database and it seems every time i add a new product in product_to_categories its assigns it as product_id 0, And doesnt appear anywhere.

Same thing happens to categories:

1062 Duplicate entry '0-1' for key 1
in:
[insert into categories_description (categories_name, categories_description, categories_id, language_id) values ('Test', '
Test

', '0', '1')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I check in myphpadmin and its created a new category with id 0 and it doesnt show up anywhere.

21 Sep 2010, 8:32 AM
#3
gee38l avatar

gee38l

Zen Follower

Join Date:
Jul 2008
Posts:
362
Plugin Contributions:
0

Re: SQL Duplicate Entry Adding New Products and Categories

Anyone?

23 Sep 2010, 8:03 AM
#4
gee38l avatar

gee38l

Zen Follower

Join Date:
Jul 2008
Posts:
362
Plugin Contributions:
0

Re: SQL Duplicate Entry Adding New Products and Categories

Bump anyone?

17 May 2011, 8:50 PM
#5
ink avatar

ink

Zen Follower

Join Date:
Jul 2004
Posts:
140
Plugin Contributions:
0

Re: SQL Duplicate Entry Adding New Products and Categories

Did you every get a resolution? I've got the same twating problem cropped up out of the blue!