2012-05-23, 01:13 AM
edit: Oops. This seems to stop EVERY plugin... I believe the better solution is to define NO_PLUGINS as 1.
Deleting a Plugin, the Database Way
![[Image: step_1_lockedout.png]](https://camo.mybb.com/d14175da0a4bbf91c8d1f769a2e783c506659036/687474703a2f2f69313135312e70686f746f6275636b65742e636f6d2f616c62756d732f6f3633302f4a6f73684854656368547574732f737465705f315f6c6f636b65646f75742e706e67)
So now you are somehow or another locked out of the ACP. What do you do now if you can't access the plugins page? This is a very short tutorial for removing a plugin utilizing a database administration tool (AKA: phpmyadmin).
Step 1: Don't cry, scream, kick, or damage your keyboard or mouse. There is no need for this, and it will just cost you money if you break something
Step 2: Get access to phpMyAdmin or similar so that you can access the data inside the database.
Step 3: Enter the database that your forum uses, then open up the tableprefix_adminoptions table (where tableprefix_ is your table prefix).
![[Image: step2_lockedout.png]](https://camo.mybb.com/55789ba62e15c95a5d29ef46491bad692cde6d7b/687474703a2f2f69313135312e70686f746f6275636b65742e636f6d2f616c62756d732f6f3633302f4a6f73684854656368547574732f73746570325f6c6f636b65646f75742e706e67)
Note to you people who think you are clever: This is not my full table prefix.
Step 4: Find the row where the title column says "plugins".
![[Image: step3_lockedout.png]](https://camo.mybb.com/5ec33eeb5e241470aa82b4bc6c9ed3c47933416d/687474703a2f2f69313135312e70686f746f6275636b65742e636f6d2f616c62756d732f6f3633302f4a6f73684854656368547574732f73746570335f6c6f636b65646f75742e706e67)
Step 5: Click edit to edit the row. Now you will have to search for a plugin, by its filename (at least, I believe it is by filename) before .php. For example, Secure MyBB Admin Key is smak before .php.
Step 6: When you find the name in the text, you will see two occurrences of it after a semicolon. Example: s:4:"smak";s:4:"smak"; .
![[Image: step4-1_lockedout.png]](https://camo.mybb.com/b5765296f433cce472de06102dd28fbde25e08ca/687474703a2f2f69313135312e70686f746f6275636b65742e636f6d2f616c62756d732f6f3633302f4a6f73684854656368547574732f73746570342d315f6c6f636b65646f75742e706e67)
Delete that text, but not the semicolon BEFORE the FIRST occurrence. In this example, s:4:"smak";s:4:"smak";.
![[Image: step4-3_lockedout.png]](https://camo.mybb.com/461d6c6483182e68d90f5982f9d2bc7069199358/687474703a2f2f69313135312e70686f746f6275636b65742e636f6d2f616c62756d732f6f3633302f4a6f73684854656368547574732f73746570342d335f6c6f636b65646f75742e706e67)
Then, in this example, the text will look like:
![[Image: step4-4_lockedout.png]](https://camo.mybb.com/583739e60aca93ec53512831d956a6e29ab78d0a/687474703a2f2f69313135312e70686f746f6275636b65742e636f6d2f616c62756d732f6f3633302f4a6f73684854656368547574732f73746570342d345f6c6f636b65646f75742e706e67)
Note that the previously mentioned code is gone.
Step 7: Save the row, and reload your ACP login page. It should work if you did it right.
![[Image: step_end.png]](https://camo.mybb.com/c781698a7771443dd6add4c186e23a26be1323f6/687474703a2f2f69313135312e70686f746f6275636b65742e636f6d2f616c62756d732f6f3633302f4a6f73684854656368547574732f737465705f656e642e706e67)
Note: If a plugin has its own tables or adds columns, you should delete those if they don't have crucial data, as those tables will want to be re-added on reactivation if you reactivate that plugin.
So now you are somehow or another locked out of the ACP. What do you do now if you can't access the plugins page? This is a very short tutorial for removing a plugin utilizing a database administration tool (AKA: phpmyadmin).
Step 1: Don't cry, scream, kick, or damage your keyboard or mouse. There is no need for this, and it will just cost you money if you break something
Step 2: Get access to phpMyAdmin or similar so that you can access the data inside the database.
Step 3: Enter the database that your forum uses, then open up the tableprefix_adminoptions table (where tableprefix_ is your table prefix).
Note to you people who think you are clever: This is not my full table prefix.
Step 4: Find the row where the title column says "plugins".
Step 5: Click edit to edit the row. Now you will have to search for a plugin, by its filename (at least, I believe it is by filename) before .php. For example, Secure MyBB Admin Key is smak before .php.
Step 6: When you find the name in the text, you will see two occurrences of it after a semicolon. Example: s:4:"smak";s:4:"smak"; .
Delete that text, but not the semicolon BEFORE the FIRST occurrence. In this example, s:4:"smak";s:4:"smak";.
Then, in this example, the text will look like:
Note that the previously mentioned code is gone.
Step 7: Save the row, and reload your ACP login page. It should work if you did it right.
Note: If a plugin has its own tables or adds columns, you should delete those if they don't have crucial data, as those tables will want to be re-added on reactivation if you reactivate that plugin.
