Bug Database issue

[snowderblazer]

vbactivity.php?do=leaderboards

Database error in vBulletin 4.1.9:

Invalid SQL:

		SELECT
			totalpoints AS value,
			21 AS typeid,
			user.userid,
			username,
			user.usergroupid,
			infractiongroupid,
			displaygroupid
			
		FROM dbtech_vbactivity_points AS points
		LEFT JOIN user AS user ON (user.userid = points.userid)
		WHERE user.dbtech_vbactivity_excluded_tmp = '0'
			AND totalpoints <> 0
		GROUP BY userid
		ORDER BY value DESC
		LIMIT 10;

MySQL Error   : Unknown column 'totalpoints' in 'field list'
Error Number  : 1054
Request Date  : Sunday, January 1st 2012 @ 10:28:41 PM
Error Date    : Sunday, January 1st 2012 @ 10:28:41 PM
Script        : http://www.legijastranaca.com/vbactivity.php?do=leaderboards
Referrer      : http://www.legijastranaca.com/vbactivity.php
IP Address    : ------------------------
Username      : Snowderblazer
Classname     : vB_Database
MySQL Version : 5.1.57-log

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 423
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 470
#2 vB_Database->query_read_slave() called in [path]/dbtech/vbactivity/actions/leaderboards.php on line 62
#3 include_once([path]/dbtech/vbactivity/actions/leaderboards.php) called in [path]/vbactivity.php on line 224

 

[Fillip H.]

Have you tampered with the Points Settings while in debug mode?

If so, please un-tick all the Display Settings for the Total Points points type.

If you haven't, please temporarily put your forum in debug mode and then follow the previous step. That should resolve this