Error message when copying product

[ozcsys]

When I go to copy a product I get the message below. Now this usually is the message that shows up when my files do not match the database and the

products_last_modified field is the one not listed in the error message so I am assuming that is the problem and my admin/categories.php has been modified quite a bit but I wen through it and compared it to a virgin file and could not find any instances of the last_modified field missing.

 

Is there another file that could be causing the problem?

 

Any Ideas would be great.

 

Thanks

 

1136 - Column count doesn't match value count at row 1

 

insert into products (products_quantity, products_model,products_image, products_price, products_cost, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('', '', '', '', now(), '', '', '0', '0', '0')

 

[TEP STOP]

[Guest]

if you count how many variables you are entering to products, then count how many values you will see they are different

[ozcsys]

if you count how many variables you are entering to products, then count how many values you will see they are different

Well I kinda know what the problem is I just do not know where it is.

 

The only time it comes up is when copying a product to another category. It does not come up when I add a new product or copy a product by linking them. I have looked through the code and did not see the problem so I was hoping maybe someone could help me narrow the search down abit. The url looks like this if that helps.

 

/admin/categories.php?action=copy_to_confirm&cPath=27

 

Thanks

[Guest]

Did you ever get this error fixed I have just found this error also in my new store which I was goin to launch this week, but not until this is sorted now im affraid.

 

many thx in advance for any help on this.

[Guest]

I'm getting this same exact error, and only when attempting to copy a product into another category as a duplicate, it works fine when linking.

 

Another problem with having one product in mulitple categories (via linking) is that the function for returning the product's category path doesn't seem to work. In general.php, it's called tep_get_product_path, and when a product is listed in multiple categories its cPath value seems to be null. Anyone know of a fix for this? It's screwing up all my breadcrumb links!

 

Thanks,

Mike

[Guest]

I have sorted this in categories.php where the db query wasnt matching the fetch array.