Announcement

Collapse
No announcement yet.

Database Error Help

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

  • [Forum] Database Error Help

    Database error in vBulletin 4.2.0:


    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,19,10,53,54,6,93) AND ( (node.permissionsfrom IN (1,8,10,11,12,13,17,18,19,20,21,22,23,24,26,53,54,55,56,57,58,93,99,100,102,115,125,131)) OR (node.userid =2614) OR ( node.permissionsfrom in (1,8,10,11,12,13,17,18,19,20,21,22,23,24,26,53,54,55,56,57,58,93,99,100,102,115,125,131) AND (node.parentnode IN (1,102,53,10,54,55,56,57,125,100,131,115,20,17,93,101) OR node.nodeid = 1) AND
    node.setpublish > 0 AND node.publishdate < 1349360441 ))AND node.new != 1

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


    MySQL Error : Got error 122 from storage engine
    Error Number : 1030
    Request Date : Thursday, October 4th 2012 @ 07:20:41 AM
    Error Date : Thursday, October 4th 2012 @ 07:20:42 AM
    Script : http://www.flyfishbc.com/forums/content/
    Referrer :
    IP Address : 70.69.40.237
    Username : flytechwarrior
    Classname : vB_Database
    MySQL Version : 5.0.77-log
    Anyone know what might be causing this, did the typical reboot but it's still there.
    Jason Craig – Partner
    Wet Coast Sports LTD
    Fishing Reviews TVBC Fishing ReportsFly Fish BCFly Tying Bug

  • #2
    Error 122 means either you are over disk quota or the disk that MySQL or /tmp is on is full, I believe.

    Comment


    • #3
      Originally posted by Matthew Gordon View Post
      Error 122 means either you are over disk quota or the disk that MySQL or /tmp is on is full, I believe.
      Thank you very much Matt!
      Jason Craig – Partner
      Wet Coast Sports LTD
      Fishing Reviews TVBC Fishing ReportsFly Fish BCFly Tying Bug

      Comment

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