If you want to try to get to the bottom of the issue check out the index filters. I suspect that there may be one that you use for columns that are not default zen cart. If this is the case then make make sure that in the code where ever you have ' . TABLE_PRODUCTS . ' in the code that it is followed by '" p .." if you do not have the space then the table name will have p appended to it and if the space p is missing then it will not be recognised." below is and example of ok
PHP Code:
$listing_sql = "select " . $select_column_list . " p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, if(s.status = 1, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status
from " . TABLE_PRODUCTS . " p left join "
not ok
PHP Code:
$listing_sql = "select " . $select_column_list . " p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, if(s.status = 1, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status
from " . TABLE_PRODUCTS . "p left join "
Could be worth checking out just in case you want to use rows for your listing.
they are in includes\index_filters\ or just search for $listing_sql.
Bookmarks