Can I disable all plugins through phpmyadmin? Site down, 500 error.

coloradocolin
(@coloradocolin)

13 years ago

Some rogue plugin brought down my whole site. I am getting 500 internal server errors and premature end of script headers. Everything was cool before I ran the plugin, but now my whole network of sites is down – including the admin area- and I am totally lost and stumped. I have restarted my vps to no avail.

I am wondering if there is a way to disable all network activated plugins enmasse through phpmyadmin?

Or is there another recommendation?

It seems to me like there is some script trying to be run which is resulting in a memory overload, but I dont know how to find and or disable it….

Viewing 15 replies - 1 through 15 (of 16 total)

1 2 →

Tim Moore
(@tmoorewp)

13 years ago

Go in via FTP or SSH and delete the files. That’s the best way to do it.

If you don’t know which plugin is causing it, change the name of the plugins folder to ‘plugins-old’ and mu-plugins to ‘mu-plugins-old’. That’ll cause WordPress to stop reading plugins entirely.

Moderator Ipstenu (Mika Epstein)
(@ipstenu)

🏳️‍🌈 Advisor and Activist

13 years ago

What Tim said 🙂

But to answer this:

I am wondering if there is a way to disable all network activated plugins enmasse through phpmyadmin?

Oddly yes. http://perishablepress.com/press/2008/02/18/quickly-disable-or-enable-all-wordpress-plugins-via-the-database/

Thread Starter coloradocolin
(@coloradocolin)

13 years ago

Hmmm, so I did that and the site still wont come up.

Does anyone have any idea what could have happened. I used a plugin to batch create a bunch of sites. The plugin timed out and now I am getting this 500 error.

Thread Starter coloradocolin
(@coloradocolin)

13 years ago

I actually tried the perishable press technique, but I didnt see any of the multisite network activated plugins in that DB entry. I thought maybe there was another table in there that the network plugins.

Moderator Ipstenu (Mika Epstein)
(@ipstenu)

🏳️‍🌈 Advisor and Activist

13 years ago

Rename your .htaccess to old.htaccess for a test?

Andrea Rennick
(@andrea_r)

13 years ago

rename the plugins folder. that disables stuff.

Thread Starter coloradocolin
(@coloradocolin)

13 years ago

So I have renamed htaccess and plugins folder and I am still getting the 500 error. Is it possible some thing in the database got corrupted?

Andrea Rennick
(@andrea_r)

13 years ago

mmmm 500 error is server side tho.

Thread Starter coloradocolin
(@coloradocolin)

13 years ago

Thats what I am saying, I ran a plugin to batch create network sites and it brought the whole site down. Now I cant figure out how to get it back up. I have turned off all plugins and restarted the vps and I still cant get in (i.e. 500 error).

Moderator Ipstenu (Mika Epstein)
(@ipstenu)

🏳️‍🌈 Advisor and Activist

13 years ago

I ran a plugin to batch create network sites

Ugh. You didn’t say THAT was the rogue plugin. Which one was it?

You may hate me but, have you got a backup?

Thread Starter coloradocolin
(@coloradocolin)

13 years ago

I thought I mentioned? Its actually a paid plugin from wpmu. I have been asking them as well, but for the time being I was orignally hoping to just get the site back up.

I do have a fairly recent backup, and I have been close to wiping and reinstalling all day. It looks like thats what I am going to have to do.

Thanks, y’all.

Moderator Ipstenu (Mika Epstein)
(@ipstenu)

🏳️‍🌈 Advisor and Activist

13 years ago

Alas, if it’s their plugin, because they are behind a pay wall, not many (if any) of us have access to the code to take a look :/ you need to get them to help.

Thread Starter coloradocolin
(@coloradocolin)

13 years ago

Thanks. I actually was mainly interested in the original question of how to disable all the plugins which you guys answered. I was hoping by extension that maybe you could enlighten me on some of the theory about what could be happening to cause the error, but it’s always so much simpler than I think it is. I.e. Rogue plugin takes down site, delete plugin and restore from backup.

Moderator Ipstenu (Mika Epstein)
(@ipstenu)

🏳️‍🌈 Advisor and Activist

13 years ago

Once you disable the plugins folder, you should go in to wp-admin/plugins.php to make sure they’re down.

If killing the folder doesn’t let you back in, then the rogue plugin really was a fokking rogue and has hooks in places we know not :/

Thread Starter coloradocolin
(@coloradocolin)

13 years ago

Well, I couldnt get in no matter what I did. I tried all these suggestions and was totally locked out (500 error). If I had to guess what happened, is that the script overloaded the server memory and brought down the server, which then somehow corrupted the database.

I deleted everything and restored the db from a back up (luckily, I had one) and am now back to normal. Thanks for all the help. Guess I am going to be a little more cautious about how I create my network of sites next time.