Quote Originally Posted by Draxwyn View Post
Hi Anne,

I have found a problem that I have been able to locate to part of this template, and I suspect this file; tpl_modules_product_listing.php. I get no products displayed when clicking the all products, specials, featured products and new products pages. I managed to get the specials, new products to work by using the zencart default (not ideal as some formatting is out) but the others do not. Here is the error message I am getting from the log file;

PHP Fatal error: 1109:Unknown table 'p' in field list :: select count(p.products_id) as total ==> (as called by) /includes/classes/split_page_results.php on line 86 <== in /includes/classes/db/mysql/query_factory.php on line 155

although this error says split_page_results I have managed to trace it back to tpl_modules_product_listing.php at which point I am lost as to the problem, so suspect that it is further in another file somewhere.

The error displayed to customers is 'WARNING: An Error occurred, please refresh the page and try again.' obviously doing so does not work. Just wondering if you could shed any light on this as it is definitely a template issue as the default works fine.

~R
This is not an inherent problem with the template package. My guess is that you have a plugin installed that has files in the old override folder that you have not copied to the new template override folder.

Thanks,

Anne