1054 - Unknown column 'popt.products_options_type

Anonymous · 02-17-2004, 09:04 PM

opening detail downloadable products but get this error

Code:

sample download
&#91;DL 1&#93; 	$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

&#91;TEP STOP&#93;

any clue?[/code]

**michael_s** · 02-18-2004, 06:03 AM

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.

Anonymous · 02-24-2004, 11:15 PM

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

Anonymous · 02-24-2004, 11:30 PM

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...

Anonymous · 03-08-2004, 01:46 AM

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

Anonymous · 03-08-2004, 01:47 AM

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