Quote Originally Posted by a_berezin View Post
BlessIsaacola!

1. Use products_price_sorter field instead of function zen_get_products_actual_price;
2. Use selected type_handler field instead of function zen_get_info_page;
Test this one.
It did not work. I got the following error:

1054 Unknown column 'databaseDELETED.m.products_id' in 'on clause'
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler FROM products p LEFT JOIN manufacturers m USING (manufacturers_id) LEFT JOIN products_description pd USING (products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_id ASC]

Please note that for security reasons, I have deleted the database name from the first line of the error.

Thanks!