Hi,
i am using oscommerce OSC v2.2rc2a and I installed Products Specifications v 1_0_2 but things doesn't look right. Filters don't show up although they are set in admin and I have a lot of errors like:
1146 - Table 'rsma4971_smartpc.TABLE_PRODUCTS_IMAGES' doesn't exist
select p.products_id, pd.products_name, pd.products_description, pd.products_index_description, p.products_quantity, p.products_model, pi.image_filename, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_weight, p.products_tax_class_id, m.manufacturers_name, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join specials s on (p.products_id = s.products_id) left join manufacturers m on ( p.manufacturers_id = m.manufacturers_id ) join products_description pd on (pd.products_id = p.products_id) left join TABLE_PRODUCTS_IMAGES pi on (pd.products_id = pi.products_id and pi.category_page = '1') where pd.products_id = '115' and pd.language_id = '4'
or
1054 - Unknown column 'c.show_comparison' in 'field list'
or
1054 - Unknown column 'p.products_sort_order' in 'order clause'
or
1146 - Table 'rsma4971_smartpc.TABLE_PRODUCTS_IMAGES' doesn't exist
From these errors i'm guessing this version of Products Specifications was not designed for my version of OSC.
Can you tell me please if I'm doing something wrong?
Thanks!