The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Got error 28 from storage engine

Discussion in 'General Discussion' started by swfmx, Apr 23, 2007.

  1. swfmx

    swfmx Member

    Joined:
    Feb 28, 2005
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    when open website i got error

    -------------------------------------
    [ERROR] Failed Query: SELECT a. * , MAX( b.time ) AS lastpost FROM mos_sb_messages AS a LEFT JOIN mos_sb_messages AS b ON b.thread = a.thread WHERE a.parent = '0' AND a.catid = 2 AND a.hold = '0' GROUP BY id ORDER BY ordering DESC , lastpost DESC , id DESC
    Mysql Said: Got error 28 from storage engine
    [ERROR] num_rows() not executed because the last query failed
    -------------------------------------

    i check disk usage this is report

    -------------------------------------
    Filesystem 1K-blocks Used Available Use% Mounted on
    /dev/sda3 151628768 21768204 122158200 16% /
    /dev/sda1 101086 11356 84511 12% /boot
    none 517208 0 517208 0% /dev/shm
    /usr/tmpDSK 495844 470249 0 100% /tmp
    /tmp 495844 470249 0 100% /var/tmp
    -------------------------------------

    how i can do??
     
  2. MN-Robert

    MN-Robert Well-Known Member

    Joined:
    Feb 19, 2003
    Messages:
    203
    Likes Received:
    0
    Trophy Points:
    16
    You need to empty the /tmp partition and then restart mysql
     
Loading...

Share This Page