Error establishing database connection

  • Like a complete fool I used WordPress garbage collector plugin to delete some tables I did not need! Yea! Now when I try to view my sites that are part of my multisite WordPress install it says ” Error establishing a database connection. I had bluehost run a restore and that had strange results. When I login to my back end my sites seem to be gone. In their place is the name of the master url. All the plugins are there. In my bluehost account everything seems to be there. After searching I found the database repair feature and I added the define code to wp-config.php and did the repair. This is what it found and could not fix. Please help me. I am an idiot and I am learning the hard way that I should have had a proper back up before I started this process. I do have a back up from 2 months ago but I’m not sure if that will help or hurt and I’m also not sure what to do with it. Thanks

    wrd_signups: Table ‘joerajch_wor2.wrd_signups’ doesn’t exist

    wrd_registration_log: Table ‘joerajch_wor2.wrd_registration_log’ doesn’t exist

    https://www.learnhowtotintcarwindows.com

Viewing 4 replies - 1 through 4 (of 4 total)

  • I find your site is nothing more than a fresh install. If you do not have recent backups, you may contact your host again for a restoration. Or at least you can get their help for a copy of the backup. Have you checked your control panel if it has stored backups? Most probably, yes? If nothing helps, you have to fall back upon your old back up.

    Thread Starter jrajchel

    (@jrajchel)

    I have 2 backups and the most recent back up has helped me get 1 site back up and running but I still have 2 that are down. Its a multi site install and the child sites are pointing to the main url site that is unedited.
    joerajchelenterprises.com works (Main site)
    medicaltyranny.com works
    learnhowtotintcarwindows.com not working
    joerajchel.com not working

    With “Plugins Garbage Collector” you could delete database table which belongs and created by plugins only. These tables are not created WordPress itself:
    wrd_signups: Table ‘joerajch_wor2.wrd_signups’ doesn’t exist
    wrd_registration_log: Table ‘joerajch_wor2.wrd_registration_log’ doesn’t exist.

    So try deactivate all your plugins and check if sites start work. After plugin reactivation dropped db tables should be created again. You will lose their content and possibly some plugin settings. But if the reason of your sites stopped working – in absence of those db tables, sites could start work again. Just check.

    Thread Starter jrajchel

    (@jrajchel)

    Thank you Vlad. You have helped me get things going. I did what you said and found that “WordPress MU Domain Mapping” plugin was the one that caused everything to go south for me. It has a manual install option that requires me to add a line to wp-config.php I am so grateful for your response. I knew that you could help me. I also know how to use your plugin properly. Thank you sir!

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