Oh btw, I'd like to share some of my sites using mojoportal :)

www.cocobeach.com
www.flamesource.ae
www.bodyworxme.com
www.zensuals-me.com
www.alqaditourism.com
www.tasweeqpro.com
www.50words.org

Thanks again :)

Hi Joe,

Sorry to bother you again, but i hope you could help me out. I'm now getting this error whenever i tried to add/create a new user. 

Server Error in '/' Application.

Index was outside the bounds of the array.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.

Source Error:
 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:
 

[IndexOutOfRangeException: Index was outside the bounds of the array.] mojoPortal.Data.SqlParameterHelper.DefineSqlParameter(String paramName, SqlDbType type, String typeName, Int32 size, Byte precision, ParameterDirection dir, Object value, Boolean sizeProvided, Boolean precisionProvided) +565 mojoPortal.Data.DBSiteUser.GetSingleUserByLoginName(Int32 siteId, String loginName, Boolean allowEmailFallback) +428 mojoPortal.Business.SiteUser.LoginExistsInDB(Int32 siteId, String loginName) +278 mojoPortal.Web.AdminUI.ManageUsers.CreateUser() +210 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804

Any idea? 

THanks in advance.

Currently on 2.3.9.4. I also tried the upgrade but still got the same error. I'm thinking of creating a fresh new site if all else fails... How can i preserve all the data and settings? Is it possible to import just the data and settings to a new mojo db?

Thanks Joe, well after digging through and debugging using the source code i was able to pinpoint where the problem is.

Parameter count for [mp_Users_SelectByLoginName] didn't match. For some reason it was not updated. I added (@AllowEmailFallback bit) and it works now. 

Thanks again. :)

Looks like last parameter timeZoneId is missing in the stored procedure 

ALTER Procedure [dbo].[mp_Users_Insert]

/*
Author:            Joe Audette
Created:        2004-09-30
Last Modified:    2011-12-29

*/

@SiteGuid    uniqueidentifier,
@SiteID    int,
@Name         nvarchar(100),
@LoginName    nvarchar(50),
@Email        nvarchar(100),
@Password     nvarchar(1000),
@PasswordSalt nvarchar(128),
@UserGuid    uniqueidentifier,
@DateCreated datetime,
@MustChangePwd bit,
@FirstName         nvarchar(100),
@LastName         nvarchar(100)

I did modify the stored procedure but still same error.

ALTER Procedure [dbo].[mp_Users_Insert]

/*
Author:            Joe Audette
Created:        2004-09-30
Last Modified:    2011-12-29

*/

@SiteGuid    uniqueidentifier,
@SiteID    int,
@Name         nvarchar(100),
@LoginName    nvarchar(50),
@Email        nvarchar(100),
@Password     nvarchar(1000),
@PasswordSalt nvarchar(128),
@UserGuid    uniqueidentifier,
@DateCreated datetime,
@MustChangePwd bit,
@FirstName         nvarchar(100),
@LastName         nvarchar(100),
@TimeZoneId         nvarchar(32),
@EmailChangeGuid    uniqueidentifier

AS
INSERT INTO         [dbo].mp_Users
(
        SiteGuid,
            SiteID,
                [Name],
            LoginName,
                Email,
                [Pwd],
            UserGuid,
            DateCreated,
            TotalRevenue,
            MustChangePwd,
            RolesChanged,
            FirstName,
            LastName,
            TimeZoneId,
            EmailChangeGuid,
            PasswordResetGuid,
            PasswordSalt
    

)

VALUES
(
            @SiteGuid,
            @SiteID,
                @Name,
            @LoginName,
                @Email,
                @Password,
            @UserGuid,
            @DateCreated,
            0,
            @MustChangePwd,
            0,
            @FirstName,
            @LastName,
            @TimeZoneId,
            @EmailChangeGuid,
            '00000000-0000-0000-0000-000000000000',
            @PasswordSalt
)

SELECT        @@Identity As UserID

I was on a older version and i did upgrade... may be something wrong happened. I will try to upgrade it. Thanks.