22 Apr 2008, 7:17 PM
New Zenner
- Join Date:
- Apr 2008
- Posts:
- 1
- Plugin Contributions:
- 0
Unknown column 'p.products_id' in 'on clause'
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¤t_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¤t_category_id=5 at the end of the URL link.
Any ideas or help greatly appreciated.:frusty:
