1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Got error 28 from table handler

Discussion in 'WordPress' started by SEbasic, Jan 23, 2006.

  1. #1
    WordPress database error: [Got error 28 from table handler]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-01-24 01:13:59' AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10
    Code (markup):
    I'm getting this error on a WP install...

    Anyone have any idea what's causing it?
    SEMrush
    I can't for the life of me work it out...

    Any help is much appreciated.
     
    SEbasic, Jan 23, 2006 IP
    SEMrush
  2. minstrel

    minstrel Illustrious Member

    Messages:
    15,082
    Likes Received:
    1,243
    Best Answers:
    0
    Trophy Points:
    480
    #2
    Is this version 2? Using Firefox?

    Google error 28 from table handler

     
    minstrel, Jan 23, 2006 IP
  3. SEbasic

    SEbasic Peon

    Messages:
    6,317
    Likes Received:
    318
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Actually, it's 1.5, regardless of the browser. Which is why I'm so stumped...
     
    SEbasic, Jan 24, 2006 IP
  4. minstrel

    minstrel Illustrious Member

    Messages:
    15,082
    Likes Received:
    1,243
    Best Answers:
    0
    Trophy Points:
    480
    #4
    The thread cited above indicates that this problem preceded version 2 and, according to the WP people, is a MySQL problem.

    I don't know. It seems to me that Error 28 generally occurs when there are a lot of hits on the database in a short time - but you're getting it with an installation and that's weird.
     
    minstrel, Jan 24, 2006 IP
  5. SEbasic

    SEbasic Peon

    Messages:
    6,317
    Likes Received:
    318
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Yep - I'm gonna have to ask the server to restart mysql I think, but it's certianly not something I've come across before...

    Thanks for the help :)
     
    SEbasic, Jan 24, 2006 IP
  6. blinxdk

    blinxdk Peon

    Messages:
    660
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    0
    #6
    You ran out of disk space...

    easter:~# perror 28
    System error: 28 = No space left on device
     
    blinxdk, Jan 24, 2006 IP
    SEbasic likes this.
  7. SEbasic

    SEbasic Peon

    Messages:
    6,317
    Likes Received:
    318
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Huh - weird... shouldn't be the case though...

    It's on a shared hosting package, so does that mean the server has simply ran out of space, or my allocation has run out?

    I'm 99.9% sure I'm still within my limit (Hell, all that's on there is a wp instalation).
     
    SEbasic, Jan 24, 2006 IP
  8. blinxdk

    blinxdk Peon

    Messages:
    660
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    0
    #8
    No idea how those shared servers work, but error 28 from mysql means no space left on device :) - do you have shell access?

    Remember it's the device that mysql stores it's data on, so if the mysql database is not running locally, this might be on a completely different server.
     
    blinxdk, Jan 24, 2006 IP
  9. minstrel

    minstrel Illustrious Member

    Messages:
    15,082
    Likes Received:
    1,243
    Best Answers:
    0
    Trophy Points:
    480
    #9
    That's what it's supposed to mean but it seems the error message is often generated when that situation doesn't exist...
     
    minstrel, Jan 24, 2006 IP
  10. SEbasic

    SEbasic Peon

    Messages:
    6,317
    Likes Received:
    318
    Best Answers:
    0
    Trophy Points:
    0
    #10
    I don't have shell access on this server I'm afraid. :(

    Thanks *so* much for the help guys - at least I know I'm not going crazy. :)

    I'll speak to the host asap and see if they know what the issue is - I'm certianly stumped.
     
    SEbasic, Jan 24, 2006 IP
  11. blinxdk

    blinxdk Peon

    Messages:
    660
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Ah, well I can only speak from personal experience and I have only seen it in actual cases where the device where full.

    Ofcouse I can't rule out that other problems with writing to disc could cause the same error.
     
    blinxdk, Jan 24, 2006 IP
  12. Cybermonsters

    Cybermonsters Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #12
    I'm getting the same error with Wordpress. This happened last year, but I can't remember how I fixed it. I have repaired db tables but error 28 still shows. I have shell access. Suggestions?
     
    Cybermonsters, Mar 29, 2006 IP