The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Help! Someone broke my forum!
I got a series of email alerts from a certain IP (registered to trend micro) getting database errors. Shortly after my site stopped working showing me SQL errors when I try to enter it:
http://www.leftunderground.com/content/ What can I do to fix this? The error I get is: Code:
Database error in vBulletin 4.1.1: Invalid SQL: SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid, (node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid, node.userid, node.layoutid, node.publishdate, node.setpublish, node.issection, parent.permissionsfrom as parentpermissions, node.permissionsfrom, node.publicpreview, node.showtitle, node.showuser, node.showpreviewonly, node.showall, node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.editshowchildren, node.shownav, node.hidden, node.nosearch, node.nodeleft, info.description, info.title, info.html_title, info.viewcount, info.creationdate, info.workflowdate, info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid, user.username, sectionorder.displayorder, thread.replycount, parentinfo.title AS parenttitle FROM cms_node AS node INNER JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid LEFT JOIN user AS user ON user.userid = node.userid LEFT JOIN thread AS thread ON thread.threadid = info.associatedthreadid LEFT JOIN cms_sectionorder AS sectionorder ON sectionorder.sectionid = 1 AND sectionorder.nodeid = node.nodeid LEFT JOIN cms_node AS parent ON parent.nodeid = node.parentnode LEFT JOIN cms_nodeinfo AS parentinfo ON parentinfo.nodeid = parent.nodeid INNER JOIN cms_node AS rootnode ON rootnode.nodeid = 1 AND (node.nodeleft >= rootnode.nodeleft AND node.nodeleft <= rootnode.noderight) AND node.nodeleft != rootnode.nodeleft AND node.contenttypeid <> 17 AND node.new != 1 AND ( (( (node.permissionsfrom IN (1)) OR (node.userid =1) OR ( node.permissionsfrom in (1) AND (node.parentnode IN (1,142,157) OR node.nodeid = 1) AND node.setpublish > 0 AND node.publishdate < 1299707670 ))) OR (node.setpublish AND node.publishdate <1299707670 AND node.publicpreview > 0)) AND (node.parentnode = 1 OR sectionorder.displayorder > 0 ) ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC, node.publishdate DESC LIMIT 0, 7; MySQL Error : Can't create/write to file '/tmp/#sql_5ce1_0.MYD' (Errcode: 17) Error Number : 1 Request Date : Wednesday, March 9th 2011 @ 04:54:30 PM Error Date : Wednesday, March 9th 2011 @ 04:54:31 PM Script : http://www.leftunderground.com/content/ Referrer : http://www.leftunderground.com/content/ IP Address : 70.58.230.31 Username : No Limit Classname : vB_Database MySQL Version : 5.0.91-community |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|