There are some fixes after the latest release involving Profile.controller.php (missing $db = database(); ) and Stats.subs.php (missing p).
In the earlier, find:
// SubForums
global $modSettings;
if(isset($modSettings['subforums'][$_SERVER['SERVER_NAME']]))
{
$result = $db->query('', '
SELECT COUNT(id_msg)
FROM {db_prefix}messages
WHERE id_member = {int:id_mem}{subforums_see_board:id_board}',
array('id_mem' => $memID)
);
list($tmp) = $db->fetch_row($result);
$db->free_result($result);
$context['num_posts'] = comma_format($tmp);
}
Change it to:
// SubForums
global $modSettings;
if(isset($modSettings['subforums'][$_SERVER['SERVER_NAME']]))
{
$db = database();
$result = $db->query('', '
SELECT COUNT(id_msg)
FROM {db_prefix}messages
WHERE id_member = {int:id_mem}{subforums_see_board:id_board}',
array('id_mem' => $memID)
);
list($tmp) = $db->fetch_row($result);
$db->free_result($result);
$context['num_posts'] = comma_format($tmp);
}
In the later, find:
// Number polls voted in.
// SubForums
$result = $db->query('distinct_poll_votes', '
SELECT COUNT(DISTINCT id_poll)
FROM {db_prefix}log_polls AS p
LEFT JOIN {db_prefix}topics as t ON (p.id_poll = t.id_poll)
WHERE id_member = {int:current_member}{subforums_see_board:t-id_board}',
And change it to:
// Number polls voted in.
// SubForums
$result = $db->query('distinct_poll_votes', '
SELECT COUNT(DISTINCT p.id_poll)
FROM {db_prefix}log_polls AS p
LEFT JOIN {db_prefix}topics as t ON (p.id_poll = t.id_poll)
WHERE id_member = {int:current_member}{subforums_see_board:t-id_board}',