Print_Catalog

[dmschool]

Hi,

 

I have installed Print_Catalog, which I think is a marvelous feature if I can get it to work. If anyone else has been successful on 2.2 MSV, I would love to know how? I am a newbie and have no SQL experience.

 

I currently get the following error, which I have seen in many other posts to the forums, but with no reply on how to fix it:

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select p.products_id, pd.products_name, pd.products_descrip

 

select count(select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, cd.categories_name, m.manufacturers_name from products p left join products_to_categories p2c on p.products_id=p2c.products_id left join categories c on p2c.categories_id=c.categories_id left join categories_description cd on c.parent_id=\'0\' and c.categories_id=cd.categories_id left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = \'1\' left join specials s on p.products_id = s.products_id where products_status = \'1\' order by cd.categories_name, c.parent_id, c.sort_order, c.categories_id, pd.products_name) as total

 

[TEP STOP]

 

If anyone can help me fix this, I would appreciate the help.

 

Kind Regards,

 

Penny

[Guest]

try this contribution

 

http://www.oscommerce.com/community/contributions,1410

 

it worked by me, i had also the same problem