Okay. I overwrite newproducts.php file offered for 4.0.x and called it. newproducts.tpl works now and Ive added products in last 3, 7 & 30 days that don't show. Says no new products and got top of page debug error:
Quote:
INVALID SQL: 0 :
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid) FROM xcart_products, xcart_categories, xcart_products_categories, xcart_pricing WHERE xcart_products.productid=xcart_products_categories .productid AND xcart_products_categories.categoryid=xcart_categor ies.categoryid AND xcart_products.productid=xcart_pricing.productid AND xcart_pricing.quantity=1 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' AND xcart_pricing.variantid = 0AND xcart_products.avail > 0 AND add_date > 1216504439 AND add_date < 1219096439 GROUP BY xcart_products.productid
|
Thanks.