Originally posted by Glenn Vergara
View Post
Announcement
Collapse
No announcement yet.
Database error in vBulletin 5.1.8
Collapse
X
-
Database error in vBulletin 5.1.8
I started getting this error about 6 days "about 10 emails everyday" ago with no certain reason.Code:[COLOR=#222222][FONT=arial]Database error in vBulletin 5.1.8:[/FONT][/COLOR] [COLOR=#222222][FONT=arial] Invalid SQL:[/FONT][/COLOR] [COLOR=#222222][FONT=arial]CREATE TABLE tmp_nodestats AS SELECT node.parentid AS nodeid, count(nv.nodeid) AS tmpvisitors,[/FONT][/COLOR] [COLOR=#222222][FONT=arial] nv.totalcount - IFNULL(existing.replies, 0) AS tmpreplies FROM nodevisits AS nv[/FONT][/COLOR] [COLOR=#222222][FONT=arial] INNER JOIN node AS node ON node.nodeid = nv.nodeid[/FONT][/COLOR] [COLOR=#222222][FONT=arial] LEFT JOIN nodestatreplies AS existing ON existing.nodeid = node.parentid[/FONT][/COLOR] [COLOR=#222222][FONT=arial] WHERE nv.dateline >= 0 AND nv.dateline < (0 + 86400)[/FONT][/COLOR] [COLOR=#222222][FONT=arial] GROUP BY node.parentid, existing.replies; /**vBForum:calculateStats called from cron **/;[/FONT][/COLOR] [COLOR=#222222][FONT=arial] MySQL Error : Table 'tmp_nodestats' already exists[/FONT][/COLOR] [COLOR=#222222][FONT=arial] Error Number : 1050[/FONT][/COLOR] [COLOR=#222222][FONT=arial] Request Date : [/FONT][/COLOR][COLOR=#222222][FONT=arial]Friday, September 25th 2015[/FONT][/COLOR][COLOR=#222222][FONT=arial] @ [/FONT][/COLOR][COLOR=#222222][FONT=arial]05:12:38 AM[/FONT][/COLOR] [COLOR=#222222][FONT=arial] Error Date : [/FONT][/COLOR][COLOR=#222222][FONT=arial]Friday, September 25th 2015[/FONT][/COLOR][COLOR=#222222][FONT=arial] @ [/FONT][/COLOR][COLOR=#222222][FONT=arial]05:12:38 AM[/FONT][/COLOR] [COLOR=#222222][FONT=arial] Script : http:///ajax/apidetach/cron/[/FONT][/COLOR][COLOR=#222222][FONT=arial]run[/FONT][/COLOR] [COLOR=#222222][FONT=arial] Referrer : [/FONT][/COLOR][URL]http://on.mac-eg.com/?_=1443179536118[/URL] [COLOR=#222222][FONT=arial] IP Address : xxxxxxxxxxxx[/FONT][/COLOR] [COLOR=#222222][FONT=arial] Username : xxxxxxxxxxx[/FONT][/COLOR] [COLOR=#222222][FONT=arial] Classname : vB_Database_MySQLi[/FONT][/COLOR] [COLOR=#222222][FONT=arial] MySQL Version :[/FONT][/COLOR]
Tags: None
Related Topics
Collapse
-
by nsglazerI've received hundreds of emails since our upgrade to vBulletin 5.1.3 Patch Level 1 all pretty similar to these. Any idea what's going on?
Database error in vBulletin 5.1.3:
...-
Channel: Support Issues & Questions
Sun 16 Nov '14, 1:27pm -
-
by markyGot an error today (everything is verbatim except the bolded part):
Invalid SQL:
/** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_10_lvl1data' AND event = 'nodeChg_10')...-
Channel: Support Issues & Questions
Tue 22 Apr '14, 1:29pm -
-
by vskylabvSince the support tickets have gone on vacation, I figured I'd asked on here.
Here's the error I'm receiving while upgrading.
Code:[COLOR=#000000][FONT=arial][SIZE=12px]<?xml version="1.0" encoding="window[/][/][/]
-
Channel: vBulletin 5 Upgrades
Sat 29 Jun '13, 4:57pm -
Leave a comment: