 |
|
|
Article Options |
|
Disabling Modifications OR Plugins via SQL Query - Fix AdminCP/Forum Access
 TheLastSuperman
Join Date: Sep 2008
Posts: 5,823
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
01 Mar 2011
SKILL LEVEL
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:
Example:
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:
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.
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:
*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
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:
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:
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:
If your tables have a prefix i.e. vb_ then add that before the first table names in either command i.e.
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  .
The following members like this post: Hornstar
Last edited by TheLastSuperman; 02 Apr 2011 at 19:26.. |
||||||||||||||||||||||||||||||||||||||||||||
|
Views: 6147
|
||||||||||||||||||||||||||||||||||||||||||||
| Comments |
|
#2
01 Mar 2011, 13:36
|
||||
|
||||
|
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! No members have liked this post.
|
|
#3
01 Mar 2011, 15:20
|
||||
|
||||
|
Nice article. I think it will come in handy to a lot of users. Nice work TheLastSuperman
__________________
My mods. No members have liked this post.
|
|
#4
02 Mar 2011, 09:19
|
||||
|
||||
Originally Posted by Princeton
I'm always smiling when someone of your caliber says thanks, just proves it's so!
Originally Posted by borbole
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! *I no longer provide vBulletin Services (No PM's, please). 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! No members have liked this post.
|
|
#5
01 Apr 2011, 07:57
|
||||
|
||||
|
Added information for disabling a plugin via SQL query.
__________________
Daddy Does Dios and Figs! *I no longer provide vBulletin Services (No PM's, please). 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! No members have liked this post.
|
|
#6
15 Dec 2011, 18:44
|
|||
|
|||
|
We need to be able to tag articles like this. lol
Thanks for the heads up
The following members like this post: TheLastSuperman
|
|
#7
24 May 2012, 05:13
|
||||
|
||||
|
Thanks. Needed this query as I didn't want to manually disable them 1 by 1 lol
__________________
Gamerz Needs - For All Your Gaming Needs! No members have liked this post.
|
|
«
Previous Article
|
Next Article
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Article Options | |
|
|
| New To Site? | Need Help? |
All times are GMT. The time now is 22:13.
Powered by vBulletin® Version 3.8.14
Copyright © 2023, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright © 2023, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Design by Princeton
Copyright ©2001 - , vbulletin.org. All rights reserved.
vBulletin® is a registered trademark. 