Try editing
/dbtech/vbactivity/install/110.php and remove the following code:
PHP Code:
self::$db->query_write("
UPDATE " . TABLE_PREFIX . "user AS user
SET dbtech_vbactivity_pointscache = (
SELECT SUM(points) AS numpoints
FROM " . TABLE_PREFIX . "dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= " . (TIMENOW - 86400) . "
),
dbtech_vbactivity_pointscache_day = (
SELECT SUM(points) AS numpoints
FROM " . TABLE_PREFIX . "dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= $today
),
dbtech_vbactivity_pointscache_week = (
SELECT SUM(points) AS numpoints
FROM " . TABLE_PREFIX . "dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= $week
),
dbtech_vbactivity_pointscache_month = (
SELECT SUM(points) AS numpoints
FROM " . TABLE_PREFIX . "dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= $month
)
");
Fillip