Hi,
We just installed VBulletin 5.1.5 in the past month, and the biggest issue we've seen is occasionally some threads get marked as deleted, closed, and unapproved. See:
Now, I do get emails whenever there's a database error, and the worst I've seen is the following:
I figured this isn't too big of a deal, but I get these about once a day around 6am.
Any help is greatly appreciated!
Ed
We just installed VBulletin 5.1.5 in the past month, and the biggest issue we've seen is occasionally some threads get marked as deleted, closed, and unapproved. See:
Now, I do get emails whenever there's a database error, and the worst I've seen is the following:
Code:
Invalid SQL: CREATE TABLE vb_tmp_nodestats AS SELECT node.parentid AS nodeid, count(nv.nodeid) AS tmpvisitors, nv.totalcount - IFNULL(existing.replies, 0) AS tmpreplies FROM vb_nodevisits AS nv INNER JOIN vb_node AS node ON node.nodeid = nv.nodeid LEFT JOIN vb_nodestatreplies AS existing ON existing.nodeid = node.parentid WHERE nv.dateline >= 1423180800 AND nv.dateline < (1423180800 + 86400) GROUP BY node.parentid, existing.replies; /**vBForum:calculateStats called from cron **/; MySQL Error : Table 'vb_tmp_nodestats' already exists
Any help is greatly appreciated!
Ed
Comment