[xcell67]

Hi,

Can somebody help me out, my server has Mysql version 4.0.25 so when I follow the instructions listed by lapidarist:

http://forum.x-cart.com/viewtopic.php?p=107474#107474


I get this error when calling newproducts.php:

INVALID SQL: 1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'xcart_products.avail > 0 AND add_date > 1146282522 AND add_date
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 > 1146282522 AND add_date < 1146887322 GROUP BY xcart_products.productid

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /include/func/func.db.php on line 125


I'm assuming that

$query = "AND $sql_tbl[products].avail > 0 AND add_date > $from_time AND add_date < $now_time ";

is not liking my msql version. Can someone tell me the correct query for mysql 4.0.25?

THANKS!