Ok guys, I was running vBulletin 3.8.7 and had vaultwiki v2.5.0 installed and everything worked fine. I upgraded to vBulletin 4.2 with vaultwiki disabled in plugin manager. I went to uninstall it, it did a few steps, rebuilt the styles, and then gave me an error. Now I get errors sent to me when people try to go to an old wiki post, or when I try to uninstall any other plugin. I see parts of vaultwiki still in my settings and phrases, so I know it never completely uninstalled, even tho it's still listed in my products.
How can I go about completely uninstalling it?
When I tried uninstalling:
Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
ALTER TABLE thread
DROP vault_description
DROP INDEX firstpostid;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP INDEX firstpostid' at line 4
Error Number : 1064
Request Date : Sunday, July 15th 2012 @ 04:27:12 PM
Error Date : Sunday, July 15th 2012 @ 04:27:15 PM
Script : forums/admincp/plugin.php?do=productkill
Referrer : forums/admincp/plugin.php?do=productdelete&productid=ces_nwsp_spec&s=
Classname : vB_Database
MySQL Version : 5.5.24-0ubuntu0.12.04.1
Errors when search bots call up old wiki posts:
Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_posting AS phrasegroup_posting,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_vaultarticles AS phrasegroup_vaultarticles,
phrasegroup_showthread AS phrasegroup_showthread,
phrasegroup_vbmediawikiglobal AS phrasegroup_vbmediawikiglobal,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;
MySQL Error : Unknown column 'phrasegroup_vaultarticles' in 'field list'
I also get
"MySQL Error : Unknown column 'phrasegroup_vaultnamespace' in 'field list' " when trying to uninstall other products not related to vaultwiki, even tho its still referring to vaultwiki columns.
Please help! This is hindering a major upgrade on a forum with over a million posts