[Big Boards] Installation Issues / Manual Queries

[Fillip H.]

If you are having difficulties installing the mod due to a large post table (~1 million posts or more) you may wish to opt for running some of the queries ran by the installer in the MySQL command line.

Remember to add your table prefix if you use any.

Manually run the following queries:

ALTER TABLE post ADD dbtech_thanks_disabledbuttons INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE post ADD dbtech_thanks_requiredbuttons_content INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE post ADD dbtech_thanks_requiredbuttons_attach INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE post ADD dbtech_thanks_cache MEDIUMTEXT NULL

ALTER TABLE thread ADD dbtech_thanks_disabledbuttons INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE thread ADD dbtech_thanks_requiredbuttons_content INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE thread ADD dbtech_thanks_requiredbuttons_attach INT(10) UNSIGNED NOT NULL DEFAULT '0'

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'

If you run them via the MySQL command line, they won't fail. You could try phpMyAdmin, but that has the potential to fail as well.

Once they're ran, the installer will see that these columns already exist and you shouldn't have any more troubles unless you decide to uninstall the mod, in which case you need to manually uninstall these columns by running

ALTER TABLE post DROP dbtech_thanks_disabledbuttons

ALTER TABLE post DROP dbtech_thanks_requiredbuttons_content

ALTER TABLE post DROP dbtech_thanks_requiredbuttons_attach

ALTER TABLE post DROP dbtech_thanks_cache

ALTER TABLE thread DROP dbtech_thanks_disabledbuttons

ALTER TABLE thread DROP dbtech_thanks_requiredbuttons_content

ALTER TABLE thread DROP dbtech_thanks_requiredbuttons_attach

ALTER TABLE user DROP dbtech_thanks_points

ALTER TABLE user DROP  dbtech_thanks_settings

ALTER TABLE user DROP dbtech_thanks_alertcount

ALTER TABLE user DROP dbtech_thanks_settings2

ALTER TABLE user DROP dbtech_thanks_excluded