Add User Error

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
9/13/2007 10:15:17 AM
Gravatar
Total Posts 31

Add User Error

Hi Joe,

I downloaded the 2.2.3.8 MSSQL release, created an empty db, opened the site to the setup & it configured everything properly.  I immediately went to add a new user.  When I click Save, I get the following error:
Procedure or function 'mp_UserProperties_Insert' expects parameter '@LastUpdatedDate', which was not supplied.
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.Data.SqlClient.SqlException: Procedure or function 'mp_UserProperties_Insert' expects parameter '@LastUpdatedDate', which was not supplied

Stack Trace:
[SqlException (0x80131904): Procedure or function 'mp_UserProperties_Insert' expects parameter '@LastUpdatedDate', which was not supplied.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +862234
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739110
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +903
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +77
mojoPortal.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +85
mojoPortal.Data.dbPortal.SiteUser_CreateProperty(Guid propertyID, Guid userGuid, String propertyName, String propertyValueString, Byte[] propertyValueBinary, DateTime lastUpdateDate, Boolean isLazyLoaded) +381
mojoPortal.Business.SiteUser.CreateProperty(String propertyName, Object propertyValue, SettingsSerializeAs serializeAs, Boolean lazyLoad) +163
mojoPortal.Business.SiteUser.SetProperty(String propertyName, Object propertyValue, SettingsSerializeAs serializeAs, Boolean lazyLoad) +1947
mojoPortal.Web.AdminUI.ManageUsers.CreateUser() +530
mojoPortal.Web.AdminUI.ManageUsers.btnUpdate_Click(Object sender, EventArgs e) +68
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

 

Interestingly enough, the user IS added.  If I go back to the Member List, the new user is there.

9/13/2007 12:26:13 PM
Gravatar
Total Posts 18439

Re: Add User Error

Hi,

That appears to be a bug introduced by some re-factoring in the ms sql data layer. I've corrected it and uploaded new release files 2-2-3-8-1

Just backup mojoPortal.Data.dll, mojoPortal.Business.dll, and mojoPortal.Web.dll and replace with the new ones. Actually the changes in the web and business dll are just to fix a different bug in the blog, only the data dll is needed to fix this bug.

Thanks,

Joe

You must sign in to post in the forums. This thread is closed to new posts.