[wp-trac] [WordPress Trac] #2719: Database error 127

WordPress Trac wp-trac at lists.automattic.com
Fri May 12 17:59:53 GMT 2006


#2719: Database error 127
----------------------------+-----------------------------------------------
       Id:  2719            |      Status:  new                     
Component:  Administration  |    Modified:  Fri May 12 17:59:53 2006
 Severity:  blocker         |   Milestone:                          
 Priority:  highest         |     Version:  1.2                     
    Owner:  anonymous       |    Reporter:  venator48               
----------------------------+-----------------------------------------------
 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 at usa.net

 Give me a phone number, and I'll call.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/2719>
WordPress Trac <http://wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list