The admincp I'm talking about is the same place you go to edit your webpages, where you see all the vbulletin files ... where they are located...
When you installed vbulletin you had to add the name of the d/b for your forum(s) in the config.php... whatever that value is you could use to set a direct path to your d/b in the xml file for this product.
so wherever you saved the xml file on your computer, go to where it's listed, right click, open with>notepad (or whatever editor you use) then
look for
Code:
<installcode>
$db->hide_errors();
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "post` ADD `dice` MEDIUMTEXT NOT NULL ;");
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` ADD `dice` MEDIUMTEXT NOT NULL ;");
$db->show_errors();
</installcode>
-
<uninstallcode>
$db->hide_errors();
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "post` DROP `dice` ");
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` DROP `dice` ");
$db->show_errors();
</uninstallcode>
THEN change it as follows... Making the asterisks the prefix you used for all your other tables (that you found in your config.php file)
Code:
<installcode>
$db->hide_errors();
$db->query_write("ALTER TABLE `****_ post` ADD `dice` MEDIUMTEXT NOT NULL ;");
$db->query_write("ALTER TABLE `****_thread` ADD `dice` MEDIUMTEXT NOT NULL ;");
$db->show_errors();
</installcode>
-
<uninstallcode>
$db->hide_errors();
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "post` DROP `dice` ");
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` DROP `dice` ");
$db->show_errors();
</uninstallcode>
Hopefully THAT will work.