Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

MySQL ERROR - Error Number: 1030 - Got error 28 from table handler

September 28, 2007 1:31pm

Subscribe [1]
  • #1 / Sep 28, 2007 1:31pm

    knirketusken

    11 posts

    Today I installed EE for a new project, and everything worked fine for some hours, then I got an error and site is down (control panel i up). Have tried to repair tables both from CP and phpMyAmdin, but does not fix the problem.


    MySQL ERROR:

    Error Number: 1030

    Description: Got error 28 from table handler

    Query: SELECT DISTINCT(t.entry_id), t.entry_id, t.weblog_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.dst_enabled, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.allow_trackbacks, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.trackback_total, t.sent_trackbacks, t.recent_trackback_date, t.site_id as entry_site_id, w.blog_title, w.blog_name, w.blog_url, w.comment_url, w.tb_return_url, w.comment_moderate, w.weblog_html_formatting, w.weblog_allow_img_urls, w.weblog_auto_link_urls, w.enable_trackbacks, w.trackback_use_url_title, w.trackback_field, w.trackback_use_captcha, w.trackback_system_enabled, m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio, md.*, wd.* FROM exp_weblog_titles AS t LEFT JOIN exp_weblogs AS w ON t.weblog_id = w.weblog_id LEFT JOIN exp_weblog_data AS wd ON t.entry_id = wd.entry_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (2) ORDER BY t.sticky desc, t.entry_date desc

  • #2 / Sep 28, 2007 1:35pm

    Lisa Wess's avatar

    Lisa Wess

    20446 posts

    What version and build are you on? Both can be found at the bottom of your control panel.  Also, see this thread. =)

  • #3 / Sep 28, 2007 1:37pm

    knirketusken

    11 posts

    Thanks!

    ExpressionEngine 1.6.0
    Build:  20070724

  • #4 / Sep 28, 2007 1:45pm

    knirketusken

    11 posts

    I looked at the link (thread) you sendt. In this the link said error 28 from storage engine, while I get error 28 from table handler. I tried, and if I set up a simple, static page it gets displayed without error (just wrote a word in an empty template).

  • #5 / Sep 28, 2007 1:49pm

    Lisa Wess's avatar

    Lisa Wess

    20446 posts

    the “From” part is not the problem, it’s the error 28:

    Error code 28: No space left on device You can even find this directly on the MySQL bug tracker - it’s simply no space in that partition. 

    Here are the Google search results for Got error 28 from table handler.

    You’ll need to ask your host on this one, have them check the space available.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases