It is currently Sat Nov 17, 2018 6:57 pm


All times are UTC


Forum rules


Please click here to view the forum rules



Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: MYSQL error - Wordpress database error
PostPosted: Mon Jul 30, 2007 4:07 pm 
Noobie
Noobie

Joined: Sat Oct 15, 2005 7:22 am
Posts: 20
Location: Burgos, Spain
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?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 30, 2007 4:41 pm 
Moderator
Moderator

Joined: Thu Dec 15, 2005 2:59 pm
Posts: 681
Location: England
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.

_________________
Mountain biking forum ;)
Ponds and fishkeeping :D


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jul 31, 2007 2:59 pm 
Noobie
Noobie

Joined: Sat Oct 15, 2005 7:22 am
Posts: 20
Location: Burgos, Spain
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.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jul 31, 2007 5:25 pm 
Moderator
Moderator

Joined: Thu Dec 15, 2005 2:59 pm
Posts: 681
Location: England
Go to phpmyadmin, click the SQL tab, and carry out the following:

Code:
repair table wp_comments;

_________________
Mountain biking forum ;)
Ponds and fishkeeping :D


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 01, 2007 3:37 pm 
Noobie
Noobie

Joined: Sat Oct 15, 2005 7:22 am
Posts: 20
Location: Burgos, Spain
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.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 01, 2007 6:02 pm 
Moderator
Moderator

Joined: Thu Dec 15, 2005 2:59 pm
Posts: 681
Location: England
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.

_________________
Mountain biking forum ;)
Ponds and fishkeeping :D


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 02, 2007 5:10 pm 
Noobie
Noobie

Joined: Sat Oct 15, 2005 7:22 am
Posts: 20
Location: Burgos, Spain
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!!


Top
 Profile  
 
 Post subject:
PostPosted: Fri Aug 03, 2007 8:28 am 
Moderator
Moderator

Joined: Thu Dec 15, 2005 2:59 pm
Posts: 681
Location: England
Your welcome. :D

_________________
Mountain biking forum ;)
Ponds and fishkeeping :D


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ]  Moderators: fhmagic, KJ, Moderators, Support Team

All times are UTC


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
100WebSpace © 2011