Register Members List Search Today's Posts Mark Forums Read

Reply
 
Article Options
Disabling Modifications OR Plugins via SQL Query - Fix AdminCP/Forum Access
TheLastSuperman
Join Date: Sep 2008
Posts: 5,492

Hey vb.org members and coders! Not much to say except I have a beautiful wife, three fantastic kids, and I develop Websites and Forums for a living 40+ hours a week.

North Carolina
by TheLastSuperman TheLastSuperman is offline 01 Mar 2011

SKILL LEVEL
  • Beginner (Level 1): Understands basic file uploads and template editing.
  • Intermediate (Level 2): Beginner + Understands basic modification and plugin installation.
  • Advanced Intermediate (Level 3): Intermediate + Understands how to read and comprehend partially PHP and vBulletin syntax plus understands the concepts of interacting with the database.
  • Experienced (Level 4): Advanced Intermediate + Understands how to fully edit and modify a database via phpmyadmin or other including executing SQL queries and more.
  • Master (Level 5): Experienced + Can edit, write and create custom modifications and code. Edit database freely w/o worry or issues and more.

Modification Issues? Not the first or last time you say?

It's either happened to you before or simply not yet! What would that be? On occasion modifications can have some unpredictable or down right "finicky" behavior dependent on a number of possible factors, the end result could possibly have locked you out of your forums control panel.

Normally you can simply disable hooks (modifications and plugins) by doing the following:

Edit config.php and add this directly below <?php:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Example:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Now save and upload that to includes/ and overwrite the original config.php - That typically allows you access the control panel again, you can now disable the modification you believe is the culprit OR disable them all. Once disabled remove the added line you included in config.php and re-enable one modification at a time until you find the modification in question.

If however your completely locked out for some unknown reason, password not functioning or well ohh geesh sometimes people put themselves in a bind plain and simple when trying their best! To get back into action, if you have phpmyadmin or access to the database directly you can execute a SQL Query to enable or disable any modification.

Running a backup on the tables mentioned below OR an entire database backup is STRONGLY recommended before beginning!

__________________________________

Disable a Modification:

phpMyAdmin > Select the Database in question > Now click on the "product" table > Once loaded find the title of the modification in question, note the productid*

Now for our demonstration let's pretend something is wrong with the CMS included with the vBulletin Suite and it's caused for some odd reason you to become locked out of your admincp, you would find vBulletin CMS in the title, and the productid is what? Yes it's vbcms.

Now you can click SQL and paste this query:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Run the query, now the CMS is disabled in the options however as Lynne noticed it must also be disabled in datastore . So while in phpmyadmin:

Edit datastore
Edit products
Edit data

Find:

s:5:"vbcms";s:1:"1";

That's the snippet of code you want to find, it also tells the forum what is enabled and disabled i.e. the cache follow? So change the 1 to a zero to disable example:

s:5:"vbcms";s:1:"0";

Remember your only changing that one value directly after vbcms and s:1 nothing else and you should have many more lines of code similar to that.

Save the change and refresh, now the CMS is completely disabled, if it was the "culprit" not allowing access for whatever unknown reason you may now access the site and or admincp. You can re-enable the modification using the Product Manager once you resolve the issue and run the query again in regards to datastore to enable it again, 1 being active.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Active set to 0 = Disabled
Active set to 1 = Enabled

You can now disable modifications using this method one at a time until your able to login to the admincp, then sort the issue and re-enable your modifications quickly via the product manager.

__________________________________

Disable a Plugin:

phpMyAdmin > Select the Database in question > Now click on the "plugin" table > Once loaded find the modification title of the plugin in question to ensure your disabling the correct one and if it is part of the modification causing the issue, note the pluginid*

Now for our demonstration let's pretend you uninstalled a modification however afterwords you receive a white page w/ error text or similar... something went wrong with the modification (either something coincidental or the author did not write the uninstall code correctly) and it's caused for some odd reason you to become locked out of your admincp, in phpmyadmin execute this query:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

*The above per Steve Machol disables the plugins in one query, I originally had you all hunting down individual plugins however Steve commented w/ a good question and a better method i.e.

Originally Posted by Steve Machol View Post
Good work. I have a question though. How would someone know which plugin to disable? Wouldn't it be better to just disable them all?

UPDATE plugin SET active=0
Therefor use that SQL query to disable all plugins, now access admincp and delete the plugins associated with the mod you had issues uninstalling!

.........................................

Continue below to disable one plugin at a time - Not required if you use the above method.

If for some reason you would like to disable a single plugin only then you would find the modification name in the "product" area... basically every plugin installed under that product will have the same product name in the plugin table however the pluginid is the actual plugin #. If the pluginid is 937 and you know it's one of the plugins you need to disable in order to get things rolling then execute this query in phpmyadmin:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Run the query, now the plugin is disabled, if it was the "culprit" not allowing access for whatever unknown reason you may now access the site and or admincp. You can run the query again and change active=0 to active=1 and re-enable:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Active set to 0 = Disabled
Active set to 1 = Enabled

You can now disable plugins using this method one at a time until your able to login to the admincp, then sort the issue and re-enable your plugins quickly via the plugin manager.

__________________________________

Notes:

You can disable multiple modifications or plugins by adding a ; behind the query and listing the new command on a new line as shown:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

If your tables have a prefix i.e. vb_ then add that before the first table names in either command i.e.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

This is just a tidbit of information, it could prove to be quite useful for a few here and there otherwise it's not required in the least and will never be used by 99% of you .

Last edited by TheLastSuperman; 02 Apr 2011 at 19:26..
Views: 5250
Reply With Quote
Comments
  #2  
Old 01 Mar 2011, 13:36
Princeton's Avatar
Princeton Princeton is offline
 
Join Date: Nov 2001
Real name: Joe Velez
great article - thank you
__________________
Former vBulletin.org Staff Member

Latest Articles:
Liquid Layout = Less Ad Revenue?
How to Monetize Your Site
Improve Web Page Performance
How To Write For The Web


If it needs instructions, there's room for improvement.
Give users what they actually want, not what they say they want. And whatever you do, don't give them new features just because your competitors have them!
Reply With Quote
  #3  
Old 01 Mar 2011, 15:20
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Nice article. I think it will come in handy to a lot of users. Nice work TheLastSuperman
__________________
My mods.
Reply With Quote
  #4  
Old 02 Mar 2011, 09:19
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
 
Join Date: Sep 2008
Real name: Michael Miller Jr
Cool

Originally Posted by Princeton View Post
great article - thank you
I'm always smiling when someone of your caliber says thanks, just proves it's so!

Originally Posted by borbole View Post
Nice article. I think it will come in handy to a lot of users. Nice work TheLastSuperman
Thanks Borbole although it pales in comparison to the mods you've released here for free and w/o branding... so hats off to you good sir and thanks for being part of the community .
__________________
Daddy Does Dios and Figs!
https://www.linkedin.com/in/thelastsuperman - Custom vBulletin Modifications, Styles, and Services.
Need a Host? I recommend URLJet.

Search - Use the search feature to find similar issues/answers.
Information - Include screenshots, copy/pasted error codes, url etc.
Fixed - Please return to your thread/post and let us know how it was fixed!
Thanks - For participating! Click the "Like" on a post if someone helped you!
Reply With Quote
  #5  
Old 01 Apr 2011, 07:57
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
 
Join Date: Sep 2008
Real name: Michael Miller Jr
Added information for disabling a plugin via SQL query.
__________________
Daddy Does Dios and Figs!
https://www.linkedin.com/in/thelastsuperman - Custom vBulletin Modifications, Styles, and Services.
Need a Host? I recommend URLJet.

Search - Use the search feature to find similar issues/answers.
Information - Include screenshots, copy/pasted error codes, url etc.
Fixed - Please return to your thread/post and let us know how it was fixed!
Thanks - For participating! Click the "Like" on a post if someone helped you!
Reply With Quote
  #6  
Old 15 Dec 2011, 18:44
OldSchoolDSL OldSchoolDSL is offline
 
Join Date: Oct 2010
Real name: Adam H.
We need to be able to tag articles like this. lol

Thanks for the heads up
Reply With Quote
  #7  
Old 24 May 2012, 05:13
Hornstar's Avatar
Hornstar Hornstar is offline
 
Join Date: Jun 2005
Real name: Matt
Thanks. Needed this query as I didn't want to manually disable them 1 by 1 lol
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Article Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 01:13.

Layout Options | Width: Wide Color: