Question Installation stuck on Altered Table

[DC23]

Installation stuck on Altered Table: dbtech_thanks_entry. Followed prompt twice, but no luck. Any suggestions as to what we should try next?

[:]​

Updating Version Number To: 1.0.0

• Altered Table: administrator
• Altered Table: forum
• Altered Table: post
• Altered Table: thread
• Altered Table: user
• Altered Table: usergroup
• Created Table: dbtech_thanks_entry

Updating Version Number To: 1.0.1
Updating Version Number To: 1.1.0

• Altered Table: dbtech_thanks_entry

 

[Fillip H.]

That is probably attempting to alter the post table. Is that table very large?

 

[DC23]

Yes, it is very large. The partial install broke our forum, so we disabled the component. Whatever we do next, please advise how we can undo if problems arise.

 

[Fillip H.]

The problem is that vBulletin runs on MyISAM tables which does not handle large alters, as opposed to InnoDB. I'd recommend just keep trying, as it should pass eventually.

 

[DC23]

The only problem we have with this approach was that when we did try to install it the first time, it broke our forum. We have quite a big audience using our services, so downtime is now an option. Is there a chance that if we keep trying it could create issues and more downtime? is there an easy way to reverse and remove the extension without going through backup restores?

 

[Fillip H.]

I think the best course of action here would be to generate the SQL commands manually, which should hopefully let you run them via CLI instead (which isn't subject to timeouts).

ALTER TABLE post
ADD dbtech_thanks_cache MEDIUMTEXT NULL

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'

Remember to add your table prefix if you use one.

If any of them return an error about the column already existing, that's fine, just move on to the next one.

I would recommend you do this via the command line (SSH) rather than a web interface like phpMyAdmin, as phpMyAdmin will be subject to the same problem.

After these are all ran, try the installation again.

 

[DC23]

This is not working for us.




There is no option available next to the post footer for users to like/dislike/thanks. How do we get this working properly?

Attached are the current configurations.

 

[Fillip H.]

Add yourself to Super Administrators in config.php or use a super admin account to grant yourself “Can administer Thanks”.

You will then see the new left side menu item.

In that menu group, click Manage Buttons. If it says no buttons exist, click Repair Cache. Once the buttons appear, edit the “Can click” permission for each of the three buttons.

 

[DC23]

We got this working, thanks.

2 more questions on this

1. Noticing when a user's post receives 10 dislikes that it is automatically hidden. How do we remove this feature so no posts are hidden?

2. Users are receiving email notifications when their posts are liked/disliked. How do we disable this?

 

[Fillip H.]

The answer to both queries are in the vBulletin Options, there's controls for both the post collapse and emails there

 

[DC23]

I was able to figure out #2. I can't figure out #1. Can you please specify how to fix this? Thanks so much @Fillip H.

 

[Fillip H.]

Empty this setting.

 

[DC23]

Perfect, thanks @Fillip H. - you can close this out. Great support. Will be buying again very soon.