TroyHoover
Member
Posted 1 year ago #
Hello everyone. I tried to get onto my site today http://troyhoover.co.cc/ and I came to a page that said I have a database table error. I clicked the button to try to repair it and it came back with a page that said it couldn't be automatically fixed and told me to post my errors here on these forums. This is the list it gave me:
wp_users: Table 'troyhoov_db01.wp_users' doesn't exist
wp_usermeta: Table 'troyhoov_db01.wp_usermeta' doesn't exist
wp_posts: Table 'troyhoov_db01.wp_posts' doesn't exist
wp_comments: Table 'troyhoov_db01.wp_comments' doesn't exist
wp_links: Table 'troyhoov_db01.wp_links' doesn't exist
wp_options: Table 'troyhoov_db01.wp_options' doesn't exist
wp_postmeta: Table 'troyhoov_db01.wp_postmeta' doesn't exist
wp_terms: Table 'troyhoov_db01.wp_terms' doesn't exist
wp_term_taxonomy: Table 'troyhoov_db01.wp_term_taxonomy' doesn't exist
wp_term_relationships: Table 'troyhoov_db01.wp_term_relationships' doesn't exist
wp_commentmeta: Table 'troyhoov_db01.wp_commentmeta' doesn't exist
Any help is greatly appreciated! Thank you!
-Troy Hoover
is this a fresh install or did you have some data.
If you have data then do you have back up that you can restore.
TroyHoover
Member
Posted 1 year ago #
This is a site that has been up for about a month. I have all the data backed up locally.
Is my next step to completely reinstall wordpress?
Paul Whitener Jr.
Member
Posted 1 year ago #
Where is your MySQL database hosted? I'd check that first to ensure it's up and running. You should also verify the path and credentials to your MySQL database in your wp-config.php file. If it worked before then something has changed...
If you can access your database, and the settings are correct in wp-config, then you can try reinstalling WordPress but I suspect this is a database, not WordPress, issue.
It might also be worth contacting your hosts to see if they have a backup of your database.
TroyHoover
Member
Posted 1 year ago #
Thanks guys. I just checked on the forums of my hosting site and a few other people have had this problem. I am on x10hosting which is free, so I can't really expect much since I am not paying anything. This website is an assignment for one of my college courses. After I finish the year and start working this summer, I am definitely going to pay for some real hosting so I won't have to worry about some of these issues as much.
Ouch! This is one of the real downsides to using free hosting. I hope they get it sorted asap. If they do, grab a backup of the database as soon as you can - just in case.
