vb error please help urgent..

Discussion in 'vBulletin' started by forumrating, Sep 17, 2011.

0
  1. #1
    Database error in vBulletin 4.1.5:

    Invalid SQL:

    SELECT socialgroup.groupid, socialgroup.name, socialgroup.description, socialgroup.dateline, sgicon.dateline AS icondateline,
    sgicon.thumbnail_width AS iconthumb_width, sgicon.thumbnail_height AS iconthumb_height
    FROM socialgroupmember AS socialgroupmember
    INNER JOIN socialgroup AS socialgroup ON
    (socialgroup.groupid = socialgroupmember.groupid)
    LEFT JOIN socialgroupicon AS sgicon ON sgicon.groupid = socialgroup.groupid
    WHERE
    socialgroupmember.userid = 336
    AND socialgroupmember.type = 'member'
    ORDER BY socialgroup.name;

    MySQL Error : Got error 28 from storage engine
    Error Number : 1030
    Request Date : Saturday, September 17th 2011 @ 12:19:49 PM
    Error Date : Saturday, September 17th 2011 @ 12:19:50 PM
    Script : http://www.businessmeet.com/member.php?336-aimhrsolution
    Referrer : http://www.businessmeet.com/forum.php
    IP Address : 114.79.178.63
    Username : business
    Classname : vB_Database
    MySQL Version : 5.0.92-community
     
    Solved! View solution.
    forumrating, Sep 17, 2011 IP
  2. AnthonyG

    AnthonyG Well-Known Member

    Messages:
    114
    Likes Received:
    3
    Best Answers:
    2
    Trophy Points:
    135
    #2
    Your out of disk space.

    Remove old junk files from the /var partition, depending on your partitioning scheme.

    Whats the output of:
    df -h
     
    AnthonyG, Sep 17, 2011 IP
  3. forumrating

    forumrating Notable Member

    Messages:
    6,565
    Likes Received:
    347
    Best Answers:
    0
    Trophy Points:
    275
    #3
    is this the problem with host /server ?
     
    forumrating, Sep 17, 2011 IP
  4. #4
    If your database is hosted on a separate server, then yes, the database server has ran out of space.
     
    AnthonyG, Sep 17, 2011 IP
    forumrating likes this.
  5. Brandon Sheley

    Brandon Sheley Illustrious Member

    Messages:
    9,721
    Likes Received:
    612
    Best Answers:
    2
    Trophy Points:
    420
    #5
    It looks like you got it working?
    and it doesn't matter if the DB was on another server.
    The error come when MySQL doesn't have any free hard disk space to write to.
     
    Brandon Sheley, Sep 19, 2011 IP
    forumrating likes this.
  6. thnam8x

    thnam8x Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    << your hosting mysql full space
    i think you buy hosting small, and use full space
    mysql cant write it more
     
    thnam8x, Sep 25, 2011 IP