No announcement yet.

Getting Database Error On CMS ONLY! PLEASE HELP!

  • Filter
  • Time
  • Show
Clear All
new posts

  • [CMS] Getting Database Error On CMS ONLY! PLEASE HELP!

    For some reason, My Vbulletin 4.0 CMS systems are reporting database error, while the "Forum" and "Blog" areas work fine. Below is the database error I am getting:

    Database error in vBulletin 4.0.1:

    Invalid SQL:
    SELECT parent.category AS parentcat, cat.categoryid, cat.category,
    cat.catleft, cat.catright, info.title AS node, parentnode.nodeid, count(nodecat.nodeid) as qty
    FROM cms_node AS node
    INNER JOIN cms_node AS parentnode ON node.nodeleft BETWEEN parentnode.nodeleft AND parentnode.noderight
    INNER JOIN cms_nodeinfo AS info ON info.nodeid = parentnode.nodeid
    INNER JOIN cms_category AS parent on parent.parentnode = parentnode.nodeid
    INNER JOIN cms_category AS cat ON cat.catleft BETWEEN parent.catleft AND parent.catright
    LEFT JOIN cms_nodecategory AS nodecat ON nodecat.categoryid = cat.categoryid
    WHERE node.nodeid = 1 AND ( (node.permissionsfrom IN (1,7)) OR (node.userid =1) OR (node.permissionsfrom IN (1,4,5,6,7,8) AND node.setpublish = 1 AND node.publishdate <1266351392))
    GROUP BY parent.category, cat.categoryid, cat.category,
    cat.catleft, cat.catright, info.title, parentnode.nodeid
    ORDER BY node.nodeleft, catleft;;

    MySQL Error : Can't create/write to file '/home/tmp/#sql_759c_0.MYD' (Errcode: 17)
    Error Number : 1
    Request Date : Tuesday, February 16th 2010 @ 12:16:32 PM
    Error Date : Tuesday, February 16th 2010 @ 12:16:32 PM
    Script :
    Referrer :
    IP Address : xxxxxxxxxxx
    Username : vdubber
    Classname : vB_Database
    MySQL Version : 5.0.82sp1-log
    I've changed the site name and IP from the message above.

    I've now found that VBadvance on two of my others sites are not working either. Although the forums work perfectly.

  • #2
    Error 17 means that MySQL is trying to create a temporary file that already exists. You may need to restart mysql.


    • #3
      thanks, that's all that was needed. Running fine now. Thanks again.


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