YAFLogo

nordic
  • nordic
  • 92% (Exalted)
  • YAF Lover Topic Starter
15 years ago
Click to save profile and show this error :

System.Data.SqlClient.SqlException: The column name 'YIM' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'YIM' may appear twice in the view definition.

The column name 'Blog' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Blog' may appear twice in the view definition.

The column name 'Gender' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Gender' may appear twice in the view definition.

The column name 'MSN' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'MSN' may appear twice in the view definition.

The column name 'ICQ' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'ICQ' may appear twice in the view definition.

The column name 'BlogServiceUsername' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'BlogServiceUsername' may appear twice in the view definition.

The column name 'BlogServicePassword' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'BlogServicePassword' may appear twice in the view definition.

The column name 'AIM' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'AIM' may appear twice in the view definition.

The column name 'Location' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Location' may appear twice in the view definition.

The column name 'Interests' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Interests' may appear twice in the view definition.

The column name 'Homepage' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Homepage' may appear twice in the view definition.

The column name 'Skype' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Skype' may appear twice in the view definition.

The column name 'RealName' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'RealName' may appear twice in the view definition.

The column name 'BlogServiceUrl' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'BlogServiceUrl' may appear twice in the view definition.

The column name 'Occupation' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Occupation' may appear twice in the view definition.

The column name 'YIM' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'YIM' may appear twice in the view definition.

The column name 'Blog' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Blog' may appear twice in the view definition.

The column name 'Gender' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Gender' may appear twice in the view definition.

The column name 'MSN' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'MSN' may appear twice in the view definition.

The column name 'ICQ' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'ICQ' may appear twice in the view definition.

The column name 'BlogServiceUsername' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'BlogServiceUsername' may appear twice in the view definition.

The column name 'BlogServicePassword' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'BlogServicePassword' may appear twice in the view definition.

The column name 'AIM' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'AIM' may appear twice in the view definition.

The column name 'Location' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Location' may appear twice in the view definition.

The column name 'Interests' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Interests' may appear twice in the view definition.

The column name 'Homepage' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Homepage' may appear twice in the view definition.

The column name 'Skype' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Skype' may appear twice in the view definition.

The column name 'RealName' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'RealName' may appear twice in the view definition.

The column name 'BlogServiceUrl' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'BlogServiceUrl' may appear twice in the view definition.

The column name 'Occupation' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Occupation' may appear twice in the view definition.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at YAF.Classes.Data.DBAccess.ExecuteNonQuery(SqlCommand cmd, Boolean transaction) in E:\6vega\Projects\YetAnotherForum\trunk\yafsrc\YAF.Classes\YAF.Classes.Data\DBAccess.cs:line 422

at YAF.Classes.Data.DBAccess.ExecuteNonQuery(SqlCommand cmd) in E:\6vega\Projects\YetAnotherForum\trunk\yafsrc\YAF.Classes\YAF.Classes.Data\DBAccess.cs:line 404

at YAF.Providers.Profile.DB.SetProfileProperties(Object appName, Object userID, SettingsPropertyValueCollection values, List`1 settingsColumnsList) in E:\6vega\Projects\YetAnotherForum\trunk\yafsrc\YAF.Providers\Profile\DB.cs:line 150

at YAF.Providers.Profile.YafProfileProvider.SetPropertyValues(SettingsContext context, SettingsPropertyValueCollection collection) in E:\6vega\Projects\YetAnotherForum\trunk\yafsrc\YAF.Providers\Profile\YafProfileProvider.cs:line 478

at System.Configuration.SettingsBase.SaveCore()

at System.Configuration.SettingsBase.Save()

at System.Web.Profile.ProfileBase.SaveWithAssert()

at System.Web.Profile.ProfileBase.Save()

at YAF.Controls.EditUsersProfile.UpdateProfile_Click(Object sender, EventArgs e)

at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Sponsor
Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
15 years ago
Never seen this problem... Can you save any profile or is this happening with all users?