Hi,
you can use this post to solve. I had same problems and used the fix for new products.
http://www.zen-cart.com/forum/showpo...0&postcount=26
Copy and paste the 2 last rows or the whole query to your recent_products.php (includes/modules/sideboxes/yourtemplate) so it looks like this:
Code:
$recent_products_query = "select p.products_id, p.products_image
from " . TABLE_PRODUCTS . " as p, " . TABLE_PRODUCTS_DESCRIPTION . " as pd "
. $sub_query ."
and p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_status = 1 " . $display_limit;
If you paste the 2 last rows to your existing query dont forget to move the ; from pd.products_id to the end of the query instead.
Bookmarks