Am I out of line here?

  • Yes, I know that I should have performed a database backup before I tried to upgrade to the most recent version of WordPress. But the one-click upgrade has worked so well, I was lulled into a false sense of security.

    So, I need to have my hosting company find the most recent back up and restore it. from that point.

    I asked them to do this on Tuesday (after first sending them a trouble ticket on Monday).

    It is now early Friday morning and every single email they have sent me is a boilerplate announcement telling me that the restore is underway.

    Having never worked for a company that hosted websites, I have no way to judge. So I thought I would ask the forum.

    Is a wait this long normal? How long should it take to find a recent database backup? My site has been down since Monday. This company has previously been much more responsive, including when restoring or backing up a database.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator James Huff

    (@macmanx)

    No, a full restore should take only an hour at most. Maybe we can fix your current installation. What happened after the upgrade?

    Thread Starter billdennis5

    (@billdennis5)

    Thank you.

    I was stupid enough to use the one-touch upgrade without doing a backup. Now, I cannot login to the main site at blogpeoria.com.

    No image file that has been uploaded will appear (even though the files are there). WPWebhost tells me it’s a redirect issue. This is the error message they are fixating on:

    [07-Oct-2010 01:07:11] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query SELECT * FROM wp_site_posts ORDER BY post_published_stamp DESC LIMIT made by require, require_once, include, include, dynamic_sidebar, call_user_func_array, widget_recent_global_posts
    [07-Oct-2010 01:07:11] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query SELECT * FROM wp_site_comments WHERE comment_approved = ‘1’ ORDER BY comment_date_stamp DESC LIMIT made by require, require_once, include, include, dynamic_sidebar, call_user_func_array, widget_recent_global_comments
    =================

    I managed to get logged in as an administrator. I found that Blog ID 1 — the site at the root of blogpeoria.com — is missing. It was there before the upgrade. I have no idea what caused it to vanish.

    I now have no plugins in the plugin folder excapt akismet. I now have only the default theme and twentyten theme (as well as the old Kubrick-based Home theme).

    I even tried to go back to a backup of the ORIGINAL .htaccess file.

    I have relayed this information to the host company, and I keep getting the same information back from them. They thank me for the new information then tell me I have to be patient because the retrieval process is still underway. They have been telling me this all day Tuesday, Wednesday and Thursday.

    I think there is something wrong and they aren’t telling me. Or maybe they are understaffed. I am getting no answers.

    Moderator James Huff

    (@macmanx)

    Try downloading WordPress again and delete then replace your copies of everything except the wp-config.php file and the /wp-content/ directory with fresh copies from the download, then run the upgrade script again at /wp-admin/upgrade.php .

    If that doesn’t work, you may need to repair the database.

    Access your WordPress database via phpMyAdmin (most hosting providers offer this in their control panel), check all of the tables, and choose “Repair tables” from the pull-down menu.

    Thread Starter billdennis5

    (@billdennis5)

    I’ll give that a try.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Am I out of line here?’ is closed to new replies.