I have got my VS setup going ok now, and I have isolated the issue to a stored procedure mp_Users_Update but I still dont know whats happening , I am using SQL server and I'm on the latest version of MojoPortal, the issue happens also when trying to update a member through the mojo member list functions, I have copied the error below, any help would be appreciated thanks.
Invalid object name 'Member'.
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: Invalid object name 'Member'.
Source Error:
Line 98: PrepareCommand(command, connection, null, commandType, commandText, commandParameters);
Line 99: command.CommandTimeout = commandTimeout;
Line 100: return command.ExecuteNonQuery();
Line 101: }
Line 102: }
Source File: C:\Websites\IwiSystem\Source\mojoportal\mojoPortal.Data.MSSQL\SqlHelper.cs Line: 100
Stack Trace:
[SqlException (0x80131904): Invalid object name 'Member'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2073550
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064508
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +215
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +178
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
mojoPortal.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters) in C:\Websites\IwiSystem\Source\mojoportal\mojoPortal.Data.MSSQL\SqlHelper.cs:100
mojoPortal.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) in C:\Websites\IwiSystem\Source\mojoportal\mojoPortal.Data.MSSQL\SqlHelper.cs:76
mojoPortal.Data.SqlParameterHelper.ExecuteNonQuery() in C:\Websites\IwiSystem\Source\mojoportal\mojoPortal.Data.MSSQL\SQLParameterHelper.cs:173
mojoPortal.Data.DBSiteUser.UpdateUser(Int32 userId, String name, String loginName, String email, String password, String passwordSalt, String gender, Boolean profileApproved, Boolean approvedForForums, Boolean trusted, Boolean displayInMemberList, String webSiteUrl, String country, String state, String occupation, String interests, String msn, String yahoo, String aim, String icq, String avatarUrl, String signature, String skin, String loweredEmail, String passwordQuestion, String passwordAnswer, String comment, Int32 timeOffsetHours, String openIdUri, String windowsLiveId, Boolean mustChangePwd, String firstName, String lastName, String timeZoneId, String editorPreference, String newEmail, Guid emailChangeGuid, Guid passwordResetGuid, Boolean rolesChanged) in C:\Websites\IwiSystem\Source\mojoportal\mojoPortal.Data.MSSQL\dbSiteUser.cs:466
mojoPortal.Business.SiteUser.Update() in C:\Websites\IwiSystem\Source\mojoportal\mojoPortal.Business\SiteUser.cs:981
mojoPortal.Business.SiteUser.Save() in C:\Websites\IwiSystem\Source\mojoportal\mojoPortal.Business\SiteUser.cs:1053
mojoPortal.Web.AdminUI.ManageUsers.UpdateUser() in C:\Websites\IwiSystem\Source\mojoportal\Web\Admin\ManageUsers.aspx.cs:642
mojoPortal.Web.AdminUI.ManageUsers.btnUpdate_Click(Object sender, EventArgs e) in C:\Websites\IwiSystem\Source\mojoportal\Web\Admin\ManageUsers.aspx.cs:532
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563