Title: [Get error -1 from table handler]
Last modified: August 18, 2016

---

# [Get error -1 from table handler]

 *  [TomPreuss](https://wordpress.org/support/users/tompreuss/)
 * (@tompreuss)
 * [21 years, 8 months ago](https://wordpress.org/support/topic/get-error-1-from-table-handler/)
 * Hi everyone, Joey Day and I are having a bit of trouble with our sites, [http://www.tompreuss.com](http://www.tompreuss.com)
   and [http://www.joeyday.com](http://www.joeyday.com) .
    We both get the following
   error: `Database error: [Got error -1 from table handler] SELECT DISTINCT * FROM
   blog_posts WHERE 1=1 AND post_date_gmt <= '2004-10-03 20:07:59' AND (post_status
   = "publish") GROUP BY blog_posts.ID ORDER BY post_date DESC LIMIT 8 We are thinking
   it might have something to do with our server, because it seems to only be happening
   on WP sites that are hosted with our reseller account. Other sites that access
   mySQL aren’t getting the error. Does anyone have any ideas as to what could be
   wrong?

Viewing 8 replies - 1 through 8 (of 8 total)

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [21 years, 8 months ago](https://wordpress.org/support/topic/get-error-1-from-table-handler/#post-97183)
 * Googling for that error indicates that it is a hosting issue. It’s certainly 
   not reported here very often at all, so I’d email your host or look into other
   hosting options if it persists.
 *  Thread Starter [TomPreuss](https://wordpress.org/support/users/tompreuss/)
 * (@tompreuss)
 * [21 years, 8 months ago](https://wordpress.org/support/topic/get-error-1-from-table-handler/#post-97191)
 * Thank you podz.
    We have contacted our host and submitted a support ticket with
   them. We were just curious to see if this was a WordPress specific problem, seeing
   as other sites on our server can access mySQL just fine. I will let you know 
   what our host says as soon as we find out.
 *  [JoeyDay](https://wordpress.org/support/users/joeyday/)
 * (@joeyday)
 * [21 years, 8 months ago](https://wordpress.org/support/topic/get-error-1-from-table-handler/#post-97232)
 * The problem has been fixed. Not sure what happened, as the host never contacted
   me back, but I didn’t change anything, so I can only assume they changed something
   on their end (or the problem fixed itself in the same way it broke itself).
    
   Hope this doesn’t happen again…
 *  [Eva](https://wordpress.org/support/users/eva/)
 * (@eva)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/get-error-1-from-table-handler/#post-97573)
 * I’m having this very same problem now (easternblot.net/blog) and I think it’s
   related to the MySQL memory of your host. I’m e-mailing mine now to see what’s
   going on.
 *  [Liew Cheon-Fong](https://wordpress.org/support/users/lcf/)
 * (@lcf)
 * [21 years, 4 months ago](https://wordpress.org/support/topic/get-error-1-from-table-handler/#post-97595)
 * I am having the same problem out of sudden at my blog ([http://www.liewcf.com/wp/index.php](http://www.liewcf.com/wp/index.php)).
   However, no problem to view permalink page.
 *  [craveytrain](https://wordpress.org/support/users/craveytrain/)
 * (@craveytrain)
 * [21 years, 1 month ago](https://wordpress.org/support/topic/get-error-1-from-table-handler/#post-97617)
 * I am getting this error as well now, and I run my own DB. heh, guess that’s what
   i get for trying to do it all myself. Guess I’ll keep googling to see what i 
   can do to fix the issue…
 *  [craveytrain](https://wordpress.org/support/users/craveytrain/)
 * (@craveytrain)
 * [21 years, 1 month ago](https://wordpress.org/support/topic/get-error-1-from-table-handler/#post-97618)
 * ok, I found it. I got my solution from this post:
    [http://forums.xmbforum.com/viewthread.php?tid=743964](http://forums.xmbforum.com/viewthread.php?tid=743964)
 * Yeah, I know it’s not about WP, but it turns out it’s a mysql/system issue, WP
   just happened to be the code that was trying to query the DB. Tthis was not a
   WP issue.
 * I was getting -1 error. I dumped my db to a file. I checked my tables, no errors.
   I repaired them just in case, no mention of anything fixed. I optimized cause
   I read it was a space issue. No avail. So I starting cutting off parts of the
   query, and even the basic select wasn’t working. But this time I was getting 
   an error 28. “perror 28” will tell you “Error code 28: No space left on device”.(
   Btw, I couldn’t get perror to look up “-1”. It kept trying to use it as a flag.)
 * Finally a “df” helped me out. Turns out I was out of /tmp space. I cleaned out
   the extraneous files in there and voila, mysql started working like a champ. 
   Didn’t even have to restart it.
 * I thought maybe others might be getting this issue, so I thought I would post
   my fix in hopes of helping other users like me who try to be DIYers.
 *  [pabbito](https://wordpress.org/support/users/pabbito/)
 * (@pabbito)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/get-error-1-from-table-handler/#post-97667)
 * > Error code 28: No space left on device
 *  Isn’t the error caused because WP generates thousands of files in cache. I supppose
   it makes the device full. Did anyone of you noticed enormous number of files 
   in your cache/userlogins or cache/users or any cache directory??

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘[Get error -1 from table handler]’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 8 replies
 * 7 participants
 * Last reply from: [pabbito](https://wordpress.org/support/users/pabbito/)
 * Last activity: [20 years, 4 months ago](https://wordpress.org/support/topic/get-error-1-from-table-handler/#post-97667)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics