Newsletter Mailer Log Cleanup error
3 posts by 2 authors in: Forums > CMS Builder
Last Post: Yesterday at 7:30am (RSS)
Hi,
I am receiving errors from the Newsletter log cleanup.
The server cannot be upgraded for now, and I need to use CMSB v3.61.
The Newsletter Builder is v3.06.
Activity: Newsletter Mailer Log Cleanup
Summary: Error
Completed: 0
Function: nlb_mailer_log_cleanup
Output:
MySQL Error: Unknown column 'function' in 'where clause' in /home/xxx.com/public_html/cmsb/plugins/newsletterBuilder3_06/newsletterBuilder.php on line 550
Above refers to this part on the newsletterBuilder.php, but it seem like it is not different from the other older versions or the newest version.
// erase successful log messages with no output that are 10 minutes old or more
function nlb_mailer_log_cleanup() {
$deleteWhere = "`function` IN('nlb_mailer','nlb_mailer_log_cleanup') AND `output` = '' AND `completed` = 1 AND `createdDate` <= (NOW() - INTERVAL 10 MINUTE)";
mysql_delete('_cron_log', null, $deleteWhere);
}
What can I do to fix the error?
Thank you in advance.
Hiroko
By Dave - Sunday at 8:40pm
Hi Hiroko,
Can you try changing 'function' to 'functionName'? We renamed that in recent versions because 'function' was a reserved word in MySQL 8.0.
interactivetools.com
Hi Dave,
Thank you very much! The errors stoped so I think its working.
Hiroko