Private Messages - Got error 28 from storage engine???

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Lorraine-H
    New Member
    • Sep 2009
    • 14
    • 3.8.x

    Private Messages - Got error 28 from storage engine???

    Find that today I can't get into private messages on my forum - I get a database error with a message:

    Invalid SQL:
    MySQL Error : Got error 28 from storage engine
    Error Number : 1030

    Any ideas what this means and how to fix?
  • DebC
    New Member
    • Oct 2003
    • 14

    #2
    Same error here, just started today only it's my whole site, not just certain areas:

    Database error in vBulletin 4.0.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.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 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 cms_sectionorder AS sectionorder ON sectionorder.sectionid = node.parentnode
    AND sectionorder.nodeid = node.nodeid
    LEFT JOIN cms_node AS parent ON parent.nodeid = node.parentnode

    WHERE node.new != 1 AND node.nodeid IN (1,3) AND ( (node.permissionsfrom IN (1,45)) OR (node.userid =2) OR (node.permissionsfrom IN (1,45) AND node.setpublish = 1 AND node.publishdate <1270738541))AND node.new != 1 AND node.hidden = 0

    ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC,
    node.publishdate DESC;
    MySQL Error : Got error 28 from storage engine
    Error Number : 1030
    Request Date : Thursday, April 8th 2010 @ 10:55:41 AM
    Error Date : Thursday, April 8th 2010 @ 10:55:41 AM
    Script : http://www.thecomputermechanics.com/forums/index.php

    Comment

    • DebC
      New Member
      • Oct 2003
      • 14

      #3
      Just to note:

      I searched for "Got error 28 from storage engine" error and it referred to mysql cache being full. I called my host and they cleared the cache, my site is back.

      Comment

      • Lynne
        Former vBulletin Support
        • Oct 2004
        • 26255

        #4
        Deb, you did exactly the right thing.


        Error code 28: No space left on device -
        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.

        Please don't PM or VM me for support - I only help out in the threads.
        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
        Want help modifying your vbulletin forum? Head on over to vbulletin.org
        If I post CSS and you don't know where it goes, throw it into the additional.css template.

        W3Schools &lt;- awesome site for html/css help

        Comment

        • DebC
          New Member
          • Oct 2003
          • 14

          #5
          Thanks Lynne, hope it helps Lorraine-H with her issue

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...