PDA

View Full Version : Database error on content page


Casca2010
05-20-2011, 10:17 AM
Dear members,

I suddenly receive an error when I try to view my content.php page. All of my other users experience this aswell.

This is displayed as error:
Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT 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) OR node.nodeid = 1) AND
node.setpublish > 0 AND node.publishdate < 1305890133 ))) OR (node.setpublish AND node.publishdate <1305890133 AND node.publicpreview > 0))

ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC,
node.publishdate DESC LIMIT 0, 7;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Friday, May 20th 2011 @ 01:15:33 PM
Error Date : Friday, May 20th 2011 @ 01:15:33 PM
Script : http://-/content.php
Referrer :
IP Address : -
Username : -
Classname : vB_Database
MySQL Version : 5.1.49-1~bpo50+1

What kind of error is it, and, Is it fixable?

Thnx in advance!

Lynne
05-20-2011, 02:53 PM
One or more partitions on your server is out of space or doesn't have enough space to complete this operation. You need to shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on disk space and either add more space or free up some.