100 Web Space
http://forum.100webspace.com/

MYSQL error - Wordpress database error
http://forum.100webspace.com/viewtopic.php?f=5&t=7340
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

http://deseosdecosasimposibles.coconia.net/

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.

Thanks,
Dale.

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:

Code:
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

Author:  sujatavid [ Tue Oct 04, 2022 10:24 am ]
Post subject:  Re: MYSQL error - Wordpress database error

Possibly the most common cause of the Error Establishing a Database Connection is simply that WordPress has incorrect login credentials for your database. This could be either the database name, username, or password. Remember, these login details are different from the ones you use to access your site. vidmate.app saveinsta

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/