Hi Jon
Can you help me with these errors Jon
Code:
[06-Mar-2005 14:23:40] SQL error: /megapcs4u/cart.php
1065 : Query was empty
Backtrace:
/home/xxxxxx/public_html/megapcs4u/include/func.php:120
/home/xxxxxx/public_html/megapcs4u/include/func.php:80
/home/xxxxxx/public_html/megapcs4u/include/func.php:164
/home/xxxxxx/public_html/megapcs4u/modules/ezRecommends/ezrecommends.php(20) : eval()'d code(1) : eval()'d code(1) : eval()'d code:65
/home/xxxxxx/public_html/megapcs4u/modules/ezRecommends/ezrecommends.php(20) : eval()'d code(1) : eval()'d code:1
/home/xxxxxx/public_html/megapcs4u/modules/ezRecommends/ezrecommends.php(20) : eval()'d code:1
/home/xxxxxx/public_html/megapcs4u/modules/ezRecommends/ezrecommends.php:20
/home/xxxxxx/public_html/megapcs4u/cart.php:718
-------------------------------------------------
[06-Mar-2005 14:23:40] SQL error: /megapcs4u/cart.php
SELECT DISTINCT productid2 as productid FROM xcart_product_links where ()) AND (productid2!='') ORDER BY RAND() LIMIT 4
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 ')) AND (productid2!='') ORDER BY RAND() LIMIT 4' at line 1
Backtrace:
/home/xxxxxx/public_html/megapcs4u/include/func.php:120
/home/xxxxxx/public_html/megapcs4u/include/func.php:80
/home/xxxxxx/public_html/megapcs4u/include/func.php:164
/home/xxxxxx/public_html/megapcs4u/modules/ezRecommends/ezrecommends.php(20) : eval()'d code(1) : eval()'d code(1) : eval()'d code:72
/home/xxxxxx/public_html/megapcs4u/modules/ezRecommends/ezrecommends.php(20) : eval()'d code(1) : eval()'d code:1
/home/xxxxxx/public_html/megapcs4u/modules/ezRecommends/ezrecommends.php(20) : eval()'d code:1
/home/xxxxxx/public_html/megapcs4u/modules/ezRecommends/ezrecommends.php:20
/home/xxxxxx/public_html/megapcs4u/cart.php:718
-------------------------------------------------
This seems to only go wrong when i use the gift certificate, all you other mods seem to work well. one other problem is the change the gift certificate redirect, and to give them a message when the certificate does not cover the cost, it will not show the message. It could be the above mod causing the problem.
John