Bug vBActivity & Awards Pro installation issues

[CoZmicShReddeR]

Everything installed just fine its when I click on the front end links I get this error:

Database error in vBulletin 4.1.4:

Invalid SQL:

			UPDATE user
			SET dbtech_vbactivity_excluded_tmp = IF(dbtech_vbactivity_excluded = '1'
				OR FIND_IN_SET(39, membergroupids)
				OR usergroupid IN(39), '1', '0');

MySQL Error   : Unknown column 'dbtech_vbactivity_excluded_tmp' in 'field list'
Error Number  : 1054
Request Date  : Sunday, June 12th 2011 @ 08:44:44 PM
Error Date    : Sunday, June 12th 2011 @ 08:44:44 PM
Script        : http://www.cozworld.com/vbactivity.php?do=achievements
Referrer      : http://www.cozworld.com/vbactivity.php
IP Address    : 99.158.234.165
Username      : CoZmicShReddeR
Classname     : vB_Database
MySQL Version : 5.5.8-log

 

[Fillip H.]

Try entering your Product Manager, edit vBActivity, set version number to 2.1.6, then re-import the XML file

 

[CoZmicShReddeR]

There is no dbtech_vbactivity_excluded_tmp in the database tried updating and reloading older version... I think all I need is that database entry maybe now?

 

[Fillip H.]

Did you try the steps I described in the above post?

 

[CoZmicShReddeR]

Yes I followed it as you said and every other way possible! I am not new to this game...

 

[Fillip H.]

Run this, then:

ALTER TABLE user ADD dbtech_vbactivity_excluded_tmp ENUM('0', '1') DEFAULT '0'

 

[CoZmicShReddeR]

Hey sorry applied it the other day seems to have fixed it!

Thanks!