Drop mysql from install file

[pipin]

He,

i know i can do this by editing the file, but it might be for good also for people who try it first on big databases.

e.g. the alter statement would run for about 12 minutes and the plugin procedure would answer with an uncomplete request.

[ElfMage]

Hi pipin, do you mean when first installing the product XML?

[pipin]

Originally Posted by ElfMage

Hi pipin, do you mean when first installing the product XML?

Yes, i wont be able to install it right now due to timeouts.

[ElfMage]

Interesting. I see what you mean. Let me add some code to the new version, which will be released shortly, that should alleviate this. However, for big boards, it may still timeout due to the browser...

[pipin]

Originally Posted by ElfMage

Interesting. I see what you mean. Let me add some code to the new version, which will be released shortly, that should alleviate this. However, for big boards, it may still timeout due to the browser...

maybe releasing the sql statements as an extra, would be sufficient. so they could be executed in mysqladmin

[ElfMage]

I can provide these. However, you may need them all or not depending on whether it is a new install or an upgrade.

These are the queries:

PHP Code:



ALTER TABLE `vb_thread` ADD `nr_votes` INT UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE `vb_thread` ADD `nr_rating` INT DEFAULT 0 NOT NULL;
ALTER TABLE `vb_thread` ADD `nr_url` VARCHAR(255) DEFAULT '' NOT NULL;
ALTER TABLE `vb_thread` ADD INDEX `nr_thread_url` (`nr_url`);

ALTER TABLE `vb_post` ADD `nr_votes` INT UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE `vb_post` ADD `nr_rating` INT DEFAULT 0 NOT NULL;

ALTER TABLE `vb_user` ADD `nr_thread_threshold` INT DEFAULT -2000 NOT NULL;
ALTER TABLE `vb_user` ADD `nr_post_threshold` INT DEFAULT -2000 NOT NULL;
ALTER TABLE `vb_user` ADD `nr_votes` INT UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE `vb_user` ADD `nr_rating` INT DEFAULT 0 NOT NULL;
ALTER TABLE `vb_user` ADD `nr_posts_votes` INT UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE `vb_user` ADD `nr_posts_rating` INT DEFAULT 0 NOT NULL;
ALTER TABLE `vb_user` ADD `nr_threads_votes` INT UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE `vb_user` ADD `nr_threads_rating` INT DEFAULT 0 NOT NULL;

CREATE INDEX nr_thread_rating ON `vb_thread` (nr_rating);
CREATE INDEX nr_user_rating ON `vb_user` (nr_rating); 


You'll need to replace vb_ with the corresponding table prefix (if any) in your vBulletin installation. Also, I recommend trying this on a test DB, just to be certain.

Thanks.

[pipin]

Originally Posted by ElfMage

You'll need to replace vb_ with the corresponding table prefix (if any) in your vBulletin installation. Also, I recommend trying this on a test DB, just to be certain.

Thanks.

thanks, sure on a test db, i just ran into this problems after dropping in a backup of productive db into the test.


threads 311 320 posts 3.332.000

[ElfMage]

Nice numbers.