The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Force Hack Removal
I am trying to remove an obsolete mod on my site but a while back i deleted the SQL Database that was attached to the hack so now when i try to remove it i get the following error:
Quote:
I thought a while ago i saw such a hack to force remove mods when such things happen. any help is appreciated, Thanks |
#2
|
||||
|
||||
Same thing happened with me and a mod I was testing out. In your product manager, you have drop down options next to each mod... Edit the mod and remove the conflicting SQL query from the uninstall code. In this case it'll be this code:
Code:
SELECT COUNT(*) AS users FROM user AS user, userfield AS userfield |
#3
|
|||
|
|||
Unfortunately, deleting the database references puts the hack in an unknown state so you may have multiple instances where you will need to follow the suggestion provided until the uninstall completes successfully. You may have some other residue that pops up as well. Hope it works out for you. If all else fails you might want to consider the alternative which is to reinstall the hack in upgrade / overwrite mode then do the uninstall. That should clean up any residual stuff that might be hiding out on your system.
|
#4
|
|||
|
|||
i cant seem to find that snip of code here is the uninstall code.
$db->query_write("DROP TABLE " . TABLE_PREFIX . "customfile"); $db->query_write("ALTER TABLE `" . TABLE_PREFIX . "user` DROP `tdban` "); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '50' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '51' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '52' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '53' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '54' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '55' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '56' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '57' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '58' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '59' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '60' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '61' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '62' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '63' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '64' LIMIT 1"); $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '65' LIMIT 1"); $db->query_write("ALTER TABLE `" . TABLE_PREFIX . "userfield` DROP `field50` , DROP `field51` , DROP `field52` , DROP `field53` , DROP `field54` , DROP `field55` , DROP `field56` , DROP `field57` , DROP `field58` , DROP `field59` , DROP `field60` , DROP `field61` , DROP `field62` , DROP `field63` , DROP `field64` , DROP `field65`"); $db->query_write("OPTIMIZE TABLE " . TABLE_PREFIX . "userfield"); |
#5
|
||||
|
||||
Remove this line:
Code:
DROP `field55` , |
#6
|
|||
|
|||
Thanks Dismounted
This worked i just kept removing the errored lines untill success. I took out: Code:
$db->query_write("DROP TABLE " . TABLE_PREFIX . "customfile"); $db->query_write("ALTER TABLE `" . TABLE_PREFIX . "user` DROP `tdban` "); "userfield` DROP `field50` , DROP `field51` , |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|