Hi everyone,
How are you doing? I am running VBulletin forum on my dedicated server (rent new recently - new set up, my server is: Intel Xeon E3-1270 16GB DDR3, 2 x 3TB HDD), but recently I keep got VBulletin Database error message with:
I have access to my dedicated server, please show me in details step by step how to fix this problem ! Thank you very much in advance!
Regards,
Calvin
==============================================================
Here is some example of the full error:
How are you doing? I am running VBulletin forum on my dedicated server (rent new recently - new set up, my server is: Intel Xeon E3-1270 16GB DDR3, 2 x 3TB HDD), but recently I keep got VBulletin Database error message with:
Code:
Out of resources when opening file '/tmp/#sql_26b7_0.MYI' (Errcode: 24)
or:
Out of resources when opening file './abcdef_forum/vb_post.MYD' (Errcode: 24)
or:
MySQL Error : Out of resources when opening file '/tmp/#sql_26b7_0.MYI' (Errcode: 24)
Error Number : 23
Regards,
Calvin
==============================================================
Here is some example of the full error:
Code:
Database error in vBulletin 4.2.2:
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.showrating,
node.permissionsfrom, node.publicpreview, node.shownav, node.hidden, node.nosearch , info.description, info.title, info.viewcount, info.creationdate, info.workflowdate,
info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid,
user.username, sectionorder.displayorder
FROM vb_cms_node AS node
INNER JOIN vb_cms_nodeinfo AS info ON info.nodeid = node.nodeid
LEFT JOIN vb_user AS user ON user.userid = node.userid
LEFT JOIN vb_cms_sectionorder AS sectionorder ON sectionorder.sectionid = node.parentnode
AND sectionorder.nodeid = node.nodeid
LEFT JOIN vb_cms_node AS parent ON parent.nodeid = node.parentnode
WHERE node.new != 1 AND node.nodeid IN (1,45,5,11,2,3) AND ( (node.permissionsfrom IN (-1)) OR (node.userid =198306) OR ( node.permissionsfrom in (1) AND (node.parentnode IN (1) OR node.nodeid = 1) AND
node.setpublish > 0 AND node.publishdate < 1405971769 ))AND node.new != 1
ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC,
node.publishdate DESC;
MySQL Error : Out of resources when opening file '/tmp/#sql_26b7_0.MYI' (Errcode: 24)
Error Number : 23
Request Date : Monday, July 21st 2014 @ 07:42:49 PM
Error Date : Monday, July 21st 2014 @ 07:42:49 PM
Script : domain.com/forum/content.php?styleid=27
Referrer : domain.com/index_frame.html
IP Address : 42.112.xxx.xxx
Username : username
Classname : vB_Database
MySQL Version :
Last edited: