Quote:
Originally Posted by DavyMac
What can I say? I changed the "Send review reminder to customer in N days " from 9 to 3 and the SQL errors went away.
|
Quote:
Originally Posted by DavyMac
SQL query : SELECT product, descr, fulldescr FROM WHERE productid = '2404' LIMIT 1
Error code : 1064
Description :You have an error in your SQL syntax; check the manual that corresponds to yourMySQL server version for the right syntax to use near 'WHERE productid = '2404'LIMIT 1' at line 1 Request URI: /send_review_reminders.php?key=
|
This SQL error should not be connected with the "Send review reminder to customer in N days " setting. I've failed to reproduce the same SQL error. However I've investigated this issue and found another possible reason.
Please check your '<xcart_dir>/send_review_reminders.php' file and found this part of code:
PHP Code:
define('SKIP_CHECK_REQUIREMENTS.PHP', true);
require './init.php';
$argv = $_SERVER['argv'];
and replace it with:
PHP Code:
define('SKIP_CHECK_REQUIREMENTS.PHP', true);
require './init.php';
require './include/get_language.php';
$argv = $_SERVER['argv'];