Hi all I have a problem that I'm finding difficult to fix. My head hurts! I hope somebody in the community can help. :(
I have;
Oscommerce 2.2 MS2 with lots of contributions added
In particular I am using "Attribute Sorter and Copier v.6.0.2" and "add-weight-to-product-attributes v0.2".
Now, I installed and have been using sorter and copier for a few days and all was fine. I then installed add weight to attributes contribution. The install went fine and i am 99% sure i merged the files as per the instructions. The problem is now when i create a new product and add the attributes that the product needs I click on preview and then submit but receive the following error message;
1136 - Column count doesn't match value count at row 1
insert into products_attributes values ('', '199', '6', '15', '', '', '1')
[TEP STOP]
The new product is created but attributes are not saved. I can add the attributes to the products in the product attributes screen still.
I've followed countless numbers of forum threads trying to find a fix but there isn't one specifically aimed at my issue. I'm sure to a php developer it's obvious but i'm not a coder so i'm finding it difficult.
I can see that there is an insert of 7 fields and i know that my DB has 8 fields. The one that I think is missing from the insert is the "options_values_weight" field (this does exist in my DB as part of the add-weight-to-product-attributes v0.2 contribution.
1. I do not know which .php file is actioning thie insert command? Is it admin/categories.php?
2. Has anyone else fixed this problem for themselves and is able to share?
Any help or suggestions is greatly appreciated.
Many thanks.