Note for vB 3.0.2 upgraders: re public poll speed display optimisation
by
04 Jul 2004
Re: Optmize Show Public Poll Results If you have installed this, you will encounter an error when running the upgrade script to 3.0.2. It will occur @ step 4 - please note if you wish to avoid this error, please make the following alteration to your UPGRADE13.PHP script before running your upgrade. FIND: Code:
$query[] = "ALTER TABLE " . TABLE_PREFIX . "pollvote DROP INDEX userid"; $explain[] = sprintf($upgrade_phrases['upgrade1.php']['altering_x_table'], 'pollvote', 1, 2); $query[] = "ALTER TABLE " . TABLE_PREFIX . "pollvote ADD INDEX pollid (pollid, userid)"; $explain[] = sprintf($upgrade_phrases['upgrade1.php']['altering_x_table'], 'pollvote', 2, 2); Code:
// $query[] = "ALTER TABLE " . TABLE_PREFIX . "pollvote DROP INDEX userid"; // $explain[] = sprintf($upgrade_phrases['upgrade1.php']['altering_x_table'], 'pollvote', 1, 2); // // $query[] = "ALTER TABLE " . TABLE_PREFIX . "pollvote ADD INDEX pollid (pollid, userid)"; // $explain[] = sprintf($upgrade_phrases['upgrade1.php']['altering_x_table'], 'pollvote', 2, 2); |
Similar Mods
Public Display of Affection (reputation display) | vBulletin 3.0 Full Releases |
Optmize Show Public Poll Results | vBulletin 3.0 Full Releases |