Database Error! re: Wordpress site

[soupcantheatre296]

Hi! My domain is maratsade.x10.mx and I am on the Stoli server.

When I try to access my wordpress website, located at http://maratsade.x10.mx/wordpress/, I get an error saying "error establishing a database connection" from Firefox, and an Error 500 in IE. When I go to my wordpress admin login page, I get a message saying "One or more database tables are unavailable. The database may need to be repaired." with a link to repair the database. When I click on the repair link, it comes back with a message essentially saying it could not repair the database and offers the following details:

wp_users: Table 'jhaigh_maratsade.wp_users' doesn't exist
wp_usermeta: Table 'jhaigh_maratsade.wp_usermeta' doesn't exist
wp_posts: Table 'jhaigh_maratsade.wp_posts' doesn't exist
wp_comments: Table 'jhaigh_maratsade.wp_comments' doesn't exist
wp_links: Table 'jhaigh_maratsade.wp_links' doesn't exist
wp_options: Table 'jhaigh_maratsade.wp_options' doesn't exist
wp_postmeta: Table 'jhaigh_maratsade.wp_postmeta' doesn't exist
wp_terms: Table 'jhaigh_maratsade.wp_terms' doesn't exist
wp_term_taxonomy: Table 'jhaigh_maratsade.wp_term_taxonomy' doesn't exist
wp_term_relationships: Table 'jhaigh_maratsade.wp_term_relationships' doesn't exist
wp_commentmeta: Table 'jhaigh_maratsade.wp_commentmeta' doesn't exist

Now just for the record, everything was working fine before the server migration. I have checked my wordpress config.php file and it appears as though the database details and username do match the information listed under MySQL. From doing a check of the database from MySQL it also appears as though there are some tables that work, but it also flags these same tables as not existing.

My guess is that this is an issue related to the recent migration (like I said, I haven’t touched a thing so I don't have a clue as to why I'm getting this error), but if you think I can fix this issue from my end, please let me know how.

Thank you very much!

 

[soupcantheatre296]

Okay, an update in case this helps the tech staff at all...

It seems as though my database tables both do exist, and do not exist. I know that sounds confusing but here is what I've discovered:

If I go into phpMyAdmin, my database is there, but it says there are no tables. Here's a screen cap of the "structure page": http://dl.dropbox.com/u/28111650/phpMyAdmin structure page.jpg

However if I try to import/restore a backup of my database, I get an error #1050 saying that the table(s) already exists. Screencap here: http://dl.dropbox.com/u/28111650/phpMyAdmin restore backup page.jpg

Furthermore, if I go to the search page, it lists all the supposedly missing tables, and if I do a search the results refer to those tables. Screencap here: http://dl.dropbox.com/u/28111650/phpMyAdmin search page.jpg

So basically it comes down to a bizarre catch 22: I can't update my database because all the tables are still there, but I can't edit or access my website because my tables are missing.

To circumvent this problem, I used MySQL to add a fresh new database, imported my database backup file into this new database (which worked perfectly), then edited my wordpress config.php file to point to the new database instead of the old broken one. That fixed the problem and I was able to view and edit my website again - for while. A couple of hours ago, I once again I started getting database errors and I, like some other users it seems, are unable to login to Cpanel and are getting strange messages about "license activation".

Since I actually managed to fix this problem, only to have it return as spontaneously as the first time, I'm going to assume that it has something to do with the MySQL problems that Stoli has been having.

Please fix this soon - my website has been COMPLETELY down since late Friday evening. Thanks!

ps. I mentioned some tables that "worked" in my previous message. These were in fact leftovers from a plugin that I uninstalled long ago, and I've since removed these tables from the database. None of the tables that I actually need are working.

 

[descalzo]

A suggestion: add an index page to your public_html directory. Going to your URL I can see a couple of .zip files that you might not want people downloading. Or, add Options -Indexes to the .htaccess file. Or use the .htaccess file to redirect any requests for / to you wordpress blog.

 

[soupcantheatre296]

Thanks for the suggestion! And thanks to the tech team for sorting out my issue, it looks like everything is back to normal and I haven't lost any progress!