Syntax Error

[JaaMor]

I installed products sorter and copier contribution and now when you go to www.jewelrycabin.com and click on a category and then a subcategory, you get this:

 

When you click on a catagory in the catalog, you get this:

 

1064 - You have an error in your SQL syntax near 'select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p' at line 1

 

select count(select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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_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 = \'32\' order by pd.products_name) as total

 

[TEP STOP]

 

Can anyone tell me what file I need to fix and what needs fixing? I am at my wits end. Thanks for any help.

[jimmyhuang]

I have an error message as below:

 

1054 - Unknown column 'sort_order' in 'field list'

 

insert into products_attributes (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, sort_order) values (NULL, '59', '1', '24', '8.8000', '+', '')

 

[TEP STOP]