Question Installation Problem on Very Large Forum

[Mei3am]

We have a very large forum (1.1m users, 8.1m posts, 0.6m topics). When we try to install it in AdminCP, It says "Please wait..." and no further change. After about 30 minutes, while following the MySQL process list in the WHM, the processes of the plugin just stop and the plugin does not install.

In General Options, there is a new section called "DragonByte Tech: Advanced User Tagging", but there is no section in AdminCP as "DBTech User Tagging". When we install it on a local test VB (with small number of users/topics), the "DBTech User Tagging" section shows as expected.

 

[Fillip H.]

Run the following query via the CLI for MySQL:

ALTER TABLE user 
ADD dbtech_usertag_excluded TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', 
ADD dbtech_usertag_mentioncount INT(10) UNSIGNED NOT NULL DEFAULT '0', 
ADD dbtech_usertag_tagcount INT(10) UNSIGNED NOT NULL DEFAULT '0', 
ADD dbtech_usertag_mentions INT(10) UNSIGNED NOT NULL DEFAULT '0', 
ADD dbtech_usertag_tags INT(10) UNSIGNED NOT NULL DEFAULT '0', 
ADD dbtech_usertag_settings INT(10) UNSIGNED NOT NULL DEFAULT '0', 
ADD dbtech_usertag_quotecount INT(10) UNSIGNED NOT NULL DEFAULT '0', 
ADD dbtech_usertag_hashcount INT(10) UNSIGNED NOT NULL DEFAULT '0', 
ADD dbtech_usertag_quotes INT(10) UNSIGNED NOT NULL DEFAULT '0';

Remember to add your table prefix if you use it.

Do not attempt to run this query in phpMyAdmin, as it will not work and may corrupt your user table. SSH in to your server and use the mysql command to enter MySQL's CLI and run the query from there. If you do not know how to do this, and you do not have a server administrator, please contact your host for assistance.

 

[Mei3am]

Thank you. Worked perfectly.

 

[Fillip H.]

Excellent, glad to hear it

If you have any further questions or issues, please feel free to start a new support ticket. Thanks!