2008-12-17, 02:59 PM
In the portal.php is a failure at line 200, where the unread messages are counted.
The SQL-statement trys to sum every field, which is incorrect, because you can only sum one field.
And the command IF does not exists, but the statement CASE WHEN ... THEN ... ELSE ... END (case, when, ...)
So the correct statement should be like
The SQL-statement trys to sum every field, which is incorrect, because you can only sum one field.
And the command IF does not exists, but the statement CASE WHEN ... THEN ... ELSE ... END (case, when, ...)
So the correct statement should be like
$query = $db->simple_select("privatemessages", "COUNT(*) AS pms_unread", "uid='".$mybb->user['uid']."' AND CASE WHEN status = '0' AND folder = '0' THEN TRUE ELSE FALSE END");