100 Web Space

MYSQL error - Wordpress database error
Page 1 of 1

Author:  Lindalawen [ Mon Jul 30, 2007 4:07 pm ]
Post subject:  MYSQL error - Wordpress database error

There is a problem with my MySQL database.

My blog can't read the comments on database and said this:
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
SELECT * FROM wp_comments WHERE comment_approved = '0' OR comment_approved = '1' ORDER BY comment_date DESC LIMIT 0,20


I got into the MySQL database and said:
#1016 - Can't open file: 'wp_comments.MYI' (errno: 145)

What can I do for fix it?

Author:  Dale [ Mon Jul 30, 2007 4:41 pm ]
Post subject: 

To solve your problem simply open phpmyadmin via the control panel and repair the following table: "wp_comments"

If your still having any problems dont hesitate to ask again.


Author:  Lindalawen [ Tue Jul 31, 2007 2:59 pm ]
Post subject: 

And how I repaired it? When I got into phpmyadmin and go to wp_comments, it only put the error message and it doesn't let me examine the comments or change anything.

Author:  Dale [ Tue Jul 31, 2007 5:25 pm ]
Post subject: 

Go to phpmyadmin, click the SQL tab, and carry out the following:

repair table wp_comments;

Author:  Lindalawen [ Wed Aug 01, 2007 3:37 pm ]
Post subject: 

Sorry to bother you, but now my database has disappeared! In my control panel doesn't appear, and in the sidebar said that I used 0 MB of MySQL and that are 5 MB left.

Author:  Dale [ Wed Aug 01, 2007 6:02 pm ]
Post subject: 

Is your blog accessable? Have a read in the announcements sections, theres quite a bit going on at the moment so maybe its something to do with that, if not then I would suggest opening a trouble ticket via your control panel.

Author:  Lindalawen [ Thu Aug 02, 2007 5:10 pm ]
Post subject: 

You're right, the disapparition was because of the database downtime. Now, I repaired the comments like you said and everything goes ok.

Thank you very, very, very much!!

Author:  Dale [ Fri Aug 03, 2007 8:28 am ]
Post subject: 

Your welcome. :D

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group