Bug Database error when going into someone profile after installing vbactivity&awards pro

[sbusinessgaming]

Database error when going into someone profile after installing vbactivity&awards pro

I Purchased the plugin, installed it, and when i go and click on my profile on the forums or any other member profile, i get a error. Im posting the image of the error and also the information on the error below, please help! thanks

View attachment 5750

Database error in vBulletin 4.2.2:

Invalid SQL:

						SELECT
							totalpoints,attachments,post,thread,threadrating,threadratingreceived,vmgiven,vmreceived,pollposted,pollvote,friend,givenrep,gottenrep,infractiongiven,infractionreceived,referral,sgmessage,sgdiscussion,calendarevent,dayregistered,blogpost,blogcomment,shout,mentionsgiven,mentionsreceived,tagsgiven,tagsreceived,ttbattledraw,ttbattlewon,ttbattlelost,tttournywon,tttrade,profilecomplete,contestswon,dbgalleryupload
						FROM vb_dbtech_vbactivity_points
						WHERE userid = '6'
					 LIMIT 1;

MySQL Error   : Unknown column 'totalpoints' in 'field list'
Error Number  : 1054
Request Date  : Saturday, May 24th 2014 @ 06:54:43 PM
Error Date    : Saturday, May 24th 2014 @ 06:54:43 PM
Script        : http://www.strictlybusinessgaming.com/forum/member.php?6-Qba-sB
Referrer      : http://www.strictlybusinessgaming.com/forum/forum.php
IP Address    : 75.115.40.147
Username      : Qba sB
Classname     : vB_Database
MySQL Version : 5.5.36-cll

 

[sbusinessgaming]

I discover yesterday after unistalling and installing the plugin again! that when i click on repair cache they that error shows up!..
Any idea why this happens? not even sure what repair cache is for?

 

[sbusinessgaming]

So i keep running into problems, i deleted the plugin again, and re-installed it, because i keep getting the error of " A required field called typeid is missing or has an invalid value." Also when i try to create a criteria , the option for type is not available, so im not able to create a criteria. Please someone help!!!

 

[Fillip H.]

If you run this query:

UPDATE vb_dbtech_vbactivity_type SET display = '0 WHERE typename = 'totalpoints'

then click Repair Cache, this should resolve the DB error


PS: For the future, there is no need to also send an email regarding your issue. If I'm not at my computer, I cannot answer your query. Thank you for your patience and understanding.

 

[sbusinessgaming]

I did the sql query and im getting this error, still getting the database error, when clicking on a members profile. If im doing something wrong please help with directions. Thanks in advance

 

[Fillip H.]

Try upgrading to the latest version, the fix has been incorporated.