I've been getting the following database error via email, any idea how to fix this issue?
Invalid SQL:
CREATE TABLE forumtmp_nodestats AS SELECT node.parentid AS nodeid, count(nv.nodeid) AS tmpvisitors,
nv.totalcount - IFNULL(existing.replies, 0) AS tmpreplies FROM forumnodevisits AS nv
INNER JOIN forumnode AS node ON node.nodeid = nv.nodeid
LEFT JOIN forumnodestatreplies AS existing ON existing.nodeid = node.parentid
WHERE nv.dateline >= 1431216000 AND nv.dateline < (1431216000 + 86400)
GROUP BY node.parentid, existing.replies; /**vBForum:calculateStats called from cron **/;
MySQL Error : Table 'forumtmp_nodestats' already exists
Error Number : 1050
Request Date : Wednesday, July 1st 2015 @ 09:06:18 PM
Error Date : Wednesday, July 1st 2015 @ 09:06:18 PM
Script : http:///forum/ajax/apidetach/cron/run
Invalid SQL:
CREATE TABLE forumtmp_nodestats AS SELECT node.parentid AS nodeid, count(nv.nodeid) AS tmpvisitors,
nv.totalcount - IFNULL(existing.replies, 0) AS tmpreplies FROM forumnodevisits AS nv
INNER JOIN forumnode AS node ON node.nodeid = nv.nodeid
LEFT JOIN forumnodestatreplies AS existing ON existing.nodeid = node.parentid
WHERE nv.dateline >= 1431216000 AND nv.dateline < (1431216000 + 86400)
GROUP BY node.parentid, existing.replies; /**vBForum:calculateStats called from cron **/;
MySQL Error : Table 'forumtmp_nodestats' already exists
Error Number : 1050
Request Date : Wednesday, July 1st 2015 @ 09:06:18 PM
Error Date : Wednesday, July 1st 2015 @ 09:06:18 PM
Script : http:///forum/ajax/apidetach/cron/run