The Simple Way to Manually Deactivate WordPress plugins

Plugins and themes on WordPress can occasionally interfere with each other and prevent your login page from loading, which will prevent you from accessing your website’s backend. In most cases you might even get nothing but a white screen. The solution in this case is to access the database associated with your WordPress site using phpMyAdmin and deactivate the plugins manually.

1. Access to the Database

To start troubleshooting first we need to login to our cPanel and click on the phpMyAdmin icon in the Database Tab. Enter your administration user name and password if required.

2. Access your WordPress Database

After you are logged into your database, click on your database name from the menu on the left side. (Please note, for this tutorial we are using theGem as our database name. Yours will be different, in most cases it is your site or business name.)

Click on theGem (your database name) and then wp_options.

From the wp_options table, you will need to search for your theme, files and plugins to temporarily deactivate them to troubleshoot the issue.

3. Searching for Various WordPress Options

The first search needs to be for an option_name. You will enter template in the search bar for option name. This should retrieve the template entry in the database.

From here, you will delete the text field and enter your original default theme.

The second search should be for the stylesheet. In this search, you will enter stylesheet in the option_name section and press enter. This will show the results of your stylesheet. Enter the default theme name in the option_value textboxt to reset to default.

The third and final search is for installed plugins. This time the value to search for is active_plugins. A long threaded bunch of letters, numbers, and symbols should show in the value field for active_plugins.

Erase this command and press enter. The option_value for the plugins should now be empty. This makes all the plugins disabled on the WordPress site.

4. Checking the WordPress site

After completing the first three steps, your WordPress site should load. You might need to refresh the page in order to see it. From this point, you will be able to go into the plugins sessions of your WordPress site and find where the conflict is. This will allow you to adjust the plugins and themes and make sure that the site loads properly.

This solution works well whenever you cannot get your WordPress site to load at all. It could either show as a blank page or simply load continuously. Make sure to complete all three of the searches within phpMyAdmin to reset all of the possible conflicts. The first two searches help to reset the theme and the third helps to deactivate the plugins.

Picking up from where we left off, we need to start by creating some HTML to display the data we’ve stored in the $results variable. You can always modify this to suite your project. I’ll be using a table structure. <!DOCTYPE html> <html> <head> <meta charset="utf-8"/> <link href="styles/theme.css" rel="stylesheet"/> <title>PHP & MySQL</title>\ </head> <body> <div id="wrapper"> <table> <thead> <th>Title</th>...

In the first two parts of this series, we created the data layer that will hold the polling data and established methods for setting the variable values and reading from the database tables. In this part, we will build the methods that will write new polls and answers to the tables. The addPoll method adds a new record to the devdrive_polls table and returns a Boolean value that signals if the record was added successfully. function addPoll($aArgs) { // add a poll record $sql = "LOCK TABLES devdrive_polls...

A SQL injection is a common programming error the consequences of which can be really devastating. Many successful hacking attacks start when a hacker discovers a vulnerability that gives an opportunity to inject SQL code. When an SQL injection occurs, the structure of an SQL query is compromised and as a result you are left at the mercy of the potential hackers. If there is a vulnerability found, hackers can exploit it to gain access not only to your site and database but in extreme cases also to your corporate...

So far we've created some basic PHP pages and added some simple authentication. Today we're going to going to build on that by adding database support. This will allow us to add proper authentication to our application and start saving tasks. I should also note that I am currently writing PHP in-line and not using functions (or object orientated PHP) I will tidy this up in the next tutorial and spend more time explaining it and what it's benefits are. Last week ... Last week we installed XAMPP, so you should...

In our last session, we looked at the process of entering information on ad banners and ad clients, as well as generating ad activity reports. This week, we examine how to retrieve a random banner ad. We will also learn how to delete, activate and deactivate ads and clients. The getRandomAd() function retrieves a random ad by using the PHP rand() function. The function returns the ad’s primary key ID, client ID, title, URL and redirect path. The function also updates the activity table for this banner...

In our last PHP Ad Tracker lesson, we constructed the database tables for our ad banner application. Now we are ready to construct the data object that will hold the variables and functions that will display, add, edit and delete the data in those tables. Once we name all of the variables and functions, we will start applying the code to them. Variables: The data object class will hold two variables: one to hold the banner ad ID number from the ads table, and one to hold the database connection information....

In the previous lesson, we examined the basic functions of our banner ad tracking system, including the retrieval of records for both banner ads and advertisers. In this lesson, we will look at the functions responsible for generating reports and manipulating the data in the ads table and advertiser table. The getClientsList() function retrieves active client records and sorts them alphabetically by client name: function getClientsList() { // get clients from db $sql = "SELECT ad_client_id,...

Introduction ... I’m going to tell you a story, its about love, death and re-birth... Or something In the beginning there was a young html element called <table>. He had one purpose in life, to display data and life was good. But before long though he had been corrupted, his masters used him to define layout and structure. Things he was not originally designed to do, and so began the dark ages of web design. Then one day, there came a young knight called CSS, and with him he brought light to designers...

About

DeveloperDrive.com is a blog about web development from the makers of the popular web design blog WebdesignerDepot.com
Founded in 2011, we focus on the latest trends, tutorials, opinion articles as well as tips and tricks to empower our readers to become better web developers.