*How to disable your WordPress plugin directly in database?

[wp_ad_camp_1]

Hmm, fews days ago I got a big trouble while login to the site event if every credentials and reCAPTCHA value is correctly provided but I never had a chance to access to the admin panels.

Login

I always got the message saying that:

Error

It is strange because I have used this plugin Google Captcha (reCAPTCHA) by BestWebSoft since the beginning of website deployment and I have never had any trouble like what I had right now. With this, I have no ways to access to my website back-end to add more posts and comments back to all of your inquiries. It is a frustrate situation because I can do nothing to my home page as administration part of the WordPress can not be accessible due to authenticate error.

After relaxing awhile then finally, I found that we can only do manually disable the plugin either in PHP code or in database MySQL. Luckily, I have full right to access on both FTP and MySQL on hosting so, it is not very complicate to disable it if I knew the points where that plugin value are setting in the database. I preferred to do it via database rather then PHP code because it would take less time to understand the structure then scripting languages used.

Please backup your database and/or your files/folders before making any change. This can solve to restore back the website in case of any problem happen un-expected.

You can use whatever GUI to access to your database back end (MySQL). For my case, I used phpMyAdminprovided by my web hosting server. The plugin configuration is stored in a table called wp_options. Now, let try to look for active plugins with the following sql statement.

SELECT * FROM `wp_options` WHERE  option_name = 'active_plugins';

You should got something similar like this in your result set.

mysql_001

Here is exactly what my option_value are in my setting

a:7:{i:0;s:36:"contact-form-7/wp-contact-form-7.php";i:1;s:50:"google-analytics-for-wordpress/googleanalytics.php";i:2;s:33:"google-captcha/google-captcha.php";i:3;s:36:"google-sitemap-generator/sitemap.php";i:4;s:49:"social-sharing-toolkit/social_sharing_toolkit.php";i:5;s:39:"syntaxhighlighter/syntaxhighlighter.php";i:6;s:41:"wordpress-importer/wordpress-importer.php";}

As you see, I have had 7 plugin enables in system. But what I would like to do now is to disable is google-captcha. To do so, I need to change the value a:7: to a:6:. Means that only 6 plugin will be enable. Then remove i:2;s:33:"google-captcha/google-captcha.php"; from the field.

Finally, the my option_value is presented like this

a:6:{i:0;s:36:"contact-form-7/wp-contact-form-7.php";i:1;s:50:"google-analytics-for-wordpress/googleanalytics.php";i:2;s:36:"google-sitemap-generator/sitemap.php";i:3;s:49:"social-sharing-toolkit/social_sharing_toolkit.php";i:4;s:39:"syntaxhighlighter/syntaxhighlighter.php";i:5;s:41:"wordpress-importer/wordpress-importer.php";}

Once the change is updated to the database, then at login page, I see no more reCAPTCHA module embedded anymore. So I can passed through administration back-end of my homepage with only username, password, and no more Captcha validation. The selected plugin is now disabled. You can re-enable it again via Plugins tools of the WordPress. Disabling does not mean deleted it, it is just temporary block their activity.

Bravo! Finally everything is returning back as normal. I can manage my posts again ๐Ÿ™‚

How to register & withdraw money from Payza Account?

Send and Receive Money with Payza
Send and Receive Money with Payza

I have seen many people online keep asking how to register and get Payza account verify. I decided to write this article just for helping those who needed for their registration and verification process while creating Payza account. It might not prefect but I am sure you will finally get your Payza account verify like mine too. The guide is base on a real account of my own.

If you have already known about Paypal, you might already have an idea what is payment processor is. It is same functionality just Payza is support more country than Paypal.

To let you know in details about what Payza is and its beneficial, please follow the summary below:

 

1. What is Payzaโ€‹ ?

 

  • Is an online payment processor which allow anyone with an email address to send and receive money, shop, make online payments or get paid from almost anywhere around the world.
  • It is one of the leading global online payment platforms that specialize in e-commerce processing, corporate disbursements, and remittances for individuals and businesses around the world.
    The e-wallet platform provides Payza members worldwide with convenient and flexible loading and withdrawal options, such as localized bank transfers, global bank wires, credit/debit card, checks, and prepaid cards, among others.
  • With over 9 million members, Payza offers its services in 197 countries and in 21 different currencies. Payza is proud to provide its merchants around the globe a complete solution for accepting payments and managing their businesses. In addition, Payza offers foreign exchange services, fraud screening services, email invoicing, mass and single remittances and business management tools. Payza also provides under-serviced and emerging markets with an affordable and convenient way to receive international payments, thereby bolstering local economies in a global marketplace.
  • Payza is a wholly owned subsidiary of MH Pillars Ltd. of London, United Kingdom.
    Corporate Headquarters Operational Center Regional Offices
    Damaras Limited, reg. 8029472 is a servicing company for MH Pillars Ltd. reg. 6243643
    Finchley House,
    707 High Road,
    London N12 0BT,
    United Kingdom
    Secure Mail Box #620, 2348 Chemin Lucerne
    Montreal, QC, H3R-2J8
    Canada
    New York, USA
    Mumbai, India
    Dhaka, Bangladesh
    Solna, Sweden

 

2. Pro & Cons of Payza?

 

Pro

Read More