The error message seems odd.

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 - TO_DAYS(`DateReg`)) % {$iPeriod} = 0"); foreach ($aProfilesToConfirm as $aProfile) activation_mail($aProfile[''ID''], 0);');