Back to General Articles

Note for vB 3.0.2 upgraders: re public poll speed display optimisation
by Natch 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);
and comment those lines like so:
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);
HTH all ...

Similar Mods

Public Display of Affection (reputation display) vBulletin 3.0 Full Releases
Optmize Show Public Poll Results vBulletin 3.0 Full Releases

vblts.ru supports vBulletin®, 2022-2024