help asap if u can

[Quicksilver]

hi i set up qtpro32

 

this when i am Categories / Products

they got stock button ,when i hot that this Comes up

 

1054 - Unknown column 'products_options.special' in 'where clause'

select products_name,products_options_name as _option,products_attributes.options_id as _option_id,products_options_values_name as _value,products_attributes.options_values_id as _value_id from products_description, products_attributes,products_options,products_options_values where products_attributes.products_id=products_description.products_id and products_attributes.products_id=45 and products_attributes.options_id=products_options.products_options_id and products_attributes.options_values_id=products_options_values.products_options_v
alues_id and products_description.language_id=1 and products_options_values.language_id=1 and products_options.special=0 and products_options.language_id=1 order by products_attributes.options_id, products_attributes.options_values_id

[TEP STOP]

[thetraveller]

hi i set up qtpro32

 

this when i am Categories / Products

  they got stock button ,when i hot that this Comes up

 

1054 - Unknown column 'products_options.special' in 'where clause'

select products_name,products_options_name as _option,products_attributes.options_id as _option_id,products_options_values_name as _value,products_attributes.options_values_id as _value_id from products_description, products_attributes,products_options,products_options_values where products_attributes.products_id=products_description.products_id and products_attributes.products_id=45 and products_attributes.options_id=products_options.products_options_id and products_attributes.options_values_id=products_options_values.products_options_v
alues_id and products_description.language_id=1 and products_options_values.language_id=1 and products_options.special=0 and products_options.language_id=1 order by products_attributes.options_id, products_attributes.options_values_id

[TEP STOP]

<{POST_SNAPBACK}>

 

You are missing a field in your database. Did you do the COMPLETE setup when you installed the contrib?

 

John

[Quicksilver]

can some one tell me how do this ALTER TABLE `products_options` ADD `special` tinyint(4) default '0' not null AFTER `products_options_name`;

 

drop table if exists products_stock;

create table products_stock (

products_stock_id int(11) not null auto_increment,

products_id int(11) default '0' not null ,

products_stock_attributes varchar(255) ,

products_stock_quantity int(11) default '0' not null ,

PRIMARY KEY (products_stock_id, products_id),

KEY idx_products_stock_attributes (products_stock_attributes)

);

[thetraveller]

can some one tell me how do this  ALTER TABLE `products_options` ADD `special` tinyint(4) default '0' not null AFTER `products_options_name`;

 

drop table if exists products_stock;

create table products_stock (

  products_stock_id int(11) not null auto_increment,

  products_id int(11) default '0' not null ,

  products_stock_attributes varchar(255) ,

  products_stock_quantity int(11) default '0' not null ,

  PRIMARY KEY (products_stock_id, products_id),

  KEY idx_products_stock_attributes (products_stock_attributes)

);

<{POST_SNAPBACK}>

 

 

Use phpMyAdmin to make the changes.

 

John