help Decoding

[Baber.com]

well installed the is 1.0v free-call for price-coming soon add on

and on most things looks ok but on the product list get a error

you

can see this at

www.baber.com/store

 

just click on one of the product list and you get this error

 

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

select count(select p.products_model, m.manufacturers_name, 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 = \'1064111\' order by pd.products_name) as total 

TEP STOP

 

and in the readme file of this it say this

 

Process Prices:

/catalog/includes/classes/currencies.php

Add 3 if statements to processes the price before it is converted for the display of regular/special prices

 

i dont know if this has anything to do wiht it but doesnt make much since.........

 

 

if anybody knows how to fix this or can read this and tell me what the problem is that would be great i really really need to get this posted in the next couple of hours