Support » Plugin: Email Log » Error reconnecting to the database

  • Resolved prashantck

    (@prashantck)


    I am facing error when I am going to view Email logs or going for the setting. I am facing this error message.
    “Error reconnecting to the database
    This means that we lost contact with the database server at localhost. This could mean your host’s database server is down.

    Are you sure the database server is running?
    Are you sure the database server is not under particularly heavy load?
    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 checked with database and there also I cannot access the wp_email_log table. So what is issue I don’t know.
    Can you help in this?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Sudar Muthu

    (@sudar)

    Hello @prashantck

    I think for some reason the wp_email_log table that the plugin creates may have gotten deleted.

    Try these steps.

    – Deactivate the plugin
    – Reactivate it again
    – See if the table is created

    If the table is still not created, check if the mysql user has permission to create tables in your database.

    kiwiman

    (@kiwiman)

    Hi Sudar,

    @prashantck is my developer.

    I have tried deactivating and then reactivating the plugins (we have the Auto delete plugin as well), but still the error message is displaying. please advise next steps.

    Thanks

    Plugin Author Sudar Muthu

    (@sudar)

    Hello @kiwiman

    I think for some reason the database and code got out of sync. One way this could have happened is if the wp_email_log table was deleted after it got created by the plugin.

    Try these steps to fix it.

    – Deactivate the plugin
    – In the wp_options table, delete the row that contains the option_name email-log-db.
    – Reactivate it again
    – See if the table is created

    kiwiman

    (@kiwiman)

    Sorry, where do I find the wp_options table?

    kiwiman

    (@kiwiman)

    I sorted out how to delete that line. i decativated the plugin, deleted the line and then reactivated the plugin. Still saying error…..

    kiwiman

    (@kiwiman)

    This was the line I deleted, right?

    (31766, ’email-log-db’, ‘0.1’, ‘yes’),

    Plugin Author Sudar Muthu

    (@sudar)

    @kiwiman

    The DB record that you deleted is correct, but not sure why this is still not working.

    I think the DB username that is used in wp-config.php doesn’t have access to create tables in the DB.

    I would require some more private details (like db username etc) about your site. Can you please reach us out through https://wpemaillog.com/support/

    Thanks and sorry for the trouble.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error reconnecting to the database’ is closed to new replies.