Error code while trying to view a product

[jim cushman]

I get this error code while trying to view individual items from a sub category. It lists all the items, then when you click on the spedific item to view it, I get this:

Home :: Engines & Components :: Internals :: Piston/Rod Kits :: Forged Rod Kits :: CP Forged Piston/Rod Kit 5.4L - 35cc
1054 Unknown column 'popt.products_options_rows' in 'field list'
in:
[select distinct popt.products_options_id, popt.products_options_name, popt.products_options_sort_order, popt.products_options_type, popt.products_options_length, popt.products_options_comment, popt.products_options_size, popt.products_options_images_per_row, popt.products_options_images_style, popt.products_options_rows from products_options popt, products_attributes patrib where patrib.products_id='1385' and patrib.options_id = popt.products_options_id and popt.language_id = '1' order by LPAD(popt.products_options_sort_order,11,"0")]


It doesn't do it for all categories, only a few.

Any ideas?

[DrByte]

What version of Zen Cart? Has it ever been "upgraded"? from which version(s)?
What addons/contributions do you have installed?
What unique customizations have been made to the site?
What's the URL to a page where this can be seen/experienced first-hand?