1054 - Unknown column 'popt.products_options_name' in 'field list'

[qm360]

When I click add to cart button I get the following error:

 

 

1054 - Unknown column 'popt.products_options_name' in 'field list'

 

select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from products_options popt, products_options_values poval, products_attributes pa where pa.products_id = '698{2}7' and pa.options_id = '2' and pa.options_id = popt.products_options_id and pa.options_values_id = '7' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '1' and poval.language_id = '1'

 

 

Note this happens only on products that have options, like color, and sizes.

 

this is what I have on product_info_tlp.php

 

$products_options_query = tep_db_query("select pa.options_id, pa.options_values_id, pa.options_values_price, pa.price_prefix, po.options_type, po.options_length, pot.products_options_name, pot.products_options_instruct, ptov.products_options_values_name from

" . TABLE_PRODUCTS_ATTRIBUTES . " pa left join

" . TABLE_PRODUCTS_OPTIONS_VALUES . " ptov on pa.options_values_id = ptov.products_options_values_id left join

" . TABLE_PRODUCTS_OPTIONS . " po on pa.options_id = po.products_options_id left join

" . TABLE_PRODUCTS_OPTIONS_TEXT . " pot on po.products_options_id = pot.products_options_text_id and pot.language_id = '" . (int)$languages_id . "'

where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'

and ptov.products_options_values_id is not null

and po.products_options_id is not null

order by pa.products_options_sort_order, ptov.products_options_values_id

");

 

Can any body help?

[healthyb]

When I click add to cart button I get the following error:

1054 - Unknown column 'popt.products_options_name' in 'field list'

 

select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from products_options popt, products_options_values poval, products_attributes pa where pa.products_id = '698{2}7' and pa.options_id = '2' and pa.options_id = popt.products_options_id and pa.options_values_id = '7' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '1' and poval.language_id = '1'

Note this happens only on products that have options, like color, and sizes.

 

this is what I have on product_info_tlp.php

 

$products_options_query = tep_db_query("select pa.options_id, pa.options_values_id, pa.options_values_price, pa.price_prefix, po.options_type, po.options_length, pot.products_options_name, pot.products_options_instruct, ptov.products_options_values_name from

" . TABLE_PRODUCTS_ATTRIBUTES . " pa left join

" . TABLE_PRODUCTS_OPTIONS_VALUES . " ptov on pa.options_values_id = ptov.products_options_values_id left join

" . TABLE_PRODUCTS_OPTIONS . " po on pa.options_id = po.products_options_id left join

" . TABLE_PRODUCTS_OPTIONS_TEXT . " pot on po.products_options_id = pot.products_options_text_id and pot.language_id = '" . (int)$languages_id . "'

where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'

and ptov.products_options_values_id is not null

and po.products_options_id is not null

order by pa.products_options_sort_order, ptov.products_options_values_id

");

 

Can any body help?

Hello

Very similar to the problem happening to my site today. All was well until I got an email saying they could not get into my Catagories and Manufacturers Section. THe error message is listed below here. ALl the other sections and the cart are working fine. COuld anyone help in what may have caused this error and what to do to fix it!

 

THanks

JO

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '30'

 

[TEP STOP]