Hi Joe, this seems to be a Postgres specific bug.

When trying to unlock a locked user, the following error occurs:

ERROR: 42804: column "failedpasswordattemptcount" is of type integer but expression is of type boolean

mojoPortal.Data.DBSiteUser.AccountClearLockout(Guid userGuid) in E:\mojoportal\mojoPortal.Data.pgsql\dbSiteUser.cs:1530

I found out that dbSiteUser.db (postgresql version) had the following code:

        public static bool AccountClearLockout(Guid userGuid)
        {
            StringBuilder sqlCommand = new StringBuilder();
            sqlCommand.Append("UPDATE mp_users ");
            sqlCommand.Append("SET islockedout = false, ");
            sqlCommand.Append("failedpasswordattemptcount = false, ");
            sqlCommand.Append("failedpwdanswerattemptcount = false ");

            sqlCommand.Append("WHERE userguid = :userguid ;");

To fix it, I just changed false to 0 (zero). Everything worked like a charm. Please confirm it. (since I don't have SQL, I couldn't confirm it).

        public static bool AccountClearLockout(Guid userGuid)
        {
            StringBuilder sqlCommand = new StringBuilder();
            sqlCommand.Append("UPDATE mp_users ");
            sqlCommand.Append("SET islockedout = false, ");
            sqlCommand.Append("failedpasswordattemptcount = 0, ");
            sqlCommand.Append("failedpwdanswerattemptcount = 0 ");

            sqlCommand.Append("WHERE userguid = :userguid ;");