Unknown column 'p.products_id' in 'on clause'

[ejwebster]

Hi,

I have been tasked with the problem of supporting a clients Zen Cart site, which I think is 1.2 and has the p2c patch in index_filters/default_filter.php

We are unable to use the products_price_manager with sub categories and get a line
PRODUCTS_PRICE_IS_CALL_FOR_PRICE_TEXT 1054 Unknown column 'p.products_id' in 'on clause'
across the front of the page. The end of the URL link is products_filter=394&current_category_id=5

The products_image_manager which looks the same layout, has PRODUCTS_PRICE_IS_CALL_FOR_PRICE_TEXT across it but does show the products and images, with products_filter=394&current_category_id=5 at the end of the URL link.

Any ideas or help greatly appreciated.

[DrByte]

Seems like you're missing a define statement for PRODUCTS_PRICE_IS_CALL_FOR_PRICE_TEXT somewhere.
Related FAQ: https://www.zen-cart.com/tutorials/index.php?article=95