Products Extra Fields error

[Guest]

After very carefully installing the Products Extra Fields contribution, I receive this error:

 

1054 - Unknown column 'products_extra_fields_order' in 'order clause'

 

Any suggestions would be greatly appreciated.

Thanks!

[Guest]

I figured it out about 30 minutes later. And to give back to the community, here is what went wrong (please ad to this post and help me clarify):

 

When I origionally updated my database using the following code:

 

DROP TABLE IF EXISTS products_extra_fields;

CREATE TABLE products_extra_fields (

products_extra_fields_id int NOT NULL auto_increment,

products_extra_fields_name varchar(64) NOT NULL default '',

products_extra_fields_order int(3) NOT NULL default '0',

products_extra_fields_status tinyint(1) NOT NULL default '0',

PRIMARY KEY (products_extra_fields_id)

);

 

DROP TABLE IF EXISTS products_to_products_extra_fields;

CREATE TABLE products_to_products_extra_fields (

products_id int NOT NULL,

products_extra_fields_id int NOT NULL,

products_extra_fields_value varchar(64),

PRIMARY KEY (products_id,products_extra_fields_id)

);

ALTER TABLE `products_extra_fields` ADD `languages_id` INT( 11 ) DEFAULT '0' NOT NULL ;

 

This DID create the field "products_extra_fields" But, there was an error - and instead of adding the field_id field_name, field_order, field_status - as requested. It somehow skipped "order" & "status".

 

All I had to do was delete the field (using phpmyadmin) and run the code again. Solved.

I know this is vague. I am not a very experienced programmer. If somebody could please help me clarify, because this explanation could be much easier.

 

Hope this helps! It worked for me.