Status
Not open for further replies.

Fillip H.

Staff member
Owner
Developer
Customer
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:
Code:
ALTER TABLE post ADD dbtech_thanks_disabledbuttons INT(10) UNSIGNED NOT NULL DEFAULT '0'
Code:
ALTER TABLE post ADD dbtech_thanks_requiredbuttons_content INT(10) UNSIGNED NOT NULL DEFAULT '0'
Code:
ALTER TABLE post ADD dbtech_thanks_requiredbuttons_attach INT(10) UNSIGNED NOT NULL DEFAULT '0'
Code:
ALTER TABLE post ADD dbtech_thanks_cache MEDIUMTEXT NULL
Code:
ALTER TABLE thread ADD dbtech_thanks_disabledbuttons INT(10) UNSIGNED NOT NULL DEFAULT '0'
Code:
ALTER TABLE thread ADD dbtech_thanks_requiredbuttons_content INT(10) UNSIGNED NOT NULL DEFAULT '0'
Code:
ALTER TABLE thread ADD dbtech_thanks_requiredbuttons_attach INT(10) 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
Code:
ALTER TABLE post DROP dbtech_thanks_disabledbuttons
Code:
ALTER TABLE post DROP dbtech_thanks_requiredbuttons_content
Code:
ALTER TABLE post DROP dbtech_thanks_requiredbuttons_attach
Code:
ALTER TABLE post DROP dbtech_thanks_cache
Code:
ALTER TABLE thread DROP dbtech_thanks_disabledbuttons
Code:
ALTER TABLE thread DROP dbtech_thanks_requiredbuttons_content
Code:
ALTER TABLE thread DROP dbtech_thanks_requiredbuttons_attach
 
Last edited:
Status
Not open for further replies.
Back
Top