[wp-trac] [WordPress Trac] #2718: WordPress database error connected to upload problem

[WordPress Trac]

#2718: WordPress database error connected to upload problem
----------------------------+-----------------------------------------------
       Id:  2718            |      Status:  new                     
Component:  Administration  |    Modified:  Fri May 12 17:03:34 2006
 Severity:  normal          |   Milestone:                          
 Priority:  normal          |     Version:  1.2                     
    Owner:  anonymous       |    Reporter:  venator48               
----------------------------+-----------------------------------------------
 Yesterday afternoon, I tried to add an additional Comment in reply to a
 new Comment to an older posting.  The upload failed, and somehow created a
 database error which has paralysed the blog.

 www.neveryetmelted.com

 At the upper edge of the screen, one finds these error messages:

 WordPress database error: [Got error 127 from storage engine]
 SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-05-12
 16:57: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 08:57:16'
 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

 Below you get the header & second and third columns, and no postings, with
 the following:

 Not Found
 Sorry, but you are looking for something that isn't here.


 -------------------

 Unfortunately, I am using Yahoo as a host, and I do not have access to try
 to repair SQL databases myself.

 This is a real mess, and I fear I may lose about 1000 postings, dating bac
 to the blog's initiation 29 October 2005.

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