Thread Starter
davegf
(@davegf)
Yep @alchymyth problem persists 🙁
In that case, your database may be corrupted.
Thread Starter
davegf
(@davegf)
OK, so is there anything I an do about that?
Thanks
Here are the steps to repair a table in a MySQL database using phpMyAdmin:
Login to hosting account.
Login to phpMyAdmin.
Choose the affected database. If you only have one database, it should choose it by default so you don’t need to do anything.
In the main panel, you should see a list of your database tables. Check the boxes by the tables that need repair.
At the bottom of the window just below the list of tables, there is a drop down menu. Choose “Repair Table”
Remember, that it is advisable to have a current backup of your database at all times.
Thread Starter
davegf
(@davegf)
Thanks, but how do I know which tables need to be repaired? 😉
Repair wp_posts and then test your website
Thread Starter
davegf
(@davegf)
So I repaired all databases and they all are ok apart from a few of them say “The storage engine for the table doesn’t support repair”
Ideas?
Thread Starter
davegf
(@davegf)
Yeah, wp_posts is one of those that says “The storage engine for the table doesn’t support repair”?
you can try the following
edit your content-single.php
find this line
<?php athemes_posted_on(); ?>
and replace it with
<?php the_time(); ?>
I have just repaired a wp_posts file in two of my databases without any problem.
Go to the phpAdmin Query tab and type REPAIR TABLE wp_posts in the query box. Then press the submit query button.
Thread Starter
davegf
(@davegf)
Tried this:
“edit your content-single.php
find this line
<?php athemes_posted_on(); ?>
and replace it with
<?php the_time(); ?>”
And ti didn’t make a difference for the posting date on the top post on the homepage but it changed the time of each post to “12:00” on each single post page.
Thread Starter
davegf
(@davegf)
And typed “REPAIR TABLE ‘wp_posts'” into the query box for that database and got no confirmation message and problem still not fixed 🙂
Do either of you guys wanna jump into my admin area or hosting account? 🙂
Andrew Nevins
(@anevins)
WCLDN 2018 Contributor | Volunteer support
I’m sure nobody wants that responsibility, you really shouldn’t flippantly give out the keys to your site or server.
Thread Starter
davegf
(@davegf)
Fair point @andrew, any advice on the issue?
