1054 - Unknown column 'popt.products_options_type

opening detail downloadable products but get this error

sample download
[DL 1] 	$0.00

Click to enlarge

Test download
1054 - Unknown column 'popt.products_options_type' in 'field list'

select distinct popt.products_options_id, popt.products_options_name, popt.products_options_type, popt.products_options_length, popt.products_options_comment from products_options popt, products_attributes patrib where patrib.products_id='64' and patrib.options_id = popt.products_options_id and popt.language_id = '1' order by popt.products_options_name

[TEP STOP]

any clue?[/code]

[michael_s]

You have added the option type feature mod, but have not run the included sql files on the database. Do that and the error goes away.

what do you mean? its all ok but after updating the newest template bts patch from this site this error comes up
i did inserting the bts sql from btsv1.2a_For_max_upgrade.zip

its weird i didn't installing option type 1.6 before patching the BTS 1.5a
i did clean install max 1.5.5 working fine then i did the bts1.5a patch and the errors showed up

i just inserting this without any files from option type 1.6 zip file, is that ok?
ALTER TABLE products_options
ADD products_options_type INT( 5 ) NOT NULL ,
ADD products_options_length SMALLINT( 2 ) DEFAULT '32' NOT NULL ,
ADD products_options_comment VARCHAR( 32 ) ;

ALTER TABLE customers_basket_attributes
ADD products_options_value_text VARCHAR( 32 ) ;

error is gone...

it seems the bts 1.2 upgrade for max 1.5.5 has some code included in the products_info.tpl.php file included in the aabox template content folder.

this should be taken out of the bts upgrade or it forces everyone to install option type feature 1.6

Originally Posted by Anonymous

it seems the bts 1.2 upgrade for max 1.5.5 has some code included in the products_info.tpl.php file included in the aabox template content folder.

this should be taken out of the bts upgrade or it forces everyone to install option type feature 1.6

i meant code from the option type 1.6 products_info.tpl.php