free call for price

[jstomasi]

I am encountering the following error after installing and updating the freecallforprice contribution. I have been over all the files that are included in v.3.0, update 1 & 2 but still cannot seem to resolve the following error which only occurs when you try to open a subcategory

 

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_image, pd.products_name, p.products_model, p

 

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

 

Any help someone may be able to provide would be greatly appreciated

[Guest]

This contribution has not been updated since July 2002 :blink:

 

It is way out of date with the current release of osCommerce.

 

The error is most likely caused by the splitPageResults class (incompatibility).

 

Matti

[jstomasi]

Matti,

 

Thanks for the info.

 

I did a little digging and found that if you restore /catalog/includes/modules/products_listing.php back to the latest release, the FREECALLFORPRICE contribution works.

 

I do not know what the impact is at this point, but everything seems to be functioning properly now.

 

Regards,

 

JT