[ivanp]

Originally Posted by meadwench

I have turned off VBSSO, and since then, have not gotten a single 'too many connections' error.

Started to experience the same errors when vBSSO is activated.

One of the issues is definitely extremely slow SQL query for displaying avatars (avatar.php) using the URL /vbsso/vbsso.php?a=act&do=avatar&id=...

    $query = "SELECT userfield.*, usertextfield.*, user.*, usergroup.genericpermissions, UNIX_TIMESTAMP(passworddate) AS passworddate,
        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid" .
        vbsso_iif($settings['avatarenabled'], ', avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar,
        customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight,
        customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb') .
        " FROM " . TABLE_PREFIX . "user AS user
    LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON (user.userid = userfield.userid)
    LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
    LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON (usertextfield.userid = user.userid) " .
        vbsso_iif($settings['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON (avatar.avatarid = user.avatarid)
        LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON (customavatar.userid = user.userid) ") .
        "WHERE MD5(LOWER(user.email)) LIKE '{$escapedHash}' LIMIT 1";

    $user = $mysqli->query($query);

Probably there are some other slow SQL queries causing this error.