Bug mysql errors (loads)

[Mohammed Khalik]

I am getting this error on the paid version (pro)

my site: Fragmasters Community (see Activity tab, lots of mysql errors)

Database error in vBulletin 4.1.10:

Invalid SQL:

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

MySQL Error   : Unknown column 'dbtech_vbactivity_excluded_tmp' in 'field list'
Error Number  : 1054
Request Date  : Sunday, February 26th 2012 @ 04:32:53 PM
Error Date    : Sunday, February 26th 2012 @ 04:32:54 PM
Script        : xxxxxxxxxxxxxxxxxxxxxxxxxx/vbactivity.php?do=maintenance&action=recalcpoints&startat=14661&pp=50&dorecalcpoints=1&startdate=1325376000
Referrer      : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/vbactivity.php?do=maintenance&action=recalcpoints&startat=14610&pp=50&dorecalcpoints=1&startdate=1325376000
IP Address    : xxxxxxxxxxxxxxxxxxxxx
Username      : xxxxxxxxxxxxxxxxxxxx
Classname     : Database
MySQL Version : 5.5.14

---------- Post added at 16:42 ---------- Previous post was at 16:38 ----------

This seem to haved fixed things.

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

 

[Ozzy47]

Glad ya got it sorted.

 

[Mohammed Khalik]

This seem to be a common problem, therefore will it not be better just to have it fixed from the initial installation process.

 

[Ozzy47]

Here is a quote from Fillip H. the dev of the mod;

For some reason, certain MySQL installations have problems creating ENUM columns. I've never been able to figure out why.