Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Products Extra Fields error


Guest

Recommended Posts

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...