Go Back   NuHIT - SEO, Wiki, Forums > NuRatings Forums > NuRatings - Feature Requests
Reply
 
Thread Tools
 
#1
Old 10-17-2007, 12:19 PM
 
pipin
Premium Member
 
pipin's Avatar
 
Join Date: Nov 2006
Posts: 190
pipin is offline  

Drop mysql from install file


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.
Reply With Quote

#2
Old 10-18-2007, 12:39 AM
 
Hi pipin, do you mean when first installing the product XML?
ElfMage
nuHIT Team
 
ElfMage's Avatar
 
Join Date: Aug 2006
Posts: 3,602
ElfMage is offline  
Reply With Quote

#3
Old 10-18-2007, 01:41 AM
 
pipin
Premium Member
 
pipin's Avatar
 
Join Date: Nov 2006
Posts: 190
pipin is offline  
Quote:
Originally Posted by ElfMage View Post
Hi pipin, do you mean when first installing the product XML?
Yes, i wont be able to install it right now due to timeouts.
Reply With Quote

#4
Old 10-19-2007, 01:40 PM
 
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...
ElfMage
nuHIT Team
 
ElfMage's Avatar
 
Join Date: Aug 2006
Posts: 3,602
ElfMage is offline  
Reply With Quote

#5
Old 10-19-2007, 02:47 PM
 
pipin
Premium Member
 
pipin's Avatar
 
Join Date: Nov 2006
Posts: 190
pipin is offline  
Quote:
Originally Posted by ElfMage View Post
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
Reply With Quote

#6
Old 10-19-2007, 03:53 PM
 
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_threadADD `nr_votesINT UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE `vb_threadADD `nr_ratingINT DEFAULT 0 NOT NULL;
ALTER TABLE `vb_threadADD `nr_urlVARCHAR(255) DEFAULT '' NOT NULL;
ALTER TABLE `vb_threadADD INDEX `nr_thread_url` (`nr_url`);

ALTER TABLE `vb_postADD `nr_votesINT UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE `vb_postADD `nr_ratingINT DEFAULT 0 NOT NULL;

ALTER TABLE `vb_userADD `nr_thread_thresholdINT DEFAULT -2000 NOT NULL;
ALTER TABLE `vb_userADD `nr_post_thresholdINT DEFAULT -2000 NOT NULL;
ALTER TABLE `vb_userADD `nr_votesINT UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE `vb_userADD `nr_ratingINT DEFAULT 0 NOT NULL;
ALTER TABLE `vb_userADD `nr_posts_votesINT UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE `vb_userADD `nr_posts_ratingINT DEFAULT 0 NOT NULL;
ALTER TABLE `vb_userADD `nr_threads_votesINT UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE `vb_userADD `nr_threads_ratingINT 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.
ElfMage
nuHIT Team
 
ElfMage's Avatar
 
Join Date: Aug 2006
Posts: 3,602
ElfMage is offline  
Reply With Quote

#7
Old 10-19-2007, 05:55 PM
 
pipin
Premium Member
 
pipin's Avatar
 
Join Date: Nov 2006
Posts: 190
pipin is offline  
Quote:
Originally Posted by ElfMage View Post
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
Reply With Quote

#8
Old 10-23-2007, 02:42 PM
 
Nice numbers.
ElfMage
nuHIT Team
 
ElfMage's Avatar
 
Join Date: Aug 2006
Posts: 3,602
ElfMage is offline  
Reply With Quote

Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL 3.23 and vB 3.5.x compatible ? type901 NuWiki - Pre-sales and feedback 5 09-18-2007 05:37 PM
XML file in download is corrupt rfikki NuLook - Installation and Support 1 05-18-2007 11:16 AM
Mysql error 1068 on reputation KingPin NuRatings - Installation and Support 6 04-08-2007 11:58 AM
MySql Question! FalkinPro1 Pre-Sales Questions 4 01-16-2007 06:27 PM


All times are GMT -4. The time now is 06:44 AM.