Opened 7 years ago
Closed 7 years ago
#2719 closed defect (bug) (duplicate)
Database error 127
| Reported by: |
|
Owned by: |
|
|---|---|---|---|
| Priority: | highest omg bbq | Milestone: | |
| Component: | Administration | Version: | 1.2 |
| Severity: | blocker | Keywords: | database error 127 |
| Cc: |
Description
A failed coment upload corrupted my database yesterday, producing this error message and a dead blog:
WordPress database error: [Got error 127 from storage engine]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-05-12 17:54:59' AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') AND post_status != "attachment" GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 50
WordPress database error: [Got error 127 from storage engine]
SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < '2006-05-12 09:54:02' AND post_date != '0000-00-00 00:00:00' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
Anybody able to fix databases looking for some work? It's hosted on Yahoo, so it's not possible to run SQL database repair software tools. One can only forward requests. There is PHP editing capability.
Blog is www.neveryetmelted.com
My email is: jdz@…
Give me a phone number, and I'll call.

Please do not spam trac with duplicate entries.
Dup of #2718