Table 'forumtmp_nodestats' already exi

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • heredia21
    Senior Member
    • Oct 2012
    • 208
    • 5.0.X

    Table 'forumtmp_nodestats' already exi

    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
    BlackBerry Empire #1 BlackBerry news site and BlackBerry forum.

Related Topics

Collapse

Working...