Error can not add product wrong product type

[DrByte]

You should only have product_type_to_category records for categories that have restrictions on them.

So ... fastest way to fix ....
1. truncate the product_type_to_category table
..... actually, check the table structure in your database vs the original in the mysql_zencart.sql file in the zc_install folder. Perhaps even drop and recreate it.

2. Now go and rebuild all your product-type restrictions on each of your categories.

3. Be sure to do good backups.

4. Go back and look at all your code-customizations to find out if anything you've changed could affect that table in any way.

[cshart]

You should only have product_type_to_category records for categories that have restrictions on them.

So ... fastest way to fix ....
1. truncate the product_type_to_category table
..... actually, check the table structure in your database vs the original in the mysql_zencart.sql file in the zc_install folder. Perhaps even drop and recreate it.

2. Now go and rebuild all your product-type restrictions on each of your categories.

3. Be sure to do good backups.

4. Go back and look at all your code-customizations to find out if anything you've changed could affect that table in any way.

Lost my DSL last night so am just getting back to this today.

Where do I rebuild the product-type restrictions? Are you saying if the product uses the default template when there is no category in the table for them???

If the category document product has a special template then the two categories I have using that template SHOULD be in the product_type to categories table??? and all others not???

Thanks for the help.

C

[DrByte]

I think there needs to be some clarification on functionality.


Category "restrictions" ONLY restrict which product-types you can use to CREATE NEW products within said category.


Whatever product type you use to create a product ... is what will be used to display that product. It has NOTHING to do with the restrictions in the admin related to a given category.

Categories can contain products of any product type. But the restrictions affect creation of NEW products.

[DrByte]

This is how you set up restrictions related to creating new products in a given category:

2. Admin->Catalog->Categories/Products ... edit the category you're getting the error with. t bottom of category edit details you see the product types which this category has been restricted to create?

[cshart]

Success --- dumped the table and put the new data in and voila things are working again.

Thanks for the help.

C