Title: Database error 127
Last modified: August 18, 2016

---

# Database error 127

 *  [tonywright](https://wordpress.org/support/users/tonywright/)
 * (@tonywright)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/database-error-127/)
 * Hi there. All of a sudden, my site has randomly started displaying the following
   pasted text, when a particular catagory on the site menu is clicked:
 * WordPress database error: [Got error 127 from table handler]
    SELECT DISTINCT*
   FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE
   1=1 AND (category_id = 13) AND post_date_gmt <= ‘2005-06-27 22:48:59’ AND (post_status
   = “publish”) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 99999999999999999999999999999999999999999
 * I haven’t altered any of the system’s code, and don’t actually know how to. I’d
   be very grateful of a solution to this problem. I’m afraid any solution will 
   have to be told to me in layman’s terms as I’m inexperienced with complicated
   stuff like this. My webdesigner has deserted me.
 * Thanks for your time,
    Tony. [http://www.rapnews.co.uk](http://www.rapnews.co.uk)

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

 *  [masquerade](https://wordpress.org/support/users/masquerade/)
 * (@masquerade)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/database-error-127/#post-226265)
 * If you have phpmyadmin, try running a repair on wp_posts.
 *  Thread Starter [tonywright](https://wordpress.org/support/users/tonywright/)
 * (@tonywright)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/database-error-127/#post-226266)
 * I’m afraid I have no idea if I have phpmyadmin or not.
 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/database-error-127/#post-226270)
 * [http://www.tamba2.org.uk/wordpress/backup/](http://www.tamba2.org.uk/wordpress/backup/)
   
   That might help find it
 * [http://www.tamba2.org.uk/wordpress/repair/](http://www.tamba2.org.uk/wordpress/repair/)
   
   That shows the repair bit
 *  Thread Starter [tonywright](https://wordpress.org/support/users/tonywright/)
 * (@tonywright)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/database-error-127/#post-226345)
 * Thanks for that info. I’ve repaired all parts of the database by following the
   phpmyadmin instructions, but the problem still remains.
 * Any other ideas of solutions?
 * Thanks.
 *  [LauraC](https://wordpress.org/support/users/laurac/)
 * (@laurac)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/database-error-127/#post-227119)
 * When this happened to me, after repairing and optimizing in MySQL and still getting
   the various error messages, I finally had to contact my host who said I had exceeded
   my space for that site. I allocated more space, problem solved.

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

The topic ‘Database error 127’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 4 participants
 * Last reply from: [LauraC](https://wordpress.org/support/users/laurac/)
 * Last activity: [20 years, 7 months ago](https://wordpress.org/support/topic/database-error-127/#post-227119)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics