Tried the mod with 7.1 and got the following error when I did the SQL Query:
#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 'INSERT INTO `sys_cron_jobs` (`id` ,`name` ,`time` ,`class` ,`file` ,`eval`) VAL' at line 3
Would love to get t his to work. It is a great idea and it could just be something at my end. Bit, I don;t know what it could be.
Tried the mod with 7.1 and got the following error when I did the SQL Query:
#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 'INSERT INTO `sys_cron_jobs` (`id` ,`name` ,`time` ,`class` ,`file` ,`eval`) VAL' at line 3
Would love to get t his to work. It is a great idea and it could just be something at my end. Bit, I don;t know what it could be.
Try to run this part of the query only (since the first part most likely worked fine):
INSERT INTO `sys_cron_jobs` (`id` ,`name` ,`time` ,`class` ,`file` ,`eval`)
VALUES (NULL , 'auto_conf_emails', '0 1 * * *', '', '', '$iPeriod = $GLOBALS[''MySQL'']->getParam(''confirmation_email_period''); $aProfilesToConfirm = $GLOBALS[''MySQL'']->getAll("SELECT `ID` FROM `Profiles` WHERE `Status` = ''Unconfirmed'' AND (`Couple`=0 OR `Couple` > `ID`) AND (TO_DAYS(NOW()) see more