That doesn't make sense. The changes to add MemberCount (which the error complains about) to that stored procedure were in version 2.3.8.5 (11 months ago). Nothing in recent versions has changed the related stored procedure. So it makes no sense that you get that error now but did not get it before upgrading from 2.3.9.3.
I would run this sql statement to fix this and hope that there are no other strange anomalies with your installation:
ALTER PROCEDURE [dbo].[mp_Roles_Select]
/*
Last Modified: 2012-04-10 Joe Audette
*/
@SiteID int
AS
SELECT
r.RoleID,
r.SiteID,
r.RoleName,
r.DisplayName,
r.SiteGuid,
r.RoleGuid,
COUNT(ur.UserID) As MemberCount
FROM [dbo].mp_Roles r
LEFT OUTER JOIN [dbo].mp_UserRoles ur
ON ur.RoleID = r.RoleID
WHERE r.SiteID = @SiteID
GROUP BY
r.RoleID,
r.SiteID,
r.RoleName,
r.DisplayName,
r.SiteGuid,
r.RoleGuid
ORDER BY r.DisplayName
GO
The above is from the script:
/Setup/applications/mojoportal-core/SchemaUpgradeScripts/mssql/2.3.8.5.config
Hope that helps,
Joe