standard attributes manager broken - HELP!!!

[scotch33]

Hi - I am trying to improve the attributes manager in a shop. I installed a contrib (Ajax attributions) and all seemed fine. However, once I discovered that the module is basically unfinished and thus effectively useless (though with great potential!) I deleted all elements it had added with the intention of returning to the old attribute system.

 

However, the old attribute system is now broken! Even though no files were changed in it. I am getting a 1136 error as below -

 

----------------------

 

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

 

insert into products_attributes values ('', '62', '1', '1', '', '+')

 

----------------------

 

I've looked at the table in the sql and it looks standard (see below) so the question is - how can i get past this to get the basic attributes correctly running again?

 

products_attributes_id int(11)

products_id int(11) NO

options_id int(11) NO

options_values_id int(11)

options_values_price decimal(15,4)

price_prefix char(1) NO

products_options_sort_order int(10)

[Alley Kat]

Did you sort this? I had the same and have fixed it. A table prob obviously so basically I went back to pre-AJAX: seemed a sort order had been added

 

`products_options_sort_order` int(10) unsigned NOT NULL default '0',

 

which was causing the break. i went back to the pre-ajax table:

 

CREATE TABLE `products_attributes` (

`products_attributes_id` int(11) NOT NULL auto_increment,

`products_id` int(11) NOT NULL default '0',

`options_id` int(11) NOT NULL default '0',

`options_values_id` int(11) NOT NULL default '0',

`options_values_price` decimal(15,4) NOT NULL default '0.0000',

`price_prefix` char(1) NOT NULL default '',

PRIMARY KEY (`products_attributes_id`)

) TYPE=MyISAM AUTO_INCREMENT=38 ;