|
Disabling Modifications OR Plugins via SQL Query - Fix AdminCP/Forum Access
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: Code:
define('DISABLE_HOOKS', true);
Code:
<?php
define('DISABLE_HOOKS', true);
/*======================================================================*\
|| #################################################################### ||
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: Code:
UPDATE product SET active=0 WHERE productid='vbcms'  . 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. Code:
s:5:"vbcms";s:1:"1"; Code:
UPDATE product SET active=1 WHERE productid='vbcms' 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: Code:
UPDATE plugin SET active=0
Quote 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: Code:
UPDATE plugin SET active=0 WHERE pluginid='937' Code:
UPDATE plugin SET active=1 WHERE pluginid='937' 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: Code:
UPDATE plugin SET active=1 WHERE pluginid='937'; UPDATE plugin SET active=1 WHERE pluginid='938'; UPDATE plugin SET active=1 WHERE pluginid='939'; Code:
UPDATE vb_product SET active=1 WHERE productid='vbcms' Code:
UPDATE vb_plugin SET active=1 WHERE pluginid='937'  .
|