Question Big Board Installation

[semprot]

I have run all queries which are stated on
http://www.dragonbyte-tech.com/f37/[big-boards]-installation-issues-manual-queries-10145/

But installing product always stopped at this

Updating Version Number To: 1.0.0

Altered Table: administrator
Altered Table: forum
Altered Table: post

Should i just try to install the XML over and over until i get success response?

( i have 2.4 million posts & 72000 threads )

 

[Fillip H.]

The next step after posts is the user table, how big is that?

 

[semprot]

The next step after posts is the user table, how big is that?

i have 455000 members. Can you tell me what queries need to be run? So that i can run on mysql console first.

 

[Fillip H.]

I've edited the install script to slim it down a little, and also added these queries to the linked thread:

ALTER TABLE user ADD dbtech_thanks_points INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE user ADD dbtech_thanks_settings INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE user ADD dbtech_thanks_alertcount INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE user ADD dbtech_thanks_settings2 INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE user ADD dbtech_thanks_excluded TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'

 

[semprot]

I've edited the install script to slim it down a little, and also added these queries to the linked thread:

ALTER TABLE user ADD dbtech_thanks_points INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE user ADD dbtech_thanks_settings INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE user ADD dbtech_thanks_alertcount INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE user ADD dbtech_thanks_settings2 INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE user ADD dbtech_thanks_excluded TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'

What do you mean with edit the install script? Should i redownload the whole product file?

 

[semprot]

Ok now it's working.
Its on this step now

Finalising Install...

What does it doing? updating each user / each post?

 

[Fillip H.]

Yeah, it's inserting a record into the statistics table for each member of your forum

 

[semprot]

Yeah, it's inserting a record into the statistics table for each member of your forum

Awesome. I used abe's previously. So after this "finalising" step is completed, should i run the import script (thanksimport.php) too?

 

[Fillip H.]

Yup, though before running the importer I'd confirm manually that the number of entries in there match the number of entries in the user table - that will avoid potential issues with the importer not being able to recalculate stats properly