Announcement

Collapse
No announcement yet.

database error....

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] database error....

    hi,have this for the moment......What to do?

    Database error in vBulletin 4.0.3:
    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,
    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 BETWEEN rootnode.nodeleft AND 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.setpublish = 1 AND node.publishdate <1273034525))) OR (node.setpublish AND node.publishdate <1273034525 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, 6;
    MySQL Error : Got error 28 from storage engine
    Error Number : 1030
    Request Date : Wednesday, May 5th 2010 @ 06:42:05 AM
    Error Date : Wednesday, May 5th 2010 @ 06:42:05 AM
    Script : http://www.riviervissen.be/index.php
    Referrer :
    IP Address :
    Username : Paul Roos
    Classname : vB_Database
    MySQL Version : 5.0.67-community
    Live....

  • #2
    fixed all ready...
    Live....

    Comment


    • #3
      If somebody else have a problem like this=> http://www.vbulletin.com/docs/html/m...t_mysql_errors
      OS Error code 28: No space left on device
      Either the swap, a partition, temp directory or hard drive on the web server is out of space or doesn't have enough space to complete the above operation.

      This is a server issue, you need to contact your hosting provider to get more space to write to. I advice you to shut down your forum to prevent more errors or data loss. You can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to turn your forum on/off.

      Comment


      • #4
        Was your database corrupt after this, i.e., did you have to restore your database from backup or did everything start working properly once you free'd up the space?

        Thanks,

        ErnestA
        Help Desk / Asset Management Software
        K12Advantage.com. Collaboration in K-12 Education

        Comment


        • #5
          everything start working properly,no problems....


          paul
          Live....

          Comment


          • #6
            Ditto... Mine came back no problem... Looks like my server on HostGator ran out of space... I kinda questioned how that could even happen ( you know, assuming you're monitoring space through SNMP and get alerts when space runs thin)... Anyways, no corruption, so all is well now...
            Help Desk / Asset Management Software
            K12Advantage.com. Collaboration in K-12 Education

            Comment

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