Zen Link Every Added New Product To Another Category

Hi, This , I have never seen. I installed my zen 1.3.7 with some contribution also, now when I add a product, zen get automatically link it to a category RANDOMELY, it means every new product get link to a different category.

can somebody help me, I have to go to Products to Multiple Categories Link Manager in admin/attribute/ .... for every product and disable this link one by one. ooooooooops.

thanks in advance
reza

reza:

Hi, This , I have never seen. I installed my zen 1.3.7 with some contribution also, now when I add a product, zen get automatically link it to a category RANDOMELY, it means every new product get link to a different category.

can somebody help me, I have to go to Products to Multiple Categories Link Manager in admin/attribute/ .... for every product and disable this link one by one. ooooooooops.

thanks in advance
reza
in between I found a threat in
http://zen-cart.com/forum/showthread.php?t=52918
and I did all reset in admin/store manager and did update as I don't have many products, but it didn't change, although the error message of Master category problem disapear, but when I add a product, automatically linked to one another category randomely.
can it be due to installation and the uninstallation of an extra language? because I did it!!!!!!!!!!!!!
can somebody help me?

still no help ,
does anybody think if I reinstall database, it will resolve the problem? or does this comes from the files?

Check your products_to_categories table ...

This should only contain products_id and categories_id that actually exist ...

If it contains more, then as you add products if they happen to match up, they will be linked ...

hi Ajeh
this is what actually I see in products_to_categories table in browser of the table:
products_id categories_id
1 466
15 466
16 450
17 466
18 453
19 453
and in structure of the table;

Field Type Collation Attributes Null Default Extra Action
products_id int(11) No 0
categories_id int(11) No 0

Indexes: Keyname Type Cardinality Action Field
PRIMARY PRIMARY 25 products_id
categories_id
idx_cat_prod_id_zen INDEX 25 categories_id
products_id

at this time, when I add a product, immediately I have to look at it again to see with which category has been linked because it's randomely, and then I do delete this product but in delete page, I deselect the origine category(red color) and let the unwanted linked category to be deleted.
very time loosing , and I don't know what I have to do.

What categories_id are in the categories table?

What products_id are in the products table?

Something sounds off on the database tables if you are having this happen ...