Error establishing database connection

  • Please help. I am running WP 3.5.1 on MS Windows Server 2008 with MS SQL Server Express 2008. The site is https://www.urgi-med.com. I installed WP as a multisite install with SQL Server DB abstraction. I had everything working great when I tried to install the WordPress Simple Surveys plugin. Ever since, the site is down and it says “Error establishing database connection”. The dashboard page says “One or more database tables are unavailable. The database may need to be repaired.” When I try to do so, I get the following:

    The wp_urgimed_mke_60users table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
    Failed to repair the wp_urgimed_mke_60users table. Error:

    The wp_urgimed_mke_60usermeta table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
    Failed to repair the wp_urgimed_mke_60usermeta table. Error:

    The wp_urgimed_mke_60posts table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
    Failed to repair the wp_urgimed_mke_60posts table. Error:

    The wp_urgimed_mke_60comments table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
    Failed to repair the wp_urgimed_mke_60comments table. Error:

    The wp_urgimed_mke_60links table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
    Failed to repair the wp_urgimed_mke_60links table. Error:

    The wp_urgimed_mke_60options table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
    Failed to repair the wp_urgimed_mke_60options table. Error:

    The wp_urgimed_mke_60postmeta table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
    Failed to repair the wp_urgimed_mke_60postmeta table. Error:

    The wp_urgimed_mke_60terms table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
    Failed to repair the wp_urgimed_mke_60terms table. Error:

    The wp_urgimed_mke_60term_taxonomy table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
    Failed to repair the wp_urgimed_mke_60term_taxonomy table. Error:

    The wp_urgimed_mke_60term_relationships table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
    Failed to repair the wp_urgimed_mke_60term_relationships table. Error:

    The wp_urgimed_mke_60commentmeta table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
    Failed to repair the wp_urgimed_mke_60commentmeta table. Error:

    Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.

    wp_urgimed_mke_60users:
    wp_urgimed_mke_60usermeta:
    wp_urgimed_mke_60posts:
    wp_urgimed_mke_60comments:
    wp_urgimed_mke_60links:
    wp_urgimed_mke_60options:
    wp_urgimed_mke_60postmeta:
    wp_urgimed_mke_60terms:
    wp_urgimed_mke_60term_taxonomy:
    wp_urgimed_mke_60term_relationships:
    wp_urgimed_mke_60commentmeta:

    Please assist!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator t-p

    (@t-p)

    Do you have backup of your DB?

    – Try resetting the plugins folder by FTP or PhpMyAdmin. Sometimes, an apparently inactive plugin can still cause problems (because the hooks remain unless plugins completely removed or some plugins stick around in cached files. So by renaming the folder, you break them and force them inactive).

    Thread Starter berkora

    (@berkora)

    Hi Tara,

    Thanks for the info, but I did try renaming the plugins directory already (sorry for not including that in my original post).

    I even tried a fresh wp install on a new directory with a new DB but that gives the following error:

    Warning: mysql_connect(): php_network_getaddresses: getaddrinfo failed: No such host is known. in …\wp-includes\wp-db.php on line 1143

    Error establishing a database connection
    This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at U16840099\SQLEXPRESS. This could mean your host’s database server is down.

    Are you sure you have the correct username and password?
    Are you sure that you have typed the correct hostname?
    Are you sure that the database server is running?
    If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.

    I have tried different combinations of DB host in wp-config.php including .\SQLEXPRESS, IPADDRESS\SQLEXPRESS and LOCALHOST\SQLEXPRESS to no avail.

    Not sure what to do.

    Burak

    Sounds like your config info is wrong. If you know the pass and username are correct then I bet it is the db path. Make sure it is actually localhost if not then change it.

    Thread Starter berkora

    (@berkora)

    Hi Delevega,

    I have tried LOCALHOST, IP, and .\ to no avail.

    Thanks,

    Burak

    I am not talking about your config.php In your phpmyadmin you must give the user acccess to the database. You must set their host as the servers host name. In phpmyadmin. You must must must grant them access. have you done this? In phpmyadmin?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Error establishing database connection’ is closed to new replies.