Manually uninstalling mod as mysql_query takes too long

[jl255]

I need to uninstall a mod that has inserted columns into the vb_posts table, which has more than 6M entries. Trying to run uninstall via browser results in a timeout (white-screen) after more than a minute of running. How can I manually uninstall this mod? This is the mod: http://www.vbulletin.org/forum/showt...184155&page=75

[Mark.B]

I need to uninstall a mod that has inserted columns into the vb_posts table, which has more than 6M entries. Trying to run uninstall via browser results in a timeout (white-screen) after more than a minute of running. How can I manually uninstall this mod? This is the mod: http://www.vbulletin.org/forum/showt...184155&page=75

You'd need to ask the author of the mod for support - we have no idea what queries it would require to do this manually.

You could ask your host to temporarily increase the timeout settings for php & MySQL though.

[jl255]

Tks, perhaps i was not clear. I'm not asking how to remove the db columns. But I'm asking how to manually remove the mod from vbulletin. i will run the mysql queries separately to remove any added tables or columns. and the creator is providing support anymore.

[Mark.B]

This is not really a good idea. Just disable the modification if it's causing issues.

[Wayne Luke]

Disable the product in the admincp. Delete its files. Database information will remain but shouldn't really hurt anything over the long term if the fields are designed correctly. If after disabling, there are database errors, you will need to contact the addon author.

[Lats]

After disabling the product, the syntax for getting rid of the column is...

alter table
 post
drop column
 column_name

Change column_name to the actual name of the column you want to get rid of.